Re: [office-formula] Formula Terminology

[Eike Rathke <erack@sun.com>]

Hi Andreas,

On Wednesday, 2010-01-13 19:03:45 -0700, Andreas J. Guelzow wrote:

> > 5.4.5 Infix Operator "/" - "Dividing by zero returns an Error.
> > 
> > Note that this operator is reported to have Constraints: *none*
> 
> This of course would be a perfect place for a constraint!

Indeed.


> > 5.4.12 Infix Operator Reference Intersection ("!")
> > 
> > > If for all intersections there are no cells in common and the result 
> > > list is empty, error #NULL! is returned.
> 
> This is really bad: We never define the #NULL! error (nor should we). In
> fact the only error that we require is #NA!

Should be "an error is returned" instead.


> > 5.5.3 MINVERSE
> > 
> > > If the matrix is not invertible, this function *should* return an 
> > > error value.
> 
> I am not quite sure whether we can/should formulate this as a
> constraint.

Probably not, if we don't want to have the constraint read "invertible
matrix" ... but again, IMHO ist should be *shall* instead of *should*.
What else would an evaluator return for a non-invertible matrix if not
an error?

  Eike

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

PGP signature