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

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

*From*:**"Andreas J. Guelzow" <aguelzow@math.concordia.ab.ca>***To*: office-formula@lists.oasis-open.org*Date*: Thu, 25 Jan 2007 13:37:04 -0700

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

**Follow-Ups**:**Re: [office-formula] FACT/FACTDOUBLE with fractions***From:*"David A. Wheeler" <dwheeler@dwheeler.com>

**Re: [office-formula] FACT/FACTDOUBLE with fractions***From:*Eike Rathke <erack@sun.com>

**Re: [office-formula] FACT/FACTDOUBLE with fractions***From:*"Tomas Mecir" <mecirt@gmail.com>

**References**:**FACT/FACTDOUBLE with fractions***From:*Eike Rathke <erack@sun.com>

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