Created attachment 53677 [details]
"Sheet1" contains base data, "Pivot1" contains the working pivot table, "Pivot1_2" is the nonfunctional copy.

Problem description: 
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 
layout" option.

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".

Current behavior:
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.

Expected behavior:
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)