Created attachment 193361 [details] Example file from Excel 2016 with sheet protection and editable pivot table Attached example file contains a simple pivot table, and the sheet protection is enabled, with the option allowing pivot table & chart editing. When this file is opened in Calc, the pivot table is not imported at all, only the cell values. If the sheet protection option allowing pivot table editing is turned off, then the pivot table is imported. 1. Open attached file -> there is no pivot table in F3:J11 Version: 24.8.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: 0020fc1167b3760d0631001689a44427b72b816e CPU threads: 15; OS: Windows 10.0 Build 19045; UI render: default; VCL: win Locale: hu-HU (hu_HU); UI: en-US Calc: default and ever since 3.3
Created attachment 193362 [details] Screenshot of the example file in Excel 2016 with the sheet protection settings visible and Calc
Created attachment 193363 [details] The same example file withouth the pivot table editing setting enabled in sheet protection
Created attachment 193364 [details] The second example in Excel and Calc Without the protection setting enabled the pivot table is imported.
Reproduced: Version: 24.8.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: d5dcc9de8ebce5d14be89ddeb6606ef0aeebf7a9 CPU threads: 8; OS: Linux 6.5; UI render: default; VCL: gtk3 Locale: en-AU (en_AU.UTF-8); UI: en-US Calc: CL threaded