https://bugs.documentfoundation.org/show_bug.cgi?id=108588
Bug ID: 108588
Summary: incorrect cell date formatting in xlsx import.
Product: LibreOffice
Version: 5.3.3.2 release
Hardware: x86-64 (AMD64)
OS: Linux (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: libreoffice-bugs@lists.freedesktop.org
Reporter: k...@kvdb.net
Created attachment 134081
--> https://bugs.documentfoundation.org/attachment.cgi?id=134081&action=edit
Screenshot of LibreOffice Calc with cell properties.
I received this xlsx spreadsheet.
When selecting cell B3, the value shows as: 03/10/5777. That's not expected.
However, looking up on the data entry bar, it shows 01/01/2017: that's a value
I did expected.
I opened cell format properties. Seems the format code is DD/MM/EE. I didn't
touch any of this, so my guess is that the xlsx import filter isn't working as
expected.
I didn't verify this as I don't have Microsoft Excel, but I assume the author
of this spreadsheet sees a 4 digit year, not a 2 digit era.
--
You are receiving this mail because:
You are the assignee for the bug._______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
