DV-0032

excel: function not implemented — ARRAY_CONSTRAIN, FLATTEN

Cause
missing-function
Category
value
Diverging engines
excel
Behavior signature
{"error":"#NAME?"}
Test count
5
Seeded
2026-04-25
Last confirmed
2026-04-25

Subjects (2)

ARRAY_CONSTRAIN FLATTEN

Tests (5)

matches canonical diverges no fixture in this DV's cluster

Test Formula Canonical gsheets excel lattice ironcalc hyperformula libreoffice formulas pycel
array-longtail/09f104 =FLATTEN({1;2}, {3;4}) [1, 2, 3, 4] gsheets[1, 2, 3, 4] excel#NAME? lattice#VALUE! ironcalc#NAME? hyperformula#NAME? libreoffice#NAME? formulas#NAME? pycel#NAME?
array-longtail/850891 =ARRAY_CONSTRAIN({1,2;3,4;5,6}, 2, 2) [1, 2, 3, 4] gsheets[1, 2, 3, 4] excel#NAME? lattice[1, 2, 3, 4] ironcalc#NAME? hyperformula[1, 2, 3, 4] libreoffice#NAME? formulas#NAME? pycel#NAME?
array-longtail/8d4e4a =ARRAY_CONSTRAIN({1,2,3;4,5,6}, 2, 2) [1, 2, 4, 5] gsheets[1, 2, 4, 5] excel#NAME? lattice[1, 2, 4, 5] ironcalc#NAME? hyperformula[1, 2, 4, 5] libreoffice#NAME? formulas#NAME? pycel#NAME?
array-longtail/49ea0a =ARRAY_CONSTRAIN({1,2;3,4}, 2, 2) [1, 2, 3, 4] gsheets[1, 2, 3, 4] excel#NAME? lattice[1, 2, 3, 4] ironcalc#NAME? hyperformula[1, 2, 3, 4] libreoffice#NAME? formulas#NAME? pycel#NAME?
array-longtail/eb3f92 =ARRAY_CONSTRAIN({1,2;3,4}, 1, 1) 1 gsheets1 excel#NAME? lattice1 ironcalc#NAME? hyperformula1 libreoffice#NAME? formulas#NAME? pycel#NAME?