https://bugs.documentfoundation.org/show_bug.cgi?id=160739
--- Comment #13 from ady <adylo811...@gmail.com> --- (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. -- You are receiving this mail because: You are the assignee for the bug.
