Color problem when choose pivot entry.

[rardcode]

This issue is unique.

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

Operating System of DocumentServer

Docker

Version information

8.2.0.1

Expected Behavior

After 8.2.0.1 upgrade, when choose PAYEMENT in T column (from pivot table), color all line.
Line 23 of screenshot

Actual Behavior

When choose PAYMENT in T column, doesn't color entire line. Line after 23

Reproduction Steps

1. choose one payment (CASH, CREDIT CARD, OTHER PAYMENT)

Additional information

Attach xlsx file
WEEKLY REPORT FRATTINA DAL 28-10-2024 AL 03-11-2024.xlsx

[VladimirProkofiev52]

Hello! @rardcode
I have reviewed your issue.
Could you please describe in more detail the steps to reproduce it, the expected outcome, and what actually happens?

[rardcode]

Hello! @rardcode I have reviewed your issue. Could you please describe in more detail the steps to reproduce it, the expected outcome, and what actually happens?

Hi @VladimirProkofiev52
Step for reproduce:

1. open WEEKLY REPORT FRATTINA DAL 28-10-2024 AL 03-11-2024.xlsx with OnlyOffice
2. go to T32 cell
3. choose CASH from pivot table

EXPECTED: ALL 32 line's cells will have to color of green (ORANGE for CREDI CARD, red for OTHER)

ACTUAL: only some cell are coloured of green

[VladimirProkofiev52]

I tried replicating your scenario in Excel, and the behavior is the same as in our editor. The colors change partially, both in our editor and in Excel.

Are you sure the formatting in the table is correct?

[rardcode]

I tried replicating your scenario in Excel, and the behavior is the same as in our editor. The colors change partially, both in our editor and in Excel.

Are you sure the formatting in the table is correct?

Thanks @VladimirProkofiev52
Excuse me but I had tried the file with Libreoffice and they work correctly, with correct color in the line.... then is some wrong "formatting" of the pivot table on the original file.