Calc: Styles don't keep changes

I’m working with an spreadsheet and trying to use some styles in order to identify some alerts depending on the content of some specific cells. I’ve created my own styles in order to do so. But once I saved the file, close it and reopen it, the style list shows new styles named ConditionalStyle_X for each new style that I create. Also the Conditional format of the cell now refers to the new ConditionalStyle_X. Furthermore, if I try to change anything on this new Conditional Style it changes at first but once I save, close and reopen the file the changes are gone. I’m using LO 7.1 on Xubuntu 20.04. Also I’m using the file extension .xlsx for compatibility when I share the file with my boss.

If someone have any solution, it’ll be much appreciated. Thanks in advance.

This is precisely the cause of the problem!

1 Like