Posted 17 September 2025, 2:36 pm EST - Updated 17 September 2025, 2:41 pm EST
If I try to edit a cell after programmatically applying a background with
setStyle
, I see both the cell editor view and the cell values. The cell editor does not show up on top of the cell values like it should.
For example, if I edit a cell with formula B2+B3 and value 30, I expect to see B2+B3 only (no 30). And if the formula spills onto adjacent cells, I expect the formula to appear on top of those cells.
Instead, on cells I have modified with
setStyle
, I see both B2+B3 and 30; and if the formula spills onto adjacent cells, I see an overlap between the formula and the adjacent cell values.
This only happens when I modify the background with
setStyle
. If I modify text color, it works fine.
Is there a way to prevent this issue?