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
jsloz...@gmail.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