https://bugs.documentfoundation.org/show_bug.cgi?id=160739
--- Comment #17 from ady <[email protected]> --- (In reply to xhertan from comment #16) > 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. First, please only quote the parts of prior comments that are relevant to your new comment, instead quoting entire comments. If you just want to point to a prior comment with no particular text that you are replying to, please just leave the first line "In reply to... from comment..." and delete the rest of the quoted text. I took attachment 193762 from comment 2 and edited the array formula, from: =IF(ISNUMBER(G2);IF(G2=1;A2:C4;MMULT(A2:C4;H2:J4));H2:J4) to: =IF(ISNUMBER(G2);IF(G2=1;A2:C4;1);H2:J4) (introduced with CSE) and I still get Err:523. After Recalculate Hard, still the same error. BTW, in attachment 193762 from comment 2, the size of the last array (with Err:523) range H2:J5 (3 Columns X 4 Rows), is not the same size as the first range of data, A2:C4, which is not "really" an array. While in theory these factors should not be a problem for MMULT() (AFAIK), I have not tested these factors for this report. I performed a similar edition in attachment 193763 from comment 3 and I still see Err:523. Are there additional steps to follow? -- You are receiving this mail because: You are the assignee for the bug.
