[Libreoffice-bugs] [Bug 86100] FILEOPEN Excel 2003 XML: DateTime cells imported wrong

bugzilla-daemon at bugs.documentfoundation.org bugzilla-daemon at bugs.documentfoundation.org
Wed Nov 21 11:16:27 UTC 2018


https://bugs.documentfoundation.org/show_bug.cgi?id=86100

--- Comment #13 from Thomas Krumbein <tk at mic-consulting.de> ---
Hi Timur,

well, all Infomations can be found in Bug #86097. 

This is not the same bug as descriped in Bug #103024 !! I cannot give any
information to this bug. 

But back to bug #86097 : 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 Bug #86097 (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 bug #86097) , in Lo 6.1.3 values will be shown.

best regrads
Tom

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20181121/d15be079/attachment.html>


More information about the Libreoffice-bugs mailing list