[Bug 163723] Missing time, datetime formats including timezones

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=163723

Eyal Rozenberg <eyalroz1 at gmx.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Blocks|                            |163222

--- Comment #5 from Eyal Rozenberg <eyalroz1 at gmx.com> ---
(In reply to Eike Rathke from comment #3)
> Right, internally a date+time is just a floating point number expressing the
> serial offset from the null date (1899-12-30T00:00:00). It can not carry any
> timezone information whatsoever.

Ah, so it seems it's an ODF compliance bug! ODF 1.2 §18.3.14 already requires
support for timezoned values (based on XML Schema 2).

> Displaying timezones or accepting them in
> input would only be possible if the date+time type and its calculation was
> changed, and timezone information be discarded when storing to alien file
> formats like Excel's.

Fair enough. It wouldn't be the only case of us having to discard information
because Excel doesn't support some ODF feature...

In fact, if we add this capability - it's something we can tout in marketing,
an improvement over MS Office :-)


Referenced Bugs:

https://bugs.documentfoundation.org/show_bug.cgi?id=163222
[Bug 163222] [META] Complete ODF-1.2 Support
-- 
You are receiving this mail because:
You are on the CC list for the bug.