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: Re: [office-formula] Formula Terminology

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!


> > 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?


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

PGP signature

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