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.
The spreadsheet also has the transpose stored separately
in cells A5:C12, and then the mmult done with this separately
stored transpose, and the result is a 3x3 matrix, as expected.
Here's the printout of formulas in csv notation:
1,4,7,10
2,5,8,11
3,6,9,12
,,,
{=TRANSPOSE(C1:D3)},{=TRANSPOSE(C1:D3)},{=TRANSPOSE(C1:D3)},
{=TRANSPOSE(C1:D3)},{=TRANSPOSE(C1:D3)},{=TRANSPOSE(C1:D3)},
,,,
"{=MMULT(A1:B3,A5:C6)}","{=MMULT(A1:B3,A5:C6)}","{=MMULT(A1:B3,A5:C6)}",
"{=MMULT(A1:B3,A5:C6)}","{=MMULT(A1:B3,A5:C6)}","{=MMULT(A1:B3,A5:C6)}",
"{=MMULT(A1:B3,A5:C6)}","{=MMULT(A1:B3,A5:C6)}","{=MMULT(A1:B3,A5:C6)}",
,,,
"{=MMULT(A1:B3,TRANSPOSE(C1:D3))}","{=MMULT(A1:B3,TRANSPOSE(C1:D3))}","{=MMULT(A1:B3,TRANSPOSE(C1:D3))}",
"{=MMULT(A1:B3,TRANSPOSE(C1:D3))}","{=MMULT(A1:B3,TRANSPOSE(C1:D3))}","{=MMULT(A1:B3,TRANSPOSE(C1:D3))}",
Why are there only 2 rows instead of 3 in the last result
[the one done with mmult(a1:b3,transpose(c1:d3))]?
TIA.
-regards,
Larry
--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted
