<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body><table border="1" cellspacing="0" cellpadding="8">
<tr>
<th>Bug ID</th>
<td><a class="bz_bug_link
bz_status_UNCONFIRMED "
title="UNCONFIRMED - PIVOTTABLE: unintuitive referencing in copying sheets"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=135825">135825</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>PIVOTTABLE: unintuitive referencing in copying sheets
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>unspecified
</td>
</tr>
<tr>
<th>Hardware</th>
<td>All
</td>
</tr>
<tr>
<th>OS</th>
<td>Linux (All)
</td>
</tr>
<tr>
<th>Status</th>
<td>UNCONFIRMED
</td>
</tr>
<tr>
<th>Severity</th>
<td>normal
</td>
</tr>
<tr>
<th>Priority</th>
<td>medium
</td>
</tr>
<tr>
<th>Component</th>
<td>Calc
</td>
</tr>
<tr>
<th>Assignee</th>
<td>libreoffice-bugs@lists.freedesktop.org
</td>
</tr>
<tr>
<th>Reporter</th>
<td>jnqnfe@gmail.com
</td>
</tr></table>
<p>
<div>
<pre>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 <a class="bz_bug_link
bz_status_UNCONFIRMED "
title="UNCONFIRMED - copying secondary sheets gives blank/broken graphs"
href="show_bug.cgi?id=135821">bug #135821</a>), 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. <a class="bz_bug_link
bz_status_NEW "
title="NEW - Calc Pivot Table Properties window not vertically scrollable"
href="show_bug.cgi?id=133124">bug #133124</a>, 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</pre>
</div>
</p>
<hr>
<span>You are receiving this mail because:</span>
<ul>
<li>You are the assignee for the bug.</li>
</ul>
</body>
</html>