OASIS Mailing List ArchivesView the OASIS mailing list archive below
or browse/search using MarkMail.


Help: OASIS Mailing Lists Help | MarkMail Help

office-formula message

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

Subject: Re: [office-formula] Groups - OpenDocument Formula Specification2008-12-21 (ODT) (OpenDocument-formula-20081221.odt) uploaded

Hi Andreas,

On Sunday, 2008-12-21 16:40:36 -0700, Andreas J. Guelzow wrote:

> > - PERMUTATIONA() formula added.
> I don't know what PERMUTATIONA is supposed to calculate. But the formula
> does _not_ match what OOo calculates: give permutationa(5.2,3) a try.

Correct, the arguments need a constraint to be integer as well.

> (Gnumeric does not have that function). Moreover if repetition is
> allowed then it really doesn't make any sense to have the constraint
> chosen <= total.

True. I don't know why Calc has that restriction, but I also don't know
why it has this function at all. Excel also doesn't have it. Any other

Seems we should remove the constraint chosen <= total.


Automatic string conversions considered dangerous. They are the GOTO statements
of spreadsheets.  --Robert Weir on the OpenDocument formula subcommittee's list.

PGP signature

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