Schema Central > OOXML > sml-pivotTable.xsd > sml-pivotTable.xsd
Advanced search
Need XML Help?

Recommended Reading:

Definitive XML Schema

 

Web Service Contract Design and Versioning for SOA

 

Advanced XML Applications

 

sml-pivotTable.xsd

Schema document information

Namespace: http://schemas.openxmlformats.org/spreadsheetml/2006/main

File path: sml-pivotTable.xsd

Properties: Element Form Default: qualified

Elements

ssml:autoFilter

ssml:autoSortScope

ssml:b

ssml:cacheField

ssml:cacheFields

ssml:cacheHierarchies

ssml:cacheHierarchy

ssml:cacheSource

ssml:calculatedItem

ssml:calculatedItems

ssml:calculatedMember

ssml:calculatedMembers

ssml:chartFormat

ssml:chartFormats

ssml:colFields

ssml:colHierarchiesUsage

ssml:colHierarchyUsage

ssml:colItems

ssml:conditionalFormat

ssml:conditionalFormats

ssml:consolidation

ssml:d

ssml:dataField

ssml:dataFields

ssml:dimension

ssml:dimensions

ssml:discretePr

ssml:e

ssml:entries

ssml:field

ssml:field

ssml:fieldGroup

ssml:fieldsUsage

ssml:fieldUsage

ssml:filter

ssml:filters

ssml:format

ssml:formats

ssml:group

ssml:groupItems

ssml:groupLevel

ssml:groupLevels

ssml:groupMember

ssml:groupMembers

ssml:groups

ssml:i

ssml:i

ssml:item

ssml:items

ssml:kpi

ssml:kpis

ssml:location

ssml:m

ssml:map

ssml:maps

ssml:measureGroup

ssml:measureGroups

ssml:member

ssml:members

ssml:mp

ssml:mpMap

ssml:mps

ssml:n

ssml:n

ssml:page

ssml:pageField

ssml:pageFields

ssml:pageItem

ssml:pages

ssml:pivotArea

ssml:pivotArea

ssml:pivotArea

ssml:pivotArea

ssml:pivotArea

ssml:pivotAreas

ssml:pivotCacheDefinition

ssml:pivotCacheRecords

ssml:pivotField

ssml:pivotFields

ssml:pivotHierarchies

ssml:pivotHierarchy

ssml:pivotTableDefinition

ssml:pivotTableStyleInfo

ssml:query

ssml:queryCache

ssml:r

ssml:rangePr

ssml:rangeSet

ssml:rangeSets

ssml:rowFields

ssml:rowHierarchiesUsage

ssml:rowHierarchyUsage

ssml:rowItems

ssml:s

ssml:serverFormat

ssml:serverFormats

ssml:set

ssml:sets

ssml:sharedItems

ssml:sortByTuple

ssml:tpl

ssml:tpls

ssml:tpls

ssml:tupleCache

ssml:worksheetSource

ssml:x

ssml:x

ssml:x

ssml:x

ssml:x

Attributes

action

allCaption

allDrilled

allUniqueName

asteriskTotals

attribute

autoEnd

autoPage

autoShow

autoStart

avgSubtotal

axis

backgroundQuery

base

baseField

baseItem

bc

c

c

c

c

cacheId

cap

caption

caption

caption

caption

caption

caption

caption

caption

chart

chartFormat

colGrandTotals

colHeaderCaption

colPageCount

compact

compact

compactData

connectionId

containsBlank

containsDate

containsInteger

containsMixedTypes

containsNonDate

containsNumber

containsSemiMixedTypes

containsString

count

count

count

count

count

count

count

count

count

count

count

count

count

count

count

count

count

count

count

count

count

count

count

count

count

count

count

count

count

count

count

count

count

count

count

countASubtotal

countSubtotal

cp

createdVersion

culture

customListSort

customRollUp

d

databaseField

dataCaption

dataField

dataOnRows

dataPosition

dataSourceSort

defaultAttributeDrillState

defaultMemberUniqueName

defaultSubtotal

description

dimension

dimensionUniqueName

disableFieldList

displayFolder

displayFolder

dragOff

dragToCol

dragToData

dragToData

dragToPage

dragToPage

dragToRow

e

editData

enableDrill

enableFieldProperties

enableRefresh

enableWizard

endDate

endNum

errorCaption

evalOrder

f

f

f

fc

field

fieldListSortAscending

fieldPrintTitles

firstDataCol

firstDataRow

firstHeaderRow

fld

fld

fld

format

format

formula

formula

goal

grandTotalCaption

gridDropZones

group

groupBy

groupInterval

h

hiddenLevel

hideNewItems

hier

hier

hierarchy

hierarchy

hierarchyUsage

i

i

i1

i2

i3

i4

iconSet

id

id

iMeasureFld

iMeasureHier

immersive

in

includeNewItemsInFilter

indent

insertBlankRow

insertPageBreak

invalid

item

itemPageCount

itemPrintTitles

keyAttribute

level

level

longText

m

mappingCount

maxDate

maxRank

maxSubtotal

maxValue

mdx

mdx

mdxSubqueries

measure

measure

measureFilter

measureGroup

measureGroup

measureGroup

measures

memberName

memberPropertyField

memberValueDatatype

mergeItem

minDate

minRefreshableVersion

