assay

DV-0071

gsheets: different error code — MID, PERMUTATIONA

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

Subjects (2)

MID PERMUTATIONA

Tests (2)

matches canonical diverges no fixture in this DV's cluster

Test Formula Canonical gsheets excel lattice ironcalc hyperformula libreoffice formulas pycel
PERMUTATIONA/permutationa-zero-pick =PERMUTATIONA(5, 0) 1 gsheets#NUM! excel1 lattice1 ironcalc#NAME? hyperformula#NAME? libreoffice— formulas1 pycel#NAME?
MID/mid-start-0 =MID("Romain", 0, 3) gsheets#NUM! excel#VALUE! lattice ironcalc#VALUE! hyperformula#VALUE! libreoffice— formulas#VALUE! pycel#VALUE!