assay

DV-0039

formulas, ironcalc: different error code — COLUMNS, ROWS

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

Subjects (2)

COLUMNS ROWS

Tests (4)

matches canonical diverges no fixture in this DV's cluster

Test Formula Canonical gsheets excel lattice ironcalc hyperformula libreoffice formulas pycel
ROWS/rows-array-literal =ROWS({1;2;3;4}) 4 gsheets4 excel4 lattice4 ironcalc#VALUE! hyperformula4 libreoffice— formulas#VALUE! pycel#NAME?
ROWS/rows-2d-array-literal =ROWS({1,2;3,4;5,6}) 3 gsheets3 excel3 lattice3 ironcalc#VALUE! hyperformula3 libreoffice— formulas#VALUE! pycel#NAME?
COLUMNS/columns-array-literal =COLUMNS({1,2,3,4,5}) 5 gsheets5 excel5 lattice5 ironcalc#VALUE! hyperformula5 libreoffice— formulas#VALUE! pycel#NAME?
COLUMNS/columns-2d-array-literal =COLUMNS({1,2;3,4;5,6}) 2 gsheets2 excel2 lattice2 ironcalc#VALUE! hyperformula2 libreoffice— formulas#VALUE! pycel#NAME?