https://bugs.documentfoundation.org/show_bug.cgi?id=160739
--- Comment #15 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, I was trying to port my research calculations from MS Excel to LO Cal when I noted that LO Cal cannot execute these simple calculations. Again, I tested those simple lines in other programs and found that only LO Cal has problems with that. I don't understand where is the overcomplicated or contradicting part of this line: =IF(ISNUMBER(G2),IF(G2=1,A2:C4,MMULT(A2:C4,H2:J4)),H2:J4) this line is executing a simple comparison to check if the number on "G2" is a number since: 1. if "G2" is a number then check that "G2" == 1, and proceed to paste the values on cells A2:C2. This is A^1 = A 2. if "G2" is a number and G2 !=1 then execute the matrix multiplication MMULT(A2:C4,H2:J4). This is A*A^(n-1) 3. if "G2" is not a number then leave the value H2:J4 untouched. Check for errors as non-numbers. with the help of a counter, I can execute the sequence in a bounded (n) iteration to reach A^n=A^(n-1)*A^(n-2)*A^(n-3)...A. The objective of this iteration is to raise a square matrix to a specific power (n). So, I can play with different powers. Again, these calculations are perfectly executed in MS Excel, WPS Office, and SoftMaker Office. Only, LO is unable to execute the iteration. -- You are receiving this mail because: You are the assignee for the bug.
