Spreadsheet editor conditional formatting, fill series breaks the range

[sunhunter777]

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

7.2.2.56

Expected Behavior

In the table, one of the columns has a conditional formatting rule configured. The rule is configured

for the entire column or one range, it makes no difference. Some of the cells already have data (formula) and I want to use "Fill" to fill the formula in new rows.

I select the cell above, move the cursor to the lower right corner of the selected cell, and drag the cursor down. I'm expecting the formula to be copied into new cells with the cell references changed, then conditional formatting applied to the formula results

Actual Behavior

The formula is copied perfectly, but the range specified in the conditional formatting rule is split into several parts (separated by a semicolon, the range before the "fill", each "filled" cell separately, the range after the "fill")

Reproduction Steps

1. Set conditional formatting for column range
2. Fill any data
3. Use fill series to fill other cells
4. Check range in conditional formatting

Additional information

This bug does not look very serious, however, when actively working in a table with deleting and adding rows, the range of conditional formatting reaches some limit and the document does not open, the document loads endlessly

[VladimirProkofiev52]

Hello!
@sunhunter777 I observed that you're utilizing an older version of the editor, version 7.2.2. Is the problem still present in the latest version, 8.0.1?
Regrettably, I couldn't replicate the issue you're experiencing.
Would you mind attaching the file where the problem occurs, please?

[sunhunter777]

I apologize for the long response, I was updating onlyoffice. Below is a gif with a reproduction of the error, also attached is a file where the problem appears
Onlyoffice version 8.0.1.31

Example.xlsx