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{1; 2; 3; 4} 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?