DV-0025
formulas, libreoffice, pycel: function not implemented — BASE, COMBINA
Subjects (2)
Tests (7)
matches canonical diverges no fixture in this DV's cluster
| Test | Formula | Canonical | gsheets | excel | lattice | ironcalc | hyperformula | libreoffice | formulas | pycel |
|---|---|---|---|---|---|---|---|---|---|---|
BASE/base-to-hex |
=BASE(10, 16) |
A | gsheets[object Object] | excel[object Object] | latticeA | ironcalcA | hyperformulaA | libreoffice— | formulas#NAME? | pycel#NAME? |
BASE/base-to-binary |
=BASE(5, 2) |
101 | gsheets[object Object] | excel[object Object] | lattice101 | ironcalc101 | hyperformula101 | libreoffice— | formulas#NAME? | pycel#NAME? |
BASE/base-zero |
=BASE(0, 2) |
0 | gsheets[object Object] | excel[object Object] | lattice0 | ironcalc0 | hyperformula0 | libreoffice— | formulas#NAME? | pycel#NAME? |
BASE/base-with-min-length-padding |
=BASE(5, 2, 8) |
00000101 | gsheets[object Object] | excel[object Object] | lattice00000101 | ironcalc00000101 | hyperformula00000101 | libreoffice— | formulas#NAME? | pycel#NAME? |
COMBINA/combina-basic |
=COMBINA(5, 2) |
15 | gsheets[object Object] | excel[object Object] | lattice15 | ironcalc15 | hyperformula15 | libreoffice— | formulas#NAME? | pycel#NAME? |
COMBINA/combina-k-zero |
=COMBINA(8, 0) |
1 | gsheets[object Object] | excel[object Object] | lattice1 | ironcalc1 | hyperformula1 | libreoffice— | formulas#NAME? | pycel#NAME? |
COMBINA/combina-larger |
=COMBINA(4, 3) |
20 | gsheets[object Object] | excel[object Object] | lattice20 | ironcalc20 | hyperformula20 | libreoffice— | formulas#NAME? | pycel#NAME? |