[Libreoffice-bugs] [Bug 117049] Self-referencing circular reference iteration executes twice

[bugzilla-daemon at bugs.documentfoundation.org]

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

Eike Rathke <erack at redhat.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
            Summary|Severe bug in LibreOffice   |Self-referencing circular
                   |(Calc Speadsheet)           |reference iteration
                   |                            |executes twice
            Version|unspecified                 |Inherited From OOo
           Assignee|libreoffice-bugs at lists.free |erack at redhat.com
                   |desktop.org                 |
             Status|NEEDINFO                    |ASSIGNED

--- Comment #15 from Eike Rathke <erack at redhat.com> ---
Mike, I know what the OP is trying here, and this kind of self-adder in Excel
works like a counter, in this example adding A1 to the current value of B1 in
B1 for each iteration. An initial value of 0 of the so far uncalculated formula
result in B1 is a fair assumption (the actual cell content previously in B1
before entering the formula doesn't matter at all) and seems to be what Excel
uses. While detecting the circular reference we execute the underlying
calculation twice in this example, hence get 200 instead of 100.

-- 
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/20180620/2f1e54ea/attachment.html>