OpenFormula

OpenFormula is an open standard for exchanging recalculated formulae in spreadsheets.wikipedia
28 Related Articles

OpenDocument

ODF.odtODT
OpenFormula is included in version 1.2 of the OpenDocument standard.
OpenDocument 1.2 includes additional accessibility features, RDF-based metadata, a spreadsheet formula specification based on OpenFormula, support for digital signatures and some features suggested by the public. It consists of three parts: Part 1: OpenDocument Schema, Part 2: Recalculated Formula (OpenFormula) Format and Part 3: Packages. Version 1.2 of the specification was approved as an OASIS Standard on 29 September 2011. It was submitted to the relevant ISO committee under the Publicly Available Specification (PAS) procedure in March 2014. As of October 2014, it has been unanimously approved as a Draft International Standard, some comments have been raised in process that need to be addressed before OpenDocument 1.2 can proceed to become an International Standard. OpenDocument 1.2 was published as ISO/IEC standard on 17 June 2015.

Microsoft Office 2007

Office 20072007Fluent
Microsoft Office 2007 SP2 uses the formula language defined in ISO/IEC IS 29500:2008 for OpenDocument spreadsheets.
Microsoft stated that they consider adding support for an official ODF formula language (OpenFormula), once a future version of the ISO/IEC 26300 standard specification includes one.

Open standard

open standardsopenstandard
OpenFormula is an open standard for exchanging recalculated formulae in spreadsheets.

Spreadsheet

spreadsheetscellspreadsheet program
OpenFormula is an open standard for exchanging recalculated formulae in spreadsheets.

David A. Wheeler

David WheelerWheeler
OpenFormula was proposed and initially drafted by David A. Wheeler.

Specification (technical standard)

specificationspecificationstechnical specifications
OpenDocument 1.0 is a specification for the exchange of office documents, and is fully capable of describing mathematical formulas that are displayed on the screen (through its reuse of the MathML standard).

Formula

mathematical formulaformulaeformulas
OpenDocument 1.0 is a specification for the exchange of office documents, and is fully capable of describing mathematical formulas that are displayed on the screen (through its reuse of the MathML standard).

MathML

Math Markup Language (MathML)Mathematical Markup Language
OpenDocument 1.0 is a specification for the exchange of office documents, and is fully capable of describing mathematical formulas that are displayed on the screen (through its reuse of the MathML standard).

Syntax

syntacticsyntacticalsyntactically
However, many believed that the syntax and semantics of table:formula was not defined in sufficient detail.

Semantics

semanticsemanticallymeaning
However, many believed that the syntax and semantics of table:formula was not defined in sufficient detail.

OASIS (organization)

OASISOrganization for the Advancement of Structured Information StandardsOASIS standards body
In February 2006, OASIS formally created the formula subcommittee, naming Wheeler as the subcommittee chair.

Microsoft

Microsoft CorporationMSMicrosoft Corp.
In 2005, Microsoft's Brian Jones noted that OpenDocument did not define spreadsheet formulae in detail.

XML

Extensible Markup LanguageExtensible Markup Language (XML).xml
However, at the time Microsoft's competing proprietary XML format also did not include this kind of detailed specification for formulae.

Office Open XML

DOCX.docxOOXML
The Office Open XML spreadsheet formula language is now part of the international standard ISO/IEC IS 29500:2008.

International standard

standardinternational standardsstandards
The Office Open XML spreadsheet formula language is now part of the international standard ISO/IEC IS 29500:2008.

Bruce Perens

Fully open standard The specification meets all widely accepted definitions of being an "open standard", including those by Bruce Perens and the European Union. For example, (1) both open source software and proprietary software can implement it, and (2) the work is based on consensus, not domination by any single supplier.

European Union

EUEuropeanEurope
Fully open standard The specification meets all widely accepted definitions of being an "open standard", including those by Bruce Perens and the European Union. For example, (1) both open source software and proprietary software can implement it, and (2) the work is based on consensus, not domination by any single supplier.

OpenOffice.org

