Issue 15566 - date & number formatting lost on export to CSV
Summary: date & number formatting lost on export to CSV
Status: CLOSED DUPLICATE of issue 4925
Alias: None
Product: Calc
Classification: Application
Component: code (show other issues)
Version: OOo 1.0.3
Hardware: PC Linux, all
: P3 Trivial (vote)
Target Milestone: ---
Assignee: oc
QA Contact: issues@sc
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2003-06-12 19:51 UTC by Unknown
Modified: 2003-09-08 16:55 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 Unknown 2003-06-12 19:51:43 UTC 
When exporting to CSV, dates are often exported as 06/01/2003 regardless of the
format assigned in the spreadsheet.  I often use OO spreadsheets to manipulate
data from Excel going into mySQL tables.  Since mySQL requires dates to be of
the format YYYYMMDD, I apply this format in OO but lose it when I export to CSV,
and then have to write Perl scripts to change the formatting back.  If dates are
actually entered or imported in the format 20030601 then the formatting sticks,
but if the date is entered as 06/01/2003 or June 1, 2003 then the dates export
as 06/01/2003 regardless of formatting applied to the cells.

Numbers also lose their formatting; currency values export as "24" and "24.7"
instead of $24.00 and $24.70 or 24.70, regardless of the formatting applied in
the spreadsheet.
Comment 1 frank 2003-09-03 13:07:14 UTC 
Hi,

this is a duplicate to Issue 4925.

Therefore I've set the flags.

Frank

*** This issue has been marked as a duplicate of 4925 ***
Comment 2 frank 2003-09-03 13:07:31 UTC 
closed double