2.1.209 Section 8.1.3, Table Cell

a.   The standard defines the element <table:covered-table-cell>

This element is supported in Word 2010, Word 2013, Word 2016, and Word 2019.

b.   The standard defines the attribute office:boolean-value, contained within the element <table:covered-table-cell>

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

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

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

d.   The standard defines the attribute office:date-value, contained within the element <table:covered-table-cell>

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

e.   The standard defines the attribute office:string-value, contained within the element <table:covered-table-cell>

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

f.   The standard defines the attribute office:time-value, contained within the element <table:covered-table-cell>

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

g.   The standard defines the attribute office:value, contained within the element <table:covered-table-cell>

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

h.   The standard defines the attribute table:content-validation-name, contained within the element <table:covered-table-cell>

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

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

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

j.   The standard defines the attribute table:number-columns-repeated, contained within the element <table:covered-table-cell>

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

k.   The standard defines the attribute table:number-matrix-columns-spanned, contained within the element <table:covered-table-cell>

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

l.   The standard defines the attribute table:number-matrix-rows-spanned, contained within the element <table:covered-table-cell>

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

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

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

n.   The standard defines the attribute table:style-name, contained within the element <table:covered-table-cell>

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

o.   The standard defines the attribute table:value-type, contained within the element <table:covered-table-cell>

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

p.   The standard defines the element <table:table-cell>

This element is supported in Word 2010, Word 2013, Word 2016, and Word 2019.

q.   The standard defines the attribute office:boolean-value, contained within the element <table:table-cell>

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

r.   The standard defines the attribute office:currency, contained within the element <table:table-cell>

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

s.   The standard defines the attribute office:date-value, contained within the element <table:table-cell>

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

t.   The standard defines the attribute office:string-value, contained within the element <table:table-cell>

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

u.   The standard defines the attribute office:time-value, contained within the element <table:table-cell>

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

v.   The standard defines the attribute office:value, contained within the element <table:table-cell>

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

w.   The standard defines the attribute table:content-validation-name, contained within the element <table:table-cell>

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

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

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

y.   The standard defines the attribute table:number-columns-repeated, contained within the element <table:table-cell>

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

z.   The standard defines the attribute table:number-columns-spanned, contained within the element <table:table-cell>

This attribute is supported in Word 2010, Word 2013, Word 2016, and Word 2019.

aa.  The standard defines the attribute table:number-matrix-columns-spanned, contained within the element <table:table-cell>

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

bb.  The standard defines the attribute table:number-matrix-rows-spanned, contained within the element <table:table-cell>

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

cc.  The standard defines the attribute table:number-rows-spanned, contained within the element <table:table-cell>

This attribute is supported in Word 2010, Word 2013, Word 2016, and Word 2019.

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

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

ee.  The standard defines the attribute table:style-name, contained within the element <table:table-cell>

This attribute is supported in Word 2010, Word 2013, Word 2016, and Word 2019.

Word does not support the use of common styles from the table-cell family, that is using a table style defined under the <office:styles> element.

ff.  The standard defines the attribute table:value-type, contained within the element <table:table-cell>

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

gg.  The standard defines the element <office:annotation>, contained within the parent element <office:spreadsheet \ table:table-cell>

This element is supported in Excel 2010, Excel 2013, Excel 2016, and Excel 2019.

hh.  The standard defines the element <office:annotation>, contained within the parent element <table:dde-link \ table:table-cell>

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

ii.  The standard defines the attribute style:cell-protect, contained within the element <style:table-cell-properties>, contained within the parent element <table:dde-link \ table:table-cell>

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

jj.  The standard defines the attribute style:cell-protect, contained within the element <style:table-cell-properties>, contained within the parent element <table:table>

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

kk.  The standard defines the element <table:cell-range-source>, contained within the parent element <office:spreadsheet \ table:table-cell>

This element is supported in Excel 2010, Excel 2013, Excel 2016, and Excel 2019.

ll.  The standard defines the element <table:cell-range-source>, contained within the parent element <table:dde-link \ table:table-cell>

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

mm.  The standard defines the element <table:covered-table-cell>, contained within the parent element <chart:chart \..\ table-covered-table-cell>

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

nn.  The standard defines the element <table:covered-table-cell>, contained within the parent element <office:spreadsheet \ table:table-row>

This element is supported in Excel 2010, Excel 2013, Excel 2016, and Excel 2019.

oo.  The standard defines the element <table:covered-table-cell>, contained within the parent element <table:dde-link \ table:table-row>

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

pp.  The standard defines the attribute table:content-validation-name, contained within the element <table:covered-table-cell>, contained within the parent element <office:spreadsheet \ table:table-row>

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

qq.  The standard defines the attribute table:formula, contained within the element <table:covered-table-cell>, contained within the parent element <office:spreadsheet \ table:table-row>

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

rr.  The standard defines the attribute table:number-columns-repeated, contained within the element <table:covered-table-cell>, contained within the parent element <office:spreadsheet \ table:table-row>

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

