Issue 111519 - ODFF: BINARY MATH
Summary: ODFF: BINARY MATH
Status: CONFIRMED
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:
URL:
Keywords: oooqa
Depends on:
Blocks:
 
Reported: 2010-05-10 18:07 UTC by joeconner
Modified: 2015-11-22 07:03 UTC (History)
7 users (show)

See Also:
Issue Type: ENHANCEMENT
Latest Confirmation in: 4.2.0-dev
Developer Difficulty: ---

Attachments
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
Add an attachment (proposed patch, testcase, etc.)

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
http://wiki.services.openoffice.org/wiki/Calc/ODFF_Implementation/Examine_functions.
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 http://wiki.services.openoffice.org/wiki/Calc/ODFF_Implementation/Examine_functions 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 4.1.4.2
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 https://bz.apache.org/ooo/show_bug.cgi?id=126668, 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.