https://bugs.documentfoundation.org/show_bug.cgi?id=101238
Qaz <[email protected]> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|RESOLVED |REOPENED
Resolution|NOTABUG |---
Ever confirmed|0 |1
--- Comment #2 from Qaz <[email protected]> ---
With respect, this *is* a bug, because there is no circular reference,
MULTIPLE.OPERATIONS incorrectly claims that there is.
In the example spreadsheet I attached:
D1 precedes A1
A1 precedes A2:A1000, which includes A399
A399 precedes D2 (D2, not D1 !)
This is a two-ended chain, not a circle. There is no circular reference here.
The bug is that MULTIPLE.OPERATIONS *incorrectly* claims that there is a
circular reference when the "Formulas" cell has more than a certain number of
precedent calculations. In this example spreadsheet the number of cells that
need to be evaluated to find the value of D2 are:
A2 -> A399 - 398 cells
A1 -> A2 - 1 cell
D1 -> A1 - 1 cell
Total of 400 precedent calculations. If you increase this slightly, for example
by setting cell D2 to "=A1000" you will see the error occur.
At this point, close the spreadsheet without saving, reopen it, and just for
fun set cell D2 to "=A55". This will work. You can then bisect the range to see
at what number of precedent calculations it fails. I found it to be 400 as
above.
--
You are receiving this mail because:
You are the assignee for the bug._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
