[Issue 80758] Bad date format imported from Excel XML

[bu...@apache.org]

https://bz.apache.org/ooo/show_bug.cgi?id=80758

damjan@apache.org changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |damjan@apache.org

--- Comment #6 from damjan@apache.org ---
(In reply to joghurt from comment #0)
> 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.)

The Windows date format is NOT saved into the Excel 2003 XML file.

> 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"/>

Yes and the "s29" style won't store the custom "YYYY-MM-DD" format, only "Short
Date". Even Excel will open that document differently on a different Windows
instance with a different short date format.

-- 
You are receiving this mail because:
You are on the CC list for the issue.
You are the assignee for the issue.