[Libreoffice-bugs] [Bug 51015] EDITING: conditional formating does not update automatically

[bugzilla-daemon at bugs.documentfoundation.org]

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

--- Comment #14 from b. <newbie-02 at gmx.de> ---
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),

-- 
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/20190311/fdfb7ca1/attachment.html>