[Libreoffice-bugs] [Bug 139934] FILEOPEN: Date is shown as an integer
bugzilla-daemon at bugs.documentfoundation.org
bugzilla-daemon at bugs.documentfoundation.org
Thu Jan 28 12:23:21 UTC 2021
https://bugs.documentfoundation.org/show_bug.cgi?id=139934
--- Comment #10 from Eike Rathke <erack at redhat.com> ---
The .xlsx attached here is in the old Excel interim XML file format that
LibreOffice only partially supports, and number formats given as some default
format IDs with cellXfs
<xf numFmtId="..." ...>
apparently are not supported by this filter.
To solve the problem, save the file in Excel once in the standard OOXML .xlsx
format and it likely will work also in LibreOffice. Or apply the date format in
LibreOffice and save as Excel 2007-365 .xlsx, which should fix things as well.
--
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/20210128/ad08b137/attachment.htm>
More information about the Libreoffice-bugs
mailing list