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: libreoffice-bugs@lists.freedesktop.org Reporter: jerome.bo...@wanadoo.fr 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 Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs