[Libreoffice-bugs] [Bug 86321] EDITING, FORMATTING: diagram didn't automatic update when change variable (recalculation not triggered)

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=86321

--- Comment #62 from matthewnote at yahoo.co.uk ---
Created attachment 166115
  --> https://bugs.documentfoundation.org/attachment.cgi?id=166115&action=edit
AppImage bundles can repair "broken" charts on any file? Windows test please.

(In reply to Eike Rathke from comment #40)
> This doesn't even seem to be a Calc problem, one can as well directly modify
> the values in the chart's (Object 15) data range $roX0_9.$U$9:$U$18 (i.e.
> set U13:U18 to 8 which is the same value as when deleting invoer.H19:L19, or
> any other value fwiw) and the chart does not update. BUT, double clicking it
> reveals the updated chart according to the values. Leaving the chart again
> displays the old values. Also modifying the data ranges for data series
> 'Column V' doesn't change that. Something seems to be broken with the chart
> view representation (old replacement/preview view used?).

Tested VLB's attachment sample here on two Linux PCs.
File repair accomplished on Linux machines.

1.  Download AppImage from Antonio's library of old versions:
https://libreoffice.soluzioniopen.com/old/LibreOffice-5.3.6-x86_64.AppImage

2.  Make the file executable.  Run the AppImage on either Ubuntu 18.04 or
20.04.
Tools>Options>Load/Save>General> switch off autorecovery saving, check ODF
format set to 1.2 (Extended).

3.  Open attachment 109539 or attachment 114246 or my sample attachment 165696.

4.  All Charts update with any user operation (here).

5.  Save the resulting file to a new file name (necessary before step 6).

6.  Files now load, charts now update (all samples) on Installed Calc versions
LO6.3.5.2 on Ubuntu 18.04.  LO7.0.1.2 on Ubuntu 20.04.
    Repaired files now load, charts update on AppImage version LO5.3.6.1 and
AppImage version LO6.5.3.2 and AppImage version (fresh) LO7.0.1.2.


7.  For Users reading this Bug, the AppImage project produces "boxed" full
LibreOffice versions without installing anything.  This is similar to .sfs
"boxed" full versions available to Linux Puppy users.  (I don't know if Windows
has or will have an equivalent).   So, for Windows OS users, you'll need to
find a friend or a Linux partition to use AppImages as repair tool.

8.  For Developers.
a.  Antonio's AppImage 4.1.0.4 failed to start on either Linux 18.04 or 20.04.
b.  AppImage 6.3.5.2 ran on both Linux yet failed to cause chart updates.
c.  AppImage 6.3.5.2 opens all, charts updates if they've been save at least
once using AppImage 5.3.6.1.
d.  AppImage 5.3.6.1 (the successful Repair Tool) failed to run on Fossa 20.04
at the first try, yet double-clicking it later and again later (the third
occasion), the application launched (very strange!).  It seems only Antonio's
7.0.1.2 "fresh" has a Fossa Ubuntu 20.04 flavour.  Not sure why the AppImage
5.3.6.1 had difficulty attracting software interrupt attention.  Another clue?

Would ladies, gentlemen please test the "seems repaired" VLB sample on Windows
and report result?  Attached with this message.  Method is at comment 28.

[By the way, the Repair Method using AppImage works also for my upload and this
morning I tried it out on the very large (102MB) Diabetes file study here with
42 charts.  Half of the charts were "broken" and now . . . . . . all are
working!  I'm very happy this morning).

-- 
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/20201006/f07fb527/attachment.htm>