assay

DV-0044

gsheets, hyperformula, libreoffice, pycel: function not implemented — TEXTAFTER, TEXTBEFORE

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

Subjects (2)

TEXTAFTER TEXTBEFORE

Tests (4)

matches canonical diverges no fixture in this DV's cluster

Test Formula Canonical gsheets excel lattice ironcalc hyperformula libreoffice formulas pycel
TEXTBEFORE/textbefore-space =TEXTBEFORE("Brian Wiles", " ") Brian gsheets[object Object] excel[object Object] latticeBrian ironcalcBrian hyperformula#NAME? libreoffice— formulasBrian pycel#NAME?
TEXTBEFORE/textbefore-second-instance =TEXTBEFORE("one,two,three", ",", 2) one,two gsheets[object Object] excel[object Object] latticeone,two ironcalcone,two hyperformula#NAME? libreoffice— formulasone,two pycel#NAME?
TEXTAFTER/textafter-space =TEXTAFTER("Brian Wiles", " ") Wiles gsheets[object Object] excel[object Object] latticeWiles ironcalcWiles hyperformula#NAME? libreoffice— formulasWiles pycel#NAME?
TEXTAFTER/textafter-second-instance =TEXTAFTER("one,two,three", ",", 2) three gsheets[object Object] excel[object Object] latticethree ironcalcthree hyperformula#NAME? libreoffice— formulasthree pycel#NAME?