Pedro wrote > > > berntie wrote >> >> When I open my CSV file, select the date column and go to "Data -> >> Validity" and tell Calc to disallow dates before, say, 01.01.2010, then I >> can nonetheless enter, e.g., 01.01.2009. >> > > Did you check the "Show error message" option in the Error Alert tab? > Yes, I did check the box.
Pedro wrote > > When you type anything but a date after 01.01.2010 it should display a > message box saying "Invalid value" and the value or text that you typed is > simply deleted (which is not very nice :) ) Maybe it's not nice, but it's > what I want. But you know what's weird? Now that I did try it again, it worked. Though, I have absolutely no clue what I did wrong before... Anyway, the problem seems to be on my side of things, so for me, this issue is closed. Thanks again for your help. -- View this message in context: http://nabble.documentfoundation.org/Cell-formatting-with-CSV-files-in-Calc-tp3557689p3558338.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
