Prevent LibreOffice Calc from deleting custom styles and changing conditional styles

CaooFantasma97 · June 6, 2018, 7:15pm

This is a MASSIVE problem I’m having since I ever remember starting using libreoffice a few months ago. Recently I installed the experimental version but the issue persists here too.

Any time I create a new style, no matter which way (from scratch, from selection, from the conditional formatting contextual menu…), after saving and exiting the file, it will be lost forever. Entering the file from any PC, including the same one it was created with, the created style will be missing, and any cell assigned to that style will be changed to a completely random one among the default ones. Cells that didn’t get applied a style but rather visually modified with the other tools (background fill, text color, etc) will keep the graphical formatting.

This bug renders impossible using conditional formatting and saving styles to be used later or in other files. And conditional formatting is more than essential in accounting entries, mill rates, payments tracking, etc, for how packed with values, numbers and text are.

hjek · June 6, 2018, 8:06pm

I can’t reproduce this issue. Does this happen every time you save any spreadsheet with a custom style, or does it only happen under certain conditions?

kompilainenn · June 6, 2018, 8:47pm

which format do you use for saving your spreadsheets? ODS or XLS(X)?

CaooFantasma97 · June 8, 2018, 2:00pm

xlsx for as I sometimes need stuff to be readable even for other users without libreoffice.

kompilainenn · June 8, 2018, 2:42pm

can you show us your file with problem?

AlexKemp · May 15, 2021, 9:52pm

You need to store LO files under their native filetype. That means, as an example, that Calc files should be stored as an ODS. If those files then suffer the sort of problems that you are reporting, then it will be a clear bug.

If you then wish to send a copy of your spreadsheet to someone using Excel, it can be exported in a filetype that will be more sympathetic for that user (and hopefully will export accurately). However, do not expect to be able to edit & store the file within a foreign format without constant glitches.