DV-0018

lattice: different error code — ADD, AVERAGE, AVERAGE.WEIGHTED (+5 more)

Cause
error-code
Category
value
Diverging engines
lattice
Behavior signature
{"error":"#VALUE!"}
Test count
16
Seeded
2026-04-25
Last confirmed
2026-04-25

Subjects (8)

ADD AVERAGE AVERAGE.WEIGHTED DATE FILTER FLATTEN ISFORMULA Z.TEST

Tests (16)

matches canonical diverges no fixture in this DV's cluster

Test Formula Canonical gsheets excel lattice ironcalc hyperformula libreoffice formulas pycel
array-longtail/09f104 =FLATTEN({1;2}, {3;4}) [1, 2, 3, 4] gsheets[1, 2, 3, 4] excel#NAME? lattice#VALUE! ironcalc#NAME? hyperformula#NAME? libreoffice#NAME? formulas#NAME? pycel#NAME?
date/3844e3 =DATE(2025, 13, 1) 46023 gsheets46023 excel46023 lattice#VALUE! ironcalc46023 hyperformula46023 libreoffice46023 formulas46023 pycel46023
date/867dc7 =DATE(2025, 1, 32) 45689 gsheets45689 excel45689 lattice#VALUE! ironcalc45689 hyperformula45689 libreoffice45689 formulas45689 pycel45689
date/3082d8 =DATE(2025, -1, 15) 45611 gsheets45611 excel45611 lattice#VALUE! ironcalc45611 hyperformula45611 libreoffice45611 formulas45611 pycel45611
error-handling/86ffb0 =AVERAGE(A1:A3) #N/A gsheets#N/A excel#N/A lattice#VALUE! ironcalc#N/A hyperformula#N/A libreoffice— formulas— pycel—
info/e30cb1 =ISFORMULA(A1) true gsheetstrue exceltrue lattice#VALUE! ironcalctrue hyperformulatrue libreoffice#NAME? formulastrue pycel#NAME?
info/08e9f8 =ISFORMULA(A1) false gsheetsfalse excelfalse lattice#VALUE! ironcalcfalse hyperformulafalse libreoffice#NAME? formulasfalse pycel#NAME?
info/6074fe =ISFORMULA(A1) false gsheetsfalse excelfalse lattice#VALUE! ironcalcfalse hyperformulafalse libreoffice#NAME? formulasfalse pycel#NAME?
info/0b6ab6 =ISFORMULA(A1) false gsheetsfalse excelfalse lattice#VALUE! ironcalcfalse hyperformulafalse libreoffice#NAME? formulasfalse pycel#NAME?
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/eb257a =ADD(TRUE, 1) 2 gsheets2 excel#NAME? lattice#VALUE! ironcalc#NAME? hyperformula#NAME? libreoffice#NAME? formulas#NAME? pycel#NAME?
operator/a6e889 =ADD("2", 3) 5 gsheets5 excel#NAME? lattice#VALUE! ironcalc#NAME? hyperformula#NAME? libreoffice#NAME? formulas#NAME? pycel#NAME?
statistical-analytics/fe904d =Z.TEST(A1:A5, 3) 0.5 gsheets0.5 excel0.5 lattice#VALUE! ironcalc0.5 hyperformula0.5 libreoffice#NAME? formulas0.5 pycel#NAME?
statistical-descriptive/a84e6c =AVERAGE.WEIGHTED({1,2,3}, {1,1,1}) 2 gsheets2 excel#NAME? lattice#VALUE! ironcalc#NAME? hyperformula#NAME? libreoffice#NAME? formulas#NAME? pycel#NAME?
statistical-descriptive/702ac0 =AVERAGE.WEIGHTED({1,2,3}, {1,2,3}) 2.33333 gsheets2.33333 excel#NAME? lattice#VALUE! ironcalc#NAME? hyperformula#NAME? libreoffice#NAME? formulas#NAME? pycel#NAME?
statistical-descriptive/772ab9 =AVERAGE.WEIGHTED(A1:A3, B1:B3) 2.33333 gsheets2.33333 excel#NAME? lattice#VALUE! ironcalc#NAME? hyperformula#NAME? libreoffice#NAME? formulas#NAME? pycel#NAME?