DV-0007

libreoffice: function not implemented — BITAND, BITLSHIFT, BITOR (+10 more)

Cause
missing-function
Category
value
Diverging engines
libreoffice
Behavior signature
{"error":"#NAME?"}
Test count
41
Seeded
2026-04-25
Last confirmed
2026-04-25

Subjects (13)

BITAND BITLSHIFT BITOR BITRSHIFT BITXOR CEILING.MATH CEILING.PRECISE FLOOR.MATH FLOOR.PRECISE GAMMA IFNA MAXIFS MINIFS

Tests (41)

matches canonical diverges no fixture in this DV's cluster

Test Formula Canonical gsheets excel lattice ironcalc hyperformula libreoffice formulas pycel
engineering/12e8ab =BITAND(5, 3) 1 gsheets1 excel1 lattice1 ironcalc1 hyperformula1 libreoffice#NAME? formulas1 pycel1
engineering/8b5309 =BITAND(12, 0) 0 gsheets0 excel0 lattice0 ironcalc0 hyperformula0 libreoffice#NAME? formulas0 pycel0
engineering/0fde0a =BITAND(-1, 3) #NUM! gsheets#NUM! excel#NUM! lattice#NUM! ironcalc#NUM! hyperformula#NUM! libreoffice#NAME? formulas#NUM! pycel#NUM!
engineering/8c15d0 =BITAND(281474976710656, 1) #NUM! gsheets#NUM! excel#NUM! lattice#NUM! ironcalc#NUM! hyperformula0 libreoffice#NAME? formulas#NUM! pycel0
engineering/759cf0 =BITOR(5, 3) 7 gsheets7 excel7 lattice7 ironcalc7 hyperformula7 libreoffice#NAME? formulas7 pycel7
engineering/54e3e1 =BITOR(8, 4) 12 gsheets12 excel12 lattice12 ironcalc12 hyperformula12 libreoffice#NAME? formulas12 pycel12
engineering/2550cc =BITOR(-1, 3) #NUM! gsheets#NUM! excel#NUM! lattice#NUM! ironcalc#NUM! hyperformula#NUM! libreoffice#NAME? formulas#NUM! pycel#NUM!
engineering/8c6b66 =BITXOR(5, 3) 6 gsheets6 excel6 lattice6 ironcalc6 hyperformula6 libreoffice#NAME? formulas6 pycel6
engineering/12bb66 =BITXOR(7, 7) 0 gsheets0 excel0 lattice0 ironcalc0 hyperformula0 libreoffice#NAME? formulas0 pycel0
engineering/ed777f =BITXOR(-1, 3) #NUM! gsheets#NUM! excel#NUM! lattice#NUM! ironcalc#NUM! hyperformula#NUM! libreoffice#NAME? formulas#NUM! pycel#NUM!
engineering/98bddc =BITLSHIFT(1, 3) 8 gsheets8 excel8 lattice8 ironcalc8 hyperformula8 libreoffice#NAME? formulas8 pycel8
engineering/1abea2 =BITLSHIFT(42, 0) 42 gsheets42 excel42 lattice42 ironcalc42 hyperformula42 libreoffice#NAME? formulas42 pycel42
engineering/48b443 =BITLSHIFT(16, -2) 4 gsheets4 excel4 lattice#NUM! ironcalc4 hyperformula4 libreoffice#NAME? formulas4 pycel4
engineering/ead10e =BITLSHIFT(-1, 2) #NUM! gsheets#NUM! excel#NUM! lattice#NUM! ironcalc#NUM! hyperformula#NUM! libreoffice#NAME? formulas#NUM! pycel#NUM!
engineering/3fa96c =BITRSHIFT(16, 2) 4 gsheets4 excel4 lattice4 ironcalc4 hyperformula4 libreoffice#NAME? formulas4 pycel4
engineering/fcc493 =BITRSHIFT(42, 0) 42 gsheets42 excel42 lattice42 ironcalc42 hyperformula42 libreoffice#NAME? formulas42 pycel42
engineering/3bcb0a =BITRSHIFT(1, -3) 8 gsheets8 excel8 lattice#NUM! ironcalc8 hyperformula8 libreoffice#NAME? formulas8 pycel8
engineering/7a5030 =BITRSHIFT(-1, 2) #NUM! gsheets#NUM! excel#NUM! lattice#NUM! ironcalc#NUM! hyperformula#NUM! libreoffice#NAME? formulas#NUM! pycel#NUM!
logical/3c7a91 =IFNA(1, "na") 1 gsheets1 excel1 lattice1 ironcalc1 hyperformula1 libreoffice#NAME? formulas1 pycel1
math-longtail/b3b8b4 =CEILING.PRECISE(4.3) 5 gsheets5 excel5 lattice5 ironcalc5 hyperformula5 libreoffice#NAME? formulas5 pycel5
math-longtail/7b9b02 =CEILING.PRECISE(-4.3) -4 gsheets-4 excel-4 lattice-4 ironcalc-4 hyperformula-4 libreoffice#NAME? formulas5 pycel-4
math-longtail/c29d05 =CEILING.PRECISE(4.3, 2) 6 gsheets6 excel6 lattice6 ironcalc6 hyperformula6 libreoffice#NAME? formulas6 pycel6
math-longtail/22ec62 =CEILING.PRECISE(-4.3, -2) -4 gsheets-4 excel-4 lattice-4 ironcalc-4 hyperformula-4 libreoffice#NAME? formulas-4 pycel-4
math-longtail/0d2927 =FLOOR.PRECISE(4.8) 4 gsheets4 excel4 lattice4 ironcalc4 hyperformula4 libreoffice#NAME? formulas4 pycel4
math-longtail/fc7f51 =FLOOR.PRECISE(-4.3) -5 gsheets-5 excel-5 lattice-5 ironcalc-5 hyperformula-5 libreoffice#NAME? formulas4 pycel-5
math-longtail/fac593 =FLOOR.PRECISE(4.8, 2) 4 gsheets4 excel4 lattice4 ironcalc4 hyperformula4 libreoffice#NAME? formulas4 pycel4
math-longtail/4e4523 =FLOOR.PRECISE(-4.3, -2) -6 gsheets-6 excel-6 lattice-6 ironcalc-6 hyperformula-6 libreoffice#NAME? formulas-6 pycel-6
math/a46ba6 =CEILING.MATH(5.2) 6 gsheets6 excel6 lattice6 ironcalc6 hyperformula6 libreoffice#NAME? formulas6 pycel6
math/2c01fa =CEILING.MATH(5.2, 2) 6 gsheets6 excel6 lattice6 ironcalc6 hyperformula6 libreoffice#NAME? formulas6 pycel6
math/0a8fdc =FLOOR.MATH(5.2) 5 gsheets5 excel5 lattice5 ironcalc5 hyperformula5 libreoffice#NAME? formulas5 pycel5
math/eab644 =FLOOR.MATH(5.2, 2) 4 gsheets4 excel4 lattice4 ironcalc4 hyperformula4 libreoffice#NAME? formulas4 pycel4
statistical-descriptive/1a9885 =MAXIFS(E1:E5, D1:D5, "A") 50 gsheets50 excel50 lattice50 ironcalc50 hyperformula50 libreoffice#NAME? formulas50 pycel50
statistical-descriptive/e3db27 =MAXIFS(A1:A5, A1:A5, "<4") 3 gsheets3 excel3 lattice3 ironcalc3 hyperformula3 libreoffice#NAME? formulas3 pycel3
statistical-descriptive/1fab07 =MAXIFS(A1:A3, A1:A3, ">100") 0 gsheets0 excel0 lattice0 ironcalc0 hyperformula0 libreoffice#NAME? formulas0 pycel0
statistical-descriptive/acd654 =MINIFS(E1:E5, D1:D5, "A") 10 gsheets10 excel10 lattice10 ironcalc10 hyperformula10 libreoffice#NAME? formulas10 pycel10
statistical-descriptive/43b830 =MINIFS(A1:A5, A1:A5, ">2") 3 gsheets3 excel3 lattice3 ironcalc3 hyperformula3 libreoffice#NAME? formulas3 pycel3
statistical-descriptive/a504c3 =MINIFS(A1:A3, A1:A3, ">100") 0 gsheets0 excel0 lattice0 ironcalc0 hyperformula0 libreoffice#NAME? formulas0 pycel0
statistical-distributions/b1b992 =GAMMA(1) 1 gsheets1 excel1 lattice1 ironcalc1 hyperformula1 libreoffice#NAME? formulas1 pycel1
statistical-distributions/10ae0f =GAMMA(5) 24 gsheets24.0000 excel24 lattice24.0000 ironcalc24 hyperformula24 libreoffice#NAME? formulas24 pycel24
statistical/76d4c7 =MAXIFS(A1:A4, B1:B4, "=A*") 15 gsheets15 excel15 lattice15 ironcalc15 hyperformula15 libreoffice#NAME? formulas15 pycel15
statistical/c61d6a =MINIFS(A1:A4, B1:B4, "=A*") 5 gsheets5 excel5 lattice5 ironcalc5 hyperformula5 libreoffice#NAME? formulas5 pycel5