Bug 160607 - Chart does not update when an unrelated worksheet is duplicated
Summary: Chart does not update when an unrelated worksheet is duplicated
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
7.2.5.2 release
Hardware: x86-64 (AMD64) Linux (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Chart
  Show dependency treegraph
 
Reported: 2024-04-10 04:06 UTC by Ronald
Modified: 2025-07-09 07:01 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


Attachments
Chart not updating when unrelated worksheet duplicated (41.11 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2024-04-10 04:06 UTC, Ronald
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Ronald 2024-04-10 04:06:39 UTC
Created attachment 193591 [details]
Chart not updating when unrelated worksheet duplicated

I have a workbook with detailed calculations in Year worksheets, and a summary worksheet which refers back to the year worksheets.  The summary worksheet has a details and a summary table and these have charts that display their data.

If I update the data the charts change to reflect the update.

However, if I duplicate a year worksheet, then the charts stop updating until I press CTL + SHIFT + F9.

Instructions to recreate the bug

In attached workbook 
Summary sheet update cell h2 to 50% see chart change
Duplicate tab - SimpleCalculator2022
Try updating Summary sheet cell h2 to 50% see chart not change

Cell h2 is just a number, you can update other cells in the table and the chart does not change.  I was changing the formulae for a column to add the 2023 results.  It is easier to just make a simple change like 3.5% to 50% to see the effect.

I am running 
Version: 24.2.0.3 (X86_64) / LibreOffice Community
Build ID: 420(Build:3)
CPU threads: 8; OS: Linux 6.6; UI render: default; VCL: gtk3
Locale: en-GB (en_GB.utf8); UI: en-GB
24.2.0-2
Calc: threaded

I had the same issue last year with an earlier version of LibreOffice, but did not report.  I run manjaro so would have been on a reasonably upto date version last year.
Comment 1 Robert Großkopf 2024-04-10 08:55:18 UTC
Might be this one is a duplicate of
https://bugs.documentfoundation.org/show_bug.cgi?id=160589
Comment 2 Robert Großkopf 2024-04-10 09:05:14 UTC
Seems it isn't a duplicate. Could reproduce it with older LO-Versions. F) only doesn't work. It has to be CTRL + SHIFT + F9.

Tested it in different versions. Falso also in
Version: 7.2.5.1 / LibreOffice Community
Build ID: 6d497ff5e83a906a307eb25cce314d40c0b8624f
CPU threads: 6; OS: Linux 6.4; UI render: default; VCL: kf5 (cairo+xcb)
Locale: de-DE (de_DE.UTF-8); UI: de-DE
Calc: threaded

Might be it never worked.
Comment 3 RethaWisozk 2024-11-18 14:20:56 UTC
Security cameras are essential for tracking suspects in https://amongusgame.io. Be firm with people you suspect because they could be impostors.
Comment 4 Selina Cruickshank 2025-07-09 07:01:33 UTC
You might want to double-check if the chart is linked dynamically or manually, as duplicated sheets sometimes break connections. Also, depending on your use case, comparing how layered systems handle structure can offer insight. For example, the https://elvishtranslator.vercel.app/ approach shows how branching data models work in similar conditions. That concept might help debug your current setup more efficiently.