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 |
|---|---|---|---|---|---|---|---|---|---|---|
operator/1b58dc |
=POW(2, 10) |
1024 | gsheets1024 | excel#NAME? | lattice1024 | ironcalc#NAME? | hyperformula#NAME? | libreoffice#NAME? | formulas#NAME? | pycel1024 |
operator/a74e1e |
=POW(5, 0) |
1 | gsheets1 | excel#NAME? | lattice1 | ironcalc#NAME? | hyperformula#NAME? | libreoffice#NAME? | formulas#NAME? | pycel1 |
operator/cebbd2 |
=POW(2, -3) |
0.125 | gsheets0.125 | excel#NAME? | lattice0.125 | ironcalc#NAME? | hyperformula#NAME? | libreoffice#NAME? | formulas#NAME? | pycel0.125 |
operator/b27e39 |
=POW(2, 0.5) |
1.41421 | gsheets1.41421 | excel#NAME? | lattice1.41421 | ironcalc#NAME? | hyperformula#NAME? | libreoffice#NAME? | formulas#NAME? | pycel1.41421 |
operator/a3609e |
=POW(-1, 0.5) |
— | gsheets#NUM! | excel#NAME? | lattice— | ironcalc#NAME? | hyperformula#NAME? | libreoffice#NAME? | formulas#NAME? | pycel#NUM! |
operator/62cbe9 |
=POW(0, 0) |
1 | gsheets1 | excel#NAME? | lattice1 | ironcalc#NAME? | hyperformula#NAME? | libreoffice#NAME? | formulas#NAME? | pycel1 |
operator/71c6a6 |
=POW(3, 4)=3^4 |
true | gsheetstrue | excel#NAME? | latticetrue | ironcalc#NAME? | hyperformula#NAME? | libreoffice#NAME? | formulas#NAME? | pyceltrue |