Formulas

To manage formulas, PRD implements the open standard OpenFormula. According to OpenFormula's specifications:

"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."

Note

For more information on OpenFormula, refer to the following links:

• Wikipedia: http://en.wikipedia.org/wiki/OpenFormula

• Specifications: https://www.oasis-open.org/committees/download.php/16826/openformula-spec-20060221.html

• Web: http://www.openformula.org/

• Pentaho wiki: http://wiki.pentaho.com/display/Reporting/Formula+Expressions

Formulas are used for greatly varied purposes, and their use depends on the result...