https://bugs.documentfoundation.org/show_bug.cgi?id=162379

--- Comment #1 from Werner Tietz <[email protected]> ---
hallo

the Explaination for »AND« in the Formula-Wizard:
»» returns TRUE if **all** Arguments are TRUE ««

and lets simplify… the Formula to 

=AND(G2:G201)
would you expect here to see an array like »TRUE;FALSE;…;…« or would you expect
simply »FALSE« because NOT all Arguments are TRUE ?

the same Evaluation happens for Formula:

=AND(G2:G201;H2:H201) 
returns FALSE because it evaluates first »G2:G201« and then »H2:H201«


btw. if you attach some …ods, please disable this crappy ⇒View⇒Grid and
Helplines⇒Display Grid

-- 
You are receiving this mail because:
You are the assignee for the bug.

Reply via email to