Re: [office-formula] Groups - OpenDocument Formula Specification 2008-06-01(ODT) (OpenDocument-formula-20080601.odt) uploaded

[Ming Fei Jia <jiamingf@cn.ibm.com>]

David,

YEARFRAC issue is a special case that Excel actually does and not what OOXML says. And I believe there should be some other similar cases. Could OpenFormula SC summarize this kind of issues together as a common issue? So that this can be for some useful purposes, e.g. submit defects to OOXML, or demonstrate that OpenFormula is doing right things than OOXML,etc. Of course, this depends on the effort evaluation since as we know 1 YEARFRAC has already cost big effort:)

Sincerely,
_________________________________________________________
Mingfei Jia
Symphony Common Apps and Performance | jiamingf@cn.ibm.com
IBM Corporation | Lotus Software
8610-8245-2493 (phone) | 915-2493 (tie-line)


IBM Lotus Symphony


[office-formula] Groups - OpenDocument Formula Specification 2008-06-01 (ODT) (OpenDocument-formula-20080601.odt) uploaded

[office-formula] Groups - OpenDocument Formula Specification 2008-06-01 (ODT) (OpenDocument-formula-20080601.odt) uploaded

dwheeler

to:

office-formula

06/03/2008 02:59 AM

---

This version:
* Resolves the Basis/YEARFRAC issue by defining it to be the same as what
Excel _actually_ does, and NOT what OOXML says.  It includes an option to
support OOXML's basis values, by adding 32.
* It defines column-naming (A...Z, AA..ZZ, etc.).  See the text for the
details.
* It clarifies what references to an empty cell mean; see section 4
(Types).
* Various other cleanups.


 -- David Wheeler

The document revision named OpenDocument Formula Specification 2008-06-01
(ODT) (OpenDocument-formula-20080601.odt) has been submitted by David
Wheeler to the OpenDocument - Formula document repository.  This document
is revision #64 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=28463

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

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