https://bugs.freedesktop.org/show_bug.cgi?id=88255
Bug ID: 88255
Summary: array formula implementing OR and AND functions
between each elements of same position
Product: LibreOffice
Version: 4.2.7.2 release
Hardware: Other
OS: All
Status: UNCONFIRMED
Severity: enhancement
Priority: medium
Component: Spreadsheet
Assignee: [email protected]
Reporter: [email protected]
When using "OR" and "AND" formula on 2 arrays of same sizes, the result is
equivalent to :
- the "OR" operator between [the result of "OR" operator between all cells of
the 1st array] and [the result of "OR" operator between all cells of the 2nd
array]
- the "AND" operator between [the result of "AND" operator between all cells of
the 1st array] and [the result of "AND" operator between all cells of the 2nd
array]
I would like array functions which provide the result of "OR" and "AND" between
the elements of the 2 arrays which have the same position.
The array result would be built as below :
- row 1 and column 1 is the result of the cell function bewteen the cell at row
1 and column 1 of the 1st array and the row 1 and column 1 of the 2nd array,
- ...
- row R and column C is the result of the cell function bewteen the cell at row
R and column C of the 1st array and the row R and column C of the 2nd array,
- etc
Currently, the work around I found is a painfull use of nested IF formulas on
arrays.
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
