officeformula message
[Date Prev]
 [Thread Prev]
 [Thread Next]
 [Date Next]

[Date Index]
 [Thread Index]
 [List Home]
Subject: Re: [officeformula] Groups  OpenDocument Formula Specification 20080601(ODT) (OpenDocumentformula20080601.odt) uploaded
 From: Ming Fei Jia <jiamingf@cn.ibm.com>
 To: dwheeler@dwheeler.com
 Date: Wed, 4 Jun 2008 18:49:58 +0800
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
861082452493 (phone)  9152493 (tieline)
IBM Lotus Symphony
[officeformula] Groups  OpenDocument Formula Specification 20080601 (ODT) (OpenDocumentformula20080601.odt) uploaded

[officeformula] Groups  OpenDocument Formula Specification 20080601 (ODT) (OpenDocumentformula20080601.odt) uploaded 

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 columnnaming (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 20080601
(ODT) (OpenDocumentformula20080601.odt) has been submitted by David
Wheeler to the OpenDocument  Formula document repository. This document
is revision #64 of openformulaspec20060221.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, easytoread infix notation is desired
for exchanging recalculated formulas.
View Document Details:
http://www.oasisopen.org/apps/org/workgroup/officeformula/document.php?document_id=28463
Download Document:
http://www.oasisopen.org/apps/org/workgroup/officeformula/download.php/28463/OpenDocumentformula20080601.odt
Revision:
This document is revision #64 of openformulaspec20060221.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]