[Libreoffice-bugs] [Bug 140868] New: Libreoffice Calc when a sheet is duplicated with multiple graphs, graphs do not reference the new duplicate correctly.

[bugzilla-daemon at bugs.documentfoundation.org]

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 at lists.freedesktop.org
          Reporter: brian.paul.hanley at 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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20210308/8989b7e6/attachment-0001.htm>