Apache OpenOffice (AOO) Bugzilla – Issue 24110
Boolean calculation in spreadsheets
Last modified: 2013-08-07 15:12:27 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.
Ho Bettina, one4you
Or, indeed, BOOL_XOR
To grep the issues easier via "requirements" I put the issues currently lying on my owner to the owner "requirements".