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
