[Libreoffice-bugs] [Bug 86321] EDITING, FORMATTING: diagram didn't automatic update when change variable (steps in comment 28)

[bugzilla-daemon at bugs.documentfoundation.org]

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

--- Comment #120 from matthewnote at yahoo.co.uk ---
Thankyou.

For VLB, one last question here for you.  Does Windows Calc7 Option OpenCL
"disabled" (OFF) work for you with this file?   It does on my PC, yet the topic
depends on the computer hardware and drivers (I use Shuttle PCs with Intel).

I'm hoping to work out one more thing (why OpenCL) before moving the Feedback
Report.


With OpenCL allowed,(ON), using Tools, Detective, trace precedents I studied
the variable results on the invoer sheet Chart M66.  

In the steps described, after first start Calc, first load file, when delete
H19:L19, invoer column DT calculates -27 for all cells DT52:DT157 but the chart
displays a "sawtooth".  At Undo: delete it's the reverse. . .column DT
calculates a "sawtooth" but the chart displays the old values before the undo
(mostly -27).  In other words, the chart is updating but one action "late".

If it's useful for you to see when the autocalculate block is occurring, at the
first start of Calc, first load of file, first Undo: delete, using
Data>Calculate>Recalculate_Hard the column EB cells (example EB58);
=IF(EXACT(EA58,$X$68)=TRUE(),TRUE(),"")  now update from WAAR to empty "".

At that moment Chart M66 can/does adopt the values of the "sawtooth" in column
DT.  However, even if I delete all the column EB (save new file) and start
again, the link between DT calculated and chart not-yet is still occurring. So
EB column changes are interesting coincidence (visual) but the chart seems not
to depend on that column.  

I find bug reports and histories of bugs in Calc concerning Grouped Formulae
and Software Interpreter and OpenCL.  (Skia seems to work! :)

@VLB  I hope that helps (to know about visual column cell clues while
engineering) and that Calc7 OpenCL disabled works for you for this particular
file (does it?).

I promise I will soon cease posting on this thread ! : )
I (personally) am a very happy engineer now the charts update.  Great!

-- 
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/20210511/0ecbef2e/attachment.htm>