DV-0026
excel, formulas, hyperformula, ironcalc, libreoffice: function not implemented — POW
Subjects (1)
Tests (7)
matches canonical diverges no fixture in this DV's cluster
| Test | Formula | Canonical | gsheets | excel | lattice | ironcalc | hyperformula | libreoffice | formulas | pycel |
|---|---|---|---|---|---|---|---|---|---|---|
POW/pow-integer |
=POW(2, 10) |
1024 | gsheets1024 | excel#NAME? | lattice1024 | ironcalc#NAME? | hyperformula#NAME? | libreoffice— | formulas#NAME? | pycel1024 |
POW/pow-zero-exponent |
=POW(5, 0) |
1 | gsheets1 | excel#NAME? | lattice1 | ironcalc#NAME? | hyperformula#NAME? | libreoffice— | formulas#NAME? | pycel1 |
POW/pow-negative-exponent |
=POW(2, -3) |
0.125 | gsheets0.125 | excel#NAME? | lattice0.125 | ironcalc#NAME? | hyperformula#NAME? | libreoffice— | formulas#NAME? | pycel#NAME? |
POW/pow-fractional-exponent |
=POW(2, 0.5) |
1.41421 | gsheets1.41421 | excel#NAME? | lattice1.41421 | ironcalc#NAME? | hyperformula#NAME? | libreoffice— | formulas#NAME? | pycel1.41421 |
POW/pow-negative-base-fractional-exponent |
=POW(-1, 0.5) |
— | gsheets#NUM! | excel#NAME? | lattice— | ironcalc#NAME? | hyperformula#NAME? | libreoffice— | formulas#NAME? | pycel#NAME? |
POW/pow-zero-to-zero |
=POW(0, 0) |
1 | gsheets1 | excel#NAME? | lattice1 | ironcalc#NAME? | hyperformula#NAME? | libreoffice— | formulas#NAME? | pycel1 |
POW/pow-matches-caret-operator |
=POW(3, 4)=3^4 |
true | gsheetstrue | excel#NAME? | latticetrue | ironcalc#NAME? | hyperformula#NAME? | libreoffice— | formulas#NAME? | pycel#NAME? |