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] Considering IFERROR function

On Fri, 2007-08-06 at 19:04 +0200, Eike Rathke wrote:
> Hi,
> As already pointed out on the comment list, for some occasions an
> IFERROR(expression;errorcase) does come handy. The function evaluates
> 'expression' as usual, and if that results in an error returns the
> result of an 'errorcase' expression, otherwise the result of
> 'expression'. Also ECMA/MOOXML defines this function.
> I propose to include IFERROR in our ODFF specification.

On first glance this looks equivalent to 

but of course this "equivalent" version evaluates 'expression' twice
which can give a different result.

"Liberty consists less in acting according to
one's own pleasure, than in not being subject 
to the will and pleasure of other people. It 
consists also in our not subjecting the wills 
of other people to our own."  Rousseau

Prof. Dr. Andreas J. Guelzow
Dept. of Mathematical & Computing Sciences
Concordia University College of Alberta

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