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")
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")
Does someone knows if i have a solution, if it's due to bug or feature?
thanks,