Bug 160536

Summary:	Support sheet protection option: Use PivotTable&PivotChart
Product:	LibreOffice	Reporter:	Gabor Kelemen (allotropia) <kelemeng>
Component:	Calc	Assignee:	Not Assigned <libreoffice-bugs>
Status:	NEW ---
Severity:	enhancement	CC:	raal
Priority:	medium
Version:	Inherited From OOo
Hardware:	All
OS:	All
Whiteboard:
Crash report or crash signature:		Regression By:
Bug Depends on:	160404
Bug Blocks:	122921
Attachments:	Example file from Excel with sheet protection feature Use PivotTable enabled The Use Pivot Table & Pivot Chart option in the Excel dialog

Description Gabor Kelemen (allotropia) 2024-04-05 12:29:56 UTC

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

Comment 1 Gabor Kelemen (allotropia) 2024-04-05 12:30:37 UTC

Created attachment 193511 [details]
The Use Pivot Table & Pivot Chart option in the Excel dialog

Comment 2 Gabor Kelemen (allotropia) 2024-04-05 12:35:42 UTC

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.

Comment 3 raal 2024-04-06 19:41:23 UTC

Setting to NEW.