assay

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
IMPRODUCT/improduct-by-real =IMPRODUCT("3+4i", "2") 6+8i gsheets6+8i excel6+8i lattice6+8i ironcalc6+8i hyperformula6+8i libreoffice— formulas#VALUE! pycel#NAME?
COUNTA/counta-inline =COUNTA(1, "x", TRUE) 3 gsheets3 excel3 lattice3 ironcalc3 hyperformula3 libreoffice— formulas#VALUE! pycel#NAME?
SEARCH/search-wildcard-question =SEARCH("m?r", "Miriam McGovern") 4 gsheets1 excel1 lattice1 ironcalc1 hyperformula1 libreoffice— formulas#VALUE! pycel#NAME?
SEARCH/search-wildcard-star =SEARCH("M*n", "Miriam McGovern") 1 gsheets1 excel1 lattice1 ironcalc1 hyperformula1 libreoffice— formulas#VALUE! pycel#NAME?