Issue 111519 - ODFF: BINARY MATH
Alias: None
Product: Calc
Classification: Application
Component: programming (show other issues)
Version: OOO320m9
Hardware: All All
: P4 Trivial with 2 votes (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Keywords: oooqa
Depends on:
Reported: 2010-05-10 18:07 UTC by joeconner
Modified: 2015-11-22 07:03 UTC (History)
7 users (show)

See Also:
Latest Confirmation in: 4.2.0-dev
Developer Difficulty: ---

Calc document illistrating failure of boolean math. (8.57 KB, application/vnd.oasis.opendocument.spreadsheet)
2010-05-10 18:46 UTC, joeconner
no flags Details
Spreadsheet with examples bitwise functions (13.21 KB, application/vnd.oasis.opendocument.spreadsheet)
2014-04-17 17:03 UTC, Joe Smith
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description joeconner 2010-05-10 18:07:13 UTC
I request binary math functions be added to calc.
For example, in cell A1 enter "A" (without quotes)
and "B" in cell B1 "B" (again without quotes) and
in cell C1 you could enter a binary formula (for 
example "=XOR(A1;B1)" (again without quotes) and 
it would accept the formula as valid binary math.
All binary operators should be added.
Comment 1 Regina Henschel 2010-05-10 18:26:13 UTC
Those functions are BITAND, BITOR, BITXOR, BITLSHIFT, and BITRSHIFT in ODF 1.2.

Comment 2 joeconner 2010-05-10 18:44:40 UTC
NICE TRY, but no cigar.
Check out the Calc
spreadsheet I am attaching.
Comment 3 joeconner 2010-05-10 18:46:18 UTC
Created attachment 69401 [details]
Calc document illistrating failure of boolean math.
Comment 4 Regina Henschel 2010-05-10 18:59:35 UTC
Not all ODF1.2 functions are implemented yet. I have written a summary on
Currently I'm working on the missing complex trigonometric functions, the others
will come by and by. If no one will take this task, you will have to wait a bit.
Comment 5 wope 2010-09-02 17:42:30 UTC
I'll implement this functions
Comment 6 joeconner 2011-03-04 02:37:22 UTC
According to the information in the XOR function is implemented already.  My try at using it in CALC v3.30 fails.  In what way. or in what OOo version, has XOR been implemented?
Comment 7 ooo 2011-03-09 15:21:28 UTC
@joeconner: (In reply to comment #6)
XOR is implemented in CWS calcishmakkica not integrated yet, see issue 114428.
Comment 8 Joe Smith 2014-04-17 17:02:43 UTC
Just to be clear: this issue concerns BITWISE functions in Calc, NOT BOOLEAN functions.

The XOR function in Issue 114428 is a BOOLEAN function.

Also, the sample spreadsheet attached seems to have some problems.
Here's an updated sheet that works in LibO
Comment 9 Joe Smith 2014-04-17 17:03:48 UTC
Created attachment 83222 [details]
Spreadsheet with examples bitwise functions
Comment 10 Pathangi Jatinshravan 2015-11-18 15:17:15 UTC
Opened, with patch attached. Currently in patch review stage.
Comment 11 damjan 2015-11-22 07:03:33 UTC
BITAND, BITOR and BITXOR have now been added in r1715605. Excel import/export for them still needs to be developed.