table:data-pilot-table

Element information

Namespace: urn:oasis:names:tc:opendocument:xmlns:table:1.0

Schema document: table.xsd

Type: Anonymous

Properties: Global, Qualified

Content

Sequence [1..1]
1. Choice [0..1]
2. table:data-pilot-field [1..*]

Attributes

Name	Occ	Type	Notes
table:name	[1..1]	text:string	from group table:name
table:application-data	[0..1]	text:string	from group text:table-data-pilot-table-attlist
table:grand-total	[0..1]	Anonymous	Default value is "both". from group text:table-data-pilot-table-attlist
table:ignore-empty-rows	[0..1]	text:boolean	Default value is "false". from group text:table-data-pilot-table-attlist
table:identify-categories	[0..1]	text:boolean	Default value is "false". from group text:table-data-pilot-table-attlist
table:target-range-address	[1..1]	text:cellRangeAddress	from group text:table-data-pilot-table-attlist
table:buttons	[0..1]	text:cellRangeAddressList	from group text:table-data-pilot-table-attlist
table:show-filter-button	[0..1]	text:boolean	Default value is "true". from group text:table-data-pilot-table-attlist
table:drill-down-on-double-click	[0..1]	text:boolean	Default value is "true". from group text:table-data-pilot-table-attlist

Used in

Anonymous type of element table:data-pilot-tables

Sample instance

<table:data-pilot-table table:name="string" table:target-range-address="string">
   <table:database-source-sql table:database-name="string" table:sql-statement="string"/>
   <table:data-pilot-field table:source-field-name="string" table:orientation="row">
      <table:data-pilot-level>
         <table:data-pilot-subtotals>...
         </table:data-pilot-subtotals>
         <table:data-pilot-members>...
         </table:data-pilot-members>
         <table:data-pilot-display-info table:enabled="true" table:data-field="string" table:member-count="1" table:display-member-mode="from-top"/>
         <table:data-pilot-sort-info table:sort-mode="data" table:order="ascending"/>
         <table:data-pilot-layout-info table:layout-mode="tabular-layout" table:add-empty-lines="true"/>
      </table:data-pilot-level>
      <table:data-pilot-field-reference table:field-name="string" table:member-type="named" table:type="none"/>
      <table:data-pilot-groups table:source-field-name="string" table:step="1.0" table:grouped-by="seconds">
         <table:data-pilot-group table:name="string">...
         </table:data-pilot-group>
      </table:data-pilot-groups>
   </table:data-pilot-field>
</table:data-pilot-table>