https://bugs.documentfoundation.org/show_bug.cgi?id=142216
Eike Rathke <[email protected]> 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 <[email protected]> ---
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._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs