OpenDocument-formula-20080604.odt Details

Document Details     TC Member Document View
Title OpenDocument Formula Specification 2008-06-04 (ODT)
Name * OpenDocument Formula Specification 2008-06-04 (ODT) (964K)
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 David Wheeler
Date Submitted Wednesday, 04 June 2008 06:07pm
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
This doc
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
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
Minor tweaks:
* Made it MUCH more obvious how to display the unannotated version (by bolding, etc., the instructions on page 2).
* Added to "What OpenFormula doesn't include": 'a special “summarize data” mechanism that presents many different statistical values of a set of data (e.g., average, minimum, first quartile, median, third quartile, maximum, standard deviation, and mode). If desired, applications may implement such a mechanism using a “wizard” to create a set of (labeled) formulas for each of these statistical values, using the formula language defined here. Such summaries can then be exchanged normally.'
* Added to "What OpenFormula doesn't include": 'a mechanism to detect likely errors in formula. However, by defining the format and semantics of formulas, it enables the creation of them.'
* Clarified that Error is NOT the same as string.
David Wheeler
2008-06-04
---