Ctrl+; Inserting Tomorrow's Date

OS version: Windows 10, Ver 22H2 (OS Build 19045.5965)
App version: version 9.0.3.29 (x86 exe)
Downloaded from: ONLYOFFICE website

When I use Ctrl+; to insert today’s date, the spreadsheet inserts tomorrow’s date. I’m assuming there’s some point in the day where it switches over to tomorrow’s date, because it’s incorrectly assuming I’m in a different time zone. Is there a way to manually set the time?

Hello,
Please provide a screenshot of Settings > Time & Language > Date & Time. I’ve tested this and in my case the correct date is inserted (Windows 11, Desktop Editors 9.0.3)

The OnlyOffice settings? I don’t see a “Time & Language” section.

Sorry for the confusion, I meant the corresponding Windows settings

Sure. Here’s one screenshot showing the current date as 7/17, and OnlyOffice giving 7/18 via the Ctrl+; input.

Could you please check what gets inserted when you do it in a different editor?

Sure, here’s a screenshot of LibreOffice’s Calc working as expected top left, OnlyOffice giving tomorrow’s date on the bottom right.

Hello, we are currently checking, please wait

Hello,
Please clarify whether you changed the time zone while the editor window was open and continued working without restarting the editor after changing the time zone.

I’m not sure what you mean. I haven’t changed my time zone. The editor has been restarted multiple times by this point, and still puts in tomorrow’s date.

Understood, we are continuing the analysis. But please clarify - does the issue occur when you insert the date particularly in the evening time?

Yes, exactly. I’m assuming at some point during the day it’s switching over. Not sure exactly what time.

Understood. Please wait for further feedback from our side

And what are your System Regional Settings? System → Time & Language → Language & Region → Regional Format
What is your language setting in the Desktop Editors app? (Settings → Interface Language when opening the app)

Hello, we have reproduced the issue and added your request to our tracking system, we will inform you as soon as a version with the fix of this bug is released

Hello,
We have released Document server v.9.1. This release contains a fix for described situation. The desktop app will be available shortly.

I can confirm, after an update, the issue is resolved. Thanks!

1 Like