DV-0016
hyperformula, pycel: function not implemented — CONVERT, ERROR.TYPE, GESTEP (+4 more)
Subjects (7)
Tests (17)
matches canonical diverges no fixture in this DV's cluster
| Test | Formula | Canonical | gsheets | excel | lattice | ironcalc | hyperformula | libreoffice | formulas | pycel |
|---|---|---|---|---|---|---|---|---|---|---|
engineering/1f80b3 |
=GESTEP(5, 3) |
1 | gsheets1 | excel1 | lattice1 | ironcalc1 | hyperformula#NAME? | libreoffice1 | formulas1 | pycel#NAME? |
engineering/6f3343 |
=GESTEP(2, 3) |
0 | gsheets0 | excel0 | lattice0 | ironcalc0 | hyperformula#NAME? | libreoffice0 | formulas0 | pycel#NAME? |
engineering/47b110 |
=GESTEP(3, 3) |
1 | gsheets1 | excel1 | lattice1 | ironcalc1 | hyperformula#NAME? | libreoffice1 | formulas1 | pycel#NAME? |
engineering/68d089 |
=GESTEP(-1) |
0 | gsheets0 | excel0 | lattice0 | ironcalc0 | hyperformula#NAME? | libreoffice0 | formulas0 | pycel#NAME? |
financial-timevalue/9862ea |
=XIRR(A1:A2, B1:B2) |
#NUM! | gsheets#NUM! | excel#NUM! | lattice#NUM! | ironcalc#NUM! | hyperformula#NAME? | libreoffice#VALUE! | formulas#NUM! | pycel#NAME? |
info/8f96b3 |
=ERROR.TYPE(1/0) |
2 | gsheets2 | excel2 | lattice2 | ironcalc2 | hyperformula#NAME? | libreoffice2 | formulas2 | pycel#NAME? |
info/eae8e2 |
=ERROR.TYPE(NA()) |
7 | gsheets7 | excel7 | lattice7 | ironcalc7 | hyperformula#NAME? | libreoffice7 | formulas7 | pycel#NAME? |
info/9e8ade |
=ERROR.TYPE("a"+1) |
3 | gsheets3 | excel3 | lattice3 | ironcalc3 | hyperformula#NAME? | libreoffice3 | formulas3 | pycel#NAME? |
info/0eebdd |
=ERROR.TYPE(42) |
#N/A | gsheets#N/A | excel#N/A | lattice#N/A | ironcalc#N/A | hyperformula#NAME? | libreoffice#N/A | formulas#N/A | pycel#NAME? |
info/7f40f7 |
=ERROR.TYPE("hello") |
#N/A | gsheets#N/A | excel#N/A | lattice#N/A | ironcalc#N/A | hyperformula#NAME? | libreoffice#N/A | formulas#N/A | pycel#NAME? |
info/820ad5 |
=ERROR.TYPE(INDIRECT("ZZZZ99999999")) |
4 | gsheets4 | excel4 | lattice#N/A | ironcalc4 | hyperformula#NAME? | libreoffice4 | formulas4 | pycel#NAME? |
parser/de0865 |
=CONVERT(1, "ft", "in") |
12 | gsheets12 | excel12 | lattice12.0000 | ironcalc12 | hyperformula#NAME? | libreoffice12 | formulas12.0000 | pycel#NAME? |
parser/70c9f4 |
=CONVERT(100, "C", "F") |
212 | gsheets212 | excel212 | lattice212 | ironcalc212 | hyperformula#NAME? | libreoffice212 | formulas212.000 | pycel#NAME? |
parser/dfc8b1 |
=CONVERT(1, "hr", "sec") |
3600 | gsheets3600 | excel3600 | lattice3600 | ironcalc3600 | hyperformula#NAME? | libreoffice3600 | formulas3600 | pycel#NAME? |
statistical-descriptive/fb527d |
=MAXA(-2, -1, TRUE) |
1 | gsheets1 | excel1 | lattice1 | ironcalc1 | hyperformula#NAME? | libreoffice1 | formulas1 | pycel#NAME? |
statistical-descriptive/19590a |
=MINA(2, 3, FALSE) |
0 | gsheets0 | excel0 | lattice0 | ironcalc0 | hyperformula#NAME? | libreoffice0 | formulas0 | pycel#NAME? |
text-longtail/f985ab |
=T(TRUE) |
gsheets— | excel— | lattice | ironcalc | hyperformula#NAME? | libreoffice— | formulas— | pycel#NAME? |