https://bz.apache.org/ooo/show_bug.cgi?id=118236
--- Comment #10 from dam...@apache.org --- (In reply to Czesław Wolański from comment #8) > (In reply to damjan from comment #7) > > ODF 1.3 added "This function does not propagate Error values." to the > > ISBLANK, ISFORMULA, ISLOGICAL, ISNONTEXT, ISNUMBER, ISREF, ISTEXT, and TYPE > > functions. OpenOffice already does the right thing. > Does it matter that the TYPE function returns #VALUE!- as shown > in the attached .ods file? Yes it might. What do Excel, LO, Gnumeric do? And how does that .ods file work? What kind of range is "aRef" when it's not listed under Data -> Select Range. Why do the values in each column differ despite having the same formula? Why does it say aRef is A2:A3 when cell O1 has "aRef" in it? > BTW: > Just wondering whether AOO Help and Calc Guide should point out > what Calc functions do not (or do) return an error if: > - there is no intersection (range - formula) or > - the range at the intersection covers several rows or columns. LO did not change its documentation, but we might consider it. -- You are receiving this mail because: You are the assignee for the issue. You are on the CC list for the issue.
