Bug 65006 - : update graphics when outside source value(s)
Summary: : update graphics when outside source value(s)
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected) release
Hardware: All All
: high normal
Assignee: Not Assigned
Whiteboard: BSA
Keywords: bibisected, regression
Depends on:
Blocks: Chart-Data
  Show dependency treegraph
Reported: 2013-05-26 14:39 UTC by celtic
Modified: 2022-09-19 09:47 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:


Note You need to log in before you can comment on or make changes to this bug.
Description celtic 2013-05-26 14:39:45 UTC
Problem description: 
graphics are not updated when source values are in another spreedsheet

Steps to reproduce:
1. have values in 1st file (calc)
2. have tables with calculations in a 2nd file (calc), results of this calculations are used for garphics in this 2nd file
3. close the 2 files, open 1st file, change values, close the 1st file, open 2nd file

Current behavior:
results of calculation in 2nd file are updated, not the graphics

Expected behavior:
update the graphics

same as Bug 45839 

congratulate for the this great job : LO.
Operating System: Windows XP
Version: release
Comment 1 ign_christian 2013-05-28 08:27:35 UTC
What is the difference with Bug 45839 ? Could you explain more detailed?
Comment 2 celtic 2013-05-29 17:09:54 UTC
what i see there no difference with bug 45839 fixed in L.O. 3.5.0. It's like the old fixed bug comes back.

do you need more explainations about the bug itself ?
Comment 3 QA Administrators 2013-12-22 21:58:16 UTC Comment hidden (obsolete)
Comment 4 celtic 2013-12-27 07:07:26 UTC
dear all,

I'm using L.O. 4.1.4 and the bug is always here. Same description as bug 45839 present in L.O. 3.4.x .

I try to improve my description.

* Problem description: 
no update the values in the chart

* Steps to reproduce:
1. in a calc file, have graphic from calculation with some "source" values in another clac file, close the files,
2. change the values located in the other file, close the file,
3. open the file with graphic, only the calculation is updated, not the graphic,

* Current behavior:
no update of the chart when open the file and accept the update with values of other files

* Expected behavior:
update the chart directly when open the file, was ok with OOo 3.3 and LO 3.5.0,

another way to explain the bug :
1) a + b = c, c is used in a graphic, b in another in another file.
2) change b
3) open the file with graphic, c is updated, the graphic not.
Comment 5 raal 2014-09-21 06:39:23 UTC
I can confirm with Version:
Build ID: 800884a0b9ce12924b8ed225571c01e7b0fb0ec7
TinderBox: Linux-rpm_deb-x86_64@46-TDF, Branch:libreoffice-4-3, Time: 2014-09-18_04:03:22

According to comment 2 it's regression.
Comment 6 Michael Weghorn 2015-02-01 21:16:32 UTC
bibisect result:
 7be7cf83087144563a18000acdae82c8fd6f4872 is the first bad commit
commit 7be7cf83087144563a18000acdae82c8fd6f4872
Author: Bjoern Michaelsen <bjoern.michaelsen@canonical.com>
Date:   Mon Dec 10 00:13:53 2012 +0000

    commit d59024b652ccfaf7247da113ec36788fe260de74
    Author:     Michael Stahl <mstahl@redhat.com>
    AuthorDate: Thu Jul 12 22:18:43 2012 +0200
    Commit:     Michael Stahl <mstahl@redhat.com>
    CommitDate: Thu Jul 12 22:18:43 2012 +0200
        warning C4101: unreferenced local variable
        Change-Id: I0648821a4d0c716371bb011df8cd9b21db79ccf5


