Function TEXT()

Docs
,
1

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

2

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.

3

Hi,

Document Server is integrated with Alfresco.

Sample:
I create formula like this

image
image777×258 12.9 KB

The result is ok and it works well.

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

4

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

image
image770×226 8.84 KB

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

5

I translate the format to yyyymmdd. It works.

image
image780×273 9.74 KB

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