<html> <head> <base href="https://bugs.documentfoundation.org/"> </head> <body> <div> <a class="bz_bug_link bz_status_NEEDINFO " title="NEEDINFO - FILEOPEN Excel 2003 XML: DateTime cells imported wrong" href="https://bugs.documentfoundation.org/show_bug.cgi?id=86100#c13">Comment # 13</a> on <a class="bz_bug_link bz_status_NEEDINFO " title="NEEDINFO - FILEOPEN Excel 2003 XML: DateTime cells imported wrong" href="https://bugs.documentfoundation.org/show_bug.cgi?id=86100">bug 86100</a> from <a class="email" href="mailto:tk@mic-consulting.de" title="Thomas Krumbein <tk@mic-consulting.de>"> Thomas Krumbein</a> <pre>Hi Timur, well, all Infomations can be found in <a class="bz_bug_link bz_status_RESOLVED bz_closed" title="RESOLVED WORKSFORME - FILEOPEN Excel 2003 XML (special source?) Cells ranges are imported with ']' at the end of the names, resulting in errors" href="show_bug.cgi?id=86097">Bug #86097</a>. This is not the same bug as descriped in <a class="bz_bug_link bz_status_NEW " title="NEW - Fileopen XML: Date format not recognized in a column and opened as general number (comment 6)" href="show_bug.cgi?id=103024">Bug #103024</a> !! I cannot give any information to this bug. But back to <a class="bz_bug_link bz_status_RESOLVED bz_closed" title="RESOLVED WORKSFORME - FILEOPEN Excel 2003 XML (special source?) Cells ranges are imported with ']' at the end of the names, resulting in errors" href="show_bug.cgi?id=86097">bug #86097</a> : See pic "file open in calc" (attachment 2) - Date-values where always imported as "0" - but with right cell-format. Now: Date value is correct, (i.e. 43213) but cell format is wrong (numeric) - changing to "date", everythig is ok. File is attachment 4 in <a class="bz_bug_link bz_status_RESOLVED bz_closed" title="RESOLVED WORKSFORME - FILEOPEN Excel 2003 XML (special source?) Cells ranges are imported with ']' at the end of the names, resulting in errors" href="show_bug.cgi?id=86097">Bug #86097</a> (original Excel file). Hope, this helps you. btw: I have tested it with a actual file provided by Amazon - maybe the have changed there output? But: in Version LO 5.3.x it is still not working (as descriped in <a class="bz_bug_link bz_status_RESOLVED bz_closed" title="RESOLVED WORKSFORME - FILEOPEN Excel 2003 XML (special source?) Cells ranges are imported with ']' at the end of the names, resulting in errors" href="show_bug.cgi?id=86097">bug #86097</a>) , in Lo 6.1.3 values will be shown. best regrads Tom</pre> </div> <hr> You are receiving this mail because: <ul> <li>You are the assignee for the bug.</li> </ul> </body> </html>