Bug spreadsheets when using a pivot and filter

[afazio]

OS version: Mac OS 15.4
App version: 8.3.2
Downloaded from: ONLYOFFICE website

The new version (8.3.2) has a problem in spreadsheets when using a pivot.
(The error occurs only after the file has been closed and reopened).
If you try to change the filter of a pivot, an error message appears that says: “A pivot table report on may overlap a table”.
To solve the problem, you have to recreate the pivot.
The next time you open the file, you will have to do the same.

[Constantine]

Hello @afazio

Similar problem was reported here:

Error message when refreshing a dynamic array

Onlyoffice-desktopeditors : version deb 8.3.2 - Ubuntu 24.10 Hi, After reloading a spreadsheet containing a dynamic array and trying to refresh it ( with alt-F5 or ‘refresh’ button ) , an error message occurs : ‘Overflow of the dynamic array cannot override another array’. But, the dynamic array is alone in its sheet and refreshing is not done. If the dynamic array is recreated, refreshing is possible again, until the file is closed and reopened. With version deb 8.3.0, it’s OK.

As it was mentioned, this behavior is a bug. We will inform you once it is resolved and new version that contains fix becomes available.

[vosaxalo]

Hello,

I can confirm the exact same issue here.
I am using OnlyOffice version 8.3.2.19 (flatpak) on my Linux system (KDE Neon, Ubuntu based distro).

Waiting for a fix as @Constantine already said.

[Constantine]

Hello @vosaxalo

I’ll provide a notification once it is resolved.

[Constantine]

Hello @vosaxalo, @afazio

I’d like to inform you that we are in the process of releasing new version 9.0 of Desktop Editors. This version brings the fix to the issue discussed in this topic, please update the app and check the situation again.

The update will be available shortly.