ONLYOFFICE 7.0: online forms, password protection in sheets, collaboration improvements and much more
ONLYOFFICE 7.0 released

Spreadsheet NOW() function

Document Server version: latest
Type of installation of the Document Server: docker
OS: Windows 10
Browser version: Latest Firefox

Having this issue in a spreadsheet when i use the NOW() function.
The docker container is in UTC and shows Tue 22 Mar 2022 10:33:43 PM UTC

In my spreadsheet if i format one cell for date and the other cell for time i get the following

3/22/2022
8:33:43 AM

This is displaying the correct time offset for my time zone however the date is still showing as the UTC date.

Formatting as both date and time i get “3/22/22 8:36 AM”.

Am i doing something obviously wrong here?

edit: Looks like this is an ongoing issue https://github.com/ONLYOFFICE/DocumentServer/issues/1178

I am surprised this has not been fixed in the year since its been discovered :confused:

Hello @antman
I’m not sure that I understand an issue right. It looks like you are describing different scenario. In the mentioned bug, an issue with incorrect date is registered (we are still working on it). In your scenario date\time is correct. Please clarify what your final goal?

Hi @Alexandre

Apologies it looks like i typed that out too fast and showed it incorrectly.

Here is an example i have in there right now. The date right now is the 25th.

[ 24/3/22 7:52 AM ] → =NOW() ← Note this is GMT time and UTC date.

This in an example of my quick workaround. F11 is my offset where i just add a day to the time if the hour is less. Seems to work for what i need.

[ 25/3/22 7:52 AM ] → =IF(HOUR(NOW())<F11,NOW()+1,NOW())

We are checking the situation. I will update this post, when we get any news.

Hello @antman
The mentioned issue will be fixed in DS v.7.1 (internal bug numbers - 49028, 49032). The release is planned in April.
Thank you for pointing us to this situation.