https://bugs.freedesktop.org/show_bug.cgi?id=85258
Bug ID: 85258 Summary: ISBLANK counts cells with reference to an empty cell in array context Product: LibreOffice Version: Inherited From OOo Hardware: Other OS: All Status: UNCONFIRMED Severity: normal Priority: medium Component: Spreadsheet Assignee: libreoffice-bugs@lists.freedesktop.org Reporter: rb.hensc...@t-online.de Created attachment 108139 --> https://bugs.freedesktop.org/attachment.cgi?id=108139&action=edit Testcases for ISBLANK Open attached document. Compare the results for a simple call =ISBLANK(B3) in column C, with the corresponding result, when =ISBLANK gets a Force Array attribute. ISBLANK expects a single value, see ODF 6.13.14 ISBLANK in part2: "Syntax: ISBLANK( Scalar X )" If such functions are forced to array context, then they follow the concept "iteration", see 6.3.4 Force to array context (ForceArray) in part 2: "... where a reference to a single cell is expected and multiple cells are provided, iteration over the multiple cells is performed and results are stored in an array that is passed on." Such iteration is done as: "When evaluating a formula in 'matrix' mode, and a non-scalar value is passed to a function argument that expects a scalar, the function is evaluated multiple times, iterating over the non-scalar input(s) and putting the function result into a matrix at the position corresponding to the input." see 3.3 Non-Scalar Evaluation (aka 'Array expressions'), section 2.2. Therefore the results in column D need to be the same as in column C. -- 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