Bug: Pivot tables - filter settings lost when clicking on 'Refresh' (with video and a test file)

Desktop editors
, ,
1

There is a (not too critical but somewhat annoying) bug in the pivot tables. Meaning, when setting a filter in the pivot table, but then refreshing that table by clicking on ‘Refresh’ (because some values might have changed in the source data and thus to update the pivot table) the filter setting is no longer respected and has to be set anew.

Here is a video (9.7MB):

Here is the spreadsheet (created in OnlyO Spreadsheet):

OnlyOffice Community version 9.0.4.50 (deb)

1 Like
2

Just a quick side note: When playing the video, change the resolution to 1920p or simply download the file and watch it locally.

3

Hey @godfatherjohn, :wave:

Thanks for reporting the pivot table filter bug and for sharing the video and test file — they’re super helpful for digging into this issue! We’re analyzing the problem with filter settings being lost on refresh and will keep you posted as soon as we have updates.

Appreciate your detailed report! :hugs:

1 Like
5

I have the same issue, so this should be a universal bug.

1 Like
6

Hey @godfatherjohn, @Basriy, :wave:

Thanks for the reports — we’ve logged the bug: “Pivot table filter settings are reset after clicking ‘Refresh’”.

No ETA on the fix yet, but I’ll keep you updated as soon as there’s progress.
Appreciate your patience!

1 Like