Enumerations


Added in 2021

xlGradientStopPositionTypeSpecifies the type of gradient stop position.
xlSeriesColorGradientStyleSpecifies the colour gradient style for a series.
xlGradientStopPositionType
Specifies the type of gradient stop position.
xlSeriesColorGradientStyle
Specifies the colour gradient style for a series.

Added in 2019

xlCategorySortOrderSpecifies the sort order for the category.
xlFormulaVersionSpecifies how you want formulas replaced when using Range.Replace.
xlGeoMappingLevelSpecifies the geography mapping level for a series within a chart group.
xlGeoProjectionTypeSpecifies the geography projection type for a series within the chart group.
xlLinkedDataTypeStateSpecifies the state of cells that may contain Linked data types such as Stocks or Geography.
xlRegionLabelOptionsSpecifies the region labelling behavior for a series within the chart group.
xlValueSortOrderSpecifies the sort order for the values.
xlCategorySortOrder
Specifies the sort order for the category.
xlFormulaVersion
Specifies how you want formulas replaced when using Range.Replace.
xlGeoMappingLevel
Specifies the geography mapping level for a series within a chart group.
xlGeoProjectionType
Specifies the geography projection type for a series within the chart group.
xlLinkedDataTypeState
Specifies the state of cells that may contain Linked data types such as Stocks or Geography.
xlRegionLabelOptions
Specifies the region labelling behavior for a series within the chart group.
xlValueSortOrder
Specifies the sort order for the values.

Added in 2016

xlBinsTypeSpecifies the values passed to and returned from the ChartGroup.BinsType property.
xlForecastAggregationSpecifies the type of aggregation to use for the forecast.
xlForecastChartTypeSpecifies the type of chart displayed for the forecast.
xlForecastDataCompletionSpecifies how data is completed for the forecast.
xlParentDataLabelOptionsSpecifies the values passed to and returned from the Series.ParentDataLabelOption property.
xlPublishToDocsDisclosureScopeSpecifies the disclosure type when publishing a workbook to a document.
xlPublishToPBINameConflictActionSpecifies the conflict action when publishing to Power BI.
xlPublishToPBIPublishTypeSpecifies the publishing type when publishing to Power BI.
xlBinsType
Specifies the values passed to and returned from the ChartGroup.BinsType property.
xlForecastAggregation
Specifies the type of aggregation to use for the forecast.
xlForecastChartType
Specifies the type of chart displayed for the forecast.
xlForecastDataCompletion
Specifies how data is completed for the forecast.
xlParentDataLabelOptions
Specifies the values passed to and returned from the Series.ParentDataLabelOption property.
xlPublishToDocsDisclosureScope
Specifies the disclosure type when publishing a workbook to a document.
xlPublishToPBINameConflictAction
Specifies the conflict action when publishing to Power BI.
xlPublishToPBIPublishType
Specifies the publishing type when publishing to Power BI.

Added in 2013

xlCalcMemNumberFormatTypeSpecifies the format of cell values that are based on the calculated member.
xlCategoryLabelLevelSpecifies the category labels for the category label levels.
xlFilterStatusSpecifies the status of the filter.
xlModelChangeSourceSpecifies the source of the change to the data model.
xlQuickAnalysisModeSpecifies which top level button the callout user interface is displayed.
xlSeriesNameLevelSpecifies the series labels for the series label levels.
xlSlicerCacheTypeSpecifies the cache type to be used in the slicer.
xlTimelineLevelSpecifies the time line to be used in the slicer.
xlTimeMovingSpecifies the period of time moving. (Removed in 2016)
xlCalcMemNumberFormatType
Specifies the format of cell values that are based on the calculated member.
xlCategoryLabelLevel
Specifies the category labels for the category label levels.
xlFilterStatus
Specifies the status of the filter.
xlModelChangeSource
Specifies the source of the change to the data model.
xlQuickAnalysisMode
Specifies which top level button the callout user interface is displayed.
xlSeriesNameLevel
Specifies the series labels for the series label levels.
xlSlicerCacheType
Specifies the cache type to be used in the slicer.
xlTimelineLevel
Specifies the time line to be used in the slicer.
xlTimeMoving
Specifies the period of time moving. (Removed in 2016)

Added in 2010

