https://bugs.freedesktop.org/show_bug.cgi?id=73756
Priority: medium
Bug ID: 73756
Assignee: libreoffice-bugs@lists.freedesktop.org
Summary: Other: mmult with transpose arg drops last row
Severity: normal
Classification: Unclassified
OS: Linux (All)
Reporter: cppljev...@gmail.com
Hardware: Other
Whiteboard: BSA
Status: UNCONFIRMED
Version: 4.1.2.3 release
Component: Spreadsheet
Product: LibreOffice
Created attachment 92313
--> https://bugs.freedesktop.org/attachment.cgi?id=92313&action=edit
.ods demonstrating bug.
Problem description:
I've a spreadsheet with 2 3x2 matridces side by side (A1:D3).
I want to mmult(A1:B3;transpose(C1:D3)); however,
the result has the last row truncated. IOW, the
resulting matrix is 2x3 instead of 3x3.
Steps to reproduce:
Here's the printout of formulas in csv notation:
1,4,7,10
2,5,8,11
3,6,9,12
,,,
{=3DTRANSPOSE(C1:D3)},{=3DTRANSPOSE(C1:D3)},{=3DTRANSPOSE(C1:D3)},
{=3DTRANSPOSE(C1:D3)},{=3DTRANSPOSE(C1:D3)},{=3DTRANSPOSE(C1:D3)},
,,,
"{=3DMMULT(A1:B3,A5:C6)}","{=3DMMULT(A1:B3,A5:C6)}","{=3DMMULT(A1:B3,A5:C6)=
}",
"{=3DMMULT(A1:B3,A5:C6)}","{=3DMMULT(A1:B3,A5:C6)}","{=3DMMULT(A1:B3,A5:C6)=
}",
"{=3DMMULT(A1:B3,A5:C6)}","{=3DMMULT(A1:B3,A5:C6)}","{=3DMMULT(A1:B3,A5:C6)=
}",
,,,
"{=3DMMULT(A1:B3,TRANSPOSE(C1:D3))}","{=3DMMULT(A1:B3,TRANSPOSE(C1:D3))}","=
{=3DMMULT(A1:B3,TRANSPOSE(C1:D3))}",
"{=3DMMULT(A1:B3,TRANSPOSE(C1:D3))}","{=3DMMULT(A1:B3,TRANSPOSE(C1:D3))}","=
{=3DMMULT(A1:B3,TRANSPOSE(C1:D3))}",
IOW, when the array formula:
MMULT(A1:B3,TRANSPOSE(C1:D3))
is put in A12, the result is a 2 row by 3 column
matrix.
Current behavior:
The result is a 2 row by 3 column matrix in A12:C13
Expected behavior:
The result should be a 3 row by 3 column matrix
the same as that in A8:C10
BTW, this was reported at:
http://listarchives.libreoffice.org/global/users/msg36097.html
but that post received no response; hence, I assume
no body has experienced it and it is an actual bug
instead of me doing something stupid.
-regards,
Larry
Operating System: Ubuntu
Version: 4.1.2.3 release
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
