https://bz.apache.org/ooo/show_bug.cgi?id=80758
[email protected] changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |[email protected] --- Comment #6 from [email protected] --- (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.
