https://bugs.documentfoundation.org/show_bug.cgi?id=160739
Bug ID: 160739 Summary: Raise a matrix to an exponential with Calc Product: LibreOffice Version: 7.6.6.3 release Hardware: x86-64 (AMD64) OS: Linux (All) Status: UNCONFIRMED Severity: normal Priority: medium Component: Calc Assignee: libreoffice-bugs@lists.freedesktop.org Reporter: jjad...@yahoo.com Description: I am trying to raise a matrix to a high power using Calc but that's throwing the "Err:523". the same file worked perfectly fine in MS Excel and WSP. I checked the recursive formula option and it is active. I installed the version 24 and the error persists. LibreOffice Version: 7.6.6.3 OS: Linux Steps to Reproduce: 1. Fill the cells A2:C4 with a square (3x3) matrix (Mo) values 2. Fill Cell E2 with the power value. Let's say E2=7 3. Fille Cell G2 with the power counter recursive formula counter: =IF(ISNUMBER(G2),IF(G2=E2,TEXT(G2,"0"),G2+1),IF(VALUE(G2)=E2,G2,1)) 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) 5. This is an array formula, need to finish with CTRL+SHIFT+ENTER Actual Results: Err:523 Expected Results: Mew Matrix M = exp(Mo,7) Reproducible: Always User Profile Reset: Yes Additional Info: I tried the same example on version LO 24 with the same error results. -- You are receiving this mail because: You are the assignee for the bug.