Chart data range incorrectly shifts when deleting rows above source table

Desktop editors
1

Hi,

When deleting rows in a spreadsheet, specifically above the table that serves as the data source for a chart, the chart becomes corrupted. The chart is initially linked to a correct data range, and when rows are deleted above that range, it should maintain its reference to the original data. However, instead of preserving the correct range, the chart’s data range shifts downward, as if it were not properly anchored. This causes the chart to reference incorrect or empty cells, effectively breaking it. This behavior makes charts unreliable, especially in documents where rows are frequently added or removed above the data source.

Before deleting rows 1, 2, and 3:

After deleting rows 1, 2, and 3:

Windows 11x64
ONLYOFFICE Desktop Editors
Community Version 9.3.1.8 (x64 exe)

3

Hi, @npaixao ！

Thank you for the detailed report and screenshots.

We’ve reproduced this behavior on our side and passed it to the QA/development team for investigation. As soon as we have any updates or a fix, we’ll come back to this thread with more information.

4

Hi, @npaixao and thank you again for reporting this issue and for the detailed example.

This issue has already been registered in our internal tracker, so we have added your case to the existing report.

Our team will continue investigating this behavior within that bug. We’ll update this thread as soon as we have any news.

Thank you for helping us improve ONLYOFFICE!