[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]