Groups - OpenFormula Specification 2007-02-14 (ODT) (openformula-20070214.odt) uploaded

[david.wheeler@OpenDocument.us]

Eike Rathke added the QuotedLabel and their intersection definitions, and
since a single QuotedLabel may appear in a formula added that to the syntax
as well. He did a lot of formatting on elements, attributes, values, and
did various other small corrections.

Attached is this week's update. I included FREQUENCY and GROWTH, but not
CONVERT, which was in the document sent with GROWTH.

Robert Weir defined NETWORKDAYS and WORKDAY; he took the approach of
passing in an array of Logical's to specify the work week: "This seemed
more natural than the bitmask. I think it would be very natural for a
spreadsheet user to have a range of 7 cells, each with a drop down,
true/false value and have that range be input to these functions."

Thomas Metcalf created the GROWTH function.

I added a test case to STDEV, created by Andreas J. Guelzow.

This has an update to CONVERT by David A. Wheeler, adding cwt and uk_cwt.

There are probably other changes I've forgotten to mention.



 -- Mr. David Wheeler

The document revision named OpenFormula Specification 2007-02-14 (ODT)
(openformula-20070214.odt) has been submitted by Mr. David Wheeler to the
OpenDocument - Formula document repository.  This document is revision #43
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=22461

Download Document:  
http://www.oasis-open.org/apps/org/workgroup/office-formula/download.php/22461/openformula-20070214.odt

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