French date format problem

[oograccount]

Hello,

i'm using a docker document server version, connected to nextcloud.

i have a problem with a spreadsheet we use in my company since 14 years in other software.

I have a column with dates ( day / month / year ) and in the summary at the top of the document there is a field with this formula :

Code: Select all

="Du "&TEXTE(MIN(A12:A39);"jj/mm/aaaa")&" au "&TEXTE(MAX(A12:A39);"jj/mm/aaaa")

to write to which period the document refers to (from datemin to datemax).

this fomula is working well on any excel/openoffice/libreoffice software, but it doesn't work on my documentserver.
If i want to make this function work i must use dd/mm/yyyy instead of jj/mm/aaaa
In advanced settings, language and regional settings are set to french.

If i'm modifying the formula, it works if opening from nextcloud in documentserver, but this formula does not work at all on french MS Office or french libreoffice anymore :

Code: Select all

="Du "&TEXTE(MIN(A12:A15);"dd/mm/yyyy")&" au "&TEXTE(MAX(A12:A15);"dd/mm/yyyy")

i don't find anything about date formats in the docs.

Does someone knows if i have a solution, if it's due to bug or feature?

thanks,

[Andrew]

Hello,

Please specify additional information about your installation:
1. Document Server version.
2. Nextcloud version.
3. Connector version in Nextcloud app store which you are using.

[oograccount]

Hello,

i'm using :
nextcloud 16.0.4
onlyoffice connector app 3.0.0
spreadsheet editor 5.4.0 (installed and upgraded with docker pull onlyoffice/documentserver:latest 14 days ago image)

about document server : i don't know which file or cmd line to check inside the docker container to check the version.

[Andrew]

Hello,

We added this to our bug tracking system and hope date format in french locale which you mentioned will be implemented in one of our future ONLYOFFICE versions.