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 |
|---|---|---|---|---|---|---|---|---|---|---|
logical/06fb8b |
=XOR(TRUE, TRUE) |
false | gsheetsfalse | excelfalse | latticefalse | ironcalcfalse | hyperformula#NAME? | libreoffice#NAME? | formulasfalse | pycel0 |
logical/608087 |
=XOR(FALSE, FALSE) |
false | gsheetsfalse | excelfalse | latticefalse | ironcalcfalse | hyperformula#NAME? | libreoffice#NAME? | formulasfalse | pycel0 |
lookup-longtail/67be54 |
=SUM(OFFSET(A1,0,0,2,2)) |
10 | gsheets10 | excel10 | lattice10 | ironcalc10 | hyperformula10 | libreoffice10 | formulas#NAME? | pycel0 |
lookup-longtail/500e03 |
=SUM(OFFSET(A1,1,0,3,1)) |
30 | gsheets30 | excel30 | lattice30 | ironcalc30 | hyperformula30 | libreoffice30 | formulas#NAME? | pycel0 |
lookup-longtail/f166ec |
=SUM(INDIRECT("A1:A3")) |
6 | gsheets6 | excel6 | lattice6 | ironcalc6 | hyperformula#NAME? | libreoffice6 | formulas6 | pycel0 |