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

*Subject*: **Re: [office-formula] Formula Terminology**

*From*:**Eike Rathke <erack@sun.com>***To*: office-formula@lists.oasis-open.org*Date*: Thu, 14 Jan 2010 14:56:40 +0100

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.

**References**:**Formula Terminology***From:*robert_weir@us.ibm.com

**Re: [office-formula] Formula Terminology***From:*"Andreas J. Guelzow" <aguelzow@math.concordia.ab.ca>

**Re: [office-formula] Formula Terminology***From:*Patrick Durusau <patrick@durusau.net>

**Re: [office-formula] Formula Terminology***From:*Andreas J Guelzow <aguelzow@math.concordia.ab.ca>

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