Bug 158974

Summary: BITXOR produced wrong result
Product: LibreOffice Reporter: peter_pollard
Component: CalcAssignee: Not Assigned <libreoffice-bugs>
Status: RESOLVED NOTABUG    
Severity: normal CC: miguelangelrv
Priority: medium    
Version: 7.5.6.2 release   
Hardware: x86-64 (AMD64)   
OS: Linux (All)   
Whiteboard:
Crash report or crash signature: Regression By:

Description peter_pollard 2024-01-02 13:41:06 UTC

    
Comment 1 peter_pollard 2024-01-02 14:04:02 UTC
Using the BITXOR function with input values 32763 and 16386 gave the result 16377

Output from a fresh session of Libre Calc displayed (use of DEC2BIN presented the heaxadecimal notation)

32763	7FFB
16386	4002
16377	3FF9

using the View menu option Show Formula displayed

32763	=DEC2HEX(A1)
16386	=DEC2HEX(A2)
 ### 	=DEC2HEX(A3)

nb. the formula =BITXOR(A1;A2) in A3 is not displayed in this view and displays ### in its place (perhaps a further bug?)
Comment 2 peter_pollard 2024-01-02 14:24:42 UTC
The author agrees this report was raised in error.
The BITXOR example shown does show the correct result.
Apologies from the author.