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