Bug 150981

Summary: Pivot table broken after cut/paste of the area containing the filter (and after undo)
Product: LibreOffice Reporter: Telesto <telesto>
Component: CalcAssignee: Not Assigned <libreoffice-bugs>
Status: NEW ---    
Severity: normal CC: raal
Priority: medium    
Version: 3.5.7.2 release   
Hardware: All   
OS: All   
Whiteboard:
Crash report or crash signature: Regression By:
Bug Depends on:    
Bug Blocks: 103381    
Attachments: Example file

Description Telesto 2022-09-15 18:16:31 UTC 
Description:
Pivot table broken after cut/paste of the area containing the filter (and after undo)

Steps to Reproduce:
1. Open the attached file
2. Select the area between A2 - B16
3. CTRL+X
4. Paste somewhere else on the sheet -> Filter gone
5. Press CTRL+Z -> filter non functional

Actual Results:
Pivot filter breaks 

Expected Results:
Moving a Pivot this way is possible in Excel


Reproducible: Always


User Profile Reset: No



Additional Info:
Found in
Version: 7.5.0.0.alpha0+ (x64) / LibreOffice Community
Build ID: dc92a4d973086ce8a6a5f75ba0f4d4c9ca05537a
CPU threads: 4; OS: Windows 6.3 Build 9600; UI render: Skia/Raster; VCL: win
Locale: nl-NL (nl_NL); UI: en-US
Calc: CL threaded

and in
Versie: 4.2.0.4 
Build ID: 05dceb5d363845f2cf968344d7adab8dcfb2ba71

and in
LibreOffice 3.5.7.2 
Build ID: 3215f89-f603614-ab984f2-7348103-1225a5b
Comment 1 Telesto 2022-09-15 18:16:44 UTC 
Created attachment 182469 [details]
Example file
Comment 2 raal 2022-09-17 14:45:06 UTC 
Confirm with Version: 7.5.0.0.alpha0+ / LibreOffice Community
Build ID: e46f9cc4b506c325cbe1060777bbc81fd1630f49
CPU threads: 4; OS: Linux 5.15; UI render: default; VCL: gtk3
Locale: cs-CZ (cs_CZ.UTF-8); UI: en-US
Calc: threaded