[Libreoffice-bugs] [Bug 123120] Bug: Calc fails to recalculate dependent cells

[bugzilla-daemon at bugs.documentfoundation.org]

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

--- Comment #9 from b. <newbie-02 at gmx.de> ---
bug may be kept closed, sheet is too complicated, just to check reliability of
calc for the 'bug hunting session', 

and to save others some time if they attempt an recheck ... (solution at the
end) 

with ver: 

Version: 6.4.0.1 (x64)
Build ID: 1b6477b31f0334bd8620a96f0aeeb449b587be9f
CPU threads: 8; OS: Windows 6.1 Service Pack 1 Build 7601; UI render: default;
VCL: win; 
Locale: de-DE (de_DE); UI-Language: en-US
Calc: CL

> 1. Open bug 3 (attached)
ok 

> 2. Delete contents of g.X6 (note g.X16 remains =16, which is incorrect)
g.X16 changes to blank, empty or similar

> 3. Select c.W281 (it equals 35, which is incorrect)
c.W281 now shows -1, i can't find why it should calculate to other value, 

> 4. Press F9 (nothing happens)
running ants, but no change in C.W281

> 5. Press F9 again c.W281 changes to 34 (which is correct)
running ants, but no change in C.W281, also on third, fourth and so on press of
F9, but changes in g.row6, some 'd' changed to 'a'

> I attach the spreadsheet bug 3 (also the macro code which is not executed in the steps above but which you might need).
implemented and error message on file open and close gone, thus correct? 

> 6. g.X16=13 (which is correct).
g.X16 still blank, empty or similar

on hard recalc - strg-shift-F9 - a long process is started and at the end
g.I6:g.X6 are empty .. 

things which might affect the results: 

i'd put the macro code in a module of the file, had to re-bind AddListener and
RmvListener from that position to open and close event, not checked if other
macros are neccessary for recalc ... 

************
maybe your script is a little bit inaccurate and and step 2. was intended as: 
2. Delete contents of g.*W*6 - you placed the cursor there ... !W6!, not! X6???

then g.W16 changes to empty, and g.X16 to 13, and c.W281 to 34 ... just as you
requested ... just after deleting g.W6 ... 
************

same with ver 6.2.8.2, thus one can say actual versions are ok for your needs
... 

<<< one bug killed! >>>

-- 
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/20200102/32dde7b5/attachment.htm>