https://bugs.documentfoundation.org/show_bug.cgi?id=140868
Bug ID: 140868
Summary: Libreoffice Calc when a sheet is duplicated with
multiple graphs, graphs do not reference the new
duplicate correctly.
Product: LibreOffice
Version: unspecified
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: libreoffice-bugs@lists.freedesktop.org
Reporter: brian.paul.han...@gmail.com
Description:
I found a question from 2015 that is pretty close to what I am seeing.
https://ask.libreoffice.org/en/question/53027/chart-does-not-update-when-cell-content-change/
It lists 3 bug reports (Bug #86321, Bug #136160, Bug#136254.) 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
--
You are receiving this mail because:
You are the assignee for the bug._______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
