https://bugs.documentfoundation.org/show_bug.cgi?id=163723
Bug ID: 163723
Summary: Missing time, datetime formats inclduing timezones
Product: LibreOffice
Version: 24.8.2.1 release
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: minor
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
A full specification of a (non-UTC) date-and-time/timestamp, according to ISO
standard 8601, should specify the timezone (as an offset from UTC). For
example, one of the standard-defined formats for a combined specification looks
like:
2024-11-01T18:42:40+01:00
that is,
Date: 2024-11-01
Time: 18:42:40
Timezone: +01:00
Unfortunately, the date and time format lists in our Format > Cells... dialog
do not offer any items involving timezones. While I suppose one can specify
them as a custom format - users would need to know how to do so (if it's at all
possible) - and they would not be able to avail themselves of any examples in
the dialog.
We need to add a few formats involving timeszones, at the very least those for
full combined date and time specifications, to the list in the dialog. As these
are standard formats (if not _the_ standard format), not having any of them
should be considered as a bug.
--
You are receiving this mail because:
You are the assignee for the bug.
