<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body>
<p>
<div>
<b><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#c9">Comment # 9</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 <span class="vcard"><a class="email" href="mailto:newbie-02@gmx.de" title="b. <newbie-02@gmx.de>"> <span class="fn">b.</span></a>
</span></b>
<pre>impressions from playing with ver 6.2.2.0.0 2019-02-17:
some things are changing?
save and reload gives corrected - calculated - results,
cells whose formulas were changed by a move become reset to their original
references by 'undo',
but some of the fundamental problem is still present:
the upper right cell of a column affected by a move is excluded from
autocalculate, see screenshot 'after_move_calculate_of_e3_still_fails.jpg',
this is kept after correcting it's value with a hard recalc, see screenshot
'after_hard_recalc_e3_still_fails_autocalculating.jpg', D3 reacts to the change
in B3 while E3 doesn't,
after undo of the move the other affected cells fail, see screenshot
'after_undo_calculate_of_e4_and_e5_still_fail.jpg',
all above errors can be corrected by ctrl-shift-F9,
care not pressing 'alt' beforehand,
everything works much better when you insert blank rows between each row with
data, (i suspect this 'breaks' the 'shared formulas' apart?)
funnily it starts misbehaving again when you delete the inserted rows,
(shared formulas 'reconnected'?)
my three cents:
it's a fundamental risk that any cells can be excluded from autocalculate in
any way,
something is wrong - inconsistent - in the design of the handling of cells with
similar formulas,
both together produce problems</pre>
</div>
</p>
<hr>
<span>You are receiving this mail because:</span>
<ul>
<li>You are the assignee for the bug.</li>
</ul>
</body>
</html>