ss.  The standard defines the attribute table:number-columns-spanned, contained within the element <table:covered-table-cell>, contained within the parent element <office:spreadsheet \ table:table-row>

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

tt.  The standard defines the attribute table:number-matrix-columns-spanned, contained within the element <table:covered-table-cell>, contained within the parent element <office:spreadsheet \ table:table-row>

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

uu.  The standard defines the attribute table:number-matrix-rows-spanned, contained within the element <table:covered-table-cell>, contained within the parent element <office:spreadsheet \ table:table-row>

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

vv.  The standard defines the attribute table:number-rows-spanned, contained within the element <table:covered-table-cell>, contained within the parent element <office:spreadsheet \ table:table-row>

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

ww.  The standard defines the attribute table:style-name, contained within the element <table:covered-table-cell>, contained within the parent element <office:spreadsheet \ table:table-row>

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

xx.  The standard defines the attribute table:value-type, contained within the element <table:covered-table-cell>, contained within the parent element <office:spreadsheet \ table:table-row>

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

yy.  The standard defines the element <table:detective>, contained within the parent element <office:spreadsheet \ table:table-cell>

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

zz.  The standard defines the element <table:detective>, contained within the parent element <table:dde-link \ table:table-cell>

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

aaa. The standard defines the element <table:table-cell>, contained within the parent element <chart:chart \..\ table-table-cell>

This element is supported in Excel 2010, Excel 2013, Excel 2016, and Excel 2019.

bbb. The standard defines the element <table:table-cell>, contained within the parent element <office:spreadsheet \ table:table-row>

This element is supported in Excel 2010, Excel 2013, Excel 2016, and Excel 2019.

ccc. The standard defines the element <table:table-cell>, contained within the parent element <table:dde-link \ table:table-row>

This element is supported in Excel 2010, Excel 2013, Excel 2016, and Excel 2019.

ddd. The standard defines the attribute table:content-validation-name, contained within the element <table:table-cell>, contained within the parent element <office:spreadsheet \ table:table-row>

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

eee. The standard defines the attribute table:content-validation-name, contained within the element <table:table-cell>, contained within the parent element <table:dde-link \ table:table-row>

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

fff. The standard defines the attribute table:formula, contained within the element <table:table-cell>, contained within the parent element <office:spreadsheet \ table:table-row>

This attribute is supported in Excel 2010, 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 [ODF1.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!

ggg. The standard defines the attribute table:formula, contained within the element <table:table-cell>, contained within the parent element <table:dde-link \ table:table-row>

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

hhh. The standard defines the attribute table:number-columns-repeated, contained within the element <table:table-cell>, contained within the parent element <office:spreadsheet \ table:table-row>

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

iii. The standard defines the attribute table:number-columns-repeated, contained within the element <table:table-cell>, contained within the parent element <table:dde-link \ table:table-row>

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

jjj. The standard defines the attribute table:number-columns-spanned, contained within the element <table:table-cell>, contained within the parent element <office:spreadsheet \ table:table-row>

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

kkk. The standard defines the attribute table:number-columns-spanned, contained within the element <table:table-cell>, contained within the parent element <table:dde-link \ table:table-row>

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

lll. The standard defines the attribute table:number-matrix-columns-spanned, contained within the element <table:table-cell>, contained within the parent element <office:spreadsheet \ table:table-row>

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

mmm. The standard defines the attribute table:number-matrix-columns-spanned, contained within the element <table:table-cell>, contained within the parent element <table:dde-link \ table:table-row>

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

nnn. The standard defines the attribute table:number-matrix-rows-spanned, contained within the element <table:table-cell>, contained within the parent element <office:spreadsheet \ table:table-row>

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

ooo. The standard defines the attribute table:number-matrix-rows-spanned, contained within the element <table:table-cell>, contained within the parent element <table:dde-link \ table:table-row>

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

ppp. The standard defines the attribute table:number-rows-spanned, contained within the element <table:table-cell>, contained within the parent element <office:spreadsheet \ table:table-row>

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

qqq. The standard defines the attribute table:number-rows-spanned, contained within the element <table:table-cell>, contained within the parent element <table:dde-link \ table:table-row>

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

rrr. The standard defines the attribute table:style-name, contained within the element <table:table-cell>, contained within the parent element <office:spreadsheet \ table:table-row>

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

sss. The standard defines the attribute table:style-name, contained within the element <table:table-cell>, contained within the parent element <table:dde-link \ table:table-row>

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

ttt. The standard defines the attribute table:value, contained within the element <table:table-cell>, contained within the parent element <table:dde-link \ table:table-row>

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

uuu. The standard defines the attribute table:value-type, contained within the element <table:table-cell>, contained within the parent element <office:spreadsheet \ table:table-row>

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

vvv. The standard defines the attribute table:value-type, contained within the element <table:table-cell>, contained within the parent element <table:dde-link \ table:table-row>

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