Share via


2.1.251 Section 8.8.1, Data Pilot Table

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

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

b.   The standard defines the element <table:database-source-sql>, contained within the parent element <table:data-pilot-table>

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

c.   The standard defines the element <table:database-source-table>, contained within the parent element <table:data-pilot-table>

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

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

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

e.   The standard defines the attribute table:application-data, contained within the element <table:data-pilot-table>, contained within the parent element <table:data-pilot-tables>

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

f.   The standard defines the attribute table:buttons, contained within the element <table:data-pilot-table>, contained within the parent element <table:data-pilot-tables>

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

The ODF specification does not specify DataPilot layout details.

On load, Excel uses button location information to help determine how to render the DataPilot, including page field locations, row and column headings, and data area.

On save, Excel writes button locations, based on how the DataPilot is positioned in Excel, so that other implementers can provide interactive buttons, if desired.

g.   The standard defines the attribute table:drill-down-on-double-click, contained within the element <table:data-pilot-table>, contained within the parent element <table:data-pilot-tables>

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

h.   The standard defines the attribute table:grand-total, contained within the element <table:data-pilot-table>, contained within the parent element <table:data-pilot-tables>

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

i.   The standard defines the property "both", contained within the attribute table:grand-total, contained within the element <table:data-pilot-table>, contained within the parent element <table:data-pilot-tables>

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

j.   The standard defines the property "column", contained within the attribute table:grand-total, contained within the element <table:data-pilot-table>, contained within the parent element <table:data-pilot-tables>

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

k.   The standard defines the property "none", contained within the attribute table:grand-total, contained within the element <table:data-pilot-table>, contained within the parent element <table:data-pilot-tables>

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

l.   The standard defines the property "row", contained within the attribute table:grand-total, contained within the element <table:data-pilot-table>, contained within the parent element <table:data-pilot-tables>

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

m.   The standard defines the attribute table:identify-categories, contained within the element <table:data-pilot-table>, contained within the parent element <table:data-pilot-tables>

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

n.   The standard defines the attribute table:ignore-empty-rows, contained within the element <table:data-pilot-table>, contained within the parent element <table:data-pilot-tables>

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

o.   The standard defines the attribute table:name, contained within the element <table:data-pilot-table>, contained within the parent element <table:data-pilot-tables>

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

p.   The standard defines the attribute table:show-filter-button, contained within the element <table:data-pilot-table>, contained within the parent element <table:data-pilot-tables>

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

On load, Excel uses the value of the attribute table:show-filter-button to help determine the layout of the DataPilot.

Excel does not support toggling the DataPilot buttons "on" and "off".

On save, Excel always writes the attribute table:show-filter-button as "false".

q.   The standard defines the attribute table:target-range-address, contained within the element <table:data-pilot-table>, contained within the parent element <table:data-pilot-tables>

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