OpenOfficeOpen OfficeCalc
Developed by many different implementors. OpenFormula is being developed by representatives from many different implementors, working together, including OpenOffice.org and Sun StarOffice (Eike Rathke), KDE Calligra Suite (formerly KOffice) (David Faure and Tomas Mecir), Gnumeric (Dr. Andreas J. Guelzow and Jody Goldberg), IBM/Lotus 1-2-3 (Rob Weir), and wikiCalc (Dan Bricklin, co-creator of the spreadsheet).

StarOffice

StarWriterStarOffice Productivity SuiteStarOffice StarWriter
Developed by many different implementors. OpenFormula is being developed by representatives from many different implementors, working together, including OpenOffice.org and Sun StarOffice (Eike Rathke), KDE Calligra Suite (formerly KOffice) (David Faure and Tomas Mecir), Gnumeric (Dr. Andreas J. Guelzow and Jody Goldberg), IBM/Lotus 1-2-3 (Rob Weir), and wikiCalc (Dan Bricklin, co-creator of the spreadsheet).

Calligra

Calligra Office Suite
Developed by many different implementors. OpenFormula is being developed by representatives from many different implementors, working together, including OpenOffice.org and Sun StarOffice (Eike Rathke), KDE Calligra Suite (formerly KOffice) (David Faure and Tomas Mecir), Gnumeric (Dr. Andreas J. Guelzow and Jody Goldberg), IBM/Lotus 1-2-3 (Rob Weir), and wikiCalc (Dan Bricklin, co-creator of the spreadsheet).

KOffice

KOffice suite
Developed by many different implementors. OpenFormula is being developed by representatives from many different implementors, working together, including OpenOffice.org and Sun StarOffice (Eike Rathke), KDE Calligra Suite (formerly KOffice) (David Faure and Tomas Mecir), Gnumeric (Dr. Andreas J. Guelzow and Jody Goldberg), IBM/Lotus 1-2-3 (Rob Weir), and wikiCalc (Dan Bricklin, co-creator of the spreadsheet).

Gnumeric

Developed by many different implementors. OpenFormula is being developed by representatives from many different implementors, working together, including OpenOffice.org and Sun StarOffice (Eike Rathke), KDE Calligra Suite (formerly KOffice) (David Faure and Tomas Mecir), Gnumeric (Dr. Andreas J. Guelzow and Jody Goldberg), IBM/Lotus 1-2-3 (Rob Weir), and wikiCalc (Dan Bricklin, co-creator of the spreadsheet).

Lotus 1-2-3

1-2-3.123.wk1
Developed by many different implementors. OpenFormula is being developed by representatives from many different implementors, working together, including OpenOffice.org and Sun StarOffice (Eike Rathke), KDE Calligra Suite (formerly KOffice) (David Faure and Tomas Mecir), Gnumeric (Dr. Andreas J. Guelzow and Jody Goldberg), IBM/Lotus 1-2-3 (Rob Weir), and wikiCalc (Dan Bricklin, co-creator of the spreadsheet).

WikiCalc

Developed by many different implementors. OpenFormula is being developed by representatives from many different implementors, working together, including OpenOffice.org and Sun StarOffice (Eike Rathke), KDE Calligra Suite (formerly KOffice) (David Faure and Tomas Mecir), Gnumeric (Dr. Andreas J. Guelzow and Jody Goldberg), IBM/Lotus 1-2-3 (Rob Weir), and wikiCalc (Dan Bricklin, co-creator of the spreadsheet).

Dan Bricklin

Daniel Bricklin
Developed by many different implementors. OpenFormula is being developed by representatives from many different implementors, working together, including OpenOffice.org and Sun StarOffice (Eike Rathke), KDE Calligra Suite (formerly KOffice) (David Faure and Tomas Mecir), Gnumeric (Dr. Andreas J. Guelzow and Jody Goldberg), IBM/Lotus 1-2-3 (Rob Weir), and wikiCalc (Dan Bricklin, co-creator of the spreadsheet).