2.1.255 Section 8.8.4, Data Pilot Field

  • Article

a.   The standard defines the element <table:data-pilot-field>, contained within the parent element <table:data-pilot-table>

This element is supported in core Excel 2007.

b.   The standard defines the attribute table:function, contained within the element <table:data-pilot-field>, contained within the parent element <table:data-pilot-table>

This attribute is supported in core Excel 2007.

c.   The standard defines the property "<any string>", contained within the attribute table:function, contained within the element <table:data-pilot-field>, contained within the parent element <table:data-pilot-table>

This property is not supported in core Excel 2007.

On load, string values that don't match the explicitly listed enumerated values are converted to "auto".

d.   The standard defines the property "auto", contained within the attribute table:function, contained within the element <table:data-pilot-field>, contained within the parent element <table:data-pilot-table>

This property is supported in core Excel 2007.

e.   The standard defines the property "average", contained within the attribute table:function, contained within the element <table:data-pilot-field>, contained within the parent element <table:data-pilot-table>

This property is supported in core Excel 2007.

f.   The standard defines the property "count", contained within the attribute table:function, contained within the element <table:data-pilot-field>, contained within the parent element <table:data-pilot-table>

This property is supported in core Excel 2007.

g.   The standard defines the property "countnums", contained within the attribute table:function, contained within the element <table:data-pilot-field>, contained within the parent element <table:data-pilot-table>

This property is supported in core Excel 2007.

h.   The standard defines the property "max", contained within the attribute table:function, contained within the element <table:data-pilot-field>, contained within the parent element <table:data-pilot-table>

This property is supported in core Excel 2007.

i.   The standard defines the property "min", contained within the attribute table:function, contained within the element <table:data-pilot-field>, contained within the parent element <table:data-pilot-table>

This property is supported in core Excel 2007.

j.   The standard defines the property "product", contained within the attribute table:function, contained within the element <table:data-pilot-field>, contained within the parent element <table:data-pilot-table>

This property is supported in core Excel 2007.

k.   The standard defines the property "stdev", contained within the attribute table:function, contained within the element <table:data-pilot-field>, contained within the parent element <table:data-pilot-table>

This property is supported in core Excel 2007.

l.   The standard defines the property "stdevp", contained within the attribute table:function, contained within the element <table:data-pilot-field>, contained within the parent element <table:data-pilot-table>

This property is supported in core Excel 2007.

m.   The standard defines the property "sum", contained within the attribute table:function, contained within the element <table:data-pilot-field>, contained within the parent element <table:data-pilot-table>

This property is supported in core Excel 2007.

n.   The standard defines the property "var", contained within the attribute table:function, contained within the element <table:data-pilot-field>, contained within the parent element <table:data-pilot-table>

This property is supported in core Excel 2007.

o.   The standard defines the property "varp", contained within the attribute table:function, contained within the element <table:data-pilot-field>, contained within the parent element <table:data-pilot-table>

This property is supported in core Excel 2007.

p.   The standard defines the attribute table:is-data-layout-field, contained within the element <table:data-pilot-field>, contained within the parent element <table:data-pilot-table>

This attribute is supported in core Excel 2007.

q.   The standard defines the attribute table:orientation, contained within the element <table:data-pilot-field>, contained within the parent element <table:data-pilot-table>

This attribute is supported in core Excel 2007.

r.   The standard defines the property "column", contained within the attribute table:orientation, contained within the element <table:data-pilot-field>, contained within the parent element <table:data-pilot-table>

This property is supported in core Excel 2007.

s.   The standard defines the property "data", contained within the attribute table:orientation, contained within the element <table:data-pilot-field>, contained within the parent element <table:data-pilot-table>

This property is supported in core Excel 2007.

t.   The standard defines the property "hidden", contained within the attribute table:orientation, contained within the element <table:data-pilot-field>, contained within the parent element <table:data-pilot-table>

This property is supported in core Excel 2007.

On save, for a range-based data source, Excel 2007 does not write fields that are not displayed on the "DataPilot". For external data sources, Excel 2007 writes out all fields, and marks those not in the "DataPilot" view as hidden.

u.   The standard defines the property "page", contained within the attribute table:orientation, contained within the element <table:data-pilot-field>, contained within the parent element <table:data-pilot-table>

This property is supported in core Excel 2007.

v.   The standard defines the property "row", contained within the attribute table:orientation, contained within the element <table:data-pilot-field>, contained within the parent element <table:data-pilot-table>

This property is supported in core Excel 2007.

w.   The standard defines the attribute table:selected-page, contained within the element <table:data-pilot-field>, contained within the parent element <table:data-pilot-table>

This attribute is supported in core Excel 2007.

On save, if Excel 2007 writes an empty value for this attribute, it means that 'blank' is chosen for the filter value. This corresponds to an empty string in the data source. If Excel 2007 doesn't write this attribute at all, it means the user has not selected a value for the manual filter.

x.   The standard defines the attribute table:source-field-name, contained within the element <table:data-pilot-field>, contained within the parent element <table:data-pilot-table>

This attribute is supported in core Excel 2007.

y.   The standard defines the attribute table:used-hierarchy, contained within the element <table:data-pilot-field>, contained within the parent element <table:data-pilot-table>

This attribute is not supported in core Excel 2007.