Issue 24110

Summary:	Boolean calculation in spreadsheets
Product:	Calc	Reporter:	lolomic <laurent-jp.michon>
Component:	ui	Assignee:	AOO issues mailing list <issues>
Status:	CONFIRMED ---	QA Contact:
Severity:	Trivial
Priority:	P5 (lowest)	CC:	issues
Version:	OOo 1.1
Target Milestone:	---
Hardware:	PC
OS:	Windows 2000
Issue Type:	ENHANCEMENT	Latest Confirmation in:	---
Developer Difficulty:	---

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".