DV-0037

formulas: different error code — COUNTA, IMPRODUCT, SEARCH

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

Subjects (3)

COUNTA IMPRODUCT SEARCH

Tests (4)

matches canonical diverges no fixture in this DV's cluster

Test Formula Canonical gsheets excel lattice ironcalc hyperformula libreoffice formulas pycel
engineering/9c3a01 =IMPRODUCT("3+4i", "2") 6+8i gsheets6+8i excel6+8i lattice{__typeof: "Complex", … ironcalc6+8i hyperformula6+8i libreoffice6+8i formulas#VALUE! pycel#NAME?
statistical-descriptive/cd8f6b =COUNTA(1, "x", TRUE) 3 gsheets3 excel3 lattice3 ironcalc3 hyperformula3 libreoffice3 formulas#VALUE! pycel#NAME?
text-longtail/031624 =SEARCH("m?r", "Miriam McGovern") 4 gsheets1 excel1 lattice1 ironcalc1 hyperformula1 libreoffice1 formulas#VALUE! pycel#NAME?
text-longtail/b8b6d1 =SEARCH("M*n", "Miriam McGovern") 1 gsheets1 excel1 lattice1 ironcalc1 hyperformula1 libreoffice1 formulas#VALUE! pycel#NAME?