Issue 34958 - CSV Save of Spreadsheet loses number formatting
Summary: CSV Save of Spreadsheet loses number formatting
Status: CLOSED DUPLICATE of issue 4925
Alias: None
Product: Calc
Classification: Application
Component: save-export (show other issues)
Version: OOo 1.1.2
Hardware: All All
: P4 Trivial (vote)
Target Milestone: ---
Assignee: spreadsheet
QA Contact: issues@sc
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2004-10-04 16:39 UTC by sgmsbro
Modified: 2004-10-05 08:51 UTC (History)
1 user (show)

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


Attachments

Note You need to log in before you can comment on or make changes to this issue.
Description sgmsbro 2004-10-04 16:39:39 UTC
Description:
Saving a spreadsheet with numbers ending in ".00" as a CSV file loses the
formatting of the numbers. 

In OOo, create a new spreadsheet and type in some number values in a column.
Something like:

1.00
3.45
5.00
6.32

The 1.00 and 5.00 get changed to 1 and 5 respectively. Formatting the cells to
show two decimal places "fixes" the display. 

In Excel, saving the displayed 2 decimal places as a CSV file will actually
carry over to the CSV file. But OOo would save this CSV file as

1
3.45
5
6.32

When it should save as shown.

I work with spreadsheets that need to be saved as CSV files for import into a
database application. The import needs to be flawless...if the database is
expecting "7.00" and it sees "7" instead, the import errors out. Since OOo is
actually superior in handling CSV files when compared to Excel, because of this
problem, it's very difficult for me to use OOo for my CSV work.
Comment 1 frank 2004-10-05 08:51:18 UTC
Hi,

this is a double to Issue 4925. Also the Prio is much to high. I've corrected this.

Frank

*** This issue has been marked as a duplicate of 4925 ***
Comment 2 frank 2004-10-05 08:51:40 UTC
closed double