Bug 116338 - PIVOT TABLE: Filter in drop-down list stops working after ungrouping or regrouping values
Summary: PIVOT TABLE: Filter in drop-down list stops working after ungrouping or regro...
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
6.0.2.1 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Pivot-Table
  Show dependency treegraph
 
Reported: 2018-03-10 15:28 UTC by Gilward Kukel
Modified: 2025-03-03 09:26 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Gilward Kukel 2018-03-10 15:28:11 UTC
Description:
PIVOT TABLE: Filter in drop-down list stops working after ungrouping or regrouping values

Steps to Reproduce:
1. make a new spreadsheet
2. enter these data:
A1: a
A2: 1
A3: 2
A4: 3
A5: 4
3. create a pivot table in a new sheet with row field "a"
4. go to cell A2 of the pivot table
5. press F12
6. input 2 into "group by". OK
7. press Ctrl+F12 to ungroup
8. open the drop-down list of "a" and deselect some value. OK

Actual Results:  
Nothing happens. The deselected value is still shown in the pivot table, and when you reopen the drop-down list, it is selected again.

Expected Results:
Deselected value is not shown any more. 


Reproducible: Always


User Profile Reset: No



Additional Info:
The filter works before and after the grouping but not after ungrouping or regrouping (changing the "group by"-value).

Version: 6.0.2.1 (x64)
Build-ID: f7f06a8f319e4b62f9bc5095aa112a65d2f3ac89
CPU-Threads: 4; BS: Windows 6.1; UI-Render: Standard; 


User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64; rv:58.0) Gecko/20100101 Firefox/58.0
Comment 1 Julien Nabet 2018-03-10 15:51:21 UTC
On pc Debian x86-64 with LO Debian package 6.0.2, I don't reproduce this.
Value unchecked doesn't show.
Comment 2 m_a_riosv 2018-03-11 00:00:37 UTC Comment hidden (obsolete)
Comment 3 QA Administrators 2019-05-24 02:58:16 UTC Comment hidden (obsolete)
Comment 4 m_a_riosv 2019-05-24 07:27:25 UTC
Still in
Version: 6.3.0.0.alpha1 (x64)
Build ID: 547edd20e527fb02900f6174973770d26306e2e7
CPU threads: 4; OS: Windows 10.0; UI render: GL; VCL: win; 
Locale: es-ES (es_ES); UI-Language: en-US
Calc: CL
Comment 5 QA Administrators 2021-05-24 04:26:17 UTC Comment hidden (obsolete)
Comment 6 Gilward Kukel 2021-10-24 23:16:44 UTC
Bug is still present but only if you open and close the drop-down list of "a" before grouping and ungrouping.

Version: 7.2.2.2 (x64) / LibreOffice Community
Build ID: 02b2acce88a210515b4a5bb2e46cbfb63fe97d56
CPU threads: 4; OS: Windows 10.0 Build 19043; UI render: Skia/Vulkan; VCL: win
Locale: de-AT (de_AT); UI: de-DE
Calc: CL
Comment 7 QA Administrators 2023-10-25 03:14:14 UTC Comment hidden (obsolete)
Comment 8 Timur 2025-03-03 09:26:46 UTC
Repro 25.8+.