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 |
|---|---|---|---|---|---|---|---|---|---|---|
SORTN/sortn-top-3 |
=SORTN({5;2;8;1;4}, 3) |
#NAME? | gsheets{[object Object]; [object Object]; [object Object]} | excel[object Object] | lattice#NAME? | ironcalc#NAME? | hyperformula#NAME? | libreoffice— | formulas#NAME? | pycel#NAME? |
SORTN/sortn-top-3-ascending |
=SORTN({5;2;8;1;4}, 3, 0, 1, TRUE) |
#NAME? | gsheets{[object Object]; [object Object]; [object Object]} | excel[object Object] | lattice#NAME? | ironcalc#NAME? | hyperformula#NAME? | libreoffice— | formulas#NAME? | pycel#NAME? |