[libreoffice-users] [calc]mmult with transpose arg drops last row

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+unsubscribe@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