[Libreoffice-bugs] [Bug 148982] Multiple Operations fail to work with long sequences of dependent cells
https://bugs.documentfoundation.org/show_bug.cgi?id=148982 Eike Rathke changed: What|Removed |Added Assignee|libreoffice-b...@lists.free |er...@redhat.com |desktop.org | Status|NEW |ASSIGNED --- Comment #7 from Eike Rathke --- 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. -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 148982] Multiple Operations fail to work with long sequences of dependent cells
https://bugs.documentfoundation.org/show_bug.cgi?id=148982 --- Comment #6 from Wolfgang Jäger --- (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. -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 148982] Multiple Operations fail to work with long sequences of dependent cells
https://bugs.documentfoundation.org/show_bug.cgi?id=148982 Wolfgang Jäger changed: What|Removed |Added CC||j...@psilosoph.de --- Comment #5 from Wolfgang Jäger --- Created attachment 180618 --> https://bugs.documentfoundation.org/attachment.cgi?id=180618&action=edit 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. -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 148982] Multiple Operations fail to work with long sequences of dependent cells
https://bugs.documentfoundation.org/show_bug.cgi?id=148982 --- Comment #4 from snarfolus --- 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). -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 148982] Multiple Operations fail to work with long sequences of dependent cells
https://bugs.documentfoundation.org/show_bug.cgi?id=148982 Telesto changed: What|Removed |Added See Also||https://bugs.documentfounda ||tion.org/show_bug.cgi?id=14 ||8977 -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 148982] Multiple Operations fail to work with long sequences of dependent cells
https://bugs.documentfoundation.org/show_bug.cgi?id=148982 Regina Henschel changed: What|Removed |Added Status|RESOLVED|NEW Ever confirmed|0 |1 Resolution|DUPLICATE |--- --- Comment #3 from Regina Henschel --- 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. -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 148982] Multiple Operations fail to work with long sequences of dependent cells
https://bugs.documentfoundation.org/show_bug.cgi?id=148982 --- Comment #2 from Mike Kaganski --- (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. -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 148982] Multiple Operations fail to work with long sequences of dependent cells
https://bugs.documentfoundation.org/show_bug.cgi?id=148982 Regina Henschel changed: What|Removed |Added CC||rb.hensc...@t-online.de Status|UNCONFIRMED |RESOLVED Resolution|--- |DUPLICATE --- Comment #1 from Regina Henschel --- 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 *** -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 148982] Multiple Operations fail to work with long sequences of dependent cells
https://bugs.documentfoundation.org/show_bug.cgi?id=148982 Mike Kaganski changed: What|Removed |Added See Also||https://bugs.documentfounda ||tion.org/show_bug.cgi?id=14 ||8983 -- You are receiving this mail because: You are the assignee for the bug.