Ask Your Question

LO calc: now() shows UTC time, not time in system time zone

asked 2019-01-16 02:36:47 +0100

gbell12 gravatar image

Long time localc user, but a recent upgrade to either LO or my system broke this. If I put =NOW() in a cell, I used to get my local time, now I get UTC time. I'm on Ubuntu 16.04 LTS. /etc/timezone is Australia/Sydney Should localc be respecting the system time zone?

edit retag flag offensive close merge delete


Have you checked that the locale setting has not been changed? Tools -> Language Settings -> Locale.

ve3oat gravatar imageve3oat ( 2019-01-16 03:31:34 +0100 )edit

The LibreOffice locale setting does not influence the result of NOW().

erAck gravatar imageerAck ( 2019-01-16 18:37:18 +0100 )edit

That's good to know. Thanks!

ve3oat gravatar imageve3oat ( 2019-01-16 20:01:58 +0100 )edit

1 Answer

Sort by » oldest newest most voted

answered 2019-01-16 18:41:06 +0100

erAck gravatar image

updated 2019-01-16 18:43:05 +0100

Check that your user account settings do not override the /etc/timezone location (try in a terminal shell the command date) and a possible shell invoking soffice does not have TZ=UTC set or some such.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2019-01-16 02:36:47 +0100

Seen: 30 times

Last updated: Jan 16