ssml:dataField
Data Field Item
Element information
Namespace: http://schemas.openxmlformats.org/spreadsheetml/2006/main
Schema document: sml-pivotTable.xsd
Type: ssml:CT_DataField
Properties: Local, Qualified
Content
- ssml:extLst [0..1] Future Feature Storage Area
Attributes
| Name | Occ | Type | Description | Notes |
|---|---|---|---|---|
| name | [0..1] | ssml:ST_Xstring | Data Field Name | |
| fld | [1..1] | xsd:unsignedInt | Field | |
| subtotal | [0..1] | ssml:ST_DataConsolidateFunction | Subtotal | Default value is "sum". |
| showDataAs | [0..1] | ssml:ST_ShowDataAs | Show Data As Display Format | Default value is "normal". |
| baseField | [0..1] | xsd:int | 'Show Data As' Base Field | Default value is "-1". |
| baseItem | [0..1] | xsd:unsignedInt | 'Show Data As' Base Setting | Default value is "1048832". |
| numFmtId | [0..1] | ssml:ST_NumFmtId | Number Format Id |
Used in
- Type ssml:CT_DataFields (Element ssml:dataFields)
Sample instance
<ssml:dataField fld="1"> <ssml:extLst> <ssml:ext> <!--any element--> </ssml:ext> </ssml:extLst> </ssml:dataField>