Bug 160404

Summary:	FILEOPEN XLSX Pivot table is not imported if sheet protection has Pivot table editing enabled
Product:	LibreOffice	Reporter:	Gabor Kelemen (allotropia) <kelemeng>
Component:	Calc	Assignee:	Balázs Varga (allotropia) <balazs.varga991>
Status:	ASSIGNED ---
Severity:	normal	CC:	mhillat, stephane.guillou
Priority:	medium
Version:	Inherited From OOo
Hardware:	All
OS:	All
Whiteboard:
Crash report or crash signature:		Regression By:
Bug Depends on:
Bug Blocks:	112416, 160536
Attachments:	Example file from Excel 2016 with sheet protection and editable pivot table Screenshot of the example file in Excel 2016 with the sheet protection settings visible and Calc The same example file withouth the pivot table editing setting enabled in sheet protection The second example in Excel and Calc

Description Gabor Kelemen (allotropia) 2024-03-28 07:05:17 UTC

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

Comment 1 Gabor Kelemen (allotropia) 2024-03-28 07:06:33 UTC

Created attachment 193362 [details]
Screenshot of the example file in Excel 2016 with the sheet protection settings visible and Calc

Comment 2 Gabor Kelemen (allotropia) 2024-03-28 07:07:31 UTC

Created attachment 193363 [details]
The same example file withouth the pivot table editing setting enabled in sheet protection

Comment 3 Gabor Kelemen (allotropia) 2024-03-28 07:09:41 UTC

Created attachment 193364 [details]
The second example in Excel and Calc

Without the protection setting enabled the pivot table is imported.

Comment 4 Stéphane Guillou (stragu) 2024-04-12 14:24:44 UTC

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