https://bugs.documentfoundation.org/show_bug.cgi?id=160607
Bug ID: 160607
Summary: Chart does not update when an unrelated worksheet is
duplicated
Product: LibreOffice
Version: 24.2.0.3 release
Hardware: x86-64 (AMD64)
OS: Linux (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: libreoffice-bugs@lists.freedesktop.org
Reporter: bugs.documentfoundation....@ronaldduncan.com
Created attachment 193591
--> https://bugs.documentfoundation.org/attachment.cgi?id=193591&action=edit
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.
--
You are receiving this mail because:
You are the assignee for the bug.
