Prevent LibreOffice Calc from deleting custom styles and changing conditional styles

asked 2018-06-06 21:15:06 +0200

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.

edit retag flag offensive close merge delete


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?

hjek gravatar imagehjek ( 2018-06-06 22:06:28 +0200 )edit

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

kompilainenn gravatar imagekompilainenn ( 2018-06-06 22:47:51 +0200 )edit

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

CaooFantasma97 gravatar imageCaooFantasma97 ( 2018-06-08 16:00:31 +0200 )edit

can you show us your file with problem?

kompilainenn gravatar imagekompilainenn ( 2018-06-08 16:42:07 +0200 )edit