Calc cell contents have disappear from the view

[ChrisL1]

Calc cell contents are there (they do exist… i.e. when moving the cursor to cells, the content appears on the display bar), but the entire column shows nothing on the main display… just blanks.
Notes:

• the column itself has conditional formatting, e.g. “display red for negative number, green for positive” type of thing
• the cells have disappeared on other apps like WPS Office.
• this only just started, i.e. after using the Calc app.

I’m on a Mac OS v12.7.6 (Monterey), LibreOffice 25.2.2.2 (AARCH64).

Please help!

[fpy]

@ChrisL1

nothing

upload a .ods example here.

Ask/Guide - How to use the Ask site - The Document Foundation Wiki

[ChrisL1]

It’s got a lot of private info. I don’t think that would be wise.

[ChrisL1]

I suspect it has something to do with the conditional formatting. I’ll figure it out.

[EarnestAl]

@ChrisL1

the cells have disappeared on other apps like WPS Office.

It might be Mac font cache issue.

Does clicking on a cell and clicking Format > Clear Direct formatting fix the issue? You would need to Undo to revert to the conditional formatting after checking or Reload.