DV-0118
gsheets: return shape differs — QUERY
Subjects (1)
Tests (1)
matches canonical diverges no fixture in this DV's cluster
| Test | Formula | Canonical | gsheets | excel | lattice | ironcalc | hyperformula | libreoffice | formulas | pycel |
|---|---|---|---|---|---|---|---|---|---|---|
QUERY/query-select-col |
=QUERY({1,"a";2,"b";3,"c"}, "select Col2") |
{a; b; c} | gsheets{a; b; c} | excel#NAME? | lattice{a; b; c} | ironcalc#NAME? | hyperformula#NAME? | libreoffice— | formulas#NAME? | pycel#NAME? |