Follow

why is libreoffice ignoring my conditional formatting rules and creates a white background if text color is set but background is set to blank :angry_trump:

i mean technically it is blank but it messes my previously set colors up obviously... my table is supposed to be gray

Show thread

@milan had to fight with something like this some time ago. Solution? No. I don‘t understand conditional formating in LibreOffice at all.

Ok. Sometimes it works. But often it does not.

@Photor it is unfortunate, i had this in a google sheet and wanted to move away from this solution... now colors and even formatting are messed up where conditions are set

@milan even worse: I have a working formatting and want to add another condition (e.g. high values in rec; now: put extreme high values in bold font) destroys the whole.

Really anoying.

@milan
Blind guess: Two sets of conditions on the same cell, and one contains the white background, as part of the formatting template it sets?
I prefer LO's conditional formatting to Excel's but don't usually use more than one set on the same cell.

Sign in to participate in the conversation
Mastodon

The social network of the future: No ads, no corporate surveillance, ethical design, and decentralization! Own your data with Mastodon!