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
Created attachment 170322 [details] This spreadsheet exhibits the effects of the bug. Right click on the graphs. You will see that they exhibit a variety of errors in most cases. References broken, references to the source sheet, and conversion to internal data tables.
Created attachment 170323 [details] This spreadsheet exhibits the effects of the bug. Right click on graphs and you will see a variety of problems. References to the source sheet, conversion to tables. Etc, as discussed in the bug report. This is the ODS version.
Created attachment 177625 [details] A sample .ods file with a bit of data and one chart In the following examples, Sheet1 name could have any number; Sheet2 name could have any number greater than Sheet1. I found a faulty method: - Copy from Sheet1, insert/move Sheet2 (or Sheet3) to the left of Sheet1 tab, and paste. Workarounds: If Sheet2 tab would be to the left of Sheet1 tab: - Copy from Sheet1 after inserting/moving Sheet2 If you already copied from Sheet1, and Sheet2 (or Sheet3) tab is (are) to the left of Sheet1 tab: - Move Sheet2 (and Sheet3) tab(s) to the right of Sheet1 tab - Paste - Reorder the sheet tabs Version: 7.1.8.1 (x64) / LibreOffice Community Build ID: e1f30c802c3269a1d052614453f260e49458c82c CPU threads: 4; OS: Windows 10.0 Build 19043; UI render: default; VCL: win Locale: es-MX (es_ES); UI: en-US Calc: CL Related question: https://ask.libreoffice.org/t/copying-chart-in-calc/72866
(In reply to LeroyG from comment #3) > Created attachment 177625 [details] > A sample .ods file with a bit of data and one chart > > In the following examples, Sheet1 name could have any number; Sheet2 name > could have any number greater than Sheet1. > > I found a faulty method: > - Copy from Sheet1, insert/move Sheet2 (or Sheet3) to the left of Sheet1 > tab, and paste. Testing with attachment 177625 [details]. If I select A1:J21, copy, insert new sheet, paste into it, everything is pasted just fine. Of the related reports you mentioned in Ask, bug 142635 is fixed and bug 99969 is still reproduced. BPH and Leroy: is there still a problem? Set to NEEDINFO. Change back to UNCONFIRMED, if the problem persists. Change to RESOLVED WORKSFORME, if the problem went away. Arch Linux 64-bit Version: 7.5.0.0.alpha1+ (X86_64) / LibreOffice Community Build ID: 2b093d27b7e6f231512920f20089fcac291b021f CPU threads: 8; OS: Linux 6.0; UI render: default; VCL: kf5 (cairo+xcb) Locale: fi-FI (fi_FI.UTF-8); UI: en-US Calc: threaded Built on 2 December 2022
Dear BPH, This bug has been in NEEDINFO status with no change for at least 6 months. Please provide the requested information as soon as possible and mark the bug as UNCONFIRMED. Due to regular bug tracker maintenance, if the bug is still in NEEDINFO status with no change in 30 days the QA team will close the bug as INSUFFICIENTDATA due to lack of needed information. For more information about our NEEDINFO policy please read the wiki located here: https://wiki.documentfoundation.org/QA/Bugzilla/Fields/Status/NEEDINFO If you have already provided the requested information, please mark the bug as UNCONFIRMED so that the QA team knows that the bug is ready to be confirmed. Thank you for helping us make LibreOffice even better for everyone! Warm Regards, QA Team MassPing-NeedInfo-Ping
Reproducible with: Version: 7.4.7.2 (x86) / LibreOffice Community Build ID: 723314e595e8007d3cf785c16538505a1c878ca5 CPU threads: 4; OS: Windows 6.1 Service Pack 1 Build 7601; UI render: Skia/Raster; VCL: win Locale: es-MX (es_MX); UI: en-US Calc: threaded Version: 7.5.3.2 (x86) / LibreOffice Community Build ID: 9f56dff12ba03b9acd7730a5a481eea045e468f3 CPU threads: 4; OS: Windows 6.1 Service Pack 1 Build 7601; UI render: Skia/Raster; VCL: win Locale: es-MX (es_MX); UI: fr-FR Calc: threaded Note that you must Copy before moving Sheet2 to the left of Sheet1, and then Paste.
Regarding Leroy's steps and sample: I reproduce the inconsistency, which depends on the order of copying and moving sheets. 1. Open attachment 177625 [details] 2. Copy A1:J21 in Sheet1 3. Insert a second sheet (Sheet2) at the end 4. Paste into Sheet2 Result A: range references the new sheet ($Sheet2.$A$1:$B$3) (expected) 5. Copy A1:J21 in Sheet1 again 6. Insert a third sheet (Sheet3) 7. Move Sheet3 to first position (before Sheet1) 8. Paste in Sheet3 Result B: range references the source sheet ($Sheet1.$A$1:$B$3) (unexpected) If the new sheet is moved _before_ copying, no issue. Reproduced in OOo 3.3 and recent trunk build: Version: 24.8.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: e2473fe3a547e5a11d3b91ab8ded833bf5b74356 CPU threads: 8; OS: Linux 6.5; UI render: default; VCL: gtk3 Locale: en-AU (en_AU.UTF-8); UI: en-US Calc: threaded Regarding BPH's sample files: It is not clear enough what steps need to be taken to reproduce the problem with the attachments (e.g. _which_ sheet, or part thereof, do we copy? Where to? Which chart has a problem?). Given the difficulty reproducing, and the various issues reported, let us focus on Leroy's example here, for which we have clear steps. (But if you can still reproduce in a recent version, please do open a new report with clear, precise steps.)
Mike, given your recent work on copy-pasting of cell ranges containing a chart object, I thought you might be interested in this one. See comment 7.
(In reply to Stéphane Guillou (stragu) from comment #8) I saw this bug. However, I have no idea if it is possible to handle it at all, without a deep reimplementation of a huge part of Calc internals. A *calc document* is created for placement to clipboard; the selected part plus its references are copied to it from the current document; there is a way to tell that this calc document is based on "this specific normal document", which avoids creation of internal data set for charts when pasting to itself. But in any case, pasting back, it's the structure of the clipboard document that defines the references, not the structure of the (updated) source document. There is no way for clipboard to know that "the sheet number X, which was the source for the chart, is now sheer number Y in the source document". (See how the sheets are referenced by numbers internally, not by names (which would not help, since you can rename freely), nor by pointers / references, etc.).