Apache OpenOffice (AOO) Bugzilla – Issue 82849
Excel XML filter loses dates
Last modified: 2014-01-16 13:49:04 UTC
When importing Excel XML files, the dates are badly imported. See Screenshots. You can test with the example file
Created attachment 49067 [details] The example file under Excel
Created attachment 49068 [details] The file opened under OOo
Created attachment 49069 [details] The example file
Hi Swante, please proceed aas needed. I think such tasks should be closed in favour of the new MSO XML filters. Frank
*** Issue 83023 has been marked as a duplicate of this issue. ***
Hi! How do I use "the new MSO XML filters" in OOO 2.3 ? Uwe Kubosch Norway
Changed target to "OOo please help" as I need help from the community! The Office 2003 filters are no longer maintained by myself. My priority has shifted to the ODF file format and the ODF Toolkit project (e.g. ODFDOM) and even MS is working now on OOXML instead of their old XML 2003 formats, therefore Sun has been implemented and is now supporting the OOXML import filter with OOo 3.0. Kind regards, Svante
Created attachment 62628 [details] Adjust Excel 2003 XML import filter to accept complete datetime values
Created attachment 62629 [details] Unconditional treatment of Excel 2003 XML DateTime values as office:date-value.
The two patches I attached resolve this problem in different ways. The original filter examined the format applied to the cell to choose either the date or the time to import. In case no format was applied, it would import as date if the time part was exactly midnight. My patch #1 modifies the substring to import dates as date-times, and times as just times. My patch #2 unconditionally imports both date and time parts as a date-time. Comments, anyone?
Thanks pturmel, Patch 1 worked for me - date/time format now imports correctly from Excel xml file. (For users like me who are unfamiliar with OO xml filters, I modified the C:\Program Files (x86)\OpenOffice.org 3\Basis\share\xslt\import\spreadsheetml\spreadsheetml2000.xsl file by removing the line pturmel marked with a "-" and adding the line marked with a "+" in his/her attachment. I expect there may be a more elegant way of editing the file, but this worked for me)
*** Issue 115227 has been marked as a duplicate of this issue. ***