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"
Created attachment 112722 [details] Sample spreadsheet containing a non-visible Pivot Table
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.