Created attachment 193510 [details] Example file from Excel with sheet protection feature Use PivotTable enabled Excel offers the sheet protection feature "Use PivotTable&PivotChart" meaning even on protected sheets the pivot tables and charts work. 1. Open attached document in Excel an Calc -> In Excel, on the first sheet the Pivot table is usable ("Use PivotTable&PivotChart" is enabled in the Protect Sheet dialog), but on the second sheet it is not. -> In Calc, the Protect Sheet dialog does not have this option, so the Pivot table is editable on both sheets. Version: 24.8.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: c9d4f99b2bb54ac7735b3e0d0cadbafbd0279518 CPU threads: 15; OS: Windows 10.0 Build 19045; UI render: default; VCL: win Locale: hu-HU (hu_HU); UI: en-US Calc: default
Created attachment 193511 [details] The Use Pivot Table & Pivot Chart option in the Excel dialog
Currently pivot tables are not imported from XLSX (bug 160404) if the sheet protection is enabled, solving that is a precondition. As such, I can't attach an image of the editable pivot table on the protected sheet. But the feature is nevertheless missing.
Setting to NEW.
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.
Balazs Varga committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/6ca76f3e6fbb19ef4982b0c178879645e7f72c00 Related: tdf#160536 - ooxml import export correctly cell 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.