Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

There is also another potential explanation: explosion of conditional formats.

If you have conditional formatting on a cell or row, and you copy or extend it or copy format, another conditional format entries are created. It is trivially easy to go from one row in the conditional format manager to hundreds or thousands of entries. This will make Libre Office run very slowly.

If this is your situation, there are two options:

  • delete all conditional formats

  • edit one conditional format to cover the entire range of cells and delete all the other entries.