Re: [office-formula] Creating the test suite

[robert_weir@us.ibm.com]

Makes me wonder if we want to formally
adopt IEEE 754 floating point conventions for things like1/0 == +Infinity,
but 0/0==NaN, etc.,  at least in the processing model.  Implementations
could collapse this all into a single Error string for the user interface
if they desired.

-Rob

Daniel Carrera <daniel.carrera@zmsl.com> wrote
on 07/19/2006 07:36:16 AM:

> This is a question for David I guess. Some of the tests are supposed
to
> produce an error. For example, see page 64, the test =1/0. I can't
> figure out what I should put on the test spreadsheet, under the Expected
> result column. Should I just put the string "Error"?
> 
> How is the test suite supposed to check error tests? Would it be a
> better idea to replace the Expression by =ISERROR(1/0) ? Ditto for
all
> expressions that are supposed to give an error.
>