# OpenFormula

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

27 Related Articles

### OpenDocument

**ODFOpen Document Format.odt**

OpenFormula is included in version 1.2 of the OpenDocument standard.

### Microsoft Office 2007

**Office 2007Microsoft Word 20072007**

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 standardsopenopen protocol**

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.

### 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

**formulaeformulasmathematical formulae**

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

**MathPlayerMathematical Markup LanguageMath Markup Language (MathML)**

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 CorporationMicrosoft Corp.MS**

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

### XML

**Extensible Markup LanguageXML documentXML parser**

However, at the time Microsoft's competing proprietary XML format also did not include this kind of detailed specification for formulae.

### Office Open XML

**OOXMLDOCX.docx**

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

### International standard

**international standardsstandardstandards**

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

### OpenOffice.org

**OpenOfficeOpenOffice.org WriterOpenOffice.org Calc**

### StarOffice

**StarWriterStarMathStarOffice 3.1**

### Dan Bricklin

**Daniel S. BricklinDaniel Bricklin**

### Astrophysics

**astrophysicistastrophysicaltheoretical astrophysics**