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
lookup-longtail/0feed3 =ROWS({1;2;3;4}) 4 gsheets4 excel4 lattice4 ironcalc#VALUE! hyperformula4 libreoffice4 formulas#VALUE! pycel#NAME?
lookup-longtail/3cf205 =ROWS({1,2;3,4;5,6}) 3 gsheets3 excel3 lattice3 ironcalc#VALUE! hyperformula3 libreoffice3 formulas#VALUE! pycel#NAME?
lookup-longtail/82d96a =COLUMNS({1,2,3,4,5}) 5 gsheets5 excel5 lattice5 ironcalc#VALUE! hyperformula5 libreoffice5 formulas#VALUE! pycel#NAME?
lookup-longtail/11ac7b =COLUMNS({1,2;3,4;5,6}) 2 gsheets2 excel2 lattice2 ironcalc#VALUE! hyperformula2 libreoffice2 formulas#VALUE! pycel#NAME?