Groups - OpenDocument Formula Specification 2007-12-28 (ODT) (OpenDocument-formula-20071228.odt) uploaded

[erack@sun.com]

- Added details of how reference infix operators range ':',
  union '~' and intersection '!' actually work.

- Swapped sections "Infix Operator Reference Range" and
  "Infix Operator &" so that the three reference operators
  are consecutive in order. 

- Some functions' assignment to Medium Group and Large Group
  reworked as discussed on the mailing list.

- Cleanup of functions listed in Huge Group, removed the
  underlying hyperlinks file:///index.php?... that were
  carried over from early wiki days.

- Clarified on which OpenOffice.org ..._ADD functions will
  be substituted with / renamed to functions from the
  specification.

- Added Maltese Lira (MTL) and Cypriot Pound (CYP) to
  EUROCONVERT() as these have fixed conversion rates now and
  the Euro will be introduced in Malta and Cyprus on
  2008-01-01.

- Added to RAND() that return value is 0 inclusive and
  1 exclusive, adjusted test cases.

- Fixed some wrong function names in syntax definitions:
  - NUMBERVALUE (was VALUE)
  - BASE (was DECIMAL)


 -- Mr. Eike Rathke

The document revision named OpenDocument Formula Specification 2007-12-28
(ODT) (OpenDocument-formula-20071228.odt) has been submitted by Mr. Eike
Rathke to the OpenDocument - Formula document repository.  This document is
revision #60 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/apps/org/workgroup/office-formula/document.php?document_id=26688

Download Document:  
http://www.oasis-open.org/apps/org/workgroup/office-formula/download.php/26688/OpenDocument-formula-20071228.odt

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