assay

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
FLATTEN/flatten-multiple-args =FLATTEN({1;2}, {3;4}) {1; 2; 3; 4} gsheets{1; 2; 3; 4} excel#NAME? lattice{1; 2; 3; 4} ironcalc#NAME? hyperformula#NAME? libreoffice— formulas#NAME? pycel#NAME?
DATE/date-month-overflow =DATE(2025, 13, 1) 46023 gsheets46023 excel46023 lattice#VALUE! ironcalc46023 hyperformula46023 libreoffice— formulas46023 pycel46023
DATE/date-day-overflow =DATE(2025, 1, 32) 45689 gsheets45689 excel45689 lattice#VALUE! ironcalc45689 hyperformula45689 libreoffice— formulas45689 pycel45689
DATE/date-negative-month =DATE(2025, -1, 15) 45611 gsheets45611 excel45611 lattice#VALUE! ironcalc45611 hyperformula45611 libreoffice— formulas45611 pycel#NAME?
AVERAGE/average-of-range-with-error-cell =AVERAGE(A1:A3) #N/A gsheets#N/A excel#N/A lattice#N/A ironcalc#N/A hyperformula#N/A libreoffice— formulas#N/A pycel#NAME?
ISFORMULA/isformula-of-formula-cell =ISFORMULA(A1) true gsheetstrue exceltrue latticetrue ironcalctrue hyperformulatrue libreoffice— formulastrue pycel#NAME?
ISFORMULA/isformula-of-number-cell =ISFORMULA(A1) false gsheetsfalse excelfalse latticefalse ironcalcfalse hyperformulafalse libreoffice— formulasfalse pycel#NAME?
ISFORMULA/isformula-of-blank-cell =ISFORMULA(A1) false gsheetsfalse excelfalse latticefalse ironcalcfalse hyperformulafalse libreoffice— formulasfalse pycel#NAME?
ISFORMULA/isformula-of-text-cell =ISFORMULA(A1) false gsheetsfalse excelfalse latticefalse ironcalcfalse hyperformulafalse libreoffice— formulasfalse pycel#NAME?
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?
ADD/add-boolean-coerces-to-1 =ADD(TRUE, 1) 2 gsheets2 excel#NAME? lattice#VALUE! ironcalc#NAME? hyperformula#NAME? libreoffice— formulas#NAME? pycel#NAME?
ADD/add-string-number-coerces =ADD("2", 3) 5 gsheets5 excel#NAME? lattice5 ironcalc#NAME? hyperformula#NAME? libreoffice— formulas#NAME? pycel#NAME?
Z.TEST/z-test-canonical =Z.TEST(A1:A5, 3) 0.5 gsheets0.5 excel0.5 lattice0.5 ironcalc0.5 hyperformula0.5 libreoffice— formulas0.5 pycel#NAME?
AVERAGE.WEIGHTED/average-weighted-basic =AVERAGE.WEIGHTED({1,2,3}, {1,1,1}) 2 gsheets2 excel#NAME? lattice2 ironcalc#NAME? hyperformula#NAME? libreoffice— formulas#NAME? pycel#NAME?
AVERAGE.WEIGHTED/average-weighted-skewed =AVERAGE.WEIGHTED({1,2,3}, {1,2,3}) 2.33333 gsheets2.33333 excel#NAME? lattice2.33333 ironcalc#NAME? hyperformula#NAME? libreoffice— formulas#NAME? pycel#NAME?
AVERAGE.WEIGHTED/average-weighted-grid =AVERAGE.WEIGHTED(A1:A3, B1:B3) 2.33333 gsheets2.33333 excel#NAME? lattice2.33333 ironcalc#NAME? hyperformula#NAME? libreoffice— formulas#NAME? pycel#NAME?