assay

DV-0008

libreoffice: different error code — ACOSH, ATANH, BIN2DEC (+35 more)

Cause
error-code
Category
value
Diverging engines
libreoffice
Behavior signature
{"error":"#VALUE!"}
Test count
40
Seeded
2026-04-25
Last confirmed
2026-04-25

Subjects (38)

ACOSH ATANH BIN2DEC BIN2HEX BIN2OCT CEILING COMBIN CUMIPMT CUMPRINC DEC2BIN DEC2HEX DEC2OCT DGET EFFECT FACT FACTDOUBLE FLOOR GAMMALN HARMEAN HEX2BIN HEX2DEC HEX2OCT IPMT LARGE MIRR MODE NOMINAL OCT2BIN OCT2DEC OCT2HEX PERMUT PPMT QUARTILE SMALL SQRT SQRTPI TRIMMEAN XIRR

Tests (40)

matches canonical diverges no fixture in this DV's cluster

Test Formula Canonical gsheets excel lattice ironcalc hyperformula libreoffice formulas pycel
DGET/dget-multiple-matches-error =DGET(A1:D5, "Price", F1:F2) #NUM! gsheets#NUM! excel#NUM! lattice#NUM! ironcalc#NUM! hyperformula#NAME? libreoffice— formulas#NAME? pycel#NAME?
BIN2DEC/bin2dec-too-long =BIN2DEC("11111111110") #NUM! gsheets#NUM! excel#NUM! lattice#NUM! ironcalc#NUM! hyperformula#NUM! libreoffice— formulas#NUM! pycel#NUM!
BIN2HEX/bin2hex-invalid =BIN2HEX("12") #NUM! gsheets#NUM! excel#NUM! lattice#NUM! ironcalc#NUM! hyperformula#NUM! libreoffice— formulas#NUM! pycel#NUM!
BIN2OCT/bin2oct-places-too-small =BIN2OCT("11111111", 1) #NUM! gsheets#NUM! excel#NUM! lattice#NUM! ironcalc#NUM! hyperformula#NUM! libreoffice— formulas#NUM! pycel#NUM!
DEC2BIN/dec2bin-out-of-range =DEC2BIN(512) #NUM! gsheets#NUM! excel#NUM! lattice#NUM! ironcalc#NUM! hyperformula#NUM! libreoffice— formulas#NUM! pycel#NUM!
DEC2HEX/dec2hex-places-too-small =DEC2HEX(255, 1) #NUM! gsheets#NUM! excel#NUM! lattice#NUM! ironcalc#NUM! hyperformula#NUM! libreoffice— formulas#NUM! pycel#NUM!
DEC2OCT/dec2oct-out-of-range =DEC2OCT(536870912) #NUM! gsheets#NUM! excel#NUM! lattice#NUM! ironcalc#NUM! hyperformula#NUM! libreoffice— formulas#NUM! pycel#NUM!
HEX2BIN/hex2bin-out-of-range =HEX2BIN("200") #NUM! gsheets#NUM! excel#NUM! lattice#NUM! ironcalc#NUM! hyperformula#NUM! libreoffice— formulas#NUM! pycel#NUM!
HEX2DEC/hex2dec-invalid =HEX2DEC("G") #NUM! gsheets#NUM! excel#NUM! lattice#NUM! ironcalc#NUM! hyperformula#NUM! libreoffice— formulas#NUM! pycel#NUM!
HEX2OCT/hex2oct-out-of-range =HEX2OCT("40000000") #NUM! gsheets#NUM! excel#NUM! lattice#NUM! ironcalc#NUM! hyperformula#NUM! libreoffice— formulas#NUM! pycel#NUM!
OCT2BIN/oct2bin-out-of-range =OCT2BIN("1000") #NUM! gsheets#NUM! excel#NUM! lattice#NUM! ironcalc#NUM! hyperformula#NUM! libreoffice— formulas#NUM! pycel#NUM!
OCT2DEC/oct2dec-invalid =OCT2DEC("8") #NUM! gsheets#NUM! excel#NUM! lattice#NUM! ironcalc#NUM! hyperformula#NUM! libreoffice— formulas#NUM! pycel#NUM!
OCT2HEX/oct2hex-invalid =OCT2HEX("9") #NUM! gsheets#NUM! excel#NUM! lattice#NUM! ironcalc#NUM! hyperformula#NUM! libreoffice— formulas#NUM! pycel#NUM!
CUMIPMT/cumipmt-invalid-period =CUMIPMT(0.05/12, 360, 100000, 0, 12, 0) #NUM! gsheets#NUM! excel#NUM! lattice#NUM! ironcalc#NUM! hyperformula#NUM! libreoffice— formulas#NUM! pycel#NAME?
CUMPRINC/cumprinc-invalid-type =CUMPRINC(0.05/12, 360, 100000, 1, 12, 2) -1884.18 gsheets-1884.18 excel#NUM! lattice#NUM! ironcalc#NUM! hyperformula#NUM! libreoffice— formulas#NUM! pycel#NAME?
EFFECT/effect-invalid-periods =EFFECT(0.05, 0) #NUM! gsheets#NUM! excel#NUM! lattice#NUM! ironcalc#NUM! hyperformula#NUM! libreoffice— formulas#NUM! pycel#NAME?
IPMT/ipmt-invalid-period =IPMT(0.05/12, 0, 360, -200000) #NUM! gsheets#NUM! excel#NUM! lattice#NUM! ironcalc#NUM! hyperformula834.3304699 libreoffice— formulas#NUM! pycel#NAME?
MIRR/mirr-no-sign-change =MIRR(A1:A3, 0.1, 0.12) #DIV/0! gsheets#DIV/0! excel#DIV/0! lattice#DIV/0! ironcalc#DIV/0! hyperformula#DIV/0! libreoffice— formulas#DIV/0! pycel#NAME?
NOMINAL/nominal-invalid-rate =NOMINAL(-0.05, 4) #NUM! gsheets#NUM! excel#NUM! lattice#NUM! ironcalc#NUM! hyperformula#NUM! libreoffice— formulas#NUM! pycel#NAME?
PPMT/ppmt-invalid-period =PPMT(0.05/12, 361, 360, -200000) #NUM! gsheets#NUM! excel#NUM! lattice#NUM! ironcalc#NUM! hyperformula1073.643246 libreoffice— formulas#NUM! pycel#NAME?
XIRR/xirr-no-sign-change =XIRR(A1:A2, B1:B2) #NUM! gsheets#NUM! excel#NUM! lattice#NUM! ironcalc#NUM! hyperformula#NAME? libreoffice— formulas#NUM! pycel#NAME?
ACOSH/acosh-out-of-domain =ACOSH(0) #NUM! gsheets#NUM! excel#NUM! lattice#NUM! ironcalc#NUM! hyperformula#NUM! libreoffice— formulas#NUM! pycel#NAME?
ATANH/atanh-out-of-domain =ATANH(1) #NUM! gsheets#NUM! excel#NUM! lattice#NUM! ironcalc#NUM! hyperformula#NUM! libreoffice— formulas#NUM! pycel#NAME?
COMBIN/combin-k-greater-than-n =COMBIN(3, 5) #NUM! gsheets#NUM! excel#NUM! lattice#NUM! ironcalc#NUM! hyperformula#NUM! libreoffice— formulas#NAME? pycel#NAME?
FACTDOUBLE/factdouble-negative =FACTDOUBLE(-1) 1 gsheets#NUM! excel1 lattice#NUM! ironcalc1 hyperformula#NUM! libreoffice— formulas1 pycel#NAME?
GAMMALN/gammaln-non-positive =GAMMALN(0) #NUM! gsheets#NUM! excel#NUM! lattice#NUM! ironcalc#NUM! hyperformula#NUM! libreoffice— formulas#NUM! pycel#NAME?
SQRTPI/sqrtpi-negative =SQRTPI(-1) #NUM! gsheets#NUM! excel#NUM! lattice#NUM! ironcalc#NUM! hyperformula#NUM! libreoffice— formulas#NUM! pycel#NAME?
CEILING/ceiling-positive-num-negative-sig =CEILING(2, -2) #NUM! gsheets#NUM! excel#NUM! lattice#NUM! ironcalc#NUM! hyperformula#NUM! libreoffice— formulas#NUM! pycel#NAME?
FLOOR/floor-zero-significance =FLOOR(2, 0) #DIV/0! gsheets#DIV/0! excel#DIV/0! lattice#DIV/0! ironcalc#DIV/0! hyperformula#DIV/0! libreoffice— formulas#DIV/0! pycel#DIV/0!
SQRT/sqrt-negative =SQRT(-4) #NUM! gsheets#NUM! excel#NUM! lattice#NUM! ironcalc#NUM! hyperformula#NUM! libreoffice— formulas#NUM! pycel#NAME?
FACT/fact-negative =FACT(-1) #NUM! gsheets#NUM! excel#NUM! lattice#NUM! ironcalc#NUM! hyperformula#NUM! libreoffice— formulas#NUM! pycel#NAME?
HARMEAN/harmean-with-zero =HARMEAN(0, 2, 4) #NUM! gsheets#NUM! excel#NUM! lattice#NUM! ironcalc#NUM! hyperformula#NUM! libreoffice— formulas#NUM! pycel#NAME?
LARGE/large-k-too-big =LARGE({1,2,3}, 5) #NUM! gsheets#NUM! excel#NUM! lattice#NUM! ironcalc#NUM! hyperformula#NUM! libreoffice— formulas#NUM! pycel#NUM!
LARGE/large-k-zero =LARGE({1,2,3}, 0) #NUM! gsheets#NUM! excel#NUM! lattice#NUM! ironcalc#NUM! hyperformula#NUM! libreoffice— formulas#NUM! pycel#NUM!
MODE/mode-no-repeats =MODE(1, 2, 3, 4, 5) #N/A gsheets#N/A excel#N/A lattice#N/A ironcalc#NAME? hyperformula#NAME? libreoffice— formulas#N/A pycel#NAME?
PERMUT/permut-invalid =PERMUT(3, 5) #NUM! gsheets#NUM! excel#NUM! lattice#NUM! ironcalc#NAME? hyperformula#NAME? libreoffice— formulas#NUM! pycel#NAME?
QUARTILE/quartile-invalid =QUARTILE({1,2,3,4,5}, 5) #NUM! gsheets#NUM! excel#NUM! lattice#NUM! ironcalc#NAME? hyperformula#NAME? libreoffice— formulas#NUM! pycel#NAME?
SMALL/small-k-too-big =SMALL({1,2,3}, 5) #NUM! gsheets#NUM! excel#NUM! lattice#NUM! ironcalc#NUM! hyperformula#NUM! libreoffice— formulas#NUM! pycel#NUM!
SMALL/small-k-zero =SMALL({1,2,3}, 0) #NUM! gsheets#NUM! excel#NUM! lattice#NUM! ironcalc#NUM! hyperformula#NUM! libreoffice— formulas#NUM! pycel#NUM!
TRIMMEAN/trimmean-invalid-percent =TRIMMEAN({1,2,3}, 1) #NUM! gsheets#NUM! excel#NUM! lattice#NUM! ironcalc#NAME? hyperformula#NAME? libreoffice— formulas#NUM! pycel#NAME?