https://bugs.documentfoundation.org/show_bug.cgi?id=39316
--- Comment #12 from Eike Rathke <[email protected]> --- (In reply to James from comment #0) > A1:B19 = The named range TestRange > C1:D19 = The array formula {=TestRange} > E1:F19 = The array formula {=ISBLANK(TestRange)} > G1:H19 = The array formula {=ISBLANK(C1:D19)} > > You will see the bug immediately: cell G1 shows FALSE, when it should show > TRUE. Not true. ISBLANK() returns true only if a cell is blank, does not contain data nor a formula, not if it displays as blank. > This same bug will also cause formulas to fail. Cell I1 contains the > formula "=C1+5", which returns the error "Wrong data type". Which is only indirectly related. Here it seems the operator '+' can't cope with the empty matrix element. @James: It would had been helpful to not mix various cases of whatsoever you noticed, be it related to arrays or not. Regarding SUM and PRODUCT, they ignore non-value cells by definition and thus may produce results where operator '+' and '*' may produce an error. And of course PRODUCT uses the start value 1 for its series. All major spreadsheet applications do it this way. @Beluga: Does your "confirmed" mean you tested all what was mentioned here, or just the original problem? -- 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
