[Libreoffice-bugs] [Bug 142636] Libreoffice Calc does not recalculate formula (not even by forcing with F9 or CTRL+SHIFT+F9)
bugzilla-daemon at bugs.documentfoundation.org
bugzilla-daemon at bugs.documentfoundation.org
Thu Jun 3 11:37:33 UTC 2021
https://bugs.documentfoundation.org/show_bug.cgi?id=142636
Eike Rathke <erack at redhat.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|UNCONFIRMED |RESOLVED
Resolution|--- |NOTABUG
--- Comment #1 from Eike Rathke <erack at redhat.com> ---
Check your math.
B6: =B5-B4
B7: =B3*B6+B3*B4
which is
=B3*(B5-B4)+B3*B4
which is
=B3*B5-B3*B4+B3*B4
You are effectively eliminating any change in B4 with -B3*B4+B3*B4
--
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/20210603/87353765/attachment.htm>
More information about the Libreoffice-bugs
mailing list