DV-0023
gsheets: different error code — CONCAT, FILTER, NORM.S.DIST (+1 more)
Subjects (4)
Tests (7)
matches canonical diverges no fixture in this DV's cluster
| Test | Formula | Canonical | gsheets | excel | lattice | ironcalc | hyperformula | libreoffice | formulas | pycel |
|---|---|---|---|---|---|---|---|---|---|---|
CONCAT/concat-vs-concatenate-arity |
=CONCAT("a", "b", "c") |
abc | gsheets#N/A | excelabc | latticeabc | ironcalcabc | hyperformula#NAME? | libreoffice— | formulasabc | pycelabc |
FILTER/filter-no-results |
=FILTER({1;2;3}, {0;0;0}, "none") |
none | gsheets#N/A | excelnone | latticenone | ironcalc#NAME? | hyperformula{#N/A; #N/A; #N/A} | libreoffice— | formulasnone | pycel#NAME? |
CONCAT/concat-strings |
=CONCAT("hello", " ", "world") |
hello world | gsheets#N/A | excelhello world | latticehello world | ironcalchello world | hyperformula#NAME? | libreoffice— | formulashello world | pycelhello world |
REGEXEXTRACT/extract-return-mode-1-all-matches-row-vector |
=REGEXEXTRACT("a1 b2 c3", "\d+", 1) |
{1, 2, 3} | gsheets#N/A | excel{1, 2, 3} | lattice{1, 2, 3} | ironcalc#NAME? | hyperformula#NAME? | libreoffice— | formulas{1, 2, 3} | pycel#NAME? |
REGEXEXTRACT/extract-return-mode-2-capture-groups-from-first-match |
=REGEXEXTRACT("2025-03-01", "(\d{4})-(\d{2})-(\d{2})", 2) |
{2025, 03, 01} | gsheets#N/A | excel{2025, 03, 01} | lattice{2025, 03, 01} | ironcalc#NAME? | hyperformula#NAME? | libreoffice— | formulas{2025, 03, 01} | pycel#NAME? |
FILTER/filter-returns-no-rows |
=FILTER({1;2;3}, {FALSE;FALSE;FALSE}) |
#VALUE! | gsheets#N/A | excel#VALUE! | lattice#VALUE! | ironcalc#NAME? | hyperformula{#N/A; #N/A; #N/A} | libreoffice— | formulas#VALUE! | pycel#NAME? |
NORM.S.DIST/norm-s-dist-at-0-cdf |
=NORM.S.DIST(0, TRUE) |
0.5 | gsheets0.5 | excel0.5 | lattice0.5 | ironcalc0.5 | hyperformula#NAME? | libreoffice— | formulas0.5 | pycel#NAME? |