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 application? Seems we should remove the constraint chosen <= total. Eike -- Automatic string conversions considered dangerous. They are the GOTO statements of spreadsheets. --Robert Weir on the OpenDocument formula subcommittee's list.