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: [email protected]
Reporter: [email protected]
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.
