Bug 123226

Summary: Pivot table if Filter is used and then turned off, then column filter stops working
Product: LibreOffice Reporter: grofaty <grofaty>
Component: CalcAssignee: Not Assigned <libreoffice-bugs>
Status: NEW ---    
Severity: normal CC: 79045_79045, marc, oliver.brinzing
Priority: medium    
Version: 3.6.7.2 release   
Hardware: All   
OS: All   
Whiteboard:
Crash report or crash signature: Regression By:
Bug Depends on:    
Bug Blocks: 103381    
Attachments: pivot_table_column_filtering_problem.gif
pivot_table_sample.ods

Description grofaty 2019-02-07 12:45:21 UTC
Created attachment 148978 [details]
pivot_table_column_filtering_problem.gif

1. Use pivot table.
2. Column filter works fine. Remove it.
3. From content window select Filter and select Name = Alice.
4. Filter is applied to pivot table. Remove Filter.
5. PROBLEM: Column filtering: Alice can't be selected to filter anymore (like in step 2).

I have recorded a video, to quickly explain the problem.


=== Help | About ===
Version: 6.1.4.2 (x64)
Build ID: 9d0f32d1f0b509096fd65e0d4bec26ddd1938fd3
CPU threads: 3; OS: Windows 6.1; UI render: default; 
Locale: sl-SI (sl_SI); Calc: group threaded
=====================
Comment 1 Roman Kuznetsov 2019-02-17 06:24:32 UTC
grofaty, can you attach sample file with pivot table?
Comment 2 grofaty 2019-02-17 16:58:10 UTC
Created attachment 149358 [details]
pivot_table_sample.ods
Comment 3 grofaty 2019-02-17 16:59:54 UTC
As requested I have attached sample file.

Today I tested on Ubuntu and the same problem.

=== Help | About ===
Version: 6.1.4.2
Build ID: 1:6.1.4-0ubuntu0.16.04.1~lo2
CPU threads: 2; OS: Linux 4.15; UI render: default; VCL: gtk2; 
Locale: sl-SI (en_US.UTF-8); Calc: group threaded
====================
Comment 4 Oliver Brinzing 2019-02-17 17:48:15 UTC
i can reproduce this issue even with LO 3.6.7.2 (Build ID: e183d5b),
but not with AOO 4.1.5.
Comment 5 QA Administrators 2021-02-17 04:14:18 UTC Comment hidden (obsolete)
Comment 6 grofaty 2022-05-03 05:43:24 UTC
After 2 years I have retested this problem and problem still persists exactly as it is displayed in gif video in first post of this bug report.

=== Help | About ===
Version: 7.3.2.2 / LibreOffice Community
Build ID: 30(Build:2)
CPU threads: 8; OS: Linux 5.15; UI render: default; VCL: gtk3
Locale: en-US (en_US.UTF-8); UI: en-US
Ubuntu package version: 1:7.3.2-0ubuntu2
Calc: threaded
=====================
Comment 7 QA Administrators 2024-05-03 03:16:31 UTC Comment hidden (obsolete)
Comment 8 grofaty 2024-05-03 15:42:20 UTC
After 5 years I have retested on latest stable and issue is the same as in GIF video in first post attachment.

=== Help | About ===
Version: 24.2.3.2 (X86_64) / LibreOffice Community
Build ID: 433d9c2ded56988e8a90e6b2e771ee4e6a5ab2ba
CPU threads: 4; OS: Linux 6.8; UI render: default; VCL: gtk3
Locale: en-US (en_US.UTF-8); UI: en-US
Flatpak
Calc: threaded
=====================
Comment 9 grofaty 2024-05-03 16:14:16 UTC
Now I also tested on the latest alfa and the same issue as in first post GIF video.

=== Help | About ===
Version: 24.8.0.0.alpha0+ (X86_64) / LibreOffice Community
Build ID: 3f2d56d486da2006e24444cfa6f2f63700a14fae
CPU threads: 4; OS: Linux 6.8; UI render: default; VCL: gtk3
Locale: en-US (en_US.UTF-8); UI: en-US
Calc: threaded
=====================