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
Context
- [libreoffice-users] [calc]mmult with transpose arg drops last row · Larry Evans
Privacy Policy |
Impressum (Legal Info) |
Copyright information: Unless otherwise specified, all text and images
on this website are licensed under the
Creative Commons Attribution-Share Alike 3.0 License.
This does not include the source code of LibreOffice, which is
licensed under the Mozilla Public License (
MPLv2).
"LibreOffice" and "The Document Foundation" are
registered trademarks of their corresponding registered owners or are
in actual use as trademarks in one or more countries. Their respective
logos and icons are also subject to international copyright laws. Use
thereof is explained in our
trademark policy.