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 | gsheetsA | excelA | latticeA | ironcalcA | hyperformulaA | libreoffice— | formulas#NAME? | pycel#NAME? |
BASE/base-to-binary |
=BASE(5, 2) |
101 | gsheets101 | excel101 | lattice101 | ironcalc101 | hyperformula101 | libreoffice— | formulas#NAME? | pycel#NAME? |
BASE/base-zero |
=BASE(0, 2) |
0 | gsheets0 | excel0 | lattice0 | ironcalc0 | hyperformula0 | libreoffice— | formulas#NAME? | pycel#NAME? |
BASE/base-with-min-length-padding |
=BASE(5, 2, 8) |
00000101 | gsheets00000101 | excel00000101 | lattice00000101 | ironcalc00000101 | hyperformula00000101 | libreoffice— | formulas#NAME? | pycel#NAME? |
COMBINA/combina-basic |
=COMBINA(5, 2) |
15 | gsheets15 | excel15 | lattice15 | ironcalc15 | hyperformula15 | libreoffice— | formulas#NAME? | pycel#NAME? |
COMBINA/combina-k-zero |
=COMBINA(8, 0) |
1 | gsheets1 | excel1 | lattice1 | ironcalc1 | hyperformula1 | libreoffice— | formulas#NAME? | pycel#NAME? |
COMBINA/combina-larger |
=COMBINA(4, 3) |
20 | gsheets20 | excel20 | lattice20 | ironcalc20 | hyperformula20 | libreoffice— | formulas#NAME? | pycel#NAME? |