https://bugs.documentfoundation.org/show_bug.cgi?id=129199
--- Comment #6 from R. Bingham <rdbing...@verizon.net> ---
Just to be clear regards:
"the error 'corrects' itself if you enter the new value a second time (then the
correct intermediate result is available,"
In the "enter the new value a second time" scenario the error seeming to
correct itself with a repeated numeric value entry is a coincidence of
displayed cell values, not a true correcting calculation. For ANY subsequent
entry in cell C17, even a non-numeric "foo", the observed behavior is that a
one-entry-operation lagging, previously calculated and remembered value is
being recalled and displayed in cell N20. Visually useful for an initial C17
entry of "foo", all dependent cells that ARE in correct synchronized
AutoCalculate immediately throw a #VALUE! error. A subsequent C17 entry of,
say, "fum", recalls the one-step-lagging calculated error #VALUE! to cell N20.
For more fun, now start entering valid numeric % entries in C17 (10% < X <
100%).
Regards.
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
