https://bugs.documentfoundation.org/show_bug.cgi?id=168032
Bug ID: 168032
Summary: Refreshing a pivot table causes all cells in the table
to become protected.
Product: LibreOffice
Version: 25.2.5.2 release
Hardware: All
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
Refreshing a pivot table causes all cells in the table to become protected, and
if in a protected sheet the table becomes inoperable. A protected sheet
containing an unprotected pivot table automatically activates cell protection
in every cell in the table as soon as the table is refreshed.
Steps to Reproduce:
1.open the attached sheet
2.Sheet2 contains a pivot table referencing the data on Sheet1. Note that
Sheet2 contains no protected cells except one: A1
3.Refresh the pivot table.
Actual Results:
All the pivot table cells are now protected.
If Sheet2 is then protected, the pivot table becomes inoperable whether or not
the "Use pivot table and pivot chart" option is selected.
Expected Results:
(1) The pivot table cells should retain the cell protection status they are
given until they are explicitly changed.
(2) If the "Use pivot table and pivot chart" option is selected when protecting
the sheet, the table should continue to function normally while the other cells
of the sheet are protected, regardless of the status of the pivot table cells.
Reproducible: Always
User Profile Reset: Yes
Additional Info:
A User may wish to protect *part* of a sheet with protected cells, while
retaining a functional pivot table. In the example of the uploaded file, only
the Title in cell A1 should be protected when Sheet2 is protected.
Or a User may wish to prevent changes to the structure of the pivot table while
still allowing the data to be refreshed, and columns or rows to be expanded and
collapsed. Currently this is impossible while the sheet is protected. This is
unworkable if the workbook is shared with others where sheet protection is
needed to prevent unauthorized changes by other users.
--
You are receiving this mail because:
You are the assignee for the bug.
