Apache OpenOffice (AOO) Bugzilla – Issue 127612
PIVOTTABLE: Copying a sheet with a pivot table copies the pivot table as data
Last modified: 2017-11-30 12:59:34 UTC
Created attachment 86280 [details] "Sheet1" contains base data, "Pivot1" contains the working pivot table, "Pivot1_2" is the nonfunctional copy. This bug was detected in Windows 7 Pro 64-bit (not tested in other platforms) with AOO 4.1.5 (but occurs in all previous versions including OOo 3.3.0) The following description (including the sample file) is a copy of Bug report #43077 in TDF's Bugzilla https://bugs.documentfoundation.org/show_bug.cgi?id=43077 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.
I disagree with this new behavior. If you want a copy of an existing pivot table, proceed as follow: 1) right click on pivot table 2) choose "edit layout" item 3) in dialogbox, click on "More" button 4) in "Results to" listbox, choose "new sheet"
(In reply to oooforum (fr) from comment #1) > I disagree with this new behavior. Why not have both? In any case it is not expected that a copied object is converted to a static image. > If you want a copy of an existing pivot table, proceed as follow: > 1) right click on pivot table > 2) choose "edit layout" item > 3) in dialogbox, click on "More" button > 4) in "Results to" listbox, choose "new sheet" Thank you for the useful tip! I didn't know this option allowed to do this. It is not obvious even for someone who uses Pivot tables on a daily basis.
(In reply to Pedro from comment #2) > I didn't know this option allowed to do this. It is not obvious even for > someone who uses Pivot tables on a daily basis. In fact the same option in LibreOffice Moves the Pivot Table from the current location to a New Sheet which makes a lot more sense because the command selected is Edit Layout. I believe that creating a new Pivot Table is not what the user expects.
(In reply to Pedro from comment #3) > In fact the same option in LibreOffice Moves the Pivot Table from the > current location to a New Sheet which makes a lot more sense because the > command selected is Edit Layout. I believe that creating a new Pivot Table > is not what the user expects. Well, maybe you can contact LibO developer to reverse this patch on AOO.