https://bugs.documentfoundation.org/show_bug.cgi?id=163723
--- Comment #18 from Eyal Rozenberg <[email protected]> --- (In reply to Eike Rathke from comment #17) > In spreadsheet context, ODF Formula (ODFF) v1.3 We're not talking about "ODF Formula", but ODF generally. > (and please stop citing > outdated ODF 1.2, though in this case information is the same) I cited ODF 1.2 to show that the ODF support for timezones in datetime values is some recent novelty but has been around for quite a while. ODF 1.4 defines the same thing, in the same place: https://docs.oasis-open.org/office/OpenDocument/v1.4/csd01/part3-schema/OpenDocument-v1.4-csd01-part3-schema.html#__RefHeading__1416564_253892949 > §18.3.14 dateOrDateTime > > A dateOrDateTime value is either an ... date value or an > [XMLSchema-2](https://www.w3.org/TR/2004/REC-xmlschema-2-20041028/#dateTime) > dateTime value. And an XML2 dateTime value is > §3.2.7.1 Lexical representation > > ... finite-length sequences of characters of the form: > > '-'? yyyy '-' mm '-' dd 'T' hh ':' mm ':' ss ('.' s+)? (zzzzzz)? > and there is a bunch of additional text about timezones. > There is no way to express and transport timezone information in a subtype > of Number. A datetime is not a subtype of number. To quote the XML schema document again, > 3.2.7 dateTime > [Definition:] dateTime values may be viewed as objects with integer-valued > year, month, day, hour and minute properties, a decimal-valued second > property, and a boolean timezoned property. Each such object also has one > decimal-valued method or computed property, timeOnTimeline, whose value is > always a decimal number; the values are dimensioned in seconds, the integer > 0 is 0001-01-01T00:00:00 and the value of timeOnTimeline for other dateTime > values is computed using the Gregorian algorithm as modified for > leap-seconds. The timeOnTimeline values form two related "timelines", one > for timezoned values and one for non-timezoned values. Each timeline is a > copy of the ·value space· of decimal, with integers given units of seconds. -- You are receiving this mail because: You are the assignee for the bug.
