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

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 |  

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