https://bugs.documentfoundation.org/show_bug.cgi?id=117049
Eike Rathke <er...@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-b...@lists.free |er...@redhat.com
|desktop.org |
Status|NEEDINFO |ASSIGNED
--- Comment #15 from Eike Rathke <er...@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._______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
