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? |