$ git bisect log
# bad: [423a84c4f7068853974887d98442bc2a2d0cc91b] source-hash-c15927f20d4727c3b8de68497b6949e72f9e6e9e
# good: [65fd30f5cb4cdd37995a33420ed8273c0a29bf00] source-hash-d6cde02dbce8c28c6af836e2dc1120f8a6ef9932
git bisect start 'latest' 'oldest'
# bad: [e02439a3d6297a1f5334fa558ddec5ef4212c574] source-hash-6b8393474974d2af7a2cb3c47b3d5c081b550bdb
git bisect bad e02439a3d6297a1f5334fa558ddec5ef4212c574
# bad: [8f4aeaad2f65d656328a451154142bb82efa4327] source-hash-1885266f274575327cdeee9852945a3e91f32f15
git bisect bad 8f4aeaad2f65d656328a451154142bb82efa4327
# good: [369369915d3582924b3d01c9b01167268ed38f3b] source-hash-45295f3cdceb4c289553791071b5d7f4962d2ec4
git bisect good 369369915d3582924b3d01c9b01167268ed38f3b
# good: [6fce03a944bf50e90cd31e2d559fe8705ccc993e] source-hash-47e4a33a6405eb1b5186027f55bd9cb99b0c1fe7
git bisect good 6fce03a944bf50e90cd31e2d559fe8705ccc993e
# bad: [da317333e5675622f55c9dda17396c659af65320] source-hash-15af925c254f27046427de70a59011e2ac3d6bdb
git bisect bad da317333e5675622f55c9dda17396c659af65320
# good: [daa21bbd8c7b50e2ca1c2cbed0e39f0e7b5a1cb2] source-hash-6b11a18071254a443c8fe7e7b0b1c95b0f9fd35e
git bisect good daa21bbd8c7b50e2ca1c2cbed0e39f0e7b5a1cb2
# good: [a08143f4bae3d6658dd756b42b6f343298d1f48c] source-hash-b7822657fa67e7265d07f5852057e975e9efae0d
git bisect good a08143f4bae3d6658dd756b42b6f343298d1f48c
# good: [5255e1fbf1f3fa3ca61c4db3005940205577863c] source-hash-63c004fc3f0bc53ce888ef012f7993b9203a7503
git bisect good 5255e1fbf1f3fa3ca61c4db3005940205577863c
# bad: [7be7cf83087144563a18000acdae82c8fd6f4872] source-hash-d59024b652ccfaf7247da113ec36788fe260de74
git bisect bad 7be7cf83087144563a18000acdae82c8fd6f4872
# good: [ad874a5319e9f68e6b3a974e44de838b8a0a82e1] source-hash-4b4ca8030285bd66526ff5bb2b6ea5a75a6c6bc7
git bisect good ad874a5319e9f68e6b3a974e44de838b8a0a82e1
# first bad commit: [7be7cf83087144563a18000acdae82c8fd6f4872] source-hash-d59024b652ccfaf7247da113ec36788fe260de74

> Current behavior:
> results of calculation in 2nd file are updated, not the graphics

Note that in the last 3 bad commits (in the bisect), the result of the calculation in the 2nd file is not updated in addition to the not-updated graphics (commits 8f4aeaad2f65d656328a451154142bb82efa4327, da317333e5675622f55c9dda17396c659af65320, 7be7cf83087144563a18000acdae82c8fd6f4872).
Comment 7 Robinson Tryon (qubit) 2015-12-13 11:16:15 UTC Comment hidden (obsolete)
Comment 8 QA Administrators 2017-01-03 19:47:26 UTC Comment hidden (obsolete)
Comment 9 Goyo 2020-09-18 20:42:16 UTC
Reproducible in LO 7.0.1 Ubuntu 20.04
Comment 10 QA Administrators 2022-09-19 03:33:08 UTC Comment hidden (obsolete)
Comment 11 celtic 2022-09-19 09:47:43 UTC
dear libreoffice bug team,

the bug is still present.
I tested it several version I am able to run on my distros until the fresh version currently available as appimage :

Version :
Build ID : 1:6.4.7-0ubuntu0.20.04.4
Threads CPU : 8; OS : Linux 5.4; UI Render : par défaut; VCL: kf5; 
Locale : fr-FR (fr_FR.UTF-8); Langue IHM : fr-FR
Calc: CL

Build ID: 00(Build:2)
CPU threads: 2; OS: Linux 5.10; UI render: default; VCL: kf5
Locale: fr-FR (fr_FR.UTF-8); Langue IHM : fr-FR
Debian package version: 1:7.0.4-4+deb11u3
Calc: threaded

Version: / LibreOffice Community
Build ID: 499f9727c189e6ef3471021d6132d4c694f357e5
CPU threads: 8; OS: Linux 5.4; UI render: default; VCL: kf5 (cairo+xcb)
Locale: fr-FR (fr_FR.UTF-8); UI: fr-FR
Calc: CL

Version: / LibreOffice Community
Build ID: a69ca51ded25f3eefd52d7bf9a5fad8c90b87951
CPU threads: 8; OS: Linux 5.4; UI render: default; VCL: kf5 (cairo+xcb)
Locale: fr-FR (fr_FR.UTF-8); UI: fr-FR
Calc: CL

Version: / LibreOffice Community
Build ID: 465c3ad95059f0efa13c8027f7383c4d20a5b2ff
CPU threads: 8; OS: Linux 5.4; UI render: default; VCL: kf5 (cairo+xcb)
Locale: fr-FR (fr_FR.UTF-8); UI: en-US
Calc: CL

about regression, I downloaded several old version as appimage, but the old ones don't run correctly with my current calc files and I'm not able to confirm the regression. What I remember, when 3.5. was the current version, the bug was fixed as well as the last version of OOo.
best regards