DV-0058
libreoffice: different error code — IFNA, IRR
Subjects (2)
Tests (2)
matches canonical diverges no fixture in this DV's cluster
| Test | Formula | Canonical | gsheets | excel | lattice | ironcalc | hyperformula | libreoffice | formulas | pycel |
|---|---|---|---|---|---|---|---|---|---|---|
IRR/irr-no-sign-change |
=IRR(A1:A3) |
#NUM! | gsheets[object Object] | excel[object Object] | lattice#NUM! | ironcalc#NUM! | hyperformula#NUM! | libreoffice— | formulas#NUM! | pycel#NAME? |
IFNA/ifna-with-na |
=IFNA(MATCH(99, {1,2,3}, 0), "not found") |
not found | gsheets[object Object] | excel[object Object] | latticenot found | ironcalcnot found | hyperformulanot found | libreoffice— | formulasnot found | pycelnot found |