https://bugs.documentfoundation.org/show_bug.cgi?id=162379
Regina Henschel <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Attachment #195743|0 |1 is obsolete| | --- Comment #2 from Regina Henschel <[email protected]> --- Created attachment 195753 --> https://bugs.documentfoundation.org/attachment.cgi?id=195753&action=edit File with AND and OR in array context (In reply to Werner Tietz from comment #1) > 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 ? and what result do you expect for CONCATENATE(A2:A201) as array formula? Try for example TEXTJOIN(" "; ;A2:A201;B2:B201), CONCAT(A2:201;" ";B2:B210), CONCATENATE(A2:201;" ";B2:B210) each as array formula. Compare the descriptions. I still think that the behavior of AND, OR, XOR is not clearly enough described. -- You are receiving this mail because: You are the assignee for the bug.
