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

[Eike Rathke <erack@sun.com>]

Hi Andreas,

On Sunday, 2008-12-21 17:13:43 -0700, Andreas J. Guelzow wrote:

> > - PERCENTRANK() much better semantic description.
> 
> That definitely lies in the eyes of the beholder. What do the indices a
> and b in Xa and Xb mean? If these are ranks then b should be a+1
> otherwise this may yield different answer depending on the chosen value
> for b. In that case, ra would also be a.

Good idea, b should be a+1 instead.

> perhaps rather than Xa and Xb some nonsubscripted names should be used

Any idea for nonsubscripted names?

> and it should be clarified that Xa is the larges tnumber smaller than X
> and Xb the smallest number larger than X.

Good.

> What is "Despite its name, PERCENTRANK returns a fraction between 0 and
> 1 inclusive, rather than a percentage." supposed to mean? A percentage
> is just a number formatted in a certain way.

True. "The eyes of the beholder" ... the suggested text was written from
UI perspective. We can remove that for the file format spec.

  Eike

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

PGP signature