[Libreoffice-bugs] [Bug 142216] FILEOPEN XLSX Excel default time formats don’t match in Calc with Hungarian locale
bugzilla-daemon at bugs.documentfoundation.org
bugzilla-daemon at bugs.documentfoundation.org
Mon May 31 21:27:40 UTC 2021
https://bugs.documentfoundation.org/show_bug.cgi?id=142216
Eike Rathke <erack at redhat.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|UNCONFIRMED |NEW
Ever confirmed|0 |1
Version|7.2.0.0.alpha0+ |Inherited From OOo
--- Comment #6 from Eike Rathke <erack at redhat.com> ---
We can easily change the AM/PM representation from "DE" to "de." and "DU" to
"du."
If the default time formats are to be expected as not displaying leading 0 we
can of course also change those to H:MM and H:MM:SS
For both, AM/PM and time formats, the current definitions are from 2005 and
thus probably never had a review or were corrected, if they should have been.
Of course, changing them will affect all documents, not just .xls/.xlxs, unless
formats are explicitly assigned differently.
Note that the first time format in the attached .xlsx is stored as
<numFmt numFmtId="165" formatCode="[$-F400]h:mm:ss\ AM/PM"/>
with the [$-F400] meaning display in whatever system default time format you
have.
--
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/20210531/f3b22a1e/attachment.htm>
More information about the Libreoffice-bugs
mailing list