<html> <head> <base href="https://bugs.documentfoundation.org/"> </head> <body> <div> <a class="bz_bug_link bz_status_NEW " title="NEW - calc autocalculate failing sometimes on editing (move or delete of cells or undo) in ranges referenced in formulas" href="https://bugs.documentfoundation.org/show_bug.cgi?id=123714#c4">Comment # 4</a> on <a class="bz_bug_link bz_status_NEW " title="NEW - calc autocalculate failing sometimes on editing (move or delete of cells or undo) in ranges referenced in formulas" href="https://bugs.documentfoundation.org/show_bug.cgi?id=123714">bug 123714</a> from <a class="email" href="mailto:newbie-02@gmx.de" title="b. <newbie-02@gmx.de>"> b.</a> <pre>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.</pre> </div> <hr> You are receiving this mail because: <ul> <li>You are the assignee for the bug.</li> </ul> </body> </html>