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
database/1bd2b2 =DGET(A1:D5, "Price", F1:F2) #NUM! gsheets#NUM! excel#NUM! lattice#NUM! ironcalc#NUM! hyperformula#NAME? libreoffice#VALUE! formulas#NAME? pycel#NAME?
engineering/bd11ac =BIN2DEC("11111111110") #NUM! gsheets#NUM! excel#NUM! lattice#NUM! ironcalc#NUM! hyperformula#NUM! libreoffice#VALUE! formulas#NUM! pycel#NUM!
engineering/de444b =BIN2HEX("12") #NUM! gsheets#NUM! excel#NUM! lattice#NUM! ironcalc#NUM! hyperformula#NUM! libreoffice#VALUE! formulas#NUM! pycel#NUM!
engineering/9d0859 =BIN2OCT("11111111", 1) #NUM! gsheets#NUM! excel#NUM! lattice#NUM! ironcalc#NUM! hyperformula#NUM! libreoffice#VALUE! formulas#NUM! pycel#NUM!
engineering/cbdc52 =DEC2BIN(512) #NUM! gsheets#NUM! excel#NUM! lattice#NUM! ironcalc#NUM! hyperformula#NUM! libreoffice#VALUE! formulas#NUM! pycel#NUM!
engineering/2d2393 =DEC2HEX(255, 1) #NUM! gsheets#NUM! excel#NUM! lattice#NUM! ironcalc#NUM! hyperformula#NUM! libreoffice#VALUE! formulas#NUM! pycel#NUM!
engineering/0d1f3e =DEC2OCT(536870912) #NUM! gsheets#NUM! excel#NUM! lattice#NUM! ironcalc#NUM! hyperformula#NUM! libreoffice#VALUE! formulas#NUM! pycel#NUM!
engineering/6f2c67 =HEX2BIN("200") #NUM! gsheets#NUM! excel#NUM! lattice#NUM! ironcalc#NUM! hyperformula#NUM! libreoffice#VALUE! formulas#NUM! pycel#NUM!
engineering/d4cce0 =HEX2DEC("G") #NUM! gsheets#NUM! excel#NUM! lattice#NUM! ironcalc#NUM! hyperformula#NUM! libreoffice#VALUE! formulas#NUM! pycel#NUM!
engineering/2d00dc =HEX2OCT("40000000") #NUM! gsheets#NUM! excel#NUM! lattice#NUM! ironcalc#NUM! hyperformula#NUM! libreoffice#VALUE! formulas#NUM! pycel#NUM!
engineering/11acd4 =OCT2BIN("1000") #NUM! gsheets#NUM! excel#NUM! lattice#NUM! ironcalc#NUM! hyperformula#NUM! libreoffice#VALUE! formulas#NUM! pycel#NUM!
engineering/6a7f55 =OCT2DEC("8") #NUM! gsheets#NUM! excel#NUM! lattice#NUM! ironcalc#NUM! hyperformula#NUM! libreoffice#VALUE! formulas#NUM! pycel#NUM!
engineering/c0d812 =OCT2HEX("9") #NUM! gsheets#NUM! excel#NUM! lattice#NUM! ironcalc#NUM! hyperformula#NUM! libreoffice#VALUE! formulas#NUM! pycel#NUM!
financial-timevalue/9c7348 =CUMIPMT(0.05/12, 360, 100000, 0, 12, 0) #NUM! gsheets#NUM! excel#NUM! lattice#NUM! ironcalc#NUM! hyperformula#NUM! libreoffice#VALUE! formulas#NUM! pycel#NAME?
financial-timevalue/eadb99 =CUMPRINC(0.05/12, 360, 100000, 1, 12, 2) -1884.18 gsheets-1884.18 excel#NUM! lattice#NUM! ironcalc#NUM! hyperformula#NUM! libreoffice#VALUE! formulas#NUM! pycel#NAME?
financial-timevalue/086aa8 =EFFECT(0.05, 0) #NUM! gsheets#NUM! excel#NUM! lattice#NUM! ironcalc#NUM! hyperformula#NUM! libreoffice#VALUE! formulas#NUM! pycel#NAME?
financial-timevalue/982b40 =IPMT(0.05/12, 0, 360, -200000) #NUM! gsheets#NUM! excel#NUM! lattice#NUM! ironcalc#NUM! hyperformula834.3304699 libreoffice#VALUE! formulas#NUM! pycel#NAME?
financial-timevalue/312e2b =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#VALUE! formulas#DIV/0! pycel#NAME?
financial-timevalue/a62e7e =NOMINAL(-0.05, 4) #NUM! gsheets#NUM! excel#NUM! lattice#NUM! ironcalc#NUM! hyperformula#NUM! libreoffice#VALUE! formulas#NUM! pycel#NAME?
financial-timevalue/6f263c =PPMT(0.05/12, 361, 360, -200000) #NUM! gsheets#NUM! excel#NUM! lattice#NUM! ironcalc#NUM! hyperformula1073.643246 libreoffice#VALUE! formulas#NUM! pycel#NAME?
financial-timevalue/9862ea =XIRR(A1:A2, B1:B2) #NUM! gsheets#NUM! excel#NUM! lattice#NUM! ironcalc#NUM! hyperformula#NAME? libreoffice#VALUE! formulas#NUM! pycel#NAME?
math-longtail/25cdbb =ACOSH(0) #NUM! gsheets#NUM! excel#NUM! lattice#NUM! ironcalc#NUM! hyperformula#NUM! libreoffice#VALUE! formulas#NUM! pycel#NUM!
math-longtail/8839e1 =ATANH(1) #NUM! gsheets#NUM! excel#NUM! lattice#NUM! ironcalc#NUM! hyperformula#NUM! libreoffice#VALUE! formulas#NUM! pycel#NUM!
math-longtail/670213 =COMBIN(3, 5) #NUM! gsheets#NUM! excel#NUM! lattice#NUM! ironcalc#NUM! hyperformula#NUM! libreoffice#VALUE! formulas#NAME? pycel#NAME?
math-longtail/e549e4 =FACTDOUBLE(-1) 1 gsheets#NUM! excel1 lattice#NUM! ironcalc1 hyperformula#NUM! libreoffice#VALUE! formulas1 pycel#NUM!
math-longtail/69d257 =GAMMALN(0) #NUM! gsheets#NUM! excel#NUM! lattice#NUM! ironcalc#NUM! hyperformula#NUM! libreoffice#VALUE! formulas#NUM! pycel#NAME?
math-longtail/9f8138 =SQRTPI(-1) #NUM! gsheets#NUM! excel#NUM! lattice#NUM! ironcalc#NUM! hyperformula#NUM! libreoffice#VALUE! formulas#NUM! pycel#NAME?
math/57203f =CEILING(2, -2) #NUM! gsheets#NUM! excel#NUM! lattice#NUM! ironcalc#NUM! hyperformula#NUM! libreoffice#VALUE! formulas#NUM! pycel#NUM!
math/60444b =FLOOR(2, 0) #DIV/0! gsheets#DIV/0! excel#DIV/0! lattice#DIV/0! ironcalc#DIV/0! hyperformula#DIV/0! libreoffice#VALUE! formulas#DIV/0! pycel#DIV/0!
math/0d88cc =SQRT(-4) #NUM! gsheets#NUM! excel#NUM! lattice#NUM! ironcalc#NUM! hyperformula#NUM! libreoffice#VALUE! formulas#NUM! pycel#NUM!
math/de34d7 =FACT(-1) #NUM! gsheets#NUM! excel#NUM! lattice#NUM! ironcalc#NUM! hyperformula#NUM! libreoffice#VALUE! formulas#NUM! pycel#NUM!
statistical-descriptive/571170 =HARMEAN(0, 2, 4) #NUM! gsheets#NUM! excel#NUM! lattice#NUM! ironcalc#NUM! hyperformula#NUM! libreoffice#VALUE! formulas#NUM! pycel#NAME?
statistical-descriptive/d1fd5a =LARGE({1,2,3}, 5) #NUM! gsheets#NUM! excel#NUM! lattice#NUM! ironcalc#NUM! hyperformula#NUM! libreoffice#VALUE! formulas#NUM! pycel#NUM!
statistical-descriptive/e75a30 =LARGE({1,2,3}, 0) #NUM! gsheets#NUM! excel#NUM! lattice#NUM! ironcalc#NUM! hyperformula#NUM! libreoffice#VALUE! formulas#NUM! pycel#NUM!
statistical-descriptive/2901e2 =MODE(1, 2, 3, 4, 5) #N/A gsheets#N/A excel#N/A lattice#N/A ironcalc#NAME? hyperformula#NAME? libreoffice#VALUE! formulas#N/A pycel#NAME?
statistical-descriptive/66de41 =PERMUT(3, 5) #NUM! gsheets#NUM! excel#NUM! lattice#NUM! ironcalc#NAME? hyperformula#NAME? libreoffice#VALUE! formulas#NUM! pycel#NAME?
statistical-descriptive/035450 =QUARTILE({1,2,3,4,5}, 5) #NUM! gsheets#NUM! excel#NUM! lattice#NUM! ironcalc#NAME? hyperformula#NAME? libreoffice#VALUE! formulas#NUM! pycel#NAME?
statistical-descriptive/509b18 =SMALL({1,2,3}, 5) #NUM! gsheets#NUM! excel#NUM! lattice#NUM! ironcalc#NUM! hyperformula#NUM! libreoffice#VALUE! formulas#NUM! pycel#NUM!
statistical-descriptive/da8c51 =SMALL({1,2,3}, 0) #NUM! gsheets#NUM! excel#NUM! lattice#NUM! ironcalc#NUM! hyperformula#NUM! libreoffice#VALUE! formulas#NUM! pycel#NUM!
statistical-descriptive/585f54 =TRIMMEAN({1,2,3}, 1) #NUM! gsheets#NUM! excel#NUM! lattice#NUM! ironcalc#NAME? hyperformula#NAME? libreoffice#VALUE! formulas#NUM! pycel#NAME?