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

On 12/03/2011 03:05 PM, berntie wrote:
> Hi, I'm having an issue with cell formatting in CSV files. Consider the
> following simple CSV file (should be self explanatory):
>
> Date;Item;Amount
> 01.12.2011;New laptop;-1.000,00
> 02.12.2011;Glass of beer;-3,00
>
> (I'm using a German locale, so the comma is the decimal spearator.) If you
> import that into Calc and format the date column with a rule like "NNNNTT.
> MMMM JJJJ" and the amount column as a currency with a rule like "#.##0,00
> [$EUR];[ROT]-#.##0,00 [$EUR]", then everything works fine (negative amounts
> are red etc.) Save the CSV file and you end up with
>
> "Date";"Item";"Amount"
> Donnerstag, 01. Dezember 2011;"New laptop";-1.000,00 EUR
> Freitag, 02. Dezember 2011;"Glass of beer";-3,00 EUR
>
> in the file. Now open that file again with Calc and try to format the amount
> column with the same rule: fail. New entries are formatted correctly, but
> not existing entries. It works for the date column if you select date as the
> column type in the import dialog, but you cannot choose currency as column
> type.
Correct
> I'm tempted to think that this is either a missing feature (no column type
> "currency" in the import dialog) or incorrect saving/exporting behavior by
> Calc (the cell format should only affect how the values are displayed, not
> how they are stored in the file). So, what should I do:
>
> * File a bug/feature request? If yes, where can I do that?
File a feature request for a currency data type
> * Work around the issue? What would that workaround be??
Work around appears to be import as standard, then format the column as 
desired. Also, once the data is imported save the Calc spreadsheet as 
*.ods to preserve formating.

I have seen with dates when I manual format an imported column Calc adds 
a ' to the original data treating the entry as text not a date. This 
occurs when I leave the import data type as standard not as date.
> * Or am I using Calc the wrong way?
>
> Any suggestions appreciated...
>
> Thanks, Bernhard
>
> --
> View this message in context: 
> http://nabble.documentfoundation.org/Cell-formatting-with-CSV-files-in-Calc-tp3557689p3557689.html
> Sent from the Users mailing list archive at Nabble.com.


--
Jay Lozier
jslozier@gmail.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