https://bugs.documentfoundation.org/show_bug.cgi?id=160404
Bug ID: 160404
Summary: FILEOPEN XLSX Pivot table is not imported if sheet
protection has Pivot table editing enabled
Product: LibreOffice
Version: Inherited From OOo
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Blocks: 112416
Created attachment 193361
--> https://bugs.documentfoundation.org/attachment.cgi?id=193361&action=edit
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
Referenced Bugs:
https://bugs.documentfoundation.org/show_bug.cgi?id=112416
[Bug 112416] [META] XLSX (OOXML) pivot table bugs
--
You are receiving this mail because:
You are the assignee for the bug.