Re: [office-formula] MIN/MAX/MINA/MAXA and no value, zero?

From
David A. Wheeler <>
Date
2007-03-06T18:12:46+00:00
ID
Thread
Re: [office-formula] MIN/MAX/MINA/MAXA and no value, zero?
robert_weir:
> 
> I don't know if I'd favor having some implementations give an error while others give zero.  If someone has a document that silently fails (gives zero) and then gives an error when they give the spreadsheet to someone else,  then this will certainly cause some user confusion.

> Also, this is not an arcane function that will be used by few people.  This is not a Bessel function.  MIN and MAX are very basic functions that all will use.  So the impact of confusion would be multiplied. So I'd recommend having a single, complete, unambiguous definition for it.

Okay.  Giving MAX/MIN/etc 0 parameters _is_ a little arcane, but I agree that the functions themselves certainly are NOT arcane.  I see your point.

In that case, I think we ought to return "0" when handed 0 parameters.  Note: This means it should be "*" not "+" in the arg list.

Any objections?

--- David A. Wheeler