Issue 52529 - csv export loses number format
Summary: csv export loses number format
Status: CLOSED DUPLICATE of issue 4925
Alias: None
Product: Calc
Classification: Application
Component: save-export (show other issues)
Version: OOo 2.0 Beta
Hardware: All All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: spreadsheet
QA Contact: issues@sc
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2005-07-27 08:47 UTC by markellse
Modified: 2005-07-28 12:40 UTC (History)
1 user (show)

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

Attachments
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 markellse 2005-07-27 08:47:33 UTC 
When calc exports a spreadsheet cell containing the number "3.00", it exports
the number as "3". There appears to be no way of formatting the cell so that it
exports as "3.00". This causes problems when exporting data to financial
packages which, in the absence of a decimal point, will interpret "3" as "0.03".

(Excel, however, if you format a number in a cell as "3.00" will export it as
"3.00")

This issue applies to all versions of OOo from 1.1 to 2.0 beta. It is important
to solve because the facility is needed and for compatibilty with Excel.
Comment 1 frank 2005-07-27 10:19:26 UTC 
Not a bug, not Prio 2 and also a double which could be easily found.

*** This issue has been marked as a duplicate of 4925 ***
Comment 2 frank 2005-07-27 10:19:49 UTC 
closed double
Comment 3 markellse 2005-07-28 12:40:29 UTC 
Apologies for the duplication. Did search for issues. Don't know why I didn't
clock 4925.