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#NAME? excelBrian latticeBrian ironcalcBrian hyperformula#NAME? libreoffice— formulasBrian pycel#NAME?
TEXTBEFORE/textbefore-second-instance =TEXTBEFORE("one,two,three", ",", 2) one,two gsheets#NAME? excelone,two latticeone,two ironcalcone,two hyperformula#NAME? libreoffice— formulasone,two pycel#NAME?
TEXTAFTER/textafter-space =TEXTAFTER("Brian Wiles", " ") Wiles gsheets#NAME? excelWiles latticeWiles ironcalcWiles hyperformula#NAME? libreoffice— formulasWiles pycel#NAME?
TEXTAFTER/textafter-second-instance =TEXTAFTER("one,two,three", ",", 2) three gsheets#NAME? excelthree latticethree ironcalcthree hyperformula#NAME? libreoffice— formulasthree pycel#NAME?