[Libreoffice-bugs] [Bug 129199] AutoCalculate silent, deceptive fail. Indicative pattern of one edit step lag in AC update noticed.
bugzilla-daemon at bugs.documentfoundation.org
bugzilla-daemon at bugs.documentfoundation.org
Sun Dec 8 05:56:28 UTC 2019
https://bugs.documentfoundation.org/show_bug.cgi?id=129199
--- Comment #6 from R. Bingham <rdbingham at 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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20191208/ef263a0c/attachment-0001.html>
More information about the Libreoffice-bugs
mailing list