https://bugs.documentfoundation.org/show_bug.cgi?id=164635
Bug ID: 164635
Summary: : boolean calculation fails when using ranges
Product: LibreOffice
Version: 24.8.4.2 release
Hardware: All
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Created attachment 198445
--> https://bugs.documentfoundation.org/attachment.cgi?id=198445&action=edit
formula using booleans from ranges
Hi!
In the attached "boolean.ods" I've filled the columns A (named range data1) and
B (named range data2) with random numbers (row 7 to 21).
The columns C (named range bool1) and D (named range bool2) contain booleans
calculated using the data ranges data1 and data2.
Eventually the formula in column E should calculate a boolean operation using
data of the ranges bool1 and bool2.
But this fails. The results aren't correct.
When I separately check the booleans, like in
colomns F ( =IF(bool1;IF(bool2;TRUE();FALSE());FALSE()) )
and G ( =IF(bool1;IF(bool2;data1+data2;"bool2=True");"bool1=True") ),
it works.
Is there something I might have done wrong, or is this a bug?
Kind regards,
Willy
--
You are receiving this mail because:
You are the assignee for the bug.
