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

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.

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?
* Work around the issue? What would that workaround be??
* 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.

-- 
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