<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 - Libreoffice Calc when a sheet is duplicated with multiple graphs, graphs do not reference the new duplicate correctly."
href="https://bugs.documentfoundation.org/show_bug.cgi?id=140868">140868</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>Libreoffice Calc when a sheet is duplicated with multiple graphs, graphs do not reference the new duplicate correctly.
</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>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>brian.paul.hanley@gmail.com
</td>
</tr></table>
<p>
<div>
<pre>Description:
I found a question from 2015 that is pretty close to what I am seeing.
<a href="https://ask.libreoffice.org/en/question/53027/chart-does-not-update-when-cell-content-change/">https://ask.libreoffice.org/en/question/53027/chart-does-not-update-when-cell-content-change/</a>
It lists 3 bug reports (<a class="bz_bug_link
bz_status_NEW "
title="NEW - EDITING, FORMATTING: diagram didn't automatic update when change variable (recalculation not triggered)"
href="show_bug.cgi?id=86321">Bug #86321</a>, <a class="bz_bug_link
bz_status_RESOLVED bz_closed"
title="RESOLVED DUPLICATE - Chart displays incorrectly, but, if I double-click on it to edit, it then displays correctly (EDITING)"
href="show_bug.cgi?id=136160">Bug #136160</a>, <a class="bz_bug_link
bz_status_RESOLVED bz_closed"
title="RESOLVED DUPLICATE - calc chart does not update after changing a value from a selection list"
href="show_bug.cgi?id=136254">Bug#136254</a>.) that when I read
them could be related. But none of them are what I'm seeing. Alex Kemp closed
that question as not relevant or outdated in 2020. I am using 7.0.4.2 of
Libreoffice calc. I created a spreadsheet with 5 graphs on one sheet. These are
sigmoid curve fits for an ELISA plate. I got my sheet done and then duplicated
it 6 times, once for each of 6 ELISA plates. For each of those 6 duplicates I
pasted the tabular data in for the relevant plate.
Everything works correctly except that the graphs don't get duplicated
correctly in all cases. When it breaks, the graphs either become references to
tables, or the references stay pointed to the original sheet. However, rarely,
some of them do get copied over correctly.
I confirmed the same behavior in Linux and Windows 10. I don't know what
version this started in the chain.
I have a file that shows this behavior. I have tried it saving as XLSX and ODS
file types. Both show the behavior. I have also tried it on two different
versions of Linux Mint.
Steps to Reproduce:
1. I have a sheet that has a table referencing another table within the sheet.
2. For each column of 4 columns, there is a a graph.
3. Then, copy the sheet 6 times. Look at the Data Ranges for all of the tables
in the new sheets.
(I noticed this because the graphs didn't all change when I replace the data in
the source sheet.)
Actual Results:
The graphs in the duplicated sheets are sometimes converted to data tables that
copied the data from the source sheet. Some of them are references to the
source sheet, not the new sheet. Some of them copied correctly.
Expected Results:
The graphs should modify the graphs in the copied sheets so that they reference
the cells in the new sheet.
Reproducible: Sometimes
User Profile Reset: Yes
OpenGL enabled: Yes
Additional Info:
Version: 7.0.4.2
Build ID: dcf040e67528d9187c66b2379df5ea4407429775
CPU threads: 8; OS: Linux 4.10; UI render: default; VCL: gtk3
Locale: en-US (en_US.UTF-8); UI: en-US
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>