https://bugs.documentfoundation.org/show_bug.cgi?id=101238
--- Comment #4 from Qaz <[email protected]> ---
Hi Miguel,
I created the MULTIPLE.OPERATIONS parameters in the example spreadsheet
attached to this bug by:
- highlighting F2:G11
- selecting Data - Multiple Operations from the menu
- entering $D$2 in the "Formulas" field of the dialog box
- entering $D$1 in the "Column Input Cell" of the dialog box
This creates in the formulas you see, and the output is arithmetically accurate
unless you exceed the magic number of 400 precedent calculations. You can
verify this by, for example, entering "2" in cell D1 manually and comparing the
value of A399 with the value of G3. They are the same. Similar for the other
values from 1-10.
If as you suggest, you were to swap the second and third parameter of each
MULTIPLE.OPERATIONS formula then you would end up with incorrect results. So
the spreadsheet is constructed correctly, without any circular references. The
error messages really are bogus.
--
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
