https://bugs.freedesktop.org/show_bug.cgi?id=88749
Bug ID: 88749
Summary: Edit>Delete Contents should not allow to delete Pivot
Table
Product: LibreOffice
Version: 4.2.8.2 release
Hardware: Other
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Spreadsheet
Assignee: [email protected]
Reporter: [email protected]
Under LibreOffice (at least 4.2.8 and higher, didn't test earlier) the user can
not delete rows, columns or cells containing a Pivot Table (unlike Excel).
It is not a bad idea to restrict this operation to the option Data > Pivot
Table > Delete
However if the user doesn't know that and after failing to delete Rows, Columns
or Cells (which popup a IMO incomplete warning), then resorting to Delete
Contents does _apparently_ work.
In the attached file a Pivot Table was created starting at cell B10 and then
was deleted using Edit>Delete Contents
The problem is that the Pivot Table although not visible is "still there".
This can easily be proven by
1) trying to delete Rows 10 to 15
2) by clicking on any cell in the range B10 to F15 and selecting Data > Pivot
Table > Create
3) right click on any cell in the range B10 to F15 and click on Refresh
So the suggestions are
a) When the user tries to delete a range containing a Pivot Table using
Edit>Delete Contents popup the same warning as for Delete Rows, Columns or
Cells
b) Improve the error message by mentioning that "To remove a Pivot Table use
option Data > Pivot Table > Delete or right click on the Pivot Table and select
Delete"
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
