Issue 33363 - Export to CSV: dates always exportet in the langauges' default format
Summary: Export to CSV: dates always exportet in the langauges' default format
Status: CLOSED DUPLICATE of issue 4925
Alias: None
Product: Calc
Classification: Application
Component: save-export (show other issues)
Version: OOo 1.1.1
Hardware: All All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: spreadsheet
QA Contact: issues@sc
URL:
Keywords: oooqa
Depends on:
Blocks:
 
Reported: 2004-08-24 18:26 UTC by white_rabbit
Modified: 2013-08-07 15:13 UTC (History)
2 users (show)

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

Attachments
cells containing dates formatted with different languages (5.77 KB, application/vnd.sun.xml.calc)
2004-08-30 20:22 UTC, lohmaier 		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 white_rabbit 2004-08-24 18:26:02 UTC 
Hi. I changed a Table with some dates to the Format YYYY-MM-DD.
When I export it to CSV and open it with a text editor it is again in
DD-MM-YYYY. I need the first format to import the CSV into a mySQL-DB. I guess
it's a bug?? Thanx,
White Rabbit
Comment 1 lohmaier 2004-08-30 20:21:43 UTC 
(component de is only for issues related to the german-speaking native-lang
project (basically everything on de.openoffice.org and related things), not for
the OpenOffie.org program. Please use wordprocessor, spreadsheet,
presentation,... instead -> reassigning).
confirmed with OOo 1.1.2 and OOo 1.9m51

Dates are exportet in the default format of the chosen language, no matter what
display format is selected.
To reproduce:
1) Open attached file.
2) Export to csv
3) Open csv in text editor.

Notice that the date is saved differently for each language (almost in default
format but with full year), even when the format is explicitly set to YYYY-MM-DD
it will be saved in the language specific format.
Comment 2 lohmaier 2004-08-30 20:22:54 UTC 
Created attachment 17441 [details]
cells containing dates formatted with different languages
Comment 3 lohmaier 2004-08-30 20:23:50 UTC 
forgot to reassign to default owner...
Comment 4 frank 2004-09-01 10:49:26 UTC 
Hi,

this is a double to Issue 4925.

Frank

*** This issue has been marked as a duplicate of 4925 ***
Comment 5 frank 2004-09-01 10:49:45 UTC 
closed double