openformula-20060719c.odt Details

Document Details     TC Member Document View
Title OpenFormula Specification 2006-07-19 (ODT)
Name * OpenFormula Specification 2006-07-19 (ODT) (214K)
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.
Group OpenDocument - Formula SC
Folder Standards
Submitter Mr. David Wheeler
Date Submitted Wednesday, 19 July 2006 06:52pm
Document State Draft (A preliminary unapproved sketch, outline, or version.)
Access This document is visible to OpenDocument - Formula SC and shared with:
  • OASIS Open (General Membership)
  • General Public
  • OASIS Open Document Format for Office Applications (OpenDocument) TC

Document Revisions
Name # State Submitter Date Action
98
Draft
Michael Brauer
2010-07-26
97
Draft
Michael Brauer
2010-05-31
96
Draft
Michael Brauer
2010-05-27
95
Draft
Michael Brauer
2010-05-12
94
Draft
Mr. Eike Rathke
2010-05-11
93
Draft
Mr. Eike Rathke
2010-05-11
92
Draft
Mr. Eike Rathke
2010-05-06
91
Draft
Patrick Durusau
2010-05-06
90
Draft
Patrick Durusau
2010-05-03
89
Draft
Mr. Eike Rathke
2010-04-29
88
Draft
Mr. Eike Rathke
2010-04-29
87
Draft
Mr. Michael Brauer
2010-04-15
86
Draft
Mr. Eike Rathke
2010-04-15
85
Draft
Patrick Durusau
2010-04-11
84
Draft
Mr. Eike Rathke
2010-03-18
83
Draft
Patrick Durusau
2010-03-15
82
Draft
Patrick Durusau
2010-02-18
81
Draft
Mr. Eike Rathke
2010-02-16
80
Draft
Mr. Eike Rathke
2010-02-12
79
Draft
Patrick Durusau
2010-02-08
78
Draft
Mr. Eike Rathke
2010-02-03
77
Draft
Mr. Eike Rathke
2010-01-20
76
Draft
Mr. Eike Rathke
2009-12-22
75
Draft
Mr. Eike Rathke
2009-12-04
74
Draft
Mr. Eike Rathke
2009-10-26
73
Draft
David Wheeler
2009-05-08
72
Draft
Mr. Eike Rathke
2009-05-01
71
Draft
Mr. Eike Rathke
2008-12-21
70
Draft
Mr. Eike Rathke
2008-10-10
69
Draft
Mr. Eike Rathke
2008-06-18
68
Draft
David Wheeler
2008-06-14
67
Draft
David Wheeler
2008-06-13
66
Draft
David Wheeler
2008-06-04
65
Draft
David Wheeler
2008-06-03
64
Draft
David Wheeler
2008-06-02
63
Draft
David Wheeler
2008-05-16
62
Draft
David Wheeler
2008-05-15
61
Draft
Mr. Eike Rathke
2008-05-09
60
Draft
Mr. Eike Rathke
2007-12-28
59
Draft
David Wheeler
2007-11-25
58
Draft
Mr. Eike Rathke
2007-07-20
57
Draft
Mr. David Wheeler
2007-06-20
56
Draft
Mr. David Wheeler
2007-06-19
55
Draft
Mr. Eike Rathke
2007-06-19
54
Draft
Mr. David Wheeler
2007-06-18
53
Draft
Mr. David Wheeler
2007-06-07
52
Draft
Mr. Eike Rathke
2007-04-13
51
Draft
Mr. Eike Rathke
2007-04-13
50
Draft
Mr. Eike Rathke
2007-03-29
49
Draft
Mr. David Wheeler
2007-03-23
48
Draft
Mr. David Wheeler
2007-03-22
47
Draft
Mr. David Wheeler
2007-03-17
46
Draft
Mr. David Wheeler
2007-03-09
45
Draft
Mr. David Wheeler
2007-03-02
44
Draft
Mr. David Wheeler
2007-02-22
43
Draft
Mr. David Wheeler
2007-02-14
42
Draft
Mr. David Wheeler
2007-02-13
41
Draft
Mr. David Wheeler
2007-02-09
40
Draft
Mr. David Wheeler
2007-02-08
39
Draft
Mr. David Wheeler
2007-02-01
38
Draft
Mr. David Wheeler
2007-02-01
37
Draft
Mr. David Wheeler
2007-01-25
36
Draft
Mr. David Wheeler
2007-01-21
35
Draft
Mr. David Wheeler
2007-01-17
34
Draft
Mr. David Wheeler
2006-12-22
33
Draft
Mr. David Wheeler
2006-12-20
32
Draft
Mr. David Wheeler
2006-12-08
31
Draft
Mr. David Wheeler
2006-11-29
30
Draft
Mr. David Wheeler
2006-11-22
29
Draft
Mr. David Wheeler
2006-11-01
28
Draft
Mr. David Wheeler
2006-10-25
27
Draft
Mr. David Wheeler
2006-10-18
26
Draft
Mr. David Wheeler
2006-10-11
25
Draft
Mr. David Wheeler
2006-09-29
24
Draft
Mr. David Wheeler
2006-09-23
23
Draft
Mr. David Wheeler
2006-09-20
22
Draft
Mr. David Wheeler
2006-09-14
21
Draft
Mr. David Wheeler
2006-09-13
20
Draft
Mr. David Wheeler
2006-09-10
19
Draft
Mr. David Wheeler
2006-09-06
18
Draft
Mr. David Wheeler
2006-08-30
17
Draft
Mr. David Wheeler
2006-08-23
16
Draft
Mr. David Wheeler
2006-08-16
15
Draft
Mr. David Wheeler
2006-08-16
14
Draft
Mr. David Wheeler
2006-08-13
13
Draft
Mr. David Wheeler
2006-08-11
12
Draft
Mr. David Wheeler
2006-08-09
11
Draft
Mr. David Wheeler
2006-08-04
10
Draft
Mr. David Wheeler
2006-08-02
9
Draft
Mr. David Wheeler
2006-07-31
8
Draft
Mr. David Wheeler
2006-07-24
7
Draft
Mr. David Wheeler
2006-07-20
6
Draft
Mr. David Wheeler
2006-07-19
This doc
5
Draft
Mr. David Wheeler
2006-07-18
4
Draft
Mr. David Wheeler
2006-07-16
3
Draft
Mr. David Wheeler
2006-07-14
2
Draft
Mr. David Wheeler
2006-07-13
1
Draft
Mr. David Wheeler
2006-07-11
0
Draft
Mr. David Wheeler
2006-02-21

Comments  
Subject & Text Submitter Date Action
Initial comment by submitter
Changed "Test Case" text to be more rigorous and clear, and added a few notational capabilities so that the test cases can be clearer. In particular, there's now support for the +/- symbol and epsilon for Numbers; True and False are used not TRUE and FALSE; "=" functions are now documented. In function syntax, defined and began using "=default" format. Continued move to general "group"s; documented GAMMA and ROMAN function (ROMAN has some oddities with Logical that needed a careful touch). Changed "^" so that it is not "split" between levels. Reformatted test cases so that they are clear AND are good examples for functions to follow. DATEVALUE _must_ accept ISO-formatted dates (it's no longer optional). For some financial functions, the error range was reduced. Created "Array Capabilities" chapter.
Mr. David Wheeler
2006-07-19
---