Bug 160536 - Support sheet protection option: Use PivotTable&PivotChart
Summary: Support sheet protection option: Use PivotTable&PivotChart
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
Inherited From OOo
Hardware: All All
: medium enhancement
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on: 160404
Blocks: 122921
  Show dependency tree / graph
 
Reported: 2024-04-05 12:29 UTC by Gabor Kelemen (allotropia)
Modified: 2024-04-06 19:41 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:

Attachments
Example file from Excel with sheet protection feature Use PivotTable enabled (13.90 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2024-04-05 12:29 UTC, Gabor Kelemen (allotropia) 		Details
The Use Pivot Table & Pivot Chart option in the Excel dialog (10.47 KB, image/png)
2024-04-05 12:30 UTC, Gabor Kelemen (allotropia) 		Details
View All Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
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.