https://bugs.documentfoundation.org/show_bug.cgi?id=162379
Bug ID: 162379
Summary: Information about behavior of functions AND and OR in
array context is missing
Product: LibreOffice
Version: unspecified
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Documentation
Assignee: [email protected]
Reporter: [email protected]
CC: [email protected]
Created attachment 195743
--> https://bugs.documentfoundation.org/attachment.cgi?id=195743&action=edit
File with AND and OR in array context
Open attached file. Look at columns G to L. The row 1 shows the formula used in
row 2.
Try to explain, why the formula in I2 does not produce a column but a single
value, although the formula is in array context. Same for formula in L2.
Neither the Help nor the extended function information in the Wiki give an
explanation.
You find the reason in the standard itself, in 6.15.2 AND and 6.15.8 OR in part
4
https://docs.oasis-open.org/office/OpenDocument/v1.3/os/part4-formula/OpenDocument-v1.3-os-part4-formula.html#__RefHeading__1018442_715980110
<quote>
Also in array context a logical AND of all arguments is computed, range or
array parameters are not evaluated as a matrix and no array is returned. This
behavior is consistent with functions like SUM. To compute a logical AND of
arrays per element use the * operator in array context.
</quote>
<quote>
Also in array context a logical OR of all arguments is computed, range or array
parameters are not evaluated as a matrix and no array is returned. This
behavior is consistent with functions like SUM. To compute a logical OR of
arrays per element use the + operator in array context.
</quote>
This information should at least be contained in the Wiki.
--
You are receiving this mail because:
You are the assignee for the bug.
