[Libreoffice-bugs] [Bug 123714] calc autocalculate failing sometimes on editing (move or delete of cells or undo) in ranges referenced in formulas

[bugzilla-daemon at bugs.documentfoundation.org]

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

--- Comment #4 from b. <newbie-02 at gmx.de> ---
imho: 

- the disbehaviour is not! a problem of hard links ('$-references'), E3 works
while E2 fails, 

- not showing up in sheets with minor changes is just an effect of occurring
only under rare special circumstances, 

- the bug is not a dup of 120013, it's another result of the same basic fault, 

- as plenty other bugs are ... 

and the basic fault is 'when and why' autocalculate is triggered or not, 

specially why, under some rare circumstances, some cells are omitted, 

workaround #0: warn all users that results 'may' be erroneous, 

workaround #1: frequently press 'ctrl-shift-F9', 

workaround #2: create an easier keyboard shortcut for that, 

workaround #3: create a time triggered makro for that, 

workaround #4: implement something similar to #3 in the code, 

- that might be an option while the basic fault isn't found -

- be sure to make that dependent of 'autocalculate' being activated -  

recommended solution: find out why sometimes some cells are omitted from
autocalculate and correct that 

remove all workarounds, 

warn all users that older results 'may' be erroneous, 

b.

-- 
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/20190226/8d198bba/attachment.html>