Bug 86932 - Pivot table: Column filter not functional when exceeds pivot range
Summary: Pivot table: Column filter not functional when exceeds pivot range
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected)
3.5.0 release
Hardware: All All
: medium normal
Assignee: Not Assigned
Depends on:
Blocks: Pivot-Table
  Show dependency treegraph
Reported: 2014-12-02 13:23 UTC by Juan Luis Gallego
Modified: 2021-12-03 08:47 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:

Example of table and pivot table (145.58 KB, application/pdf)
2014-12-02 13:23 UTC, Juan Luis Gallego
test pivot table (12.87 KB, application/vnd.oasis.opendocument.spreadsheet)
2014-12-03 03:22 UTC, Kevin Suo

Note You need to log in before you can comment on or make changes to this bug.
Description Juan Luis Gallego 2014-12-02 13:23:24 UTC
Created attachment 110356 [details]
Example of table and pivot table

When a column field is filtered in a pivot table and therefore falls outside the filter result table, it is impossible to recover the filtered data, unless re-edit the pivot table and change the order of fields .
Comment 1 raal 2014-12-02 20:26:52 UTC
Hello ,

Thank you for filing the bug. Please send us a sample document, as this makes it easier for us to verify the bug. 
(Please note that the attachment will be public, remove any sensitive information before attaching it.)
How can I eliminate confidential data from a sample document?
Thank you
Comment 2 Kevin Suo 2014-12-03 03:22:08 UTC
Created attachment 110383 [details]
test pivot table

I am able to create a test pivot table, see attached. I believe this matches the issue as Juan Luis Gallego described.

Steps to reproduce the issue:
1. In column B, filter "b1" only.
2. In column C, filter "c1" only.
3. Try to click the filter arrow for C.
--> Unresponsive.

This is the same issue as described in bug 58691:
> 2. column filter buttons become nonfunctional when they exceed the rectangular cell range of the pivot table

Set to NEW.

@Juan Luis Gallego: If you find it impossible to recover the filtered data, try to right-click on the pivot table, then click "filter"...

Build ID: 8fd0451cc08e6a5310bed8b7ad1c46b93c1c6889

Build ID: 9af3d21234aa89dac653c0bd76648188cdeb683e
Locale: zh_CN
Comment 3 raal 2014-12-03 06:52:52 UTC
Kevin's comment -> NEW
The same problem in LibreOffice 3.5.0 Build ID: d6cde02, changing version
Comment 4 Kevin Suo 2014-12-03 07:27:32 UTC
Changed title. (Actually it's possible to recover the filtered data)
Comment 5 QA Administrators 2015-12-20 16:16:50 UTC Comment hidden (obsolete)
Comment 6 QA Administrators 2017-01-03 19:49:31 UTC Comment hidden (obsolete)
Comment 7 QA Administrators 2019-12-03 14:26:14 UTC Comment hidden (obsolete)
Comment 8 QA Administrators 2021-12-03 04:33:00 UTC Comment hidden (obsolete)
Comment 9 Kevin Suo 2021-12-03 08:47:53 UTC
If it works now but you do not know which commmit had fixed this, then it should be marked as RESOLVED WORKSFORME.