ONLYOFFICE Docs v7.3 released: enhanced forms, SmartArt, new security settings, Watch Window, and more
ONLYOFFICE Docs v7.3 released

Spreadsheet Editor doesn't remember format

my spreadsheet editor does not save some formating options, in this case “EURO Format” and “Column Width”.

EURO Format:
I want my numbers to be shown as “X.XXX,XX €” which works great with the formatting shortcut button in the “Start” Tab. However when i reopen the file after some time, or on another browser or device the formating changes to “XXXX,XX” - without the “.” and without the “€”.

Column Width:
Same problem. I assign specific column width, but when i open the document after some time, or on another browser or device the column width changes again.

I am using OnlyOffice within my nextcloud instance.
Spreadsheet Editor Version 7.0.0


Hi @GutmenschAlex

Can I ask you to provide a file to reproduce the problem?
You can upload it to some external storage and provide us with download link.

Sure, i extracted one sheet of my larger file: metamine Cloud

The formating options that onlyoffice doesn’t seem to remember are:

  • column width: I have to manually adjust column A, D and M everytime I reopen the file to keep the text within the column width
  • money format “X.XXX,XX €” - for some reason it switches to “XXXX,XX”

This is how it looks like everytime I open the file:
2023-03-19 16_01_29-Window

And this i how I would like it to look (see next comment, because I am only allowed one image per post)

And this i how I would like it to look (see previous comment for context)

2023-03-19 16_02_04-Window


Thank you, @GutmenschAlex, for the information.
I want you to pay attention that you are using an outdated version of Document Server, the actual version is 7.3.3.

I Can’t reproduce this on 7.3.3.
Please provide a detailed description of editing and saving the file to reproduce the situation. And attach the original file (no changes made)