Wrong default date time format.

[kamilko]

In spreadsheet comments or tooltip long date is always formatted as M/D/Y type.

How to reproduce:

• have your zone date format as D/M/Y
• add comment (while doing this, comment date will be displayed properly)
• save comment and then display comment tooltip
• date format will be always as M/D/Y

This was tested on many different version of Nextcloud as well as many different version of OS (mostly Debian and Ubuntu, also snap version of Nextcloud).
Also it doesn't matter what locale is on server or user system, as long it isn't M/D/Y.

[timur-g]

@kamilko this seem to depend on the sheet, and NC locale settings. Please attach test sheet. Today is 01 Feb so you may write there to be clear, when show wrongly it is 02 Jan, please take screenshots and put in the file aside to the comments.
I cannot say why I see this in some sheets and not others, which does not seem related to cell format setting.

[kamilko]

This are another examples:


So writing comment dialog has proper date, but as soon as you save and hover over, you get US formatted date.

And also attached file from screenshots.
test.ods

As you can see, locale for server are set as PL however tooltip has US date. BTW there are some part which are always not translated when richdocummentscode is used. To get everything in PL standalone CODE server must be installed and all the localized libraries must be with -pl version - but I digress.

ServerOS: Ubuntu LTS 22.04 with Nextcloud installed as snap package.