[Libreoffice-bugs] [Bug 121851] Calc loses time zone information for datetime cells

[bugzilla-daemon at bugs.documentfoundation.org]

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

--- Comment #12 from ysangkok at gmail.com ---
To begin supporting time zones, it would be necessary to first support them in
the internal structures.

I have been exploring how I can insert the current UTC time into a spreadsheet.

The Basic expression "Now" returns a value of type "Variant/Date" which shows
no time zone information in the Basic debugger.

I tried "CDateToUnoDateTime(Now)" which returns a struct with a "isUTC" field.
Since this is a boolean, it is not sufficient for me convert to UTC myself.

The IDL file is here:
https://github.com/LibreOffice/core/blob/master/offapi/com/sun/star/util/DateTime.idl

Irregardless of what the file formats support, it would be nice to at least
have an enriched UTCDateTime type available in Basic.

Right now, I am resorting to calling into Python just to get the UTC time,
which seems a bit ridiculous.

-- 
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/20191004/d653bf62/attachment.html>