xlAllocationSpecifies when to calculate changes when performing what-if analysis on a Pivot Table based on an OLAP data source.
xlAllocationMethodSpecifies the method to use to allocate values when performing what-if analysis on a Pivot Table report based on an OLAP data source.
xlAllocationValueSpecifies what value to allocate when performing what-if analysis on a Pivot Table report based on an OLAP data source.
xlCellChangedStateSpecifies whether a Pivot Table value cell has been edited or recalculated since the Pivot Table report was created or the last commit operation was performed.
xlDataBarAxisPositionSpecifies the axis position for a range of cells with conditional formatting as data bars.
xlDataBarFillTypeSpecifies how a data bar is filled with color.
xlDataBarBorderTypeSpecifies the border of a data bar.
xlDataBarNegativeColorTypeSpecifies whether to use the same border and fill color as postive data bars.
xlFileValidationPivotModeSpecifies how to validate the data caches for Pivot Table reports.
xlIconSpecifies the icon for a criterion in an icon set conditional formatting rule.
xlOartHorizontalOverflowSpecifies the horizontal overflow setting for a text frame.
xlOartVerticalOverflowSpecifies the vertical overflow setting for a text frame.
xlPieSliceIndexSpecifies which position on the slice to return the coordinate of.
xlPieSliceLocationSpecifies the horizontal or vertical position of a point on a pie chart, in points, from the top or left edge of the object to the top or left edge of the chart area.
xlPivotFieldRepeatLabelsSpecifies whether to repeat all field item labels in a Pivot Table report.
xlPortugueseReformSpecifies the mode for checking the spelling of Portuguese.
xlProtectedViewCloseReasonSpecifies how the Protected View window was closed.
xlProtectedViewWindowStateSpecifies the state of the Protected View window.
xlSlicerCrossFilterTypeSpecifies the type of cross filtering used by the specified slicer cache and how it is visualized.
xlSlicerSortSpecifies whether items displayed in the slicer are sorted, and if they are sorted, whether they are sorted in ascending or descending order by item captions.
xlSpanishModesSpecifies the mode for checking the spelling of Spanish.
xlSparklineRowColSpecifies how to plot the sparkline when the data on which it is based is in a square-shaped range.
xlSparkScaleSpecifies how the minimum or maximum value of the vertical axis of the sparkline is scaled relative to other sparklines in the group.
xlSparkTypeSpecifies the type of sparkline.
xlAllocation
Specifies when to calculate changes when performing what-if analysis on a Pivot Table based on an OLAP data source.
xlAllocationMethod
Specifies the method to use to allocate values when performing what-if analysis on a Pivot Table report based on an OLAP data source.
xlAllocationValue
Specifies what value to allocate when performing what-if analysis on a Pivot Table report based on an OLAP data source.
xlCellChangedState
Specifies whether a Pivot Table value cell has been edited or recalculated since the Pivot Table report was created or the last commit operation was performed.
xlDataBarAxisPosition
Specifies the axis position for a range of cells with conditional formatting as data bars.
xlDataBarFillType
Specifies how a data bar is filled with color.
xlDataBarBorderType
Specifies the border of a data bar.
xlDataBarNegativeColorType
Specifies whether to use the same border and fill color as postive data bars.
xlFileValidationPivotMode
Specifies how to validate the data caches for Pivot Table reports.
xlIcon
Specifies the icon for a criterion in an icon set conditional formatting rule.
xlOartHorizontalOverflow
Specifies the horizontal overflow setting for a text frame.
xlOartVerticalOverflow
Specifies the vertical overflow setting for a text frame.
xlPieSliceIndex
Specifies which position on the slice to return the coordinate of.
xlPieSliceLocation
Specifies the horizontal or vertical position of a point on a pie chart, in points, from the top or left edge of the object to the top or left edge of the chart area.
xlPivotFieldRepeatLabels
Specifies whether to repeat all field item labels in a Pivot Table report.
xlPortugueseReform
Specifies the mode for checking the spelling of Portuguese.
xlProtectedViewCloseReason
Specifies how the Protected View window was closed.
xlProtectedViewWindowState
Specifies the state of the Protected View window.
xlSlicerCrossFilterType
Specifies the type of cross filtering used by the specified slicer cache and how it is visualized.
xlSlicerSort
Specifies whether items displayed in the slicer are sorted, and if they are sorted, whether they are sorted in ascending or descending order by item captions.
xlSpanishModes
Specifies the mode for checking the spelling of Spanish.
xlSparklineRowCol
Specifies how to plot the sparkline when the data on which it is based is in a square-shaped range.
xlSparkScale
Specifies how the minimum or maximum value of the vertical axis of the sparkline is scaled relative to other sparklines in the group.
xlSparkType
Specifies the type of sparkline.

Added in 2007

