<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body>
<p>
<div>
<b><a class="bz_bug_link
bz_status_NEW "
title="NEW - EDITING: conditional formating does not update automatically"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=51015#c14">Comment # 14</a>
on <a class="bz_bug_link
bz_status_NEW "
title="NEW - EDITING: conditional formating does not update automatically"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=51015">bug 51015</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>hello @all ... to whom it may concern ... ,
sorry for undigging an old thread, i'm on the hunt for a bug,
not calculating the conditional format for C2:D10 in sample 1 while:
a) - being able to do so, strg-shift-F9 produces results as expected, and
b) - doing it with manually triggered forced recalc (strg-shift-F9),
(both tested with ver. 4.1.6.2, win7-x64)
shows two things to me,
1) - despite being complex the formula for the conditional formatting is ok,
2) - something for the view / display / calculation of the cells is excluded
from autocalculate (normally it shouldn't be like that),
3) - already in this version it is possible that aspects of cells become
excluded from autocalculate (that's what i'm hunting for),
additional results:
A) - it's not dependent on pointing to ranges,
B) - it's somehow dependent on pointing to a cell in the same row, works better
on them,
C) - other influences, in sample 2 switching the sheet, touching conditional
formatting and similar have the same effect as forced recalc, (was mentioned in
former comments),
D) - in sample 1 it's somehow dependent on the complexity of the formula and
pointing to ranges, a workaround with two conditions with simpler formulas
(less "$", no absolute sheet reference) pointing to ranges in single columns
works as expected,
E) - sample 1 works as expected with ver. 6.3.0.0.alpha0+ from 2019-03-09, it's
either fixed or plastered by changes in 4.2 to 6.3,
F) - E) is not the case for sample 2, it works as buggy in 6.3 as it has been
in 4.1,
who / what the heck made anything in the displayed result of a sheet dependent
on forced recalc (recalculations not done without additional triggering),</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>