French date format problem

Any issues about docs (uploading, editing and etc.)
Post Reply
oograccount
Posts: 2
Joined: Fri Sep 13, 2019 7:43 am

French date format problem

Post by oograccount » Fri Sep 13, 2019 7:57 am

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
Posts: 59
Joined: Mon Apr 01, 2019 1:09 pm

Re: French date format problem

Post by Andrew » Mon Sep 16, 2019 11:09 am

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
Posts: 2
Joined: Fri Sep 13, 2019 7:43 am

Re: French date format problem

Post by oograccount » Thu Sep 19, 2019 7:06 am

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
Posts: 59
Joined: Mon Apr 01, 2019 1:09 pm

Re: French date format problem

Post by Andrew » Fri Sep 20, 2019 2:02 pm

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.

Post Reply