Bug 158974 - BITXOR produced wrong result
Summary: BITXOR produced wrong result
Status: RESOLVED NOTABUG
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
7.5.6.2 release
Hardware: x86-64 (AMD64) Linux (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2024-01-02 13:41 UTC by peter_pollard
Modified: 2024-01-02 16:23 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
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.