xlAboveBelowSpecifies if the values are above or below average.
xlActionTypeSpecifies the action that should be performed.
xlCalcForSpecifies what should be calculated.
xlChartElementPositionSpecifies the position of the chart element.
xlCheckInVersionTypeSpecifies the type of version for the document checked in when using the CheckIn method. Applies to workbooks stored in a SharePoint library.
xlConditionValueTypesSpecifies the types of condition values that can be used.
xlConnectionTypeSpecifies the type of database connection.
xlContainsOperatorSpecifies the operator used in a function.
xlCredentialsMethodSpecifies the type of credentials method used.
xlCubeFieldSubTypeSpecifies the subtype of the CubeField.
xlDupeUniqueSpecifies whether duplicate or unique values shoud be displayed.
xlDynamicFilterCriteriaSpecifies the filter criterion.
xlFilterAllDatesInPeriodSpecifies how dates should be filtered in the specified period.
xlFixedFormatQualitySpecifies the quality of speadsheets saved in different fixed formats.
xlFixedFormatTypeSpecifies the type of file format.
xlFormatFilterTypesSpecifies the types of format filters.
xlGenerateTableRefsSpecifies the type of table references.
xlGradientFillTypeSpecifies the type of gradient fill.
xlIconSetSpecifies the type of icon set.
xlLayoutRowTypeSpecifies the type of layout row.
xlLookForSpecifies what to look for in searches.
xlMeasurementUnitsSpecifies the measurement units.
xlPivotConditionScopeThis enumeration specifies the conditional formatting applied for filtering values from the Pivot Table object.
xlPivotFilterTypeThe type of filter applied.
xlPivotLineTypeSpecifies the type of the PivotLine.
xlPropertyDisplayedInSpecifies where to display the property.
xlRemoveDocInfoTypeSpecifies the type information to be removed from the document information.
xlRgbColorSpecifies the RGB color.
xlSortOnSpecifies the parameter on which the data should be sorted.
xlStdColorScaleSpecifies the standard color scale.
xlTableStyleElementTypeSpecifies the table style element used.
xlThemeColorSpecifies the theme color to be used.
xlThemeFontSpecifies the theme font to use.
xlThreadModeSpecifies the control over the multi-threaded calculation mode.
xlTimePeriodsSpecifies the time period.
xlTopBottomSpecifies the top 10 values from the top or bottom of a series of values.
xlAboveBelow
Specifies if the values are above or below average.
xlActionType
Specifies the action that should be performed.
xlCalcFor
Specifies what should be calculated.
xlChartElementPosition
Specifies the position of the chart element.
xlCheckInVersionType
Specifies the type of version for the document checked in when using the CheckIn method. Applies to workbooks stored in a SharePoint library.
xlConditionValueTypes
Specifies the types of condition values that can be used.
xlConnectionType
Specifies the type of database connection.
xlContainsOperator
Specifies the operator used in a function.
xlCredentialsMethod
Specifies the type of credentials method used.
xlCubeFieldSubType
Specifies the subtype of the CubeField.
xlDupeUnique
Specifies whether duplicate or unique values shoud be displayed.
xlDynamicFilterCriteria
Specifies the filter criterion.
xlFilterAllDatesInPeriod
Specifies how dates should be filtered in the specified period.
xlFixedFormatQuality
Specifies the quality of speadsheets saved in different fixed formats.
xlFixedFormatType
Specifies the type of file format.
xlFormatFilterTypes
Specifies the types of format filters.
xlGenerateTableRefs
Specifies the type of table references.
xlGradientFillType
Specifies the type of gradient fill.
xlIconSet
Specifies the type of icon set.
xlLayoutRowType
Specifies the type of layout row.
xlLookFor
Specifies what to look for in searches.
xlMeasurementUnits
Specifies the measurement units.
xlPivotConditionScope
This enumeration specifies the conditional formatting applied for filtering values from the Pivot Table object.
xlPivotFilterType
The type of filter applied.
xlPivotLineType
Specifies the type of the PivotLine.
xlPropertyDisplayedIn
Specifies where to display the property.
xlRemoveDocInfoType
Specifies the type information to be removed from the document information.
xlRgbColor
Specifies the RGB color.
xlSortOn
Specifies the parameter on which the data should be sorted.
xlStdColorScale
Specifies the standard color scale.
xlTableStyleElementType
Specifies the table style element used.
xlThemeColor
Specifies the theme color to be used.
xlThemeFont
Specifies the theme font to use.
xlThreadMode
Specifies the control over the multi-threaded calculation mode.
xlTimePeriods
Specifies the time period.
xlTopBottom
Specifies the top 10 values from the top or bottom of a series of values.

© 2024 Better Solutions Limited. All Rights Reserved. © 2024 Better Solutions Limited TopPrevNext