[Libreoffice-bugs] [Bug 135825] New: PIVOTTABLE: unintuitive referencing in copying sheets

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=135825

            Bug ID: 135825
           Summary: PIVOTTABLE: unintuitive referencing in copying sheets
           Product: LibreOffice
           Version: unspecified
          Hardware: All
                OS: Linux (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: jnqnfe at gmail.com

Description:
if you create a pivot table in the same sheet as the data it is based upon,
then copy the sheet, the sheet name in the 'destination' reference is changed
to point to the new sheet, while 'source' remains referring to the copied-from
sheet.

why? this seems totally wrong to me.

we have copied both the data and the pivot table based on it into our duplicate
sheet, and surely common intuition is that the right thing to do in this
situation is for the duplicated pivot table to point to the duplicated data as
its source...

that's certainly what i expected in the document i created recently (attached
to bug #135821), where i was doing a lot of copying and adjusting of sheets. it
was an annoying waste of my time to have to go in and manually edit the tables
in each instance (especially wrt. bug #133124, and alongside copying with the
issues of #135821).

Actual Results:


Expected Results:



Reproducible: Always


User Profile Reset: No


OpenGL enabled: Yes

Additional Info:
Version: 7.0.1.1.0+
Build ID: <buildversion>
CPU threads: 4; OS: Linux 5.7; UI render: default; VCL: gtk3
Locale: en-GB (en_GB.utf8); UI: en-GB
Debian package version: 1:7.0.1_rc1-1
Calc: threaded

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20200817/719cc495/attachment.htm>