Global
The Global namespace provides a collection of enumerations and helper classes that influence cell styling, chart axes, autofill behavior, shape types, and other global settings. Use these types to fine‑tune workbook rendering and interaction across the Aspose.Cells API.
Enumerations
| Enumeration | Description |
|---|---|
| AccessCacheOptions | Utility class containing constants. Cache options for data access. Can be combined with | operator for multiple options |
| AdjustFontSizeForRowType | Utility class containing constants. Represents which kind of rows should be ajusted. |
| AutoFillType | Utility class containing constants. Represents the auto fill type. |
| AutoFitMergedCellsType | Utility class containing constants. Represents the type of auto fitting merged cells. |
| AutoFitWrappedTextType | Utility class containing constants. Represents the type of auto fitting wrapped text. |
| AutoShapeType | Utility class containing constants. Represents all built-in auto shape type. |
| AxisType | Utility class containing constants. Represents the axis type. |
| BackgroundMode | Utility class containing constants. Represents the display mode of the background. |
| BackgroundType | Utility class containing constants. Enumerates cell background pattern types. |
| Bar3DShapeType | Utility class containing constants. Represents the shape used with the 3-D bar or column chart. |
| BevelPresetType | Utility class containing constants. Represents a preset for a type of bevel which can be applied to a shape in 3D. |
| BevelType | Utility class containing constants. Represents a preset for a type of bevel which can be applied to a shape in 3D. |
| BorderType | Utility class containing constants. Enumerates the border line and diagonal line types. |
| BubbleSizeRepresents | Utility class containing constants. Represents what the bubble size represents on a bubble chart. |
| BuiltinStyleType | Utility class containing constants. Represents all built-in style types. |
| BulletType | Utility class containing constants. Represents the type of the bullet. |
| CalcModeType | Utility class containing constants. Represents the mode type of calculating formulas. Only sets for MS Excel. |
| CalculationPrecisionStrategy | Utility class containing constants. Enumerates strategies for handling calculation precision. Because of the precision i |
| CategoryType | Utility class containing constants. Represents the category axis type. |
| CellBorderType | Utility class containing constants. Enumerates a cell’s border type. |
| CellValueFormatStrategy | Utility class containing constants. Specifies how to apply style for the value of the cell. |
| CellValueType | Utility class containing constants. Specifies a cell value type. |
| CellsUnitType | Utility class containing constants. Specifies the unit of measurement. |
| ChartColorPaletteType | Utility class containing constants. |
| ChartLineFormattingType | Utility class containing constants. Represents line format type of chart line. |
| ChartMarkerType | Utility class containing constants. Represents the marker style in a line chart, scatter chart, or radar chart. |
| ChartSplitType | Utility class containing constants. Represents the way the two sections of either a pie of pie chart or a bar of pie cha |
| ChartTextDirectionType | Utility class containing constants. Represents the text direction type of the chart. |
| ChartType | Utility class containing constants. Enumerates all chart types used in Excel. |
| CheckValueType | Utility class containing constants. Represents the check value type of the check box. |
| ColorDepth | Utility class containing constants. Enumerates Bit Depth Type for tiff image. |
| ColorType | Utility class containing constants. Represents all color type |
| CommentTitleType | Utility class containing constants. Represents comment title type while rendering when comment is set to display at end |
| ConsolidationFunction | Utility class containing constants. Represents consolidation function. |
| ControlBorderType | Utility class containing constants. Represents the border type of the ActiveX control. |
| ControlCaptionAlignmentType | Utility class containing constants. Represents the position of the Caption relative to the control. |
| ControlListStyle | Utility class containing constants. Represents the visual appearance of the list in a ListBox or ComboBox. |
| ControlMatchEntryType | Utility class containing constants. Represents how a ListBox or ComboBox searches its list as the user types. |
| ControlMousePointerType | Utility class containing constants. Represents the type of icon displayed as the mouse pointer for the control. |
| ControlPictureAlignmentType | Utility class containing constants. Represents the alignment of the picture inside the Form or Image. |
| ControlPicturePositionType | Utility class containing constants. Represents the location of the control’s picture relative to its caption. |
| ControlPictureSizeMode | Utility class containing constants. Represents how to display the picture. |
| ControlScrollBarType | Utility class containing constants. Represents the type of scroll bar. |
| ControlScrollOrientation | Utility class containing constants. Represents type of scroll orientation |
| ControlSpecialEffectType | Utility class containing constants. Represents the type of special effect. |
| ControlType | Utility class containing constants. Represents all type of ActiveX control. |
| CopyFormatType | Utility class containing constants. Represents type of copying format when inserting rows. |
| CountryCode | Utility class containing constants. Represents Excel country identifiers. |
| CredentialsMethodType | Utility class containing constants. Specifies Credentials method used for server access. |
| CrossType | Utility class containing constants. Represents the axis cross type. |
| DataBarAxisPosition | Utility class containing constants. Specifies the axis position for a range of cells with conditional formatting as data |
| DataBarBorderType | Utility class containing constants. Specifies the border type of a data bar. |
| DataBarFillType | Utility class containing constants. Specifies how a data bar is filled with color. |
| DataBarNegativeColorType | Utility class containing constants. Specifies whether to use the same border and fill color as positive data bars. |
| DataBarRenderMode | Utility class containing constants. |
| DataLabelShapeType | Utility class containing constants. Specifies the preset shape geometry that is to be used for a chart. |
| DataLabelsSeparatorType | Utility class containing constants. Represents the separator type of DataLabels. |
| DateTimeGroupingType | Utility class containing constants. Specifies how to group dateTime values. |
| DefaultEditLanguage | Utility class containing constants. Represents the default edit language. |
| DirectoryType | Utility class containing constants. Represents the directory type of the file name. |
| DisplayDrawingObjects | Utility class containing constants. Represents whether and how to show objects in the workbook. |
| DisplayUnitType | Utility class containing constants. Represents the type of display unit of chart’s axis. |
| DropButtonStyle | Utility class containing constants. Represents the symbol displayed on the drop button. |
| DynamicFilterType | Utility class containing constants. Dynamic filter type. |
| EmfRenderSetting | Utility class containing constants. Setting for rendering Emf metafile. |
| EncryptionType | Utility class containing constants. Encryption Type. Only used by excel2003. We will encrypt 2007/2010 workbook using SH |
| EquationCharacterPositionType | Utility class containing constants. Specifies the position of a particular subobject within its parent |
| EquationCombiningCharacterType | Utility class containing constants. Type of combining characters. |
| EquationDelimiterShapeType | Utility class containing constants. This specifies the shape of delimiters in the delimiter object. |
| EquationFractionType | Utility class containing constants. This specifies the display style of the fraction bar. |
| EquationHorizontalJustificationType | Utility class containing constants. This specifies the default horizontal justification of equations in the document. |
| EquationLimitLocationType | Utility class containing constants. Specifies the limit location on an operator. |
| EquationMathematicalOperatorType | Utility class containing constants. Mathematical Operators Type |
| EquationNodeType | Utility class containing constants. Equation node type. Notice: (1)[1-99] Currently there is only one node in the scope, |
| EquationVerticalJustificationType | Utility class containing constants. This specifies the default vertical justification of equations in the document. |
| ErrorBarDisplayType | Utility class containing constants. Represents error bar display type. |
| ErrorBarType | Utility class containing constants. Represents error bar amount type. |
| ErrorCellValueType | Utility class containing constants. |
| ErrorCheckType | Utility class containing constants. Represents all error check type. |
| ExceptionType | Utility class containing constants. Represents custom exception type code. |
| ExternalConnectionClassType | Utility class containing constants. |
| ExternalLinkType | Utility class containing constants. Represents the type of external link. |
| FileFormatType | Utility class containing constants. Represents the file format types. |
| FillPattern | Utility class containing constants. Enumerates shape fill pattern types. |
| FillPictureType | Utility class containing constants. Represents the picture fill type. |
| FillType | Utility class containing constants. Fill format type. |
| FilterCategory | Utility class containing constants. |
| FilterOperatorType | Utility class containing constants. Custom Filter operator type. |
| FilterType | Utility class containing constants. The filter type. |
| FilterValueType | Utility class containing constants. |
| FontFileFormatType | Utility class containing constants. |
| FontSchemeType | Utility class containing constants. Represents the scheme type of the font. |
| FontSourceType | Utility class containing constants. Specifies the type of a font source. |
| FontUnderlineType | Utility class containing constants. Enumerates the font underline types. |
| FormatConditionType | Utility class containing constants. Conditional format rule type. |
| FormatConditionValueType | Utility class containing constants. Condition value type. |
| FormatSetType | Utility class containing constants. Fill format set type. |
| FormattingType | Utility class containing constants. Represents the type of formatting applied to an Area object or a Line object. |
| GradientColorType | Utility class containing constants. Represents the gradient color type for the specified fill. |
| GradientDirectionType | Utility class containing constants. Represents all direction type of gradient. |
| GradientFillType | Utility class containing constants. Represents all Gradient fill type. |
| GradientPresetType | Utility class containing constants. Represents gradient preset color type. |
| GradientStyleType | Utility class containing constants. Represents gradient shading style. |
| GridlineType | Utility class containing constants. Enumerates grid line Type. |
| HeaderFooterCommandType | Utility class containing constants. Represents the command type of header and footer. |
| HtmlCrossType | Utility class containing constants. Represents five types of html cross string. |
| HtmlEmbeddedFontType | Utility class containing constants. |
| HtmlExportDataOptions | Utility class containing constants. Represents the options for exporting html data. |
| HtmlFormatHandlingType | Utility class containing constants. Specifies how to handle formatting from the HTML source |
| HtmlHiddenColDisplayType | Utility class containing constants. Represents two types of showing the hidden columns in html. |
| HtmlHiddenRowDisplayType | Utility class containing constants. Represents two types of showing the hidden rows in html. |
| HtmlLayoutMode | Utility class containing constants. |
| HtmlLinkTargetType | Utility class containing constants. Represents the type of target attribute in HTML tag. |
| HtmlOfficeMathOutputType | Utility class containing constants. |
| HtmlParagraphLayoutMode | Utility class containing constants. |
| HtmlSpaceMode | Utility class containing constants. |
| HtmlVersion | Utility class containing constants. |
| HyperlinkLoadMode | Utility class containing constants. |
| IconSetType | Utility class containing constants. Icon set type for conditional formatting. The threshold values for triggering the di |
| ImageBinarizationMethod | Utility class containing constants. Specifies the method used to binarize image. |
| ImageType | Utility class containing constants. Specifies the type (format) of an image. |
| InputMethodEditorMode | Utility class containing constants. Represents the default run-time mode of the Input Method Editor. |
| ItemsWithNoDataShowMode | Utility class containing constants. |
| JsonExportHyperlinkType | Utility class containing constants. Represents type of exporting hyperlinks to json. |
| LabelPositionType | Utility class containing constants. Represents data label position type. |
| LegendPositionType | Utility class containing constants. Enumerates the legend position types. |
| LightRigDirectionType | Utility class containing constants. Represents the light rig direction type. |
| LightRigType | Utility class containing constants. Represents a preset light right that can be applied to a shape |
| LineCapType | Utility class containing constants. Represents the caps of a line |
| LineJoinType | Utility class containing constants. Represents the join styles of a line. |
| LineSpaceSizeType | Utility class containing constants. Represents the unit type of line space size. |
| LineType | Utility class containing constants. Enumerates the type of Picture border or Chart line. |
| LoadDataFilterOptions | Utility class containing constants. Represents the options to filter data when loading workbook from template. |
| LoadFormat | Utility class containing constants. Represents the load file format. |
| LoadNumbersTableType | Utility class containing constants. Indicates type of loading tables when some tables are in a sheet. |
| LookAtType | Utility class containing constants. Represents look at type. |
| LookInType | Utility class containing constants. Represents look in type. |
| MapChartLabelLayout | Utility class containing constants. Represents the layout of map chart’s labels. |
| MapChartProjectionType | Utility class containing constants. Represents projection type of the map chart. |
| MapChartRegionType | Utility class containing constants. Represents the region type of the map chart. |
| MemorySetting | Utility class containing constants. Memory usage options. |
| MergeEmptyTdType | Utility class containing constants. Represents the merge type for empty TD element when exporting file to html. |
| MergedCellsShrinkType | Utility class containing constants. |
| MetadataType | Utility class containing constants. Represents the type of metadata. |
| MirrorType | Utility class containing constants. Represents mirror type of texture fill |
| MsoArrowheadLength | Utility class containing constants. Enumerates the line end width of the shape border line. |
| MsoArrowheadStyle | Utility class containing constants. Enumerates the line end type of the shape border line. |
| MsoArrowheadWidth | Utility class containing constants. Enumerates the line end width of the shape border line. |
| MsoDrawingType | Utility class containing constants. Represents office drawing objects type. |
| MsoLineDashStyle | Utility class containing constants. Represents style of dash drawing lines. |
| MsoLineStyle | Utility class containing constants. Represents style of drawing lines. |
| MsoPresetTextEffect | Utility class containing constants. Represents preset text effect type of WordArt. |
| MsoPresetTextEffectShape | Utility class containing constants. Represents preset text effect shape type of WordArt. |
| NameScopeType | Utility class containing constants. Represents the scope type of defined names. |
| NumberCategoryType | Utility class containing constants. Represents category type of cell’s number formatting. |
| OLEDBCommandType | Utility class containing constants. Specifies the OLE DB command type. |
| OdsCellFieldType | Utility class containing constants. Represents the cell field type of ods. |
| OdsGeneratorType | Utility class containing constants. Represents the type of ODS generator. |
| OdsPageBackgroundGraphicPositionType | Utility class containing constants. Represents the position. |
| OdsPageBackgroundGraphicType | Utility class containing constants. Represents the type of formatting page background with image. |
| OdsPageBackgroundType | Utility class containing constants. Represents the page background type of ods. |
| OoxmlCompliance | Utility class containing constants. Allows to specify which OOXML specification will be used when saving in the Xlsx for |
| OoxmlCompressionType | Utility class containing constants. The Ooxml compression type |
| OpenDocumentFormatVersionType | Utility class containing constants. Open Document Format version type. |
| OperatorType | Utility class containing constants. Represents the operator type of conditional format and data validation. |
| PageLayoutAlignmentType | Utility class containing constants. Enumerates page layout alignment types. |
| PageOrientationType | Utility class containing constants. Represents print orientation constants. |
| PaneStateType | Utility class containing constants. Represents state of the sheet’s pane. |
| PaperSizeType | Utility class containing constants. Represents paper size constants. |
| ParameterType | Utility class containing constants. Represents all parameters’ type or return value type of function. |
| PasteOperationType | Utility class containing constants. Represents operation type when pasting range. |
| PasteType | Utility class containing constants. Represents the paste special type. |
| PdfCompliance | Utility class containing constants. Allowing user to set PDF conversion’s Compatibility |
| PdfCompressionCore | Utility class containing constants. Specifies a type of compression applied to all content in the PDF file except images |
| PdfCustomPropertiesExport | Utility class containing constants. Specifies the way CustomDocumentPropertyCollection are exported to PDF file. |
| PdfFontEncoding | Utility class containing constants. Represents pdf embedded font encoding. |
| PdfOptimizationType | Utility class containing constants. Specifies a type of optimization. |
| PdfZoomBehavior | Utility class containing constants. |
| PivotAreaType | Utility class containing constants. Indicates the type of rule being used to describe an area or aspect of the PivotTabl |
| PivotConditionFormatRuleType | Utility class containing constants. Represents PivotTable condition formatting rule type. |
| PivotConditionFormatScopeType | Utility class containing constants. Represents PivotTable condition formatting scope type. |
| PivotFieldDataDisplayFormat | Utility class containing constants. Represents data display format in the PivotTable data field. |
| PivotFieldGroupType | Utility class containing constants. Represents the group type of pivot field. |
| PivotFieldSubtotalType | Utility class containing constants. Summary description for PivotFieldSubtotalType. |
| PivotFieldType | Utility class containing constants. Represents PivotTable field type. |
| PivotFilterType | Utility class containing constants. Represents PivotTable Filter type. |
| PivotGroupByType | Utility class containing constants. Represents group by type. |
| PivotItemPosition | Utility class containing constants. Represents PivotTable base item Next/Previous/All position in the base field . |
| PivotItemPositionType | Utility class containing constants. Represents the position type of the pivot base item in the base field when the ShowD |
| PivotLineType | Utility class containing constants. |
| PivotMissingItemLimitType | Utility class containing constants. Represents number of items to retain per field. |
| PivotRefreshState | Utility class containing constants. |
| PivotTableAutoFormatType | Utility class containing constants. Represents PivotTable auto format type. |
| PivotTableSelectionType | Utility class containing constants. Specifies what can be selected in a PivotTable during a structured selection. These |
| PivotTableSourceType | Utility class containing constants. Represents the pivot table data source type. |
| PivotTableStyleType | Utility class containing constants. Represents the pivot table style type. |
| PlacementType | Utility class containing constants. Represents the way the drawing object is attached to the cells below it. |
| PlotDataByType | Utility class containing constants. Represents the type of data plot by row or column. |
| PlotEmptyCellsType | Utility class containing constants. Represents all plot empty cells type of a chart. |
| PowerQueryFormulaItemType | Utility class containing constants. |
| PowerQueryFormulaType | Utility class containing constants. |
| PresetCameraType | Utility class containing constants. Represent different algorithmic methods for setting all camera properties, including |
| PresetMaterialType | Utility class containing constants. Describes surface appearance of a shape. |
| PresetShadowType | Utility class containing constants. Represents preset shadow type. |
| PresetThemeGradientType | Utility class containing constants. Represents the preset theme gradient type. |
| PresetWordArtStyle | Utility class containing constants. Represents the preset WordArt styles. |
| PrintCommentsType | Utility class containing constants. Represents the way comments are printed with the sheet. |
| PrintErrorsType | Utility class containing constants. Represents print errors constants. |
| PrintOrderType | Utility class containing constants. Represent print order constants. |
| PrintSizeType | Utility class containing constants. Represents the printed chart size. |
| PrintingPageType | Utility class containing constants. Indicates which pages will not be printed. |
| PropertyType | Utility class containing constants. Specifies data type of a document property. |
| ProtectionType | Utility class containing constants. Represents workbook/worksheet protection type. |
| QuartileCalculationType | Utility class containing constants. Represents quartile calculation methods. |
| ReConnectionMethodType | Utility class containing constants. Specifies what the spreadsheet application should do when a connection fails. |
| RectangleAlignmentType | Utility class containing constants. Represents how to position two rectangles relative to each other. |
| ReflectionEffectType | Utility class containing constants. Represents the effect type of reflection. |
| RenameStrategy | Utility class containing constants. Strategy option for duplicate names of columns. When processing data with headers, s |
| ReserveMissingPivotItemType | Utility class containing constants. Represents how to keep the missing pivot items. |
| ResourceLoadingType | Utility class containing constants. Represents how to loading the linked resource. |
| RevisionActionType | Utility class containing constants. Represents the type of revision action. |
| RevisionType | Utility class containing constants. Represents the revision type. |
| SaveElementType | Utility class containing constants. |
| SaveFormat | Utility class containing constants. Represents the format in which the workbook is saved. |
| SelectionType | Utility class containing constants. The selection type of list box. |
| ShapeAnchorType | Utility class containing constants. Represents the anchor type. |
| ShapeDisplayType | Utility class containing constants. |
| ShapeLockType | Utility class containing constants. Represents type of the property to be locked. |
| ShapePathPointValueType | Utility class containing constants. |
| ShapePathType | Utility class containing constants. Represents path segment type. |
| ShapeTextVerticalAlignmentType | Utility class containing constants. |
| SheetType | Utility class containing constants. Specifies the worksheet type. |
| ShiftType | Utility class containing constants. Represent the shift options when deleting a range of cells. |
| ShowDropButtonType | Utility class containing constants. Specifies when to show the drop button |
| SignatureType | Utility class containing constants. |
| SignificantDigitsType | Utility class containing constants. |
| SlicerCacheCrossFilterType | Utility class containing constants. Represent the type of SlicerCacheCrossFilterType |
| SlicerStyleType | Utility class containing constants. Specify the style of slicer view |
| SlideViewType | Utility class containing constants. Represents the type when exporting to slides. |
| SmartTagShowType | Utility class containing constants. Represents the show type of the smart tag. |
| SortOnType | Utility class containing constants. Sorted value type. |
| SortOrder | Utility class containing constants. Represents sort order for the data range. |
| SparklineAxisMinMaxType | Utility class containing constants. Represents the minimum and maximum value types for the sparkline vertical axis. |
| SparklinePresetStyleType | Utility class containing constants. Represents the preset style types for sparkline. |
| SparklineType | Utility class containing constants. Represents the sparkline types. |
| SqlDataType | Utility class containing constants. Specifies SQL data type of the parameter. Only valid for ODBC sources. |
| SqlScriptOperatorType | Utility class containing constants. Represents the type of operating data. |
| StyleModifyFlag | Utility class containing constants. The style modified flags. |
| SvgEmbeddedFontType | Utility class containing constants. |
| TableDataSourceType | Utility class containing constants. Represents the table’s data source type. |
| TableStyleElementType | Utility class containing constants. Represents the Table or PivotTable style element type. |
| TableStyleType | Utility class containing constants. Represents the built-in table style type. |
| TargetModeType | Utility class containing constants. Represents the type of target mode. |
| TextAlignmentType | Utility class containing constants. Enumerates text alignment types. |
| TextAutonumberScheme | Utility class containing constants. Represents all automatic number scheme. |
| TextCapsType | Utility class containing constants. This type specifies the cap types of the text. |
| TextCrossType | Utility class containing constants. Enumerates displaying text type when the text width is larger than cell width. |
| TextDirectionType | Utility class containing constants. Represents the direction of the text flow for this paragraph. |
| TextFontAlignType | Utility class containing constants. Represents the different types of font alignment. |
| TextNodeType | Utility class containing constants. Represents the node type. |
| TextOrientationType | Utility class containing constants. Enumerates text orientation types. |
| TextOverflowType | Utility class containing constants. Represents the way the text vertical or horizontal overflow. |
| TextStrikeType | Utility class containing constants. This type specifies the strike type. |
| TextTabAlignmentType | Utility class containing constants. Represents the text tab alignment types. |
| TextVerticalType | Utility class containing constants. Represents the text direct type. |
| TextureType | Utility class containing constants. Represents the preset texture type. |
| ThemeColorType | Utility class containing constants. Enumerates the theme color types. |
| TickLabelAlignmentType | Utility class containing constants. Represents the text alignment type for the tick labels on the axis |
| TickLabelPositionType | Utility class containing constants. Represents the position type of tick-mark labels on the specified axis. |
| TickMarkType | Utility class containing constants. Represents the tick mark type for the specified axis. |
| TiffCompression | Utility class containing constants. Specifies what type of compression to apply when saving images into TIFF format file |
| TimePeriodType | Utility class containing constants. Used in a FormatConditionType.TimePeriod conditional formatting rule. These are dyna |
| TimeUnit | Utility class containing constants. Represents the base unit for the category axis. |
| TimelineLevelType | Utility class containing constants. |
| TotalsCalculation | Utility class containing constants. Determines the type of calculation in the Totals row of the list column. |
| TrendlineType | Utility class containing constants. Represents the trendline type. |
| TxtLoadStyleStrategy | Utility class containing constants. Specifies how to apply style for parsed values when converting string value to numbe |
| TxtValueQuoteType | Utility class containing constants. Specifies the type of using quotation marks for values in text format files. |
| UpdateLinksType | Utility class containing constants. Represents how to update links to other workbooks when the workbook is opened. |
| ValidationAlertType | Utility class containing constants. Represents the data validation alert style. |
| ValidationType | Utility class containing constants. Represents data validation type. |
| VbaModuleType | Utility class containing constants. Represents the type of VBA module. |
| VbaProjectReferenceType | Utility class containing constants. Represents the type of VBA project reference. |
| ViewType | Utility class containing constants. Represents the view type of the worksheet. |
| VisibilityType | Utility class containing constants. Represents the states for sheet visibility. |
| WebExtensionStoreType | Utility class containing constants. Represents the store type of web extension. |
| WeightType | Utility class containing constants. Enumerates the weight types for a picture border or a chart line. |
| XAdESType | Utility class containing constants. Type of XML Advanced Electronic Signature (XAdES). |