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

*Subject*: **Groups - OpenDocument Formula Specification 2008-12-21 (ODT) (OpenDocument-formula-20081221.odt) uploaded**

*From*:**erack@sun.com***To*: office-formula@lists.oasis-open.org*Date*: 21 Dec 2008 22:57:55 -0000

- BETADIST() - Density missed the factor 1/(b-a). - Substitution z=(t-a)/(b-a) in formula. - Adapted test cases. - GAMMA() domain contains negative values. - GAMMADIST() and GAMMAINV() OOo, Excel, and Gnumeric use the third parameter 'beta' in the way, that mean=alpha*beta, but ODFF draft spec used the third parameter 'lambda' in the way that mean=alpha/lambda. Changed. - SUMIFS() - Added that, similar to COUNTIFS() and AVERAGEIFS(). - Put all 3 in group Large. - EUROCONVERT() - Currencies are ignore-case. - If FROM and TO are equal, the value is returned, no precision or triangulation applied. - DAYS360() algorithm. David King's (many thanks!) remarks on the TC's comments list: - DATE() day and month may roll over. - EOMONTH() parameter MonthAdd is Integer. - LEN() Number is converted to Text. - Cross references for LEFT, LEN, MID, RIGHT. - PERMUT() formula corrected. - PERMUTATIONA() formula added. - GROWTH() changed misleading allowOffset to allowConstant. - HARMEAN() clarified meaning of N as sequence. - INDEX() clarified some wording. - STDEVA() calculates (not estimates) the standard deviation. - RANK() typo in Order (descending vs. ascending), Value must exist in Data. - SHEETS() typo, clarified test case description and added test case for multiple sheets in reference. - 3.2 Non-Scalar evaluation: changed 1.2) and 1.3) to 1.2)References 1.2.1)row-vector 1.2.2)column-vector - 3.2 Non-Scalar evaluation: corrected return value of 2.2.3.5), #N/A => #VALUE! - B() added "inclusive" to between S and S2. - NEGBINOMDIST() - Changed parameter names to common names x,r,p. - Corrected test case result. - GAUSS() use NORMDIST instead of NORMSDIST, which would had been LEGACY.NORMSDIST. - LEGACY.NORMSDIST() is NORMDIST(x;0;1;TRUE()) instead of NORMDIST(x). - LOGNORMDIST() made syntax read LOGNORMDIST instead of NORMDIST. - POISSON() x is Integer. - FORECAST() corrected order of parameters data_y,data_x. - MATCH() explicitly return #N/A error if no value was found. - Spelling, replaced Macauley with Macaulay. - PERCENTRANK() much better semantic description. - CONVERT() clarified on unit prefix, (km)^2 vs. k(m^2). -- Mr. Eike Rathke The document revision named OpenDocument Formula Specification 2008-12-21 (ODT) (OpenDocument-formula-20081221.odt) has been submitted by Mr. Eike Rathke to the OpenDocument - Formula document repository. This document is revision #71 of openformula-spec-20060221.odt. Document Description: OpenFormula is an open format for exchanging recalculated formulas between office application implementations, particularly for spreadsheets. OpenFormula defines the types, syntax, and semantics for calculated formulas, including many predefined functions and operations, so that formulas can be exchanged between applications and produce substantively equal outputs when recalculated with equal inputs. Both closed and open source software can implement OpenFormula. OpenFormula is intended to be a supporting document to the Open Document Format for Office Applications (OpenDocument) format, particularly for defining its attributes table:formula and text:formula. It can be used in other circumstances where a simple, easy-to-read infix notation is desired for exchanging recalculated formulas. View Document Details: http://www.oasis-open.org/committees/document.php?document_id=30459 Download Document: http://www.oasis-open.org/committees/download.php/30459/OpenDocument-formula-20081221.odt Revision: This document is revision #71 of openformula-spec-20060221.odt. The document details page referenced above will show the complete revision history. PLEASE NOTE: If the above links do not work for you, your email application may be breaking the link into two pieces. You may be able to copy and paste the entire link address into the address field of your web browser. -OASIS Open Administration

**Follow-Ups**:**Re: [office-formula] Groups - OpenDocument Formula Specification2008-12-21 (ODT) (OpenDocument-formula-20081221.odt) uploaded***From:*Andreas J Guelzow <aguelzow@math.concordia.ab.ca>

**Re: [office-formula] Groups - OpenDocument Formula Specification2008-12-21 (ODT) (OpenDocument-formula-20081221.odt) uploaded***From:*Andreas J Guelzow <aguelzow@math.concordia.ab.ca>

**Re: [office-formula] Groups - OpenDocument Formula Specification2008-12-21 (ODT) (OpenDocument-formula-20081221.odt) uploaded***From:*Andreas J Guelzow <aguelzow@math.concordia.ab.ca>

*From:*Andreas J Guelzow <aguelzow@math.concordia.ab.ca>

*From:*Andreas J Guelzow <aguelzow@math.concordia.ab.ca>

*From:*Andreas J Guelzow <aguelzow@math.concordia.ab.ca>

**Re: [office-formula] changes***From:*Andreas J Guelzow <aguelzow@math.concordia.ab.ca>

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