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 |
|---|---|---|---|---|---|---|---|---|---|---|
array-longtail/f65a1f |
=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} | libreoffice1 | formulas{1; 2; 3} | pycel#NAME? |
array-longtail/b41aec |
=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} | libreoffice1 | formulas{1, 2, 3} | pycel#NAME? |
array-longtail/4c8b50 |
=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} | libreoffice1 | formulas{1, 3; 2, 4} | pycel#NAME? |
array-longtail/126a11 |
=TRANSPOSE(A1:C1) |
{1; 2; 3} | gsheets{1; 2; 3} | excel{1; 2; 3} | lattice{1; 2; 3} | ironcalc#NAME? | hyperformula{1; 2; 3} | libreoffice1 | formulas{1; 2; 3} | pycel#NAME? |
array-longtail/f8a614 |
=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? | libreoffice1 | formulas{1, 0; 0, 1} | pycel#NAME? |
array-longtail/659fda |
=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? | libreoffice1 | formulas[3×3] | pycel#NAME? |
array-longtail/a97912 |
=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} | libreoffice1 | formulas{1, 2; 3, 4} | pycel#NAME? |