[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