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[object Object] | excel[object Object] | latticeabc | ironcalcabc | hyperformula#NAME? | libreoffice— | formulasabc | pycelabc |
FILTER/filter-no-results |
=FILTER({1;2;3}, {0;0;0}, "none") |
none | gsheets[object Object] | excel[object Object] | latticenone | ironcalc#NAME? | hyperformula{#N/A; #N/A; #N/A} | libreoffice— | formulasnone | pycel#NAME? |
CONCAT/concat-strings |
=CONCAT("hello", " ", "world") |
hello world | gsheets[object Object] | excel[object Object] | 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[object Object] | excel{[object Object], [object Object], [object Object]} | 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[object Object] | excel{[object Object], [object Object], [object Object]} | 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}) |
#CALC! | gsheets[object Object] | excel[object Object] | lattice— | ironcalc— | hyperformula— | libreoffice— | formulas— | pycel— |
NORM.S.DIST/norm-s-dist-at-0-cdf |
=NORM.S.DIST(0, TRUE) |
0.5 | gsheets[object Object] | excel[object Object] | lattice0.5 | ironcalc0.5 | hyperformula#NAME? | libreoffice— | formulas0.5 | pycel#NAME? |