Re: [libreoffice-users] Re: Cell formatting with CSV files in Calc

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 <fraeggermann@yahoo.com> wrote:

From: berntie <fraeggermann@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+help@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+help@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