Text() in Spreadsheet is not updated/evaluated

Docs
1

Wouldn’t call it a bug so far as I don’t know if I missed something. So let’s call it “something that does not work as expected”.

If I add the following formula in a cell, it doesn’t et evaluated automatically:

="Todays month and year: “&TEXT(A19,“MMMM”)&” "&TEXT(A19,“JJJJ”)

In A19 a date is stored.

Output after the spreadsheet as been loaded: =“Todays month and year: January JJJJ”.

Interesstingly, MMMM is evaluated, JJJ ist not.

If select the formula in the edit bar and press enter without changing anything, that specific cell is updated. All the others remain non-updated.

Interesstingly, the document’s language is German, the fields however are evaluated in english.

Happens on the local OnlyOffice client as well as on the docs server. So it does not seem to be a browser issue nor a presenation issue, is seems to be rather a core functionality issue.

So bottom line: Something’s not working as it should and it looks inconsistent. Any ideas if the problem is no my side or in OnlyOffice?

2

Hello @Notyetfullyconvinced

Assume I place todays’ date into A19 as 02.09.2026:

  • Using the formula provided it indeed shows up as “Todays month and year: January JJJJ”;
  • Changing Region and Formula language to German and Deutsch respectively, then contents are “Todays month and year: Februar 2026”;
  • Using English region and formula language and changing formula to ="Todays month and year: "&TEXT(A19,"MMMM")&" "&TEXT(A19,"YYYY") gives “Todays month and year: February 2026”.

Basically, you can see that regional settings/formula language and spelling in the formula affect the outputs. You can configure your settings in Advanced settings or change the fomula accordingly.