Issue 11399 - Comma Delimeted Files Refuse to preserve Numeric Formatting
Summary: Comma Delimeted Files Refuse to preserve Numeric Formatting
Status: CONFIRMED
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:
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2003-02-11 22:18 UTC by Unknown
Modified: 2013-02-07 22:41 UTC (History)
1 user (show)

See Also:
Issue Type: ENHANCEMENT
Latest Confirmation in: ---
Developer Difficulty: ---

Attachments
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
Add an attachment (proposed patch, testcase, etc.)

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

ex:
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 
Hi,

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.

Frank
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".