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.

Reply via email to