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: [email protected]
Reporter: [email protected]
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._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
