DV-0034
pycel: different argument interpretation — INDIRECT, OFFSET, XOR
Subjects (3)
Tests (5)
matches canonical diverges no fixture in this DV's cluster
| Test | Formula | Canonical | gsheets | excel | lattice | ironcalc | hyperformula | libreoffice | formulas | pycel |
|---|---|---|---|---|---|---|---|---|---|---|
XOR/xor-even-trues |
=XOR(TRUE, TRUE) |
false | gsheetsfalse | excelfalse | latticefalse | ironcalcfalse | hyperformula#NAME? | libreoffice— | formulasfalse | pycel0 |
XOR/xor-all-false |
=XOR(FALSE, FALSE) |
false | gsheetsfalse | excelfalse | latticefalse | ironcalcfalse | hyperformula#NAME? | libreoffice— | formulasfalse | pycel0 |
OFFSET/offset-sum-height-width |
=SUM(OFFSET(A1,0,0,2,2)) |
10 | gsheets10 | excel10 | lattice10 | ironcalc10 | hyperformula10 | libreoffice— | formulas#NAME? | pycel0 |
OFFSET/offset-sum-shifted-range |
=SUM(OFFSET(A1,1,0,3,1)) |
30 | gsheets30 | excel30 | lattice30 | ironcalc30 | hyperformula30 | libreoffice— | formulas#NAME? | pycel0 |
INDIRECT/indirect-sum-range |
=SUM(INDIRECT("A1:A3")) |
6 | gsheets6 | excel6 | lattice6 | ironcalc6 | hyperformula#NAME? | libreoffice— | formulas6 | pycel0 |