2.1.820 Part 1 Section 19.642, table:formula

  • Article

a.   The standard defines the attribute table:formula, contained within the element <table:covered-table-cell>

This attribute is not supported in Word 2013, Word 2016, or Word 2019.

b.   The standard defines the attribute table:formula, contained within the element <table:table-cell>

This attribute is not supported in Word 2013, Word 2016, or Word 2019.

c.   The standard defines the attribute table:formula, contained within the element <table:covered-table-cell>

This attribute is not supported in Excel 2013, Excel 2016, or Excel 2019.

d.   The standard defines the attribute table:formula, contained within the element <table:table-cell>

This attribute is supported in Excel 2013, Excel 2016, and Excel 2019.

  1. When saving the table:formula attribute, Excel precedes the formula string with the "of" namespace.

  2. When saving the table:formula attribute, Excel saves a formula string that follows [ODF1.2] part 2.

  3. When loading the attribute table:formula, Excel first looks at the namespace.  If the namespace is 'of' , 'msoxl' or not specified, Excel will attempt to load the value of table:formula as a formula in Excel.

  4. Formulas using the 'of' namespace and those without a namespaces are expected to follow [Oasis ODF 1.2] part 2.

  5. Formulas using the 'msoxl' namespace follow  [ISO/IEC-29500-1] section 18.17, except workbook-names are written as literal values instead of tokens given the lack of a relationship part.

  6. When loading the table:formula attribute, if the namespace is unknown, the table:formula attribute is not loaded, and the value "office:value" is used instead. If the result of the formula is an error, Excel loads the <text:p> element and maps the element to an Error data type. Error data types that Excel does not support are mapped to #VALUE!

e.   The standard defines the attribute table:formula, contained within the element <table:table-cell>