why is libreoffice ignoring my conditional formatting rules and creates a white background if text color is set but background is set to blank
i mean technically it is blank but it messes my previously set colors up obviously... my table is supposed to be gray
@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.
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.
@Mr_Teatime sadly not the case
The social network of the future: No ads, no corporate surveillance, ethical design, and decentralization! Own your data with Mastodon!