Hi :) Csv doesn't store many different options for formatting. Basically it can only just about cope with text or number. It's not really a proper spreadsheet format. The plus side is that even a text-editor can open it and the file-size tends to be very small.
When you import into a spreadsheet program you often get a chance to let the program know which columns need to be defined with whatever greater level of sophistication you need. The sort of sophistication that proper spreadsheet formats (ods or xls or xlsx) routinely save in with the file. I think Calc might even remember your choices for the next csv you open or perhaps just for the same file-name but either way it could be hopelessly inappropriate by then if extra columns have been inserted or anything like that. Regards from Tom :) --- On Sun, 4/12/11, berntie <fraeggerm...@yahoo.com> wrote: From: berntie <fraeggerm...@yahoo.com> Subject: [libreoffice-users] Re: Cell formatting with CSV files in Calc To: users@global.libreoffice.org Date: Sunday, 4 December, 2011, 1:06 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 -- 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
