You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@openoffice.apache.org by bu...@apache.org on 2017/11/28 16:25:42 UTC

[Issue 127612] New: PIVOTTABLE: Copying a sheet with a pivot table copies the pivot table as data

https://bz.apache.org/ooo/show_bug.cgi?id=127612

          Issue ID: 127612
        Issue Type: DEFECT
           Summary: PIVOTTABLE: Copying a sheet with a pivot table copies
                    the pivot table as data
           Product: Calc
           Version: 3.3.0 or older (OOo)
          Hardware: All
                OS: All
            Status: CONFIRMED
          Severity: Normal
          Priority: P5 (lowest)
         Component: editing
          Assignee: issues@openoffice.apache.org
          Reporter: pedlino@gmail.com
  Target Milestone: ---

Created attachment 86280
  --> https://bz.apache.org/ooo/attachment.cgi?id=86280&action=edit
"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.

-- 
You are receiving this mail because:
You are the assignee for the issue.

[Issue 127612] PIVOTTABLE: Copying a sheet with a pivot table copies the pivot table as data

Posted by bu...@apache.org.
https://bz.apache.org/ooo/show_bug.cgi?id=127612

oooforum (fr) <oo...@free.fr> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |oooforum@free.fr

--- Comment #1 from oooforum (fr) <oo...@free.fr> ---
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"

-- 
You are receiving this mail because:
You are the assignee for the issue.

[Issue 127612] PIVOTTABLE: Copying a sheet with a pivot table copies the pivot table as data

Posted by bu...@apache.org.
https://bz.apache.org/ooo/show_bug.cgi?id=127612

--- Comment #2 from Pedro <pe...@gmail.com> ---
(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.

-- 
You are receiving this mail because:
You are the assignee for the issue.

[Issue 127612] PIVOTTABLE: Copying a sheet with a pivot table copies the pivot table as data

Posted by bu...@apache.org.
https://bz.apache.org/ooo/show_bug.cgi?id=127612

--- Comment #4 from oooforum (fr) <oo...@free.fr> ---
(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.

-- 
You are receiving this mail because:
You are the assignee for the issue.

[Issue 127612] PIVOTTABLE: Copying a sheet with a pivot table copies the pivot table as data

Posted by bu...@apache.org.
https://bz.apache.org/ooo/show_bug.cgi?id=127612

--- Comment #3 from Pedro <pe...@gmail.com> ---
(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.

-- 
You are receiving this mail because:
You are the assignee for the issue.