assay

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
BITAND/bitand-basic =BITAND(5, 3) 1 gsheets1 excel1 lattice1 ironcalc1 hyperformula1 libreoffice— formulas1 pycel1
BITAND/bitand-zero =BITAND(12, 0) 0 gsheets0 excel0 lattice0 ironcalc0 hyperformula0 libreoffice— formulas0 pycel0
BITAND/bitand-negative-error =BITAND(-1, 3) #NUM! gsheets#NUM! excel#NUM! lattice#NUM! ironcalc#NUM! hyperformula#NUM! libreoffice— formulas#NUM! pycel#NAME?
BITAND/bitand-exceeds-2-48 =BITAND(281474976710656, 1) #NUM! gsheets#NUM! excel#NUM! lattice#NUM! ironcalc#NUM! hyperformula0 libreoffice— formulas#NUM! pycel0
BITOR/bitor-basic =BITOR(5, 3) 7 gsheets7 excel7 lattice7 ironcalc7 hyperformula7 libreoffice— formulas7 pycel7
BITOR/bitor-disjoint =BITOR(8, 4) 12 gsheets12 excel12 lattice12 ironcalc12 hyperformula12 libreoffice— formulas12 pycel12
BITOR/bitor-negative-error =BITOR(-1, 3) #NUM! gsheets#NUM! excel#NUM! lattice#NUM! ironcalc#NUM! hyperformula#NUM! libreoffice— formulas#NUM! pycel#NAME?
BITXOR/bitxor-basic =BITXOR(5, 3) 6 gsheets6 excel6 lattice6 ironcalc6 hyperformula6 libreoffice— formulas6 pycel6
BITXOR/bitxor-self-zero =BITXOR(7, 7) 0 gsheets0 excel0 lattice0 ironcalc0 hyperformula0 libreoffice— formulas0 pycel0
BITXOR/bitxor-negative-error =BITXOR(-1, 3) #NUM! gsheets#NUM! excel#NUM! lattice#NUM! ironcalc#NUM! hyperformula#NUM! libreoffice— formulas#NUM! pycel#NAME?
BITLSHIFT/bitlshift-basic =BITLSHIFT(1, 3) 8 gsheets8 excel8 lattice8 ironcalc8 hyperformula8 libreoffice— formulas8 pycel8
BITLSHIFT/bitlshift-zero-shift =BITLSHIFT(42, 0) 42 gsheets42 excel42 lattice42 ironcalc42 hyperformula42 libreoffice— formulas42 pycel42
BITLSHIFT/bitlshift-negative-shift-acts-as-rshift =BITLSHIFT(16, -2) 4 gsheets4 excel4 lattice4 ironcalc4 hyperformula4 libreoffice— formulas4 pycel#NAME?
BITLSHIFT/bitlshift-negative-number-error =BITLSHIFT(-1, 2) #NUM! gsheets#NUM! excel#NUM! lattice#NUM! ironcalc#NUM! hyperformula#NUM! libreoffice— formulas#NUM! pycel#NAME?
BITRSHIFT/bitrshift-basic =BITRSHIFT(16, 2) 4 gsheets4 excel4 lattice4 ironcalc4 hyperformula4 libreoffice— formulas4 pycel4
BITRSHIFT/bitrshift-zero-shift =BITRSHIFT(42, 0) 42 gsheets42 excel42 lattice42 ironcalc42 hyperformula42 libreoffice— formulas42 pycel42
BITRSHIFT/bitrshift-negative-shift-acts-as-lshift =BITRSHIFT(1, -3) 8 gsheets8 excel8 lattice8 ironcalc8 hyperformula8 libreoffice— formulas8 pycel#NAME?
BITRSHIFT/bitrshift-negative-number-error =BITRSHIFT(-1, 2) #NUM! gsheets#NUM! excel#NUM! lattice#NUM! ironcalc#NUM! hyperformula#NUM! libreoffice— formulas#NUM! pycel#NAME?
IFNA/ifna-no-error =IFNA(1, "na") 1 gsheets1 excel1 lattice1 ironcalc1 hyperformula1 libreoffice— formulas1 pycel1
CEILING.PRECISE/ceiling-precise-positive =CEILING.PRECISE(4.3) 5 gsheets5 excel5 lattice5 ironcalc5 hyperformula5 libreoffice— formulas5 pycel5
CEILING.PRECISE/ceiling-precise-negative =CEILING.PRECISE(-4.3) -4 gsheets-4 excel-4 lattice-4 ironcalc-4 hyperformula-4 libreoffice— formulas5 pycel#NAME?
CEILING.PRECISE/ceiling-precise-with-significance =CEILING.PRECISE(4.3, 2) 6 gsheets6 excel6 lattice6 ironcalc6 hyperformula6 libreoffice— formulas6 pycel6
CEILING.PRECISE/ceiling-precise-negative-significance-ignored =CEILING.PRECISE(-4.3, -2) -4 gsheets-4 excel-4 lattice-4 ironcalc-4 hyperformula-4 libreoffice— formulas-4 pycel#NAME?
FLOOR.PRECISE/floor-precise-positive =FLOOR.PRECISE(4.8) 4 gsheets4 excel4 lattice4 ironcalc4 hyperformula4 libreoffice— formulas4 pycel4
FLOOR.PRECISE/floor-precise-negative =FLOOR.PRECISE(-4.3) -5 gsheets-5 excel-5 lattice-5 ironcalc-5 hyperformula-5 libreoffice— formulas4 pycel#NAME?
FLOOR.PRECISE/floor-precise-with-significance =FLOOR.PRECISE(4.8, 2) 4 gsheets4 excel4 lattice4 ironcalc4 hyperformula4 libreoffice— formulas4 pycel4
FLOOR.PRECISE/floor-precise-negative-significance-ignored =FLOOR.PRECISE(-4.3, -2) -6 gsheets-6 excel-6 lattice-6 ironcalc-6 hyperformula-6 libreoffice— formulas-6 pycel#NAME?
CEILING.MATH/ceiling-math-basic =CEILING.MATH(5.2) 6 gsheets6 excel6 lattice6 ironcalc6 hyperformula6 libreoffice— formulas6 pycel6
CEILING.MATH/ceiling-math-with-significance =CEILING.MATH(5.2, 2) 6 gsheets6 excel6 lattice6 ironcalc6 hyperformula6 libreoffice— formulas6 pycel6
FLOOR.MATH/floor-math-basic =FLOOR.MATH(5.2) 5 gsheets5 excel5 lattice5 ironcalc5 hyperformula5 libreoffice— formulas5 pycel5
FLOOR.MATH/floor-math-with-significance =FLOOR.MATH(5.2, 2) 4 gsheets4 excel4 lattice4 ironcalc4 hyperformula4 libreoffice— formulas4 pycel4
MAXIFS/maxifs-single-criterion =MAXIFS(E1:E5, D1:D5, "A") 50 gsheets50 excel50 lattice50 ironcalc50 hyperformula50 libreoffice— formulas50 pycel50
MAXIFS/maxifs-comparator =MAXIFS(A1:A5, A1:A5, "<4") 3 gsheets3 excel3 lattice3 ironcalc3 hyperformula3 libreoffice— formulas3 pycel3
MAXIFS/maxifs-no-match =MAXIFS(A1:A3, A1:A3, ">100") 0 gsheets0 excel0 lattice0 ironcalc0 hyperformula0 libreoffice— formulas0 pycel0
MINIFS/minifs-single-criterion =MINIFS(E1:E5, D1:D5, "A") 10 gsheets10 excel10 lattice10 ironcalc10 hyperformula10 libreoffice— formulas10 pycel10
MINIFS/minifs-comparator =MINIFS(A1:A5, A1:A5, ">2") 3 gsheets3 excel3 lattice3 ironcalc3 hyperformula3 libreoffice— formulas3 pycel3
MINIFS/minifs-no-match =MINIFS(A1:A3, A1:A3, ">100") 0 gsheets0 excel0 lattice0 ironcalc0 hyperformula0 libreoffice— formulas0 pycel0
GAMMA/gamma-at-1 =GAMMA(1) 1 gsheets1 excel1 lattice1 ironcalc1 hyperformula1 libreoffice— formulas1 pycel1
GAMMA/gamma-at-5 =GAMMA(5) 24 gsheets24.0000 excel24 lattice24.0000 ironcalc24 hyperformula24 libreoffice— formulas24 pycel24
MAXIFS/maxifs-with-criteria =MAXIFS(A1:A4, B1:B4, "=A*") 15 gsheets15 excel15 lattice15 ironcalc15 hyperformula15 libreoffice— formulas15 pycel15
MINIFS/minifs-with-criteria =MINIFS(A1:A4, B1:B4, "=A*") 5 gsheets5 excel5 lattice5 ironcalc5 hyperformula5 libreoffice— formulas5 pycel5