EMA3D API Documentation

EMA3D API Documentation

EMA3D Scripting API

EMC Plus API V25 Documentation

DocumentFormat Namespaces

DocumentFormat.OpenXml.Office2010 Namespaces

DocumentFormat.OpenXml.Office2010.Excel

AllocationMethodValues Enumeration

ArgumentDescription Class

ArgumentDescriptions Class

AxisColor Class

BarAxisColor Class

BorderColor Class

CacheField Class

CacheHierarchy Class

CalculatedMember Class

CalculatedMembers Class

CheckedValues Enumeration

ColorScale Class

ColorType Class

ConditionalFormat Class

ConditionalFormats Class

ConditionalFormatting Class

ConditionalFormattingIcon Class

ConditionalFormattingRule Class

ConditionalFormattings Class

ConditionalFormattingValueObject Class

ConditionalFormattingValueObjectTypeValues Enumeration

Connection Class

CustomFilter Class

CustomFilters Class

DataBarAxisPositionValues Enumeration

DataBarDirectionValues Enumeration

DataField Class

DatastoreItem Class

DataValidation Class

DataValidationFormulaType Class

DataValidationForumla1 Class

DataValidationForumla2 Class

DataValidations Class

DdeValues Class

DefinedName Class

DefinedNames Class

DifferentialFormats Class

DifferentialType Class

DisplayBlanksAsValues Enumeration

DropStyleValues Enumeration

EditValidationValues Enumeration

ExtensionList Class

FillColor Class

FirstMarkerColor Class

FormControlProperties Class

HighMarkerColor Class

IconFilter Class

IconSetTypeValues Enumeration

IgnoredError Class

IgnoredErrors Class

LastMarkerColor Class

ListItems Class

LowMarkerColor Class

MarkersColor Class

NegativeBorderColor Class

NegativeColor Class

NegativeFillColor Class

ObjectTypeValues Enumeration

OlapSlicerCache Class

OlapSlicerCacheItem Class

OlapSlicerCacheItemParent Class

OlapSlicerCacheLevelData Class

OlapSlicerCacheLevelsData Class

OlapSlicerCacheRange Class

OlapSlicerCacheRanges Class

OlapSlicerCacheSelection Class

OlapSlicerCacheSelections Class

OlapSlicerCacheSortOrderValues Enumeration

PivotArea Class

PivotAreas Class

PivotCacheDefinition Class

PivotCaches Class

PivotChange Class

PivotChanges Class

PivotEdit Class

PivotEdits Class

PivotEditValue Class

PivotEditValueTypeValues Enumeration

PivotField Class

PivotHierarchy Class

PivotShowAsValues Enumeration

PivotTableDefinition Class

PivotUserEdit Class

ProtectedRange Class

ProtectedRanges Class

SelectionTypeValues Enumeration

SeriesColor Class

SetLevels Class

SlicerCache Class

SlicerCacheCrossFilterValues Enumeration

SlicerCacheData Class

SlicerCacheDefinition Class

SlicerCacheDefinitionExtensionList Class

SlicerCachePivotTable Class

SlicerCachePivotTables Class

SlicerCaches Class

SlicerList Class

SlicerRef Class

SlicerStyle Class

SlicerStyleElement Class

SlicerStyleElements Class

SlicerStyles Class

SlicerStyleTypeValues Enumeration

SortCondition Class

SourceConnection Class

Sparkline Class

SparklineAxisMinMaxValues Enumeration

SparklineGroup Class

SparklineGroups Class

Sparklines Class

SparklineTypeValues Enumeration

TabularSlicerCache Class

TabularSlicerCacheItem Class

TabularSlicerCacheItems Class

TabularSlicerCacheSortOrderValues Enumeration

TextHorizontalAlignmentValues Enumeration

TextVerticalAlignmentValues Enumeration

TupleItems Class

TupleSetHeader Class

TupleSetHeaders Class

TupleSetRow Class

TupleSetRowItem Class

TupleSetRows Class

WorkbookProperties Class

Click or drag to resize

PivotShowAsValues Enumeration

Defines the PivotShowAsValues enumeration.

Namespace: DocumentFormat.OpenXml.Office2010.Excel
Assembly: DocumentFormat.OpenXml (in DocumentFormat.OpenXml.dll) Version: 2.20.0+Branch.release-v2.20.0.Sha.a873d3fbff9bffe179fea62486da950adf5be65d.a873d3fbff9bffe179fea62486da950adf5be65d

Syntax

public enum PivotShowAsValues

Public Enumeration PivotShowAsValues

public enum class PivotShowAsValues

type PivotShowAsValues

Members

Member name	Value	Description
PercentOfParent	0	percentOfParent. When the item is serialized out as xml, its value is "percentOfParent".
PercentOfParentRow	1	percentOfParentRow. When the item is serialized out as xml, its value is "percentOfParentRow".
PercentOfParentColumn	2	percentOfParentCol. When the item is serialized out as xml, its value is "percentOfParentCol".
PercentOfRunningTotal	3	percentOfRunningTotal. When the item is serialized out as xml, its value is "percentOfRunningTotal".
RankAscending	4	rankAscending. When the item is serialized out as xml, its value is "rankAscending".
RankDescending	5	rankDescending. When the item is serialized out as xml, its value is "rankDescending".

See Also

Reference

DocumentFormat.OpenXml.Office2010.Excel Namespace