Issue 24110 - Boolean calculation in spreadsheets
Summary: Boolean calculation in spreadsheets
Status: CONFIRMED
Alias: None
Product: Calc
Classification: Application
Component: ui (show other issues)
Version: OOo 1.1
Hardware: PC Windows 2000
: P5 (lowest) Trivial with 2 votes (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2004-01-05 14:47 UTC by lolomic
Modified: 2013-08-07 15:12 UTC (History)
1 user (show)

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


Attachments

Note You need to log in before you can comment on or make changes to this issue.
Description lolomic 2004-01-05 14:49:06 UTC
Adding a function to do boolean calculation. It could be something like :

= BOOL_AND(3;2)
or
= 3 BOOL_AND 2

and then the result shows "2" or shows "10" (binary) or even "00000010" (binary in with 8 bits).

Another similar point to test with a mask :

=TEST_BOOL_AND(5;4)

The result shows TRUE as bit 2 is set for both 5 and 4.

Not only 2 parameters could be entered BOOL_AND(X;Y;...;n).

Same for a BOOL_OR and TEST_BOOL_OR function.
Comment 1 oc 2004-01-09 11:39:22 UTC
Ho Bettina, one4you
Comment 2 bobharvey 2007-03-25 10:20:20 UTC
Or, indeed, BOOL_XOR
Comment 3 bettina.haberer 2010-05-21 14:36:36 UTC
To grep the issues easier via "requirements" I put the issues currently lying on
my owner to the owner "requirements".