DV-0055

lattice: different error code — AVERAGE, SUM

Cause
error-code
Category
error-code
Diverging engines
lattice
Behavior signature
{"error":"#DIV/0!"}
Test count
2
Seeded
2026-04-25
Last confirmed
2026-04-25

Subjects (2)

AVERAGE SUM

Tests (2)

matches canonical diverges no fixture in this DV's cluster

Test Formula Canonical gsheets excel lattice ironcalc hyperformula libreoffice formulas pycel
error-handling/bc1c25 =SUM(#N/A, 1/0) #N/A gsheets#N/A excel#N/A lattice#DIV/0! ironcalc#N/A hyperformula#N/A libreoffice— formulas— pycel—
type-coercion/3e62ee =AVERAGE(TRUE, FALSE, TRUE) 0.666667 gsheets0.666667 excel0.666667 lattice#DIV/0! ironcalc0.666666667 hyperformula#NAME? libreoffice— formulas— pycel—