OASIS Mailing List ArchivesView the OASIS mailing list archive below
or browse/search using MarkMail.

 


Help: OASIS Mailing Lists Help | MarkMail Help

office-formula message

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


Subject: Groups - OpenFormula Specification 2007-03-22-wheeler (ODT) (openformula-20070322-wheeler.odt) uploaded


Okay folks - to make ideas more concrete, I've posted another modified
version of the document.  Consider this a "non-official" version, feel free
to continue working off the March 22 release.  This one includes proposed
modifications for VALUE, NUMBERVALUE, FLOOR, CEILING, with change tracking
ON so you can see it.

FLOOR and CEILING haven't changed in their SEMANTICS from previous
releases, but it warns users that this is NOT the same as some
implementations (such as Excel! We can do the Excel semantics - and much
more - but it looks a little different).

VALUE is now clearly locale-dependent, and there are specific requirements
for locale en_US (so that we can test it!).  I've also added NUMBERVALUE,
which takes two parameters (the text to convert, and the character to use
as the decimal point)... that won't handle ALL locales, but it'll handle a
whole lot without needing to deal with "all possible locales".

Hopefully, this will deal with some issues we've recently discussed in a
sane way!



 -- Mr. David Wheeler

The document revision named OpenFormula Specification 2007-03-22-wheeler
(ODT) (openformula-20070322-wheeler.odt) has been submitted by Mr. David
Wheeler to the OpenDocument - Formula document repository.  This document
is revision #49 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=23142

Download Document:  
http://www.oasis-open.org/apps/org/workgroup/office-formula/download.php/23142/openformula-20070322-wheeler.odt

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


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