Created attachment 53677 [details]
"Sheet1" contains base data, "Pivot1" contains the working pivot table, "Pivot1_2" is the nonfunctional copy.
Copying a sheet in its entirety doesn't copy pivot tables properly -- the cells are copied, including formatting, but none of the pivot selection fields work and there is no "edit
Steps to reproduce:
1. In the sheet selection area, right-click on a sheet that contains a pivot table and choose "Move/Copy Sheet".
2. For "Action", choose "Copy".
3. Click "OK".
A new sheet is created that looks just like the original, but it doesn't contain a pivot table. It contains a copy of the contents and formatting of the table. Filter fields are transferred as non-functional table filter dropdowns. If you save the workbook and reopen it, the drop-downs disappear altogether and only the data is left.
A new sheet is created with exactly the same contents as the old sheet, including any special functionality like pivot tables.
Platform (if different from the browser):
Windows 7 Home Premium 64-bit (running 32-bit LibreOffice)
Upgraded; verified the same behavior is present in 3.4.4.
I'll look into it.
This is now fixed. The fix will be in 3.5 RC1.