Hi, whenever I apply conditional formatting that specifies a background or font colour, cell borders disappear. This seems to be due to the fact that ultimately all styles inherit from Default, and Default specifies “no borders”, meaning that it actively removes borders. Thus, applying a conditional style will overwrite existing borders with “no borders”. I would like to remove this specification from Default style so that Default style and all inheriting styles would leave existing borders as they are, but I don’t know how. Any ideas?
Using LibreOffice 22.214.171.124
I’m not referring to the borders that form the grid, I’m referring to borders that I manually add with format > borders, eg when drawing a table, or cell borders added to visually group columns or rows together. I would like those borders to remain when i apply a conditional format to cells that have borders added to them.
To see what I mean:
- add borders to a cell (format cells > border)
- add conditional formatting to the cell with the rule: when cell content = “test” ==> apply style “Default”
- write “test” in the cell
- the borders you just added are gone
I’ve uploaded an example: example.ods