Re: [office-formula] CEILING/FLOOR

["Andreas J. Guelzow" <aguelzow@math.concordia.ab.ca>]

On Fri, 2007-26-01 at 20:19 +0100, Eike Rathke wrote:
> Hi,
> 
> As can be found in the TODOs, CEILING and FLOOR can have these strange
> Excel semantics that round the absolute amount if number and
> significance are negative (away from zero for CEILING, toward zero for
> FLOOR). This is the reason why OOoCalc introduced a third optional
> parameter that if given and not zero signals to do the same.
> 
> The possibilities we have are:
> 
> 1) Use the usual mathematical definition with two parameters, have
>    a third optional parameter to mimic the Excel behavior.
> 
> 2) Use the usual mathematical definition with two parameters, ignoring
>    Excel. Optionally define another function that behaves like in Excel.
> 
> 3) Swap #2 and do like Excel, optionally define another function with
>    mathematical behavior.
> 
> 4) Only copy Excel behavior.
> 
> Opinions? I'm undecided between #1 and #2.

#1 (since it has already an implementing application)

Andreas
-- 
Andreas J. Guelzow, Professor
Dept. of Mathematical & Computing Sciences
Concordia University College of Alberta