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! 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.