Download it now!
Bug 94643 - FILESAVE : Date format lost when exporting to XML
Summary: FILESAVE : Date format lost when exporting to XML
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected)
Inherited From OOo
Hardware: All All
: medium normal
Assignee: Not Assigned
Depends on:
Blocks: MSO-XML2003
  Show dependency treegraph
Reported: 2015-09-30 14:35 UTC by jmgigandet
Modified: 2019-09-02 09:59 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:

Test file (2.08 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2015-09-30 14:35 UTC, jmgigandet

Note You need to log in before you can comment on or make changes to this bug.
Description jmgigandet 2015-09-30 14:35:35 UTC
Created attachment 119140 [details]
Test file

Same as bug 88019 which has been closed.
When saving an XML (text) spreadsheet, date format is lost.
Attached an example file.
- Open the file.
- Date is show in short date format.
- Change the date format of the cell to DD/MM/YYYY (european format).
- Save.
- Re-open.
- Date format has been lost.
Comment 1 raal 2015-10-01 16:40:31 UTC
I can confirm with Version:
Build ID: 83ef294dddf3b1ab5cd5f91a792a7d9413a08f1f
TinderBox: Linux-rpm_deb-x86_64@70-TDF, Branch:master, Time: 2015-09-20_07:00:46
Comment 2 QA Administrators 2016-11-08 10:39:27 UTC Comment hidden (obsolete)
Comment 3 jmgigandet 2016-11-08 11:07:46 UTC Comment hidden (obsolete)
Comment 4 QA Administrators 2017-11-09 07:43:43 UTC Comment hidden (obsolete)
Comment 5 jmgigandet 2017-11-09 08:49:02 UTC
Bug is still present on (Win 7 x64 pro) and (MacOSX 10.11.6)
Comment 6 Timur 2018-11-01 17:03:39 UTC Comment hidden (obsolete)
Comment 7 Timur 2018-11-01 18:10:18 UTC
"- Date is show in short date format." probably means 7-9-15.
"- Save." Now it's "Export to XML".

Bug repro with Lo 6.0. Cannot be tested with 6.2+ due to fileopen Bug 103024.
Comment 8 Timur 2019-09-02 09:59:39 UTC
If we open attched  Bug_Date_Format.xml we can see:
	<NumberFormat ss:Format="Short Date"/>
It remains the same after resave. Repro 6.4+ and OO so I set Inherited.
In Excel, this is changed to: 
   <NumberFormat ss:Format="[$-1141A]dd/mm/yyyy;@"/>