minSubtotal

minValue

missingCaption

missingItemsLimit

mpFld

multipleFieldFilters

multipleItemSelectionAllowed

n

name

name

name

name

name

name

name

name

name

name

name

name

name

name

name

nameLen

nonAutoSortDefault

numFmtId

oneField

optimizeMemory

outline

outline

outline

outlineData

pageOverThenDown

pageStyle

pageWrap

par

parent

parent

parentSet

pivotTableStyle

pLen

pPos

preserveFormatting

printDrill

priority

productSubtotal

propertyName

published

queryFailed

r

rankBy

recordCount

refreshedBy

refreshedDate

refreshedVersion

refreshOnLoad

rowGrandTotals

rowHeaderCaption

rowPageCount

s

saveData

scope

sd

series

serverField

serverField

set

setDefinition

sheet

showAll

showAsCaption

showCalcMbrs

showCell

showColHeaders

showColStripes

showDataAs

showDataDropDown

showDataTips

showDrill

showDropDowns

showDropZones

showEmptyCol

showEmptyRow

showError

showHeaders

showInFieldList

showItems

showLastColumn

showMemberPropertyTips

showMissing

showMultipleLabel

showPropAsCaption

showPropCell

showPropTip

showRowHeaders

showRowStripes

showTip

solveOrder

sortType

sortType

st

startDate

startNum

status

stdDevPSubtotal

stdDevSubtotal

stringValue1

stringValue2

subtotal

subtotalCaption

subtotalHiddenItems

subtotalTop

subtotalTop

sumSubtotal

supportAdvancedDrill

supportSubquery

t

tag

time

time

topAutoShow

trend

tupleCache

type

type

type

u

un

unbalanced

unbalancedGroup

uniqueList

uniqueMemberProperty

uniqueName

uniqueName

uniqueName

uniqueName

uniqueName

uniqueName

uniqueParent

updatedVersion

upgradeOnRefresh

useAutoFormatting

user

v

v

v

v

vacatedStyle

value

varPSubtotal

varSubtotal

visualTotals

weight

x

x

Complex types

ssml:CT_AutoSortScope

ssml:CT_Boolean

ssml:CT_CacheField

ssml:CT_CacheFields

ssml:CT_CacheHierarchies

ssml:CT_CacheHierarchy

ssml:CT_CacheSource

ssml:CT_CalculatedItem

ssml:CT_CalculatedItems

ssml:CT_CalculatedMember

ssml:CT_CalculatedMembers

ssml:CT_ChartFormat

ssml:CT_ChartFormats

ssml:CT_ColFields

ssml:CT_ColHierarchiesUsage

ssml:CT_colItems

ssml:CT_ConditionalFormat

ssml:CT_ConditionalFormats

ssml:CT_Consolidation

ssml:CT_DataField

ssml:CT_DataFields

ssml:CT_DateTime

ssml:CT_Dimensions

ssml:CT_DiscretePr

ssml:CT_Error

ssml:CT_Field

ssml:CT_FieldGroup

ssml:CT_FieldsUsage

ssml:CT_FieldUsage

ssml:CT_Format

ssml:CT_Formats

ssml:CT_GroupItems

ssml:CT_GroupLevel

ssml:CT_GroupLevels

ssml:CT_GroupMember

ssml:CT_GroupMembers

ssml:CT_Groups

ssml:CT_HierarchyUsage

ssml:CT_I

ssml:CT_Item

ssml:CT_Items

ssml:CT_LevelGroup

ssml:CT_Location

ssml:CT_MeasureDimensionMap

ssml:CT_MeasureDimensionMaps

ssml:CT_MeasureGroup

ssml:CT_MeasureGroups

ssml:CT_Member

ssml:CT_MemberProperties

ssml:CT_MemberProperty

ssml:CT_Members

ssml:CT_Missing

ssml:CT_Number

ssml:CT_PageField

ssml:CT_PageFields

ssml:CT_PageItem

ssml:CT_Pages

ssml:CT_PCDKPI

ssml:CT_PCDKPIs

ssml:CT_PCDSCPage

ssml:CT_PCDSDTCEntries

ssml:CT_PivotAreas

ssml:CT_PivotCacheDefinition

ssml:CT_PivotCacheRecords

ssml:CT_PivotDimension

ssml:CT_PivotField

ssml:CT_PivotFields

ssml:CT_PivotFilter

ssml:CT_PivotFilters

ssml:CT_PivotHierarchies

ssml:CT_PivotHierarchy

ssml:CT_pivotTableDefinition

ssml:CT_PivotTableStyle

ssml:CT_Query

ssml:CT_QueryCache

ssml:CT_RangePr

ssml:CT_RangeSet

ssml:CT_RangeSets

ssml:CT_Record

ssml:CT_RowFields

ssml:CT_RowHierarchiesUsage

ssml:CT_rowItems

ssml:CT_ServerFormat

ssml:CT_ServerFormats

ssml:CT_Set

ssml:CT_Sets

ssml:CT_SharedItems

ssml:CT_String

ssml:CT_Tuple

ssml:CT_TupleCache

ssml:CT_Tuples

ssml:CT_WorksheetSource

ssml:CT_X

Site developed and hosted by Datypic, Inc.

Please report errors or comments about this site to pwalmsley@datypic.com