https://bugs.documentfoundation.org/show_bug.cgi?id=160739
--- Comment #16 from xhertan <[email protected]> --- (In reply to ady from comment #13) > (In reply to Regina Henschel from comment #12) > > > I set the report to New as enhancement request to introduce a iteration mode > > similar to Excel. > > The OP does not agree (nor understand, apparently) that the problem is a > lack of support for iteration without convergence in Calc. > > According to the OP, the problem is about the MMULT() function; it is not: > > > (In reply to xhertan from comment #0) > > 4. Select Fill the Output Matrix cells H2:J4 with the array formula: > > =IF(ISNUMBER(G2),IF(G2=1,A2:C4,MMULT(A2:C4,H2:J4)),H2:J4) > > > > > Actual Results: > > Err:523 > > > > Expected Results: > > Mew Matrix M = exp(Mo,7) > > Changing such over-complicated (and contradicting) formula to: > > =IF(ISNUMBER(G2),IF(G2=1,A2:C4,1),H2:J4) > > eliminates the influence of MMULT() and the Err:523 will still occur. > > Since the report is about MMULT() being somehow wrong (which it isn't), and > after repeatedly trying to explain this to the OP, then this report should > be Not-A-Bug (NAB). > > For this ticket to be an enhancement request about non-converging iterations > in Calc, _that_ should be the real content of the Summary and the initial > Description, with an OP that knows what exactly is being requested, > containing a clear sample case. Unfortunately, we don't have such situation > here. Ady, Your new formula confirms the issue is with the MMULT function in a recursive formula in LO Calc. I tested the new formula you posted: "IF(ISNUMBER(G2),IF(G2=1,A2:C4,1),H2:J4)" and this worked fine on my side with the expected result of 1 for all cells. Please, see my previous comment of why the expected result is 1 for your new formula. -- You are receiving this mail because: You are the assignee for the bug.
