DV-0056
gsheets: return shape differs — SORTN
Subjects (1)
Tests (2)
matches canonical diverges no fixture in this DV's cluster
| Test | Formula | Canonical | gsheets | excel | lattice | ironcalc | hyperformula | libreoffice | formulas | pycel |
|---|---|---|---|---|---|---|---|---|---|---|
external/f932ba |
=SORTN({5;2;8;1;4}, 3) |
#NAME? | gsheets[1, 2, 4] | excel#NAME? | lattice#NAME? | ironcalc#NAME? | hyperformula#NAME? | libreoffice#NAME? | formulas#NAME? | pycel#NAME? |
external/3d3ee3 |
=SORTN({5;2;8;1;4}, 3, 0, 1, TRUE) |
#NAME? | gsheets[1, 2, 4] | excel#NAME? | lattice#NAME? | ironcalc#NAME? | hyperformula#NAME? | libreoffice#NAME? | formulas#NAME? | pycel#NAME? |