Text conditional formatting doesn't refresh properly on cells far away in the spreadsheets from the position of the editor's viewing area.

[Awilen-Bernkastel]

This issue is unique.

• I have used the search tool and did not find an issue describing my bug.

Operating System of DocumentServer

Linux (DEB package)

Version information

onlyoffice-documentserver-ee 8.2.2-22

Expected Behavior

On large Excel spreadsheets, in the browser-based document editor, changing a cell that triggers conditional formatting far away from it properly refreshes both cell style and text style.

Actual Behavior

On large Excel spreadsheets, in the browser-based document editor, changing a cell that triggers conditional formatting far away from it refreshes the cell style (background color) but not the text style.

Reproduction Steps

1. Change a number that has far-reaching consequences down in the worksheet:

2. See this kind of result down the line, some 300+ lines down:

This is what it should look like:

3. Going back up and reducing the number in the first screenshot again, the formatting ends up like so:

clearly showing there is an issue with the refresh of text formatting.

---

There is a Conditional Formatting rule that makes the background and text of this specific region white if the number in the screenshots is under 9, or puts the green backgrounds otherwise and gives back its colors to the text.

It refreshes the background color perfectly fine.

However the it doesn't refresh the text formatting properly, and we can see some of it in white over the green cells, until the area is refreshed with a cell "text input" validation (double-click on cell, hit the Enter key.) This is also true of the last screenshot, in which the background is properly refreshed, but not the text, still showing instead of being whited-out.

Additional information

The screenshots were taken using:

1. Firefox 131.0
2. Brave Browser v1.74.48 based on Chromium 132.0.6834.83 (Official build)

[VladimirProkofiev52]

Hello!
@Awilen-Bernkastel I have reviewed your issue, but I have a few questions.
Could you please share the file where the issue occurs, or a similar file where the problem can be reproduced?

If sharing a file is not possible, please provide a step-by-step description of how to create a file that replicates the issue.

[Awilen-Bernkastel]

Hi! Thank you for your reply.

Here is the file this occurs in. The screenshots were taken from the "Instruction" sheet.

instruction.xlsx