OASIS Mailing List ArchivesView the OASIS mailing list archive below
or browse/search using MarkMail.

 


Help: OASIS Mailing Lists Help | MarkMail Help

office-formula message

[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]


Subject: ISERROR(undefinedname) behavior


Hi,

There is a special case with the ISERROR function when used with an
undefined name, as in =ISERROR(undefinedname)

Excel and Gnumeric return TRUE, while Calc returns a #NAME? error
because the error is already propagated at compile time when
encountering 'undefinedname' and the formula is never interpreted.
Kspread 1.5.0 returns FALSE, which obviously is wrong.

Do we want to require that ISERROR still returns TRUE in this case?

  Eike

-- 
Automatic string conversions considered dangerous. They are the GOTO statements
of spreadsheets.  --Robert Weir on the OpenDocument formula subcommittee's list.


[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]