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: [email protected]
Reporter: [email protected]
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.
