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: [email protected]
Reporter: [email protected]
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
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
