Summary: | Multiple Operations fail to work with long sequences of dependent cells | ||
---|---|---|---|
Product: | LibreOffice | Reporter: | Mike Kaganski <mikekaganski> |
Component: | Calc | Assignee: | Eike Rathke <erack> |
Status: | ASSIGNED --- | ||
Severity: | normal | CC: | erack, jag, nhall, rb.henschel, telesto |
Priority: | medium | ||
Version: | Inherited From OOo | ||
Hardware: | All | ||
OS: | All | ||
URL: | https://ask.libreoffice.org/t/calc-getting-list-of-output-values-for-a-set-of-input-values/77238/ | ||
See Also: |
https://bugs.documentfoundation.org/show_bug.cgi?id=148983 https://bugs.documentfoundation.org/show_bug.cgi?id=148977 |
||
Whiteboard: | |||
Crash report or crash signature: | Regression By: | ||
Attachments: | Demonstration of the milit of 400 formula steps |
Description
Mike Kaganski
2022-05-08 09:26:24 UTC
Same as in bug 148983. "A cell, which contains the current value must not depend on cells which are used in the sample calculation, neither directly nor indirectly." *** This bug has been marked as a duplicate of bug 148983 *** (In reply to Regina Henschel from comment #1) OMG. Please read the comment in bug 148983 that explains that the quote has nothing to do with the problem there; and also please execute what is explained here to see that this is completely different both to the quote and to the bug 148983. Sorry Mike, you are right. I do not get an error, but a wrong result. That is worse than an error. Curious, =MULTIPLE.OPERATIONS(A$401;A1;$B1) has correct result, whereas =MULTIPLE.OPERATIONS(A$402;A1;$B1) is wrong. In addition there is an update problem in column A. If you change the value in A1, values below row 53 (about) are not updated. But you need to hard recalculate. I am experiencing what appears to be the same bug in LibreOffice 6.4.7.2 (build ID: 1:6.4.7-0ubuntu0.20.04.4). Created attachment 180618 [details]
Demonstration of the milit of 400 formula steps
Experimenting with Mike's model (in V 7.3.3.2 -64- under Win10) I got a maximum of 400 steps (result formula from A$401) MULTIPLEOPERATIONS() worked correctly with.
Very strange! Looks like the consequence of an arbitrary decision which didn't find its way into specifying/helping texts.
See attachment.
(In reply to snarfolus from comment #4) > I am experiencing what appears to be the same bug in LibreOffice 6.4.7.2 > (build ID: 1:6.4.7-0ubuntu0.20.04.4). Sorry. You won't get fixed old versions. I veryfied the bug as showing in my example also with LibO V3.3 Portable. That's the all-heritage version. This is a problem of MULTIPLE.OPERATIONS() (TableOp) accessing the recursion in column A (through the A$1 or A$255 or A$401 or A$402 "replacements"). The maximum recursion limit is 400 after which further blocks of recursions are assembled in reverse (logically forward) order and if completed all cells are iterated. In a TableOp scenario this seems to prematurely end, hence it works until A$401 but not from A$402 on. Needs further investigation. *** Bug 148977 has been marked as a duplicate of this bug. *** When fixing, https://bugs.documentfoundation.org/attachment.cgi?id=179987 of bug 148977 should be confirmed or that bug reopened. |