[Libreoffice-bugs] [Bug 51015] EDITING: conditional formating does not update automatically
bugzilla-daemon at bugs.documentfoundation.org
bugzilla-daemon at bugs.documentfoundation.org
Mon Mar 11 06:41:32 UTC 2019
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>
More information about the Libreoffice-bugs
mailing list