Re: [office-formula] FACT/FACTDOUBLE with fractions

From
Andreas J. Guelzow <>
Date
2007-01-25T20:36:57+00:00
ID
Thread
Re: [office-formula] FACT/FACTDOUBLE with fractions
On Thu, 2007-25-01 at 16:42 +0100, Eike Rathke wrote:
> Hi,
> 
> FACT and FACTDOUBLE have
> 
> | TBD: Should we mandate that it compute INT() first? Excel 2002 computes
> | the INT() of the parameter first, and then computes the factorial. It'd
> | be more flexible if we allowed fractional values. This has been reworded
> | to note that it's only REQUIRED to support integer parameters, and then
> | permitting GAMMA() for fractional values.
> 
> For interoperability we should not allow fractionals. Opinions?
> 
> Btw, which applications do support GAMMA?

Gnumeric implements GAMMALN, the natural logarithm of the Gamma
function. So if GAMMA would be defined in OpenFormula we would have
GAMMA in short order.

Andreas


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