Function TEXT()

[Jonathan]

Hello,
I have onlyoffice-documentserver-ee 7.0.1-37 on Centos 7
My OnlyOffice is in French

The bug is in Spreadsheets doc:

When I use the Text(date,format) function, the format value is also in French
ex: format in french (aaaammjj) (In English (yyyymmdd))

It works, I have results. But when I close the editor and go back to the document, the function displays the format and not the result.

When I go to settings, go to regional settings and put it in English. I translate the format to yyyymmdd. It works and when I go back to the document it also works.

Thank you

Jonathan

[Carl]

Hello Jonathan,

Please specify the platform your Document Server is integrated with (Nextcloud, ownCloud etc).

Also please record a video with how you reproduce the issue.

[Jonathan]

Hi,

Document Server is integrated with Alfresco.

Sample:
I create formula like this

The result is ok and it works well.

(sorry I can’t post more than 1 img in one post)

[Jonathan]

But when I close the editor and go back to the document it displays wrong:

When I go to settings, go to regional settings and put it in English.

[Jonathan]

I translate the format to yyyymmdd. It works.

I close the editor and when I go back to the document it also works the result is displayed.

I think the issue comes from the interpretation of the translation in parameter “format” in a formula.

Jonathan