Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
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.
When saving the table:formula attribute, Excel precedes the formula string with the "of" namespace.
When saving the table:formula attribute, Excel saves a formula string that follows [ODF1.2] part 2.
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.
Formulas using the 'of' namespace and those without a namespaces are expected to follow [Oasis ODF 1.2] part 2.
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.
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>