Apache OpenOffice (AOO) Bugzilla – Issue 118236
ISBLANK() returns FALSE instead of #VALUE!
Last modified: 2014-03-19 11:35:23 UTC
First an example of correct behaviour using ABS(): Create new blank spreadsheet In cell A1 enter =ABS(B1:B2) In cell A2 enter =ABS(B1:B2) In cell A3 enter =ABS(B1:B2) Result: A1=0, A2=0, A3=#VALUE! (this is correct) Now an example of failure with ISBLANK(): Create new blank spreadsheet In cell A1 enter =ISBLANK(B1:B2) In cell A2 enter =ISBLANK(B1:B2) In cell A3 enter =ISBLANK(B1:B2) Result: A1=TRUE, A2=TRUE, A3=FALSE. Problem: A3 should be #VALUE! because the target range is invalid. Note: Excel is reported to have the same behaviour, but that does not make it correct. :p
Standard is, "Summary: Return TRUE if the referenced cell is blank, else return FALSE" It does not state that an error value is not propagated, but 'else' can be read to cover all other cases including error values. Gnumeric returns FALSE too. So I see no need to change the behavior. The ODF1.2 draft is in public comment state. You might report to OASIS, that the specification is unclear for the error value case.
http://www.oasis-open.org/news/announcements/60-day-public-review-for-opendocument-version-1-2-cos
getting rid of value "enhancement" for field "severity". For enhancement the field "issue type" shall be used.
I'm missing something here. Why is the range B1:B2 invalid when references from cell A3, but not when references from A1 or A2? It is the same range either way, yes?
Results of description are obtained with Calc 4.1 and Excel 2010. IMHO true correct behavior should not allow cell range for the functions ABS and ISBLANK. These functions are intended according both Calc and Excel help to apply on "a cell" - not plural. AOO410m1(Build:9750) - Rev. 1543812 Rev.1543812 Win 7
Version has been modified erroneous, so back to most early version