https://bugs.freedesktop.org/show_bug.cgi?id=65354
Lionel Elie Mamane <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|NEW |RESOLVED Resolution|--- |INVALID --- Comment #5 from Lionel Elie Mamane <[email protected]> --- After some more analysis / more thought, I rest on "it is not supposed to work at all". It cannot work. Use TEXT(NOW(); "HH:mm:ss z") instead of TIMEVALUE(NOW()) Here's what happens: NOW() returns a Date+Time, with timezone information and all. So when you do the formula "blah blah " & NOW() you get the default formatting, which is the Java "FULL", including timezone. Which is determined correctly because it has a date to rely one, so it can apply daylight time saving rules. When you do TIMEVALUE(NOW()) you strip the date away. When you then append a string to that, again default formatting, that is Java "FULL". Which slaps the winter timezone on it, probably because "no time" is understood as "1 January 1900" or some such. Now, you'll (maybe?) tell me that slapping a timezone on a time-without-date does not make sense, precisely because there is ambiguity between winter time and summer time. So the default formatting of a time should not include any timezone. And I do agree with that. -- You are receiving this mail because: You are the assignee for the bug.
_______________________________________________ Libreoffice-bugs mailing list [email protected] http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
