Date: prev next · Thread: first prev next last
2014 Archives by date, by thread · List index


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


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.