Re: [office-formula] Creating the test suite

From
<>
Date
2006-07-19T18:42:20+00:00
ID
Thread
Re: [office-formula] Creating the test suite
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 <> 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.

>