DV-0022
libreoffice: return shape differs — MINVERSE, MMULT, TRANSPOSE
Subjects (3)
Tests (7)
matches canonical diverges no fixture in this DV's cluster
| Test | Formula | Canonical | gsheets | excel | lattice | ironcalc | hyperformula | libreoffice | formulas | pycel |
|---|---|---|---|---|---|---|---|---|---|---|
TRANSPOSE/transpose-row-to-col |
=TRANSPOSE({1,2,3}) |
{1; 2; 3} | gsheets{1; 2; 3} | excel{1; 2; 3} | lattice{1; 2; 3} | ironcalc#NAME? | hyperformula{1; 2; 3} | libreoffice— | formulas{1; 2; 3} | pycel#NAME? |
TRANSPOSE/transpose-col-to-row |
=TRANSPOSE({1;2;3}) |
{1, 2, 3} | gsheets{1, 2, 3} | excel{1, 2, 3} | lattice{1, 2, 3} | ironcalc#NAME? | hyperformula{1, 2, 3} | libreoffice— | formulas{1, 2, 3} | pycel#NAME? |
TRANSPOSE/transpose-2x2 |
=TRANSPOSE({1,2;3,4}) |
{1, 3; 2, 4} | gsheets{1, 3; 2, 4} | excel{1, 3; 2, 4} | lattice{1, 3; 2, 4} | ironcalc#NAME? | hyperformula{1, 3; 2, 4} | libreoffice— | formulas{1, 3; 2, 4} | pycel#NAME? |
TRANSPOSE/transpose-from-grid |
=TRANSPOSE(A1:C1) |
{1; 2; 3} | gsheets{1; 2; 3} | excel{1; 2; 3} | lattice{1; 2; 3} | ironcalc#NAME? | hyperformula{1; 2; 3} | libreoffice— | formulas{1; 2; 3} | pycel#NAME? |
MINVERSE/minverse-2x2-identity |
=MINVERSE({1,0;0,1}) |
{1, 0; 0, 1} | gsheets{1, 0; 0, 1} | excel{1, 0; 0, 1} | lattice{1, 0; 0, 1} | ironcalc#NAME? | hyperformula#NAME? | libreoffice— | formulas{1, 0; 0, 1} | pycel#NAME? |
MINVERSE/minverse-3x3-identity |
=MINVERSE({1,0,0;0,1,0;0,0,1}) |
[3×3] | gsheets[3×3] | excel[3×3] | lattice[3×3] | ironcalc#NAME? | hyperformula#NAME? | libreoffice— | formulas[3×3] | pycel#NAME? |
MMULT/mmult-a-times-identity |
=MMULT({1,2;3,4}, {1,0;0,1}) |
{1, 2; 3, 4} | gsheets{1, 2; 3, 4} | excel{1, 2; 3, 4} | lattice{1, 2; 3, 4} | ironcalc#NAME? | hyperformula{1, 2; 3, 4} | libreoffice— | formulas{1, 2; 3, 4} | pycel#NAME? |