Bug 88749

Summary: Edit>Delete Contents should not allow to delete Pivot Table
Product: LibreOffice Reporter: Pedro <pedlino>
Component: SpreadsheetAssignee: Not Assigned <libreoffice-bugs>
Status: NEW --- QA Contact:
Severity: normal    
Priority: medium CC: raal
Version: 4.2.8.2 release   
Hardware: Other   
OS: All   
Whiteboard:
i915 platform: i915 features:
Attachments: Sample spreadsheet containing a non-visible Pivot Table

Description Pedro 2015-01-23 14:55:27 UTC
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"
Comment 1 Pedro 2015-01-23 14:57:22 UTC
Created attachment 112722 [details]
Sample spreadsheet containing a non-visible Pivot Table
Comment 2 raal 2015-01-23 21:58:07 UTC
I can confirm with Version: 4.5.0.0.alpha0+
Build ID: 60143f4f7bc50054dcef923218b8c7c3bc154933
TinderBox: Linux-rpm_deb-x86_64@46-TDF, Branch:master, Time: 2015-01-21_04:58:34

Use of freedesktop.org services, including Bugzilla, is subject to our Code of Conduct. How we collect and use information is described in our Privacy Policy.