DV-0023

gsheets: different error code — CONCAT, FILTER, NORM.S.DIST (+1 more)

Cause
error-code
Category
value
Diverging engines
gsheets
Behavior signature
{"error":"#N/A"}
Test count
7
Seeded
2026-04-25
Last confirmed
2026-04-25

Subjects (4)

CONCAT FILTER NORM.S.DIST REGEXEXTRACT

Tests (7)

matches canonical diverges no fixture in this DV's cluster

Test Formula Canonical gsheets excel lattice ironcalc hyperformula libreoffice formulas pycel
divergences/15880e =CONCAT("a", "b", "c") abc gsheets#N/A excelabc latticeabc ironcalcabc hyperformula#NAME? libreoffice#NAME? formulasabc pycelabc
lambda/c2caf0 =FILTER({1;2;3}, {0;0;0}, "none") none gsheets#N/A excelnone lattice#VALUE! ironcalc#NAME? hyperformula[#N/A, #N/A, #N/A] libreoffice#NAME? formulasnone pycel#NAME?
operator/c3302a =CONCAT("hello", " ", "world") hello world gsheets#N/A excelhello world latticehello world ironcalchello world hyperformula#NAME? libreoffice#NAME? formulashello world pycelhello world
regex/725906 =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#NAME? formulas[1, 2, 3] pycel#NAME?
regex/7d98d3 =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#NAME? formulas[2025, 03, 01] pycel#NAME?
spill-edge/6289b6 =FILTER({1;2;3}, {FALSE;FALSE;FALSE}) {} gsheets#N/A excel#VALUE! lattice{} ironcalc#NAME? hyperformula[#N/A, #N/A, #N/A] libreoffice— formulas— pycel—
statistical-distributions/b1d7b4 =NORM.S.DIST(0, TRUE) 0.5 gsheets#N/A excel0.5 lattice0.5 ironcalc0.5 hyperformula#NAME? libreoffice#NAME? formulas0.5 pycel#NAME?