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 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.


> 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.


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]