Groups - OpenDocument Formula Specification 2008-10-10 (ODT) (OpenDocument-formula-20081010.odt) uploaded

[erack@sun.com]

EUROCONVERT: triangulation precision is also used for
conversion to EUR.

3.2 Non-Scalar Evaluation (aka 'Array expressions')
Added 2.2.3.4) for the evaluation of one argument 1 row
height and one argument 1 column width.
Corrected example in 1.2) B4 -> D4

BETADIST: added constraints about pole values of certain
argument combinations.

NPV: order of evaluation matters.

HYPERLINK: second argument can be number in which case
number is returned.

ADDRESS: for R1C1 (A1=FALSE()) use '!' exclamation mark as
sheet name separator.

INDIRECT: for R1C1 (A1=FALSE()) use '!' exclamation mark as
sheet name separator. Added note that applications should be
able to parse both, '.' and '!'.

UNICODE: swapped UNICHAR(UNICODE(N))

LARGE, SMALL: added rounding contraints; array cases return
arrays

RATE: examples


 -- Mr. Eike Rathke

The document revision named OpenDocument Formula Specification 2008-10-10
(ODT) (OpenDocument-formula-20081010.odt) has been submitted by Mr. Eike
Rathke to the OpenDocument - Formula document repository.  This document is
revision #70 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=29629

Download Document:  
http://www.oasis-open.org/committees/download.php/29629/OpenDocument-formula-20081010.odt

Revision:
This document is revision #70 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