Issue 80758 - Bad date format imported from Excel XML
Summary: Bad date format imported from Excel XML
Alias: None
Product: Calc
Classification: Application
Component: open-import (show other issues)
Version: OOo 2.2.1
Hardware: PC Windows XP
: P4 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Depends on:
Reported: 2007-08-16 21:55 UTC by joghurt
Modified: 2013-08-07 15:14 UTC (History)
2 users (show)

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

screenshot for date format in Excel and Calc (124.07 KB, image/png)
2008-10-27 08:40 UTC, yuko
no flags Details
Excel SpreadSheet 2003 xml file (33.26 KB, text/xml)
2008-10-27 08:41 UTC, yuko
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description joghurt 2007-08-16 21:55:47 UTC
Preface: I've tried OOo 2.2.1 Hungarian on a Hungarian XP, and exported from a
Hungarian Excel. I expected dates keeping their format (YYYY-MM-DD, that's how
we use dates in Hungarian).

0. Change Windows short date format to something else than DD-MM-YY. (Try the
U.S. order MM-DD-YY, or the Japanese/Hungarian YY-MM-DD.)
1. Enter a date in Excel.
2. Format the cell to short date format.
3. Export spreadsheet in XML format.
4. Open in OOo Calc.
5. The date format will be D-M-YY instead of the short date format according to
the system/user default locale. In my case, it should have been YYYY-MM-DD.

Inside the XML file:

<Cell ss:StyleID="s29"><Data

while "s29" defines <NumberFormat ss:Format="Short Date"/>
Comment 1 frank 2007-10-12 09:31:08 UTC
Hi Swante,

one more for you. Proceed as needed.

Comment 2 yuko 2008-10-27 08:39:26 UTC
This issue occurs in OOo 3.0.
The date format "YYYY/MM/DD" in Excel is displayed as "DD-MM-YY" in OOo Calc.
Please see the attached screenshot.

Comment 3 yuko 2008-10-27 08:40:55 UTC
Created attachment 57486 [details]
screenshot for date format in Excel and Calc
Comment 4 yuko 2008-10-27 08:41:38 UTC
Created attachment 57487 [details]
Excel SpreadSheet 2003 xml file
Comment 5 svante.schubert 2008-10-27 18:31:11 UTC

thanks for the bug report.

Nevertheless, my work shifted to ODF OASIS Technical Comitee work, esp. metadata
in ODF 1.2 and ODFDOM as library, I won't be working on these filters any longer.

We here in Hamburg (Sun) are focusing on development the new OOXML (as Microsoft
does). If on the elder Microsoft 2003 XML format filters some fix is in need
from the community, we need as well someone from the community to fix it.

Changed therefore the status to "OOo Please help"..