search

ONLYOFFICE / DesktopEditors

An office suite that combines text, spreadsheet and presentation editors allowing to create, view and edit local documents
https://www.onlyoffice.com
Other
2.82k stars 322 forks source link

Pivot table filter rows does not filter blanks #1665

Open gemorgan opened 1 month ago

gemorgan commented 1 month ago

This issue is unique.

Operating System

Linux (DEB package)

Version information

8.1.1.27

Expected Behavior

When unchecking (blank) and {Blanks} in the Row Labels filter, the row that is labeled (blank) with no values show no be shown.

Actual Behavior

The row shows no matter how I try to filter it. Unchecking the boxes in the filter, creating a new column and using it to filter. Nothing hides that (blank) row. When opening the same file in MS Excel, the "(blank)" row is indeed hidden.

Reproduction Steps

pivot a table that produces values for rows. Try to make the (blank) row go away.

Additional information

No response

VladimirProkofiev52 commented 2 weeks ago

Hello! @gemorgan I have reviewed your issue but was unable to reproduce it. Could you please provide a more detailed description? If the problem occurs only with a specific file, kindly share that file with me.