API Reference
Enum
ExcelPivotShowDataAs
Defines OfficeIMO values corresponding to DocumentFormat.OpenXml.Spreadsheet.ShowDataAsValues.
Inheritance
- Enum
- ExcelPivotShowDataAs
Usage
This type appears in these public API surfaces even when no hand-authored example is attached directly to the page.
Returned or exposed by
- Property ExcelPivotDataField.ShowDataAs
- Property ExcelPivotDataFieldInfo.ShowDataAs
- Field ExcelPivotShowDataAs.Difference
- Field ExcelPivotShowDataAs.Index
- Field ExcelPivotShowDataAs.Normal
- Field ExcelPivotShowDataAs.Percent
- Field ExcelPivotShowDataAs.PercentageDifference
- Field ExcelPivotShowDataAs.PercentOfColumn
- Field ExcelPivotShowDataAs.PercentOfRow
- Field ExcelPivotShowDataAs.PercentOfTotal
- Field ExcelPivotShowDataAs.RunTotal
Accepted by parameters
- Constructor ExcelPivotDataField.ExcelPivotDataField
- Constructor ExcelPivotDataFieldInfo.ExcelPivotDataFieldInfo
- Constructor ExcelPivotDataFieldInfo.ExcelPivotDataFieldInfo
- Method PivotTableBuilder.Value
Inherited Methods
public override sealed Int32 CompareTo(Object target) #Returns:
Int32Inherited from Enum
Parameters
- target Object
ToString 4 overloads
public override sealed String ToString(IFormatProvider provider) #Returns:
StringInherited from Enum
Obsolete("The provider argument is not used. Use ToString() instead.")Parameters
- provider IFormatProvider
public override sealed String ToString(String format, IFormatProvider provider) #Returns:
StringInherited from Enum
Obsolete("The provider argument is not used. Use ToString(String) instead.")Parameters
- format String
- provider IFormatProvider
Values
public const ExcelPivotShowDataAs PercentageDifference #Represents the Open XML value percentDiff.
Value:
3public const ExcelPivotShowDataAs PercentOfColumn #Represents the Open XML value percentOfCol.
Value:
6public const ExcelPivotShowDataAs PercentOfTotal #Represents the Open XML value percentOfTotal.
Value:
7