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
Balazs Varga committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/83910246044c1e05a3b50e25d21ac6a31566cc38 tdf#160404 tdf#160535 tdf#160536 - sc improve sheet protection It will be available in 25.2.0. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.