Issue 11399 - Comma Delimeted Files Refuse to preserve Numeric Formatting
Summary: Comma Delimeted Files Refuse to preserve Numeric Formatting
Alias: None
Product: Calc
Classification: Application
Component: ui (show other issues)
Version: OOo 1.0.1
Hardware: PC All
: P4 Trivial with 4 votes (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Depends on:
Reported: 2003-02-11 22:18 UTC by Unknown
Modified: 2013-02-07 22:41 UTC (History)
1 user (show)

See Also:
Latest Confirmation in: ---
Developer Difficulty: ---

gnumeric CSV export (127 bytes, text/plain)
2003-02-11 22:30 UTC, Unknown
no flags Details
openOffice1.0.1 CSV Export File (122 bytes, text/plain)
2003-02-11 22:31 UTC, Unknown
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description Unknown 2003-02-11 22:18:52 UTC
Normally when Excel or Gnumeric export to a csv file, using "" to denote text,
they preserve numerical formatting such as commas and dollar signs using quotes
to allow the commas to be included as a text field within the comma delimeted
field structure. OpenOffice Calc does not preserve the formatting. I use csv
files to create PDF files using PHP scripts... when the data comes in unformated
I have to parse it out... a much more simple process if the numerical data is
converted to text using quoted fields. I use the quote option on export... but I
haven't been able to truly reproduce the file format excel and gnumeric give me. jh

Excel/Gnumeric exported to csv: 123 ,"text,here","$1,900" ,0
OpenOffice exported to csv:     123 ,texthere , 1900 ,0
Comment 1 Unknown 2003-02-11 22:25:20 UTC
Of note: This formatting is not typed in... rather it is applied under
cell format, number, currency. Nearly the same way currency formatting
is applied in excell.
Comment 2 Unknown 2003-02-11 22:30:45 UTC
Created attachment 4665 [details]
gnumeric CSV export
Comment 3 Unknown 2003-02-11 22:31:36 UTC
Created attachment 4666 [details]
openOffice1.0.1 CSV Export File
Comment 4 frank 2003-02-13 09:23:48 UTC

for now the CSV Filter does not preserve the formats for currencys. So
this one is an enhancement and will be handled by Bettina.

I re-assign this Issue to her.

Comment 5 dolmen 2008-02-02 10:15:13 UTC
Comma is correctly exported in text fields at least in locale fr_FR in OOo 2.3.
"text, here" is correctly exported with quotes.
Comment 6 bettina.haberer 2010-05-21 15:00:46 UTC
To grep the issues easier via "requirements" I put the issues currently lying on
my owner to the owner "requirements".