DV-0044
gsheets, hyperformula, libreoffice, pycel: function not implemented — TEXTAFTER, TEXTBEFORE
Subjects (2)
Tests (4)
matches canonical diverges no fixture in this DV's cluster
| Test | Formula | Canonical | gsheets | excel | lattice | ironcalc | hyperformula | libreoffice | formulas | pycel |
|---|---|---|---|---|---|---|---|---|---|---|
text/5038f9 |
=TEXTBEFORE("Brian Wiles", " ") |
Brian | gsheets#NAME? | excelBrian | latticeBrian | ironcalcBrian | hyperformula#NAME? | libreoffice#NAME? | formulasBrian | pycel#NAME? |
text/c9fb28 |
=TEXTBEFORE("one,two,three", ",", 2) |
one,two | gsheets#NAME? | excelone,two | latticeone,two | ironcalcone,two | hyperformula#NAME? | libreoffice#NAME? | formulasone,two | pycel#NAME? |
text/598724 |
=TEXTAFTER("Brian Wiles", " ") |
Wiles | gsheets#NAME? | excelWiles | latticeWiles | ironcalcWiles | hyperformula#NAME? | libreoffice#NAME? | formulasWiles | pycel#NAME? |
text/be6810 |
=TEXTAFTER("one,two,three", ",", 2) |
three | gsheets#NAME? | excelthree | latticethree | ironcalcthree | hyperformula#NAME? | libreoffice#NAME? | formulasthree | pycel#NAME? |