OpenDocument-formula-20080516.odt Details

Document Details     TC Member Document View
Title OpenDocument Formula Specification 2008-05-16 (ODT)
Name * OpenDocument Formula Specification 2008-05-16 (ODT) (967K)
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 Friday, 16 May 2008 04:51pm
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
This doc
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
* Added annotation from Michael Brauer's email of 2008-05-16, noting other specifications that use namespace prefixes inside attribute values. This should help eliminate the confusion that this approach was somehow unique.
* Modified the introduction to clarify some key differences in the formula specification, compared to some other specifications, explaining why this one is needed.
* Eliminated a TODO in PROPER, by clarifying in the specification what the "beginning" of a word was. Tweaked PROPER, UPPER, and LOWER, to clarify that all will guarantee that A-Z is uppercase and a-z is lowercase, no matter what the locale, but for some characters, it depends on the locale. Sorry, that's the way Unicode/ISO 10646 (and life) really are.
David Wheeler
2008-05-16
---