Issue 33363

Summary: Export to CSV: dates always exportet in the langauges' default format
Product: Calc Reporter: white_rabbit <mic01>
Component: save-exportAssignee: spreadsheet <spreadsheet>
Status: CLOSED DUPLICATE QA Contact: issues@sc <issues>
Severity: Trivial    
Priority: P3 CC: issues, lohmaier
Version: OOo 1.1.1Keywords: oooqa
Target Milestone: ---   
Hardware: All   
OS: All   
Issue Type: DEFECT Latest Confirmation in: ---
Developer Difficulty: ---
Attachments:
Description Flags
cells containing dates formatted with different languages none

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