Bug 123226 - Pivot table if Filter is used and then turned off, then column filter stops working
Summary: Pivot table if Filter is used and then turned off, then column filter stops w...
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
3.6.7.2 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Pivot-Table
  Show dependency treegraph
 
Reported: 2019-02-07 12:45 UTC by grofaty
Modified: 2024-05-03 16:14 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:


Attachments
pivot_table_column_filtering_problem.gif (952.96 KB, image/gif)
2019-02-07 12:45 UTC, grofaty
Details
pivot_table_sample.ods (9.13 KB, application/vnd.oasis.opendocument.spreadsheet)
2019-02-17 16:58 UTC, grofaty
Details

Note You need to log in before you can comment on or make changes to this bug.
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
=====================