Apache OpenOffice (AOO) Bugzilla – Issue 80758
Bad date format imported from Excel XML
Last modified: 2013-08-07 15:14:53 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 ss:Type="DateTime">2007-06-02T00:00:00.000</Data></Cell> while "s29" defines <NumberFormat ss:Format="Short Date"/>
Hi Swante, one more for you. Proceed as needed. Frank
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.
Created attachment 57486 [details] screenshot for date format in Excel and Calc
Created attachment 57487 [details] Excel SpreadSheet 2003 xml file
Hi, 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"..