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

2019-10-04 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=121851 --- Comment #12 from ysang...@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

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

2019-08-01 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=121851 --- Comment #11 from rsneha --- Check out this site : https://timely.is/ -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list

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

2019-02-10 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=121851 --- Comment #10 from mikeclemmons_2...@yahoo.com --- Also hit by this bug. I use Calc to record brokerage transactions. These are executed in the time zone of the New York Stock Exchange (UTC-5). My broker sends a list of transactions in

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

2019-01-29 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=121851 --- Comment #9 from Eike Rathke --- Everyone talking about a maybe theoretically possible time zone support, please be aware that in spreadsheet context a date+time value is one single numeric floating point value in days since null date

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

2019-01-22 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=121851 --- Comment #8 from Libomark --- Not sure that works. Consider a timestamp inserted the day before a change from daylight savings time to standard time, viewed the day after. Consider a timestamp made at 01:45 the day that the time

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

2019-01-18 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=121851 --- Comment #7 from Dan Dascalescu --- I'm a developer, albeit not a Java one, so maybe I'm wrong. Why would it be so complicated to store timestamps in UTC? I've already shown in my previous comment that date fields already have a 'Z'

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

2019-01-18 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=121851 --- Comment #6 from Libomark --- I suspect this would turn into a nightmare to maintain, because time zones and daylight savings time date changes are subject to constant change on political whim. Expecting these events all to be

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

2019-01-15 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=121851 --- Comment #5 from Xisco FaulĂ­ --- *** Bug 121781 has been marked as a duplicate of this bug. *** -- You are receiving this mail because: You are the assignee for the bug.___

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

2019-01-14 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=121851 --- Comment #4 from Dan Dascalescu --- Created attachment 148321 --> https://bugs.documentfoundation.org/attachment.cgi?id=148321=edit The timezone is expressed as "Z" in content.xml -- You are receiving this mail because: You are

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

2019-01-14 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=121851 --- Comment #3 from Dan Dascalescu --- I've had a second look at the underlying content.xml file of the .ODS that I've attached to my first ticket. The timezone information is included as "Z" (Zulu/UTC time) in the

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

2019-01-14 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=121851 Xisco FaulĂ­ changed: What|Removed |Added See Also||https://bugs.documentfounda

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

2018-12-09 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=121851 Roman Kuznetsov <79045_79...@mail.ru> changed: What|Removed |Added Blocks||107977

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

2018-12-04 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=121851 Eike Rathke changed: What|Removed |Added Severity|normal |enhancement

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

2018-12-04 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=121851 Roman Kuznetsov <79045_79...@mail.ru> changed: What|Removed |Added CC|