Namespaces
	Charts

	DigitalSignatures

	Drawing

	Metadata

	Pivot

	Properties

	Rendering

	Tables

	Vba

Classes
class	CellsException

class	Factory
	If you need new an object in Client-Side code, you can call the following static method to create related object. More...

class	IAboveAverage
	Describe the AboveAverage conditional formatting rule. This conditional formatting rule highlights cells that are above or below the average for all values in the range. More...

class	IAutoFilter
	Represents auto filtering for the specified worksheet. More...

class	IAutoFitterOptions
	Represents all auto fitter options. More...

class	IBorder
	Encapsulates the object that represents the cell border. More...

class	IBorderCollection
	Encapsulates a collection of IBorder objects. More...

class	ICalculationOptions
	Represents options for calculation. More...

class	ICell
	Encapsulates the object that represents a single Workbook cell. More...

class	ICellArea
	Represent an area of cells. More...

class	ICells
	Encapsulates a collection of ICell objects. More...

class	ICellsColor
	Represents all types of color. More...

class	ICellsHelper
	Provides helper functions. More...

class	IColorScale
	Describe the ColorScale conditional formatting rule. This conditional formatting rule creates a gradated color scale on the cells. More...

class	IColumn

class	IColumnCollection
	Collects the IColumn objects that represent the individual columns in a worksheet. More...

class	IComment
	Encapsulates the object that represents a cell comment. More...

class	ICommentCollection
	Encapsulates a collection of IComment objects. More...

class	IConditionalFormattingCollection
	Encapsulates a collection of FormatCondition objects. More...

class	IConditionalFormattingIcon
	Represents the custom icon of conditional formatting rule. More...

class	IConditionalFormattingIconCollection
	Represents a collection of IConditionalFormattingIcon objects. More...

class	IConditionalFormattingResult
	Represents the result of conditional formatting which applies to a cell. More...

class	IConditionalFormattingValue
	Describes the values of the interpolation points in a gradient scale, dataBar or iconSet. More...

class	IConditionalFormattingValueCollection
	Describes a collection of CFValueObject. Use only for icon sets. More...

class	ICopyOptions
	Represents the copy options. More...

class	ICustomFunction

class	IDataBar
	Describe the DataBar conditional formatting rule. This conditional formatting rule displays a gradated data bar in the range of cells. More...

class	IDataBarBorder
	Represents the border of the data bars specified by a conditional formatting rule. More...

class	IDataSorter
	Summary description for DataSorter. More...

class	IErrorCheckOption
	Error check setting applied on certain ranges. More...

class	IErrorCheckOptionCollection
	Represents all error check option. More...

class	IExternalLink
	Represents an external link in a workbook. More...

class	IExternalLinkCollection
	Represents external links collection in a workbook. More...

class	IFileFormatInfo
	Contains data returned by IFileFormatUtil file format detection methods. More...

class	IFileFormatUtil
	Provides utility methods for working with file formats, such as detecting file format or converting file extensions to/from file format enums. More...

class	IFilterColumn
	Represents a filter for a single column. The Filter object is a member of the Filters collection More...

class	IFilterColumnCollection
	A collection of Filter objects that represents all the filters in an autofiltered range. More...

class	IFindOptions
	Represents find options. More...

class	IFont
	Encapsulates the font object used in a spreadsheet. More...

class	IFontSetting
	Represents a range of characters within the cell text. More...

class	IFormatCondition
	Represents conditional formatting condition. More...

class	IFormatConditionCollection
	Represents conditional formatting. The FormatConditions can contain up to three conditional formats. More...

class	IHeaderFooterCommand
	Represents the command of header/footer More...

class	IHorizontalPageBreak
	Encapsulates the object that represents a horizontal page break. More...

class	IHorizontalPageBreakCollection
	Encapsulates a collection of IHorizontalPageBreak objects. More...

class	IHtmlSaveOptions
	Represents the options for saving html file. More...

class	IHyperlink
	Encapsulates the object that represents a hyperlink. More...

class	IHyperlinkCollection
	Encapsulates a collection of IHyperlink objects. More...

class	IIconSet
	Describe the IconSet conditional formatting rule. This conditional formatting rule applies icons to cells according to their values. More...

class	ILightCellsDataHandler
	Represents cells data handler for reading large spreadsheet files in light weight mode. More...

class	ILightCellsDataProvider
	Represents Data provider for saving large spreadsheet files in light weight mode. More...

class	ILoadDataOption
	The load data options. More...

class	ILoadOptions
	Represents the options of loading the file. More...

class	IName
	Represents a defined name for a range of cells. More...

class	INameCollection
	Represents a collection of all the IName objects in the spreadsheet. More...

class	INegativeBarFormat
	Represents the color settings of the data bars for negative values that are defined by a data bar conditional formatting rule. More...

class	IOoxmlSaveOptions
	Represents the options of saving office open xml file. More...

class	IOutline
	Represents an outline on a worksheet. More...

class	IPageSetup
	Encapsulates the object that represents the page setup description. The IPageSetup object contains all page setup options. More...

class	IPaneCollection
	Represents all Pane objects shown in the specified window. More...

class	IPasteOptions
	Represents the paste special options. More...

class	IPdfSaveOptions
	Represents the options for saving pdf file. More...

class	IProtectedRange
	A specified range to be allowed to edit when the sheet protection is ON. More...

class	IProtectedRangeCollection
	Encapsulates a collection of IProtectedRange objects. More...

class	IProtection
	Represents the various types of protection options available for a worksheet. Only used in ExcelXP and above version. More...

class	IRange
	Encapsulates the object that represents a range of cells within a spreadsheet. More...

class	IRangeCollection
	Encapsulates a collection of IRange objects. More...

class	IReferredArea
	Represents a referred area by the formula. More...

class	IReferredAreaCollection
	Represents all referred cells and areas. More...

class	IReplaceOptions
	Represent the replace options. More...

class	IRow
	Represents a single row in a worksheet. More...

class	IRowCollection
	Collects the IRow objects that represent the individual rows in a worksheet. More...

class	ISaveOptions
	Represents all save options More...

class	IScenario
	Represents an individual scenario. More...

class	IScenarioCollection
	Represents the list of scenarios. More...

class	IScenarioInputCell
	Represents input cell for the scenario. More...

class	IScenarioInputCellCollection
	Represents the list of the scenario's input cells. More...

class	ISpreadsheetML2003SaveOptions
	Represents the options for saving Excel 2003 spreadml file. More...

class	IStyle
	Represents display style of excel document, such as font, color, alignment, border, etc. More...

class	IStyleFlag
	Represents flags which indicates applied formatting properties. More...

class	IThemeColor
	Represents a theme color. More...

class	ITop10
	Describe the Top10 conditional formatting rule. This conditional formatting rule highlights cells whose values fall in the top N or bottom N bracket, as specified. More...

class	ITxtLoadOptions
	Represents the options for loading text file. More...

class	ITxtSaveOptions
	Repesents the save options for csv/tab delimitered/other text format. More...

class	IValidation
	Represents data validation settings. More...

class	IValidationCollection
	Represents data validation collection. More...

class	IVerticalPageBreak
	Encapsulates the object that represents a vertical page break. More...

class	IVerticalPageBreakCollection
	Encapsulates a collection of IVerticalPageBreak objects. More...

class	IWorkbook
	Represents a root object to create an Excel spreadsheet. More...

class	IWorkbookDesigner
	Encapsulates the object that represents a designer spreadsheet. More...

class	IWorkbookSettings
	Represents all settings of the workbook. More...

class	IWorksheet
	Encapsulates the object that represents a single worksheet. More...

class	IWorksheetCollection
	Encapsulates a collection of IWorksheet objects. More...

class	IWriteProtection
	Specifies write protection settings for a workbook. More...

class	IXlsbSaveOptions
	Represents the options for saving xlsb file. More...

class	IXlsSaveOptions
	Represents the save options for the Excel 97-2003 file format: xls and xlt. More...

class	License

Enumerations
enum	BackgroundType { BackgroundType_DiagonalCrosshatch = 9, BackgroundType_DiagonalStripe = 8, BackgroundType_Gray6 = 18, BackgroundType_Gray12 = 17, BackgroundType_Gray25 = 4, BackgroundType_Gray50 = 2, BackgroundType_Gray75 = 3, BackgroundType_HorizontalStripe = 5, BackgroundType_None = 0, BackgroundType_ReverseDiagonalStripe = 7, BackgroundType_Solid = 1, BackgroundType_ThickDiagonalCrosshatch = 10, BackgroundType_ThinDiagonalCrosshatch = 16, BackgroundType_ThinDiagonalStripe = 14, BackgroundType_ThinHorizontalCrosshatch = 15, BackgroundType_ThinHorizontalStripe = 11, BackgroundType_ThinReverseDiagonalStripe = 13, BackgroundType_ThinVerticalStripe = 12, BackgroundType_VerticalStripe = 6 }
	Enumerates cell background pattern types. More...

enum	BorderType { BorderType_BottomBorder = 8, BorderType_DiagonalDown = 0x10, BorderType_DiagonalUp = 0x20, BorderType_LeftBorder = 1, BorderType_RightBorder = 2, BorderType_TopBorder = 4, BorderType_Horizontal = 0x80, BorderType_Vertical = 0x40 }
	Enumerates the border line and diagonal line types. More...

enum	BuiltinStyleType { BuiltinStyleType_TwentyPercentAccent1 = 30, BuiltinStyleType_TwentyPercentAccent2 = 34, BuiltinStyleType_TwentyPercentAccent3 = 38, BuiltinStyleType_TwentyPercentAccent4 = 42, BuiltinStyleType_TwentyPercentAccent5 = 46, BuiltinStyleType_TwentyPercentAccent6 = 50, BuiltinStyleType_FortyPercentAccent1 = 31, BuiltinStyleType_FortyPercentAccent2 = 35, BuiltinStyleType_FortyPercentAccent3 = 39, BuiltinStyleType_FortyPercentAccent4 = 43, BuiltinStyleType_FortyPercentAccent5 = 47, BuiltinStyleType_FortyPercentAccent6 = 51, BuiltinStyleType_SixtyPercentAccent1 = 32, BuiltinStyleType_SixtyPercentAccent2 = 36, BuiltinStyleType_SixtyPercentAccent3 = 40, BuiltinStyleType_SixtyPercentAccent4 = 44, BuiltinStyleType_SixtyPercentAccent5 = 48, BuiltinStyleType_SixtyPercentAccent6 = 52, BuiltinStyleType_Accent1 = 29, BuiltinStyleType_Accent2 = 33, BuiltinStyleType_Accent3 = 37, BuiltinStyleType_Accent4 = 41, BuiltinStyleType_Accent5 = 45, BuiltinStyleType_Accent6 = 49, BuiltinStyleType_Bad = 27, BuiltinStyleType_Calculation = 22, BuiltinStyleType_CheckCell = 23, BuiltinStyleType_Comma = 3, BuiltinStyleType_Comma1 = 6, BuiltinStyleType_Currency = 4, BuiltinStyleType_Currency1 = 7, BuiltinStyleType_ExplanatoryText = 53, BuiltinStyleType_Good = 26, BuiltinStyleType_Header1 = 16, BuiltinStyleType_Header2 = 17, BuiltinStyleType_Header3 = 18, BuiltinStyleType_Header4 = 19, BuiltinStyleType_Hyperlink = 8, BuiltinStyleType_FollowedHyperlink = 9, BuiltinStyleType_Input = 20, BuiltinStyleType_LinkedCell = 24, BuiltinStyleType_Neutral = 28, BuiltinStyleType_Normal = 0, BuiltinStyleType_Note = 10, BuiltinStyleType_Output = 21, BuiltinStyleType_Percent = 5, BuiltinStyleType_Title = 15, BuiltinStyleType_Total = 25, BuiltinStyleType_WarningText = 11, BuiltinStyleType_RowLevel = 1, BuiltinStyleType_ColumnLevel = 2 }
	Represents all built-in style type More...

enum	CalcModeType { CalcModeType_Automatic, CalcModeType_AutomaticExceptTable, CalcModeType_Manual }
	Represents the mode type of calculating formulas. More...

enum	CalculationPrecisionStrategy { CalculationPrecisionStrategy_None, CalculationPrecisionStrategy_Round, CalculationPrecisionStrategy_Decimal }
	Enumerates strategies for handling calculation precision. Because of the precision issue of IEEE 754 Floating-Point Arithmetic, some "seemingly simple" formulas may not be calculated as the expected result. Such as formula "=-0.45+0.43+0.02", when calculating operands by '+' operator directly, the result is not zero. For such kind of precision issue, some special strategies may give the expected result. More...

enum	CellBorderType { CellBorderType_DashDot = 9, CellBorderType_DashDotDot = 11, CellBorderType_Dashed = 3, CellBorderType_Dotted = 4, CellBorderType_Double = 6, CellBorderType_Hair = 7, CellBorderType_MediumDashDot = 10, CellBorderType_MediumDashDotDot = 12, CellBorderType_MediumDashed = 8, CellBorderType_None = 0, CellBorderType_Medium = 2, CellBorderType_SlantedDashDot = 13, CellBorderType_Thick = 5, CellBorderType_Thin = 1 }
	Enumerates a cell's border type. More...

enum	CellValueFormatStrategy { CellValueFormatStrategy_None, CellValueFormatStrategy_CellStyle, CellValueFormatStrategy_DisplayStyle, CellValueFormatStrategy_DisplayString }
	Specifies how to apply style for the value of the cell. More...

enum	CellValueType { CellValueType_IsUnknown = 0x00, CellValueType_IsNull = 0x01, CellValueType_IsNumeric = 0x02, CellValueType_IsDateTime = 0x04, CellValueType_IsString = 0x08, CellValueType_IsBool = 0x10, CellValueType_IsError = 0x20 }
	Specifies a cell value type. More...

enum	ColorType { ColorType_Automatic, ColorType_AutomaticIndex, ColorType_RGB, ColorType_IndexedColor, ColorType_Theme }
	Represents all color type More...

enum	ConsolidationFunction { ConsolidationFunction_Sum = 0, ConsolidationFunction_Count = 1, ConsolidationFunction_Average = 2, ConsolidationFunction_Max = 3, ConsolidationFunction_Min = 4, ConsolidationFunction_Product = 5, ConsolidationFunction_CountNums = 6, ConsolidationFunction_StdDev = 7, ConsolidationFunction_StdDevp = 8, ConsolidationFunction_Var = 9, ConsolidationFunction_Varp = 10, ConsolidationFunction_DistinctCount }
	Represents consolidation function. More...

enum	CountryCode { CountryCode_Default = 0, CountryCode_USA = 1, CountryCode_Canada = 2, CountryCode_LatinAmeric = 3, CountryCode_Russia = 7, CountryCode_Egypt = 20, CountryCode_Greece = 30, CountryCode_Netherlands = 31, CountryCode_Belgium = 32, CountryCode_France = 33, CountryCode_Spain = 34, CountryCode_Hungary = 36, CountryCode_Italy = 39, CountryCode_Switzerland = 41, CountryCode_Austria = 43, CountryCode_UnitedKingdom = 44, CountryCode_Denmark = 45, CountryCode_Sweden = 46, CountryCode_Norway = 47, CountryCode_Poland = 48, CountryCode_Germany = 49, CountryCode_Mexico = 52, CountryCode_Brazil = 55, CountryCode_Australia = 61, CountryCode_NewZealand = 64, CountryCode_Thailand = 66, CountryCode_Japan = 81, CountryCode_SouthKorea = 82, CountryCode_VietNam = 84, CountryCode_China = 86, CountryCode_Turkey = 90, CountryCode_India = 91, CountryCode_Algeria = 213, CountryCode_Morocco = 216, CountryCode_Libya = 218, CountryCode_Portugal = 351, CountryCode_Iceland = 354, CountryCode_Finland = 358, CountryCode_Czech = 420, CountryCode_Taiwan = 886, CountryCode_Lebanon = 961, CountryCode_Jordan = 962, CountryCode_Syria = 963, CountryCode_Iraq = 964, CountryCode_Kuwait = 965, CountryCode_Saudi = 966, CountryCode_UnitedArabEmirates = 971, CountryCode_Israel = 972, CountryCode_Qatar = 974, CountryCode_Iran = 981 }
	Represents Excel country identifiers. More...

enum	DataBarAxisPosition { DataBarAxisPosition_Automatic = 0, DataBarAxisPosition_Midpoint = 1, DataBarAxisPosition_None = 2 }
	Specifies the axis position for a range of cells with conditional formatting as data bars. More...

enum	DataBarBorderType { DataBarBorderType_None = 0, DataBarBorderType_Solid = 1 }
	Specifies the border type of a data bar. More...

enum	DataBarFillType { DataBarFillType_Solid = 0, DataBarFillType_Gradient = 1 }
	Specifies how a data bar is filled with color. More...

enum	DataBarNegativeColorType { DataBarNegativeColorType_Color = 0, DataBarNegativeColorType_SameAsPositive = 1 }
	Specifies whether to use the same border and fill color as positive data bars. More...

enum	DateTimeGroupingType { DateTimeGroupingType_Day, DateTimeGroupingType_Hour, DateTimeGroupingType_Minute, DateTimeGroupingType_Month, DateTimeGroupingType_Second, DateTimeGroupingType_Year }
	Specifies how to group dateTime values. More...

enum	DirectoryType { DirectoryType_Volume, DirectoryType_SameVolume, DirectoryType_DownDirectory, DirectoryType_UpDirectory }
	Represents the directory type of the file name. More...

enum	DisplayDrawingObjects { DisplayDrawingObjects_DisplayShapes, DisplayDrawingObjects_Placeholders, DisplayDrawingObjects_Hide }
	Represents whether and how to show objects in the workbook. More...

enum	DynamicFilterType { DynamicFilterType_AboveAverage, DynamicFilterType_BelowAverage, DynamicFilterType_LastMonth, DynamicFilterType_LastQuarter, DynamicFilterType_LastWeek, DynamicFilterType_LastYear, DynamicFilterType_January, DynamicFilterType_October, DynamicFilterType_November, DynamicFilterType_December, DynamicFilterType_February, DynamicFilterType_March, DynamicFilterType_April, DynamicFilterType_May, DynamicFilterType_June, DynamicFilterType_July, DynamicFilterType_August, DynamicFilterType_September, DynamicFilterType_NextMonth, DynamicFilterType_NextQuarter, DynamicFilterType_NextWeek, DynamicFilterType_NextYear, DynamicFilterType_None, DynamicFilterType_Quarter1, DynamicFilterType_Quarter2, DynamicFilterType_Quarter3, DynamicFilterType_Quarter4, DynamicFilterType_ThisMonth, DynamicFilterType_ThisQuarter, DynamicFilterType_ThisWeek, DynamicFilterType_ThisYear, DynamicFilterType_Today, DynamicFilterType_Tomorrow, DynamicFilterType_YearToDate, DynamicFilterType_Yesterday }
	Dynamic filter type. More...

enum	EncryptionType { EncryptionType_XOR, EncryptionType_Compatible, EncryptionType_EnhancedCryptographicProviderV1, EncryptionType_StrongCryptographicProvider }
	Encryption Type. Only used by excel2003. We will encrypt 2007/2010 workbook using SHA AES the same as Excel does, and this EncryptionType will be ignored. More...

enum	ErrorCheckType { ErrorCheckType_Calc = 0x00000001, ErrorCheckType_EmptyCellRef = 0x00000002, ErrorCheckType_TextNumber = 0x00000004, ErrorCheckType_InconsistRange = 0x00000008, ErrorCheckType_InconsistFormula = 0x00000010, ErrorCheckType_TextDate = 0x00000020, ErrorCheckType_UnproctedFormula = 0x00000040, ErrorCheckType_Validation = 0x00000080, ErrorCheckType_CalculatedColumn }
	Represents all error check type. More...

enum	ErrorType { ErrorType_Div = 0x07, ErrorType_NA = 0x2A, ErrorType_Name = 0x1D, ErrorType_Null = 0, ErrorType_Number = 0x24, ErrorType_Ref = 0x17, ErrorType_Recursive = 0xFE, ErrorType_Value = 0x0F }
	Summary description for ErrorType. More...

enum	ExceptionType { ExceptionType_Chart, ExceptionType_DataType, ExceptionType_DataValidation, ExceptionType_ConditionalFormatting, ExceptionType_FileFormat, ExceptionType_Formula, ExceptionType_InvalidData, ExceptionType_InvalidOperator, ExceptionType_IncorrectPassword, ExceptionType_License, ExceptionType_Limitation, ExceptionType_PageSetup, ExceptionType_PivotTable, ExceptionType_Shape, ExceptionType_Sparkline, ExceptionType_SheetName, ExceptionType_SheetType, ExceptionType_Interrupted, ExceptionType_IO, ExceptionType_Permission, ExceptionType_UnsupportedFeature, ExceptionType_UnsupportedStream, ExceptionType_UndisclosedInformation, ExceptionType_FileCorrupted }
	Represents custom exception type code. More...

enum	ExternalCellValueType { ExternalCellValueType_Blank = 0, ExternalCellValueType_Number = 1, ExternalCellValueType_String = 2, ExternalCellValueType_Error = 3, ExternalCellValueType_Bool = 4 }

enum	FileFormatType { FileFormatType_Csv = 1, FileFormatType_Xlsx = 6, FileFormatType_Xlsm = 7, FileFormatType_Xltx = 8, FileFormatType_Xltm = 9, FileFormatType_Xlam = 10, FileFormatType_Tsv = 11, FileFormatType_TabDelimited = Aspose::Cells::FileFormatType_Tsv, FileFormatType_Html = 12, FileFormatType_MHtml = 17, FileFormatType_Ods = 14, FileFormatType_Excel97To2003 = 5, FileFormatType_SpreadsheetML = 15, FileFormatType_Xlsb = 16, FileFormatType_Unknown = 255, FileFormatType_Pdf = 13, FileFormatType_Xps = 20, FileFormatType_Tiff = 21, FileFormatType_Svg = 28, FileFormatType_Excel95 = 22, FileFormatType_Excel4 = 23, FileFormatType_Excel3 = 24, FileFormatType_Excel2 = 25, FileFormatType_Pptx = 26, FileFormatType_Docx = 27, FileFormatType_Dif = 30, FileFormatType_Doc = 31, FileFormatType_Ppt = 32, FileFormatType_MapiMessage = 33, FileFormatType_MsEquation = 34, FileFormatType_Ole10Native = 35, FileFormatType_Vsd = 36, FileFormatType_Vsdx = 37, FileFormatType_Docm = 38, FileFormatType_Dotx = 39, FileFormatType_Dotm = 40, FileFormatType_Pptm = 41, FileFormatType_Potx = 42, FileFormatType_Potm = 43, FileFormatType_Ppsx = 44, FileFormatType_Ppsm = 45, FileFormatType_Ooxml = 46, FileFormatType_Odt = 47, FileFormatType_Odp = 48, FileFormatType_Odf = 49, FileFormatType_Odg = 50, FileFormatType_Xml = 51, FileFormatType_Xlt = 52, FileFormatType_Ott = 53, FileFormatType_Bmp = 54, FileFormatType_Ots = 55, FileFormatType_Numbers = 56, FileFormatType_Numbers09 = 56, FileFormatType_Markdown = 57, FileFormatType_GraphChart = 58, FileFormatType_Fods = 59, FileFormatType_Sxc = 60, FileFormatType_Otp = 61, FileFormatType_Numbers35 = 62, FileFormatType_Emf = 0x102, FileFormatType_Wmf = 0x103, FileFormatType_Jpg = 0x105, FileFormatType_Png = 0x106, FileFormatType_Gif = 0x142, FileFormatType_Json = 0x201, FileFormatType_SqlScript = 0x202, FileFormatType_XHtml = 0x303, FileFormatType_OneNote = 0x304, FileFormatType_MicrosoftCabinet = 0x305, FileFormatType_Rtf = 0x306, FileFormatType_Epub = 0x307, FileFormatType_GZip = 0x8B1F }
	Represents the file format types. More...

enum	FilterOperatorType { FilterOperatorType_LessOrEqual, FilterOperatorType_LessThan, FilterOperatorType_Equal, FilterOperatorType_GreaterThan, FilterOperatorType_NotEqual, FilterOperatorType_GreaterOrEqual, FilterOperatorType_None, FilterOperatorType_BeginsWith, FilterOperatorType_EndsWith, FilterOperatorType_Contains, FilterOperatorType_NotContains }
	Custom Filter operator type. More...

enum	FontUnderlineType { FontUnderlineType_None = 0, FontUnderlineType_Single = 1, FontUnderlineType_Double = 2, FontUnderlineType_Accounting = 3, FontUnderlineType_DoubleAccounting = 4, FontUnderlineType_Dash = 5, FontUnderlineType_DashDotDotHeavy = 6, FontUnderlineType_DashDotHeavy = 7, FontUnderlineType_DashedHeavy = 8, FontUnderlineType_DashLong = 9, FontUnderlineType_DashLongHeavy = 0x0A, FontUnderlineType_DotDash = 0x0B, FontUnderlineType_DotDotDash = 0x0C, FontUnderlineType_Dotted = 0x0D, FontUnderlineType_DottedHeavy = 0x0E, FontUnderlineType_Heavy = 0x0F, FontUnderlineType_Wave = 0x10, FontUnderlineType_WavyDouble = 0x11, FontUnderlineType_WavyHeavy = 0x12, FontUnderlineType_Words = 0x13 }
	Enumerates the font underline types. More...

enum	FormatConditionType { FormatConditionType_CellValue, FormatConditionType_Expression, FormatConditionType_ColorScale, FormatConditionType_DataBar, FormatConditionType_IconSet, FormatConditionType_Top10, FormatConditionType_UniqueValues, FormatConditionType_DuplicateValues, FormatConditionType_ContainsText, FormatConditionType_NotContainsText, FormatConditionType_BeginsWith, FormatConditionType_EndsWith, FormatConditionType_ContainsBlanks, FormatConditionType_NotContainsBlanks, FormatConditionType_ContainsErrors, FormatConditionType_NotContainsErrors, FormatConditionType_TimePeriod, FormatConditionType_AboveAverage }
	Conditional format rule type. More...

enum	FormatConditionValueType { FormatConditionValueType_Formula, FormatConditionValueType_Max, FormatConditionValueType_Min, FormatConditionValueType_Number, FormatConditionValueType_Percent, FormatConditionValueType_Percentile, FormatConditionValueType_AutomaticMax, FormatConditionValueType_AutomaticMin }
	Condition value type. More...

enum	HeaderFooterCommandType { HeaderFooterCommandType_Text, HeaderFooterCommandType_CurrentPage, HeaderFooterCommandType_Pagecount, HeaderFooterCommandType_CurrentDate, HeaderFooterCommandType_CurrentTime, HeaderFooterCommandType_SheetName, HeaderFooterCommandType_FileName, HeaderFooterCommandType_FilePath, HeaderFooterCommandType_Picture }
	Represents the command type of header and footer. More...

enum	HtmlCrossType { HtmlCrossType_Default, HtmlCrossType_MSExport, HtmlCrossType_Cross, HtmlCrossType_CrossHideRight, HtmlCrossType_FitToCell }
	Represents five types of html cross string. More...

enum	HtmlExportDataOptions { HtmlExportDataOptions_Table = 0x01, HtmlExportDataOptions_All = 0xFF }
	Represents the options for exporting html data. More...

enum	HtmlHiddenColDisplayType { HtmlHiddenColDisplayType_Hidden, HtmlHiddenColDisplayType_Remove }
	Represents two types of showing the hidden columns in html. More...

enum	HtmlHiddenRowDisplayType { HtmlHiddenRowDisplayType_Hidden, HtmlHiddenRowDisplayType_Remove }
	Represents two types of showing the hidden rows in html. More...

enum	HtmlLinkTargetType { HtmlLinkTargetType_Blank, HtmlLinkTargetType_Parent, HtmlLinkTargetType_Self, HtmlLinkTargetType_Top }
	Represents the type of target attribute in HTML tag. More...

enum	IconSetType { IconSetType_Arrows3, IconSetType_ArrowsGray3, IconSetType_Flags3, IconSetType_Signs3, IconSetType_Symbols3, IconSetType_Symbols32, IconSetType_TrafficLights31, IconSetType_TrafficLights32, IconSetType_Arrows4, IconSetType_ArrowsGray4, IconSetType_Rating4, IconSetType_RedToBlack4, IconSetType_TrafficLights4, IconSetType_Arrows5, IconSetType_ArrowsGray5, IconSetType_Quarters5, IconSetType_Rating5, IconSetType_Stars3, IconSetType_Boxes5, IconSetType_Triangles3, IconSetType_None, IconSetType_CustomSet, IconSetType_Smilies3, IconSetType_ColorSmilies3 }
	Icon set type for conditional formatting. The threshold values for triggering the different icons within a set are configurable, and the icon order is reversible. More...

enum	LoadDataFilterOptions { LoadDataFilterOptions_None = 0x00000000, LoadDataFilterOptions_All = 0x7FFFFFFF, LoadDataFilterOptions_CellBlank = 0x00000001, LoadDataFilterOptions_CellString = 0x00000002, LoadDataFilterOptions_CellNumeric = 0x00000004, LoadDataFilterOptions_CellError = 0x00000008, LoadDataFilterOptions_CellBool = 0x00000010, LoadDataFilterOptions_CellValue = 0x0000001F, LoadDataFilterOptions_Formula = 0x00000020, LoadDataFilterOptions_CellData = 0x0400003F, LoadDataFilterOptions_Chart = 0x00000100, LoadDataFilterOptions_Shape = 0x18000200, LoadDataFilterOptions_Drawing = 0x18000300, LoadDataFilterOptions_MergedArea = 0x00000400, LoadDataFilterOptions_ConditionalFormatting = 0x00000800, LoadDataFilterOptions_DataValidation = 0x00001000, LoadDataFilterOptions_PivotTable = 0x00002000, LoadDataFilterOptions_Table = 0x00004000, LoadDataFilterOptions_Hyperlinks = 0x00008000, LoadDataFilterOptions_SheetSettings = 0x00010000, LoadDataFilterOptions_SheetData = 0x180FFFFF, LoadDataFilterOptions_BookSettings = 0x00100000, LoadDataFilterOptions_Settings = 0x00110000, LoadDataFilterOptions_XmlMap = 0x00200000, LoadDataFilterOptions_Structure = 0x00400000, LoadDataFilterOptions_DocumentProperties = 0x00800000, LoadDataFilterOptions_DefinedNames = 0x01000000, LoadDataFilterOptions_VBA = 0x02000000, LoadDataFilterOptions_Style = 0x04000000, LoadDataFilterOptions_Picture = 0x08000000, LoadDataFilterOptions_OleObject = 0x10000000, LoadDataFilterOptions_Revision = 0x20000000 }
	Represents the options to filter data when loading workbook from template. More...

enum	LoadFormat { LoadFormat_Auto, LoadFormat_Csv = 1, LoadFormat_CSV = 1, LoadFormat_Xlsx = 6, LoadFormat_Tsv = 11, LoadFormat_TSV = 11, LoadFormat_TabDelimited = Aspose::Cells::LoadFormat_Tsv, LoadFormat_Html = 12, LoadFormat_MHtml = 13, LoadFormat_Ods = 14, LoadFormat_ODS = 14, LoadFormat_Excel97To2003 = 5, LoadFormat_SpreadsheetML = 15, LoadFormat_Xlsb = 16, LoadFormat_Ots = 31, LoadFormat_Numbers = 56, LoadFormat_Fods = 59, LoadFormat_FODS = 59, LoadFormat_Sxc = 60, LoadFormat_SXC = 60, LoadFormat_Xml = 51, LoadFormat_Epub = 52, LoadFormat_Unknown = 255, LoadFormat_Image = 254, LoadFormat_Json = 0x201 }
	Represents the load file format. More...

enum	LookAtType { LookAtType_Contains, LookAtType_StartWith, LookAtType_EndWith, LookAtType_EntireContent }
	Represents look at type. More...

enum	LookInType { LookInType_Formulas, LookInType_Values, LookInType_ValuesExcludeFormulaCell, LookInType_Comments, LookInType_OnlyFormulas, LookInType_OriginalValues }
	Represents look in type. More...

enum	MemorySetting { MemorySetting_Normal, MemorySetting_MemoryPreference }
	Memory usage options. More...

enum	NumberCategoryType { NumberCategoryType_General, NumberCategoryType_Text, NumberCategoryType_Number, NumberCategoryType_Date, NumberCategoryType_Time, NumberCategoryType_Fraction, NumberCategoryType_Scientific }
	Represents category type of cell's number formatting. More...

enum	OperatorType { OperatorType_Between, OperatorType_Equal, OperatorType_GreaterThan, OperatorType_GreaterOrEqual, OperatorType_LessThan, OperatorType_LessOrEqual, OperatorType_None, OperatorType_NotBetween, OperatorType_NotEqual }
	Represents the operator type of conditional format and data validation. More...

enum	PageOrientationType { PageOrientationType_Landscape, PageOrientationType_Portrait }
	Represents print orientation constants. More...

enum	PaperSizeType { PaperSizeType_PaperLetter = 1, PaperSizeType_PaperLetterSmall = 2, PaperSizeType_PaperTabloid = 3, PaperSizeType_PaperLedger = 4, PaperSizeType_PaperLegal = 5, PaperSizeType_PaperStatement = 6, PaperSizeType_PaperExecutive = 7, PaperSizeType_PaperA3 = 8, PaperSizeType_PaperA4 = 9, PaperSizeType_PaperA4Small = 10, PaperSizeType_PaperA5 = 11, PaperSizeType_PaperB4 = 12, PaperSizeType_PaperB5 = 13, PaperSizeType_PaperFolio = 14, PaperSizeType_PaperQuarto = 15, PaperSizeType_Paper10x14 = 16, PaperSizeType_Paper11x17 = 17, PaperSizeType_PaperNote = 18, PaperSizeType_PaperEnvelope9 = 19, PaperSizeType_PaperEnvelope10 = 20, PaperSizeType_PaperEnvelope11 = 21, PaperSizeType_PaperEnvelope12 = 22, PaperSizeType_PaperEnvelope14 = 23, PaperSizeType_PaperCSheet = 24, PaperSizeType_PaperDSheet = 25, PaperSizeType_PaperESheet = 26, PaperSizeType_PaperEnvelopeDL = 27, PaperSizeType_PaperEnvelopeC5 = 28, PaperSizeType_PaperEnvelopeC3 = 29, PaperSizeType_PaperEnvelopeC4 = 30, PaperSizeType_PaperEnvelopeC6 = 31, PaperSizeType_PaperEnvelopeC65 = 32, PaperSizeType_PaperEnvelopeB4 = 33, PaperSizeType_PaperEnvelopeB5 = 34, PaperSizeType_PaperEnvelopeB6 = 35, PaperSizeType_PaperEnvelopeItaly = 36, PaperSizeType_PaperEnvelopeMonarch = 37, PaperSizeType_PaperEnvelopePersonal = 38, PaperSizeType_PaperFanfoldUS = 39, PaperSizeType_PaperFanfoldStdGerman = 40, PaperSizeType_PaperFanfoldLegalGerman = 41, PaperSizeType_PaperISOB4 = 42, PaperSizeType_PaperJapanesePostcard = 43, PaperSizeType_Paper9x11 = 44, PaperSizeType_Paper10x11 = 45, PaperSizeType_Paper15x11 = 46, PaperSizeType_PaperEnvelopeInvite = 47, PaperSizeType_PaperLetterExtra = 50, PaperSizeType_PaperLegalExtra = 51, PaperSizeType_PaperTabloidExtra = 52, PaperSizeType_PaperA4Extra = 53, PaperSizeType_PaperLetterTransverse = 54, PaperSizeType_PaperA4Transverse = 55, PaperSizeType_PaperLetterExtraTransverse = 56, PaperSizeType_PaperSuperA = 57, PaperSizeType_PaperSuperB = 58, PaperSizeType_PaperLetterPlus = 59, PaperSizeType_PaperA4Plus = 60, PaperSizeType_PaperA5Transverse = 61, PaperSizeType_PaperJISB5Transverse = 62, PaperSizeType_PaperA3Extra = 63, PaperSizeType_PaperA5Extra = 64, PaperSizeType_PaperISOB5Extra = 65, PaperSizeType_PaperA2 = 66, PaperSizeType_PaperA3Transverse = 67, PaperSizeType_PaperA3ExtraTransverse = 68, PaperSizeType_PaperJapaneseDoublePostcard = 69, PaperSizeType_PaperA6 = 70, PaperSizeType_PaperJapaneseEnvelopeKaku2 = 71, PaperSizeType_PaperJapaneseEnvelopeKaku3 = 72, PaperSizeType_PaperJapaneseEnvelopeChou3 = 73, PaperSizeType_PaperJapaneseEnvelopeChou4 = 74, PaperSizeType_PaperLetterRotated = 75, PaperSizeType_PaperA3Rotated = 76, PaperSizeType_PaperA4Rotated = 77, PaperSizeType_PaperA5Rotated = 78, PaperSizeType_PaperJISB4Rotated = 79, PaperSizeType_PaperJISB5Rotated = 80, PaperSizeType_PaperJapanesePostcardRotated = 81, PaperSizeType_PaperJapaneseDoublePostcardRotated = 82, PaperSizeType_PaperA6Rotated = 83, PaperSizeType_PaperJapaneseEnvelopeKaku2Rotated = 84, PaperSizeType_PaperJapaneseEnvelopeKaku3Rotated = 85, PaperSizeType_PaperJapaneseEnvelopeChou3Rotated = 86, PaperSizeType_PaperJapaneseEnvelopeChou4Rotated = 87, PaperSizeType_PaperJISB6 = 88, PaperSizeType_PaperJISB6Rotated = 89, PaperSizeType_Paper12x11 = 90, PaperSizeType_PaperJapaneseEnvelopeYou4 = 91, PaperSizeType_PaperJapaneseEnvelopeYou4Rotated = 92, PaperSizeType_PaperPRC16K = 93, PaperSizeType_PaperPRC32K = 94, PaperSizeType_PaperPRCBig32K = 95, PaperSizeType_PaperPRCEnvelope1 = 96, PaperSizeType_PaperPRCEnvelope2 = 97, PaperSizeType_PaperPRCEnvelope3 = 98, PaperSizeType_PaperPRCEnvelope4 = 99, PaperSizeType_PaperPRCEnvelope5 = 100, PaperSizeType_PaperPRCEnvelope6 = 101, PaperSizeType_PaperPRCEnvelope7 = 102, PaperSizeType_PaperPRCEnvelope8 = 103, PaperSizeType_PaperPRCEnvelope9 = 104, PaperSizeType_PaperPRCEnvelope10 = 105, PaperSizeType_PaperPRC16KRotated = 106, PaperSizeType_PaperPRC32KRotated = 107, PaperSizeType_PaperPRCBig32KRotated = 108, PaperSizeType_PaperPRCEnvelope1Rotated = 109, PaperSizeType_PaperPRCEnvelope2Rotated = 110, PaperSizeType_PaperPRCEnvelope3Rotated = 111, PaperSizeType_PaperPRCEnvelope4Rotated = 112, PaperSizeType_PaperPRCEnvelope5Rotated = 113, PaperSizeType_PaperPRCEnvelope6Rotated = 114, PaperSizeType_PaperPRCEnvelope7Rotated = 115, PaperSizeType_PaperPRCEnvelope8Rotated = 116, PaperSizeType_PaperPRCEnvelope9Rotated = 117, PaperSizeType_PaperPRCEnvelope10Rotated = 118, PaperSizeType_PaperB3 = 300, PaperSizeType_PaperBusinessCard = 301, PaperSizeType_PaperThermal = 302, PaperSizeType_Custom = 0 }
	Represents paper size constants. More...

enum	ParameterType { ParameterType_Reference, ParameterType_Value, ParameterType_Array }
	Represent all parameters' type or return value type of function. More...

enum	PasteType { PasteType_All, PasteType_Default, PasteType_AllExceptBorders, PasteType_DefaultExceptBorders, PasteType_ColumnWidths, PasteType_RowHeights, PasteType_Comments, PasteType_Formats, PasteType_Formulas, PasteType_FormulasAndNumberFormats, PasteType_Validation, PasteType_Values, PasteType_ValuesAndFormats, PasteType_ValuesAndNumberFormats }
	Represents the paste special type. More...

enum	PrintCommentsType { PrintCommentsType_PrintInPlace, PrintCommentsType_PrintNoComments, PrintCommentsType_PrintSheetEnd }
	Represents the way comments are printed with the sheet. More...

enum	PrintErrorsType { PrintErrorsType_PrintErrorsBlank, PrintErrorsType_PrintErrorsDash, PrintErrorsType_PrintErrorsDisplayed, PrintErrorsType_PrintErrorsNA }
	Represents print errors constants. More...

enum	PrintingPageType { PrintingPageType_Default = 0, PrintingPageType_IgnoreBlank = 1, PrintingPageType_IgnoreStyle = 2 }
	Indicates which pages will not be printed. More...

enum	PrintOrderType { PrintOrderType_DownThenOver, PrintOrderType_OverThenDown }
	Represent print order constants. More...

enum	PrintSizeType { PrintSizeType_Full, PrintSizeType_Fit, PrintSizeType_Custom }
	Represents the printed chart size. More...

enum	ProtectionType { ProtectionType_All, ProtectionType_Contents, ProtectionType_Objects, ProtectionType_Scenarios, ProtectionType_Structure, ProtectionType_Windows, ProtectionType_None }
	Represents workbook/worksheet protection type. More...

enum	SaveFormat { SaveFormat_Csv = 1, SaveFormat_CSV = 1, SaveFormat_Xlsx = 6, SaveFormat_Xlsm = 7, SaveFormat_Xltx = 8, SaveFormat_Xltm = 9, SaveFormat_Xlam = 10, SaveFormat_Tsv = 11, SaveFormat_TSV = 11, SaveFormat_TabDelimited = Aspose::Cells::SaveFormat_Tsv, SaveFormat_Html = 12, SaveFormat_MHtml = 17, SaveFormat_Ods = 14, SaveFormat_ODS = 14, SaveFormat_Excel97To2003 = 5, SaveFormat_SpreadsheetML = 15, SaveFormat_Xlsb = 16, SaveFormat_Auto = 0, SaveFormat_Unknown = 255, SaveFormat_Pdf = 13, SaveFormat_Xps = 20, SaveFormat_XPS = 20, SaveFormat_Tiff = 21, SaveFormat_TIFF = 21, SaveFormat_Svg = 28, SaveFormat_SVG = 28, SaveFormat_Dif = 30, SaveFormat_Ots = 31, SaveFormat_Xlt = 32, SaveFormat_Xml = 51, SaveFormat_Numbers = 56, SaveFormat_Markdown = 57, SaveFormat_Fods = 59, SaveFormat_FODS = 59, SaveFormat_Sxc = 60, SaveFormat_SXC = 60, SaveFormat_Pptx = 61, SaveFormat_Docx = 62, SaveFormat_Emf = 0x102, SaveFormat_Jpg = 0x105, SaveFormat_Png = 0x106, SaveFormat_Bmp = 0x107, SaveFormat_Gif = 0x142, SaveFormat_Json = 0x201, SaveFormat_SqlScript = 0x202, SaveFormat_XHtml = 0x303, SaveFormat_Epub }
	Represents the format in which the workbook is saved. More...

enum	SheetType { SheetType_VB, SheetType_Worksheet, SheetType_Chart, SheetType_BIFF4Macro, SheetType_InternationalMacro, SheetType_Other, SheetType_Dialog }
	Specifies the worksheet type. More...

enum	ShiftType { ShiftType_Down, ShiftType_Left, ShiftType_None, ShiftType_Right, ShiftType_Up }
	Represent the shift options when deleting a range of cells. More...

enum	SortOrder { SortOrder_Ascending, SortOrder_Descending }
	Represents sort order for the data range. More...

enum	StyleModifyFlag { StyleModifyFlag_LeftBorder = 0x00000100, StyleModifyFlag_RightBorder = 0x00000200, StyleModifyFlag_TopBorder = 0x00000400, StyleModifyFlag_BottomBorder = 0x00000800, StyleModifyFlag_DiagonalDownBorder = 0x00001000, StyleModifyFlag_DiagonalUpBorder = 0x00002000, StyleModifyFlag_Diagonal = Aspose::Cells::StyleModifyFlag_DiagonalDownBorder\|Aspose::Cells::StyleModifyFlag_DiagonalUpBorder, StyleModifyFlag_HorizontalBorder = 0x0000020, StyleModifyFlag_VerticalBorder = 0x0000040, StyleModifyFlag_Borders = Aspose::Cells::StyleModifyFlag_LeftBorder\|Aspose::Cells::StyleModifyFlag_RightBorder\|Aspose::Cells::StyleModifyFlag_TopBorder\|Aspose::Cells::StyleModifyFlag_BottomBorder\|Aspose::Cells::StyleModifyFlag_Diagonal\|Aspose::Cells::StyleModifyFlag_HorizontalBorder\|Aspose::Cells::StyleModifyFlag_VerticalBorder, StyleModifyFlag_NumberFormat = 0x00004000, StyleModifyFlag_HorizontalAlignment = 0x00008000, StyleModifyFlag_VerticalAlignment = 0x00010000, StyleModifyFlag_Indent = 0x00020000, StyleModifyFlag_Rotation = 0x00040000, StyleModifyFlag_WrapText = 0x00080000, StyleModifyFlag_ShrinkToFit = 0x00100000, StyleModifyFlag_TextDirection = 0x00200000, StyleModifyFlag_RelativeIndent = 0x0000080, StyleModifyFlag_AlignmentSettings = Aspose::Cells::StyleModifyFlag_HorizontalAlignment\|Aspose::Cells::StyleModifyFlag_VerticalAlignment\|Aspose::Cells::StyleModifyFlag_Rotation\|Aspose::Cells::StyleModifyFlag_WrapText\|Aspose::Cells::StyleModifyFlag_Indent\|Aspose::Cells::StyleModifyFlag_ShrinkToFit\|Aspose::Cells::StyleModifyFlag_TextDirection\|Aspose::Cells::StyleModifyFlag_RelativeIndent, StyleModifyFlag_Pattern = 0x00400000, StyleModifyFlag_ForegroundColor = 0x00800000, StyleModifyFlag_BackgroundColor = 0x01000000, StyleModifyFlag_CellShading = Aspose::Cells::StyleModifyFlag_Pattern\|Aspose::Cells::StyleModifyFlag_ForegroundColor\|Aspose::Cells::StyleModifyFlag_BackgroundColor, StyleModifyFlag_Locked = 0x04000000, StyleModifyFlag_HideFormula = 0x08000000, StyleModifyFlag_ProtectionSettings = Aspose::Cells::StyleModifyFlag_Locked\|Aspose::Cells::StyleModifyFlag_HideFormula, StyleModifyFlag_FontSize = 0x00000001, StyleModifyFlag_FontName = 0x00000002, StyleModifyFlag_FontColor = 0x00000003, StyleModifyFlag_FontWeight = 0x00000004, StyleModifyFlag_FontItalic = 0x00000005, StyleModifyFlag_FontUnderline = 0x00000006, StyleModifyFlag_FontStrike = 0x00000007, StyleModifyFlag_FontScript = 0x00000008, StyleModifyFlag_FontFamily = 0x00000009, StyleModifyFlag_FontCharset = 0x0000000A, StyleModifyFlag_FontScheme = 0x0000000B, StyleModifyFlag_FontDirty = 0x0000000C, StyleModifyFlag_FontSpellingError = 0x0000000D, StyleModifyFlag_FontUFillTx = 0x0000000E, StyleModifyFlag_FontSpacing = 0x0000000F, StyleModifyFlag_FontKerning = 0x00000010, StyleModifyFlag_FontEqualize = 0x00000011, StyleModifyFlag_FontCap = 0x00000012, StyleModifyFlag_FontVerticalText = 0x00000013, StyleModifyFlag_Font = 0x000000014, StyleModifyFlag_All = Aspose::Cells::StyleModifyFlag_Borders\|Aspose::Cells::StyleModifyFlag_NumberFormat\|Aspose::Cells::StyleModifyFlag_AlignmentSettings\|Aspose::Cells::StyleModifyFlag_CellShading\|Aspose::Cells::StyleModifyFlag_ProtectionSettings\|Aspose::Cells::StyleModifyFlag_Font }
	The style modified flags. More...

enum	TextAlignmentType { TextAlignmentType_General = 0x0700, TextAlignmentType_Bottom = 0x0210, TextAlignmentType_Center = 0x070A, TextAlignmentType_CenterAcross = 0x0506, TextAlignmentType_Distributed = 0x0327, TextAlignmentType_Fill = 0x0504, TextAlignmentType_Justify = 0x071D, TextAlignmentType_Left = 0x0101, TextAlignmentType_Right = 0x0103, TextAlignmentType_Top = 0x0200, TextAlignmentType_JustifiedLow = 0x0340, TextAlignmentType_ThaiDistributed = 0x0380 }
	Enumerates text alignment types. More...

enum	TextCapsType { TextCapsType_None, TextCapsType_All, TextCapsType_Small }
	This type specifies the cap types of the text. More...

enum	TextDirectionType { TextDirectionType_Context = 0, TextDirectionType_LeftToRight = 1, TextDirectionType_RightToLeft = 2 }
	Represents the direction of the text flow for this paragraph. More...

enum	TextOrientationType { TextOrientationType_ClockWise, TextOrientationType_CounterClockWise, TextOrientationType_NoRotation, TextOrientationType_TopToBottom }
	Enumerates text orientation types. More...

enum	TextStrikeType { TextStrikeType_Single, TextStrikeType_Double, TextStrikeType_None }
	This type specifies the strike type. More...

enum	ThemeColorType { ThemeColorType_Background1 = 0, ThemeColorType_Text1 = 1, ThemeColorType_Background2 = 2, ThemeColorType_Text2 = 3, ThemeColorType_Accent1 = 4, ThemeColorType_Accent2 = 5, ThemeColorType_Accent3 = 6, ThemeColorType_Accent4 = 7, ThemeColorType_Accent5 = 8, ThemeColorType_Accent6 = 9, ThemeColorType_Hyperlink = 10, ThemeColorType_FollowedHyperlink = 11, ThemeColorType_StyleColor }
	Enumerates the theme color types. More...

enum	TimePeriodType { TimePeriodType_Today, TimePeriodType_Yesterday, TimePeriodType_Tomorrow, TimePeriodType_Last7Days, TimePeriodType_ThisMonth, TimePeriodType_LastMonth, TimePeriodType_NextMonth, TimePeriodType_ThisWeek, TimePeriodType_LastWeek, TimePeriodType_NextWeek, TimePeriodType_ThisYear, TimePeriodType_LastYear, TimePeriodType_NextYear }
	Used in a FormatConditionType.TimePeriod conditional formatting rule. These are dynamic time periods, which change based on the date the conditional formatting is refreshed / applied. More...

enum	TxtLoadStyleStrategy { TxtLoadStyleStrategy_None, TxtLoadStyleStrategy_BuiltIn, TxtLoadStyleStrategy_ExactFormat }
	Specifies how to apply style for parsed values when converting string value to number or datetime. More...

enum	TxtValueQuoteType { TxtValueQuoteType_Normal, TxtValueQuoteType_Always, TxtValueQuoteType_Minimum, TxtValueQuoteType_Never }
	Specifies the type of using quotation marks for values in text format files. More...

enum	UpdateLinksType { UpdateLinksType_UserSet = 0, UpdateLinksType_Never = 1, UpdateLinksType_Always }
	Represents how to update links to other workbooks when the workbook is opened. More...

enum	ValidationAlertType { ValidationAlertType_Information, ValidationAlertType_Stop, ValidationAlertType_Warning }
	Represents the data validation alert style. More...

enum	ValidationType { ValidationType_AnyValue, ValidationType_WholeNumber, ValidationType_Decimal, ValidationType_List, ValidationType_Date, ValidationType_Time, ValidationType_TextLength, ValidationType_Custom }
	Represents data validation type. More...

enum	ViewType { ViewType_NormalView, ViewType_PageBreakPreview, ViewType_PageLayoutView }
	Represents the view type of the worksheet. More...

enum	VisibilityType { VisibilityType_Visible = 0, VisibilityType_Hidden = 1, VisibilityType_VeryHidden = 2 }
	Represents the states for sheet visibility. More...

Enumeration Type Documentation

◆ BackgroundType

enum Aspose::Cells::BackgroundType

Enumerates cell background pattern types.

Enumerator
BackgroundType_DiagonalCrosshatch	Represents diagonal crosshatch pattern.
BackgroundType_DiagonalStripe	Represents diagonal stripe pattern.
BackgroundType_Gray6	Represents 6.25% gray pattern
BackgroundType_Gray12	Represents 12.5% gray pattern
BackgroundType_Gray25	Represents 25% gray pattern.
BackgroundType_Gray50	Represents 50% gray pattern.
BackgroundType_Gray75	Represents 75% gray pattern.
BackgroundType_HorizontalStripe	Represents horizontal stripe pattern.
BackgroundType_None	Represents no background.
BackgroundType_ReverseDiagonalStripe	Represents reverse diagonal stripe pattern.
BackgroundType_Solid	Represents solid pattern.
BackgroundType_ThickDiagonalCrosshatch	Represents thick diagonal crosshatch pattern.
BackgroundType_ThinDiagonalCrosshatch	Represents thin diagonal crosshatch pattern.
BackgroundType_ThinDiagonalStripe	Represents thin diagonal stripe pattern.
BackgroundType_ThinHorizontalCrosshatch	Represents thin horizontal crosshatch pattern.
BackgroundType_ThinHorizontalStripe	Represents thin horizontal stripe pattern.
BackgroundType_ThinReverseDiagonalStripe	Represents thin reverse diagonal stripe pattern.
BackgroundType_ThinVerticalStripe	Represents thin vertical stripe pattern.
BackgroundType_VerticalStripe	Represents vertical stripe pattern.

◆ BorderType

enum Aspose::Cells::BorderType

Enumerates the border line and diagonal line types.

Enumerator
BorderType_BottomBorder	Represents bottom border line.
BorderType_DiagonalDown	Represents the diagonal line from top left to right bottom.
BorderType_DiagonalUp	Represents the diagonal line from bottom left to right top.
BorderType_LeftBorder	Represents left border line.
BorderType_RightBorder	Represents right border line exists.
BorderType_TopBorder	Represents top border line.
BorderType_Horizontal	Only for dynamic style,such as conditional formatting.
BorderType_Vertical	Only for dynamic style,such as conditional formatting.

◆ BuiltinStyleType

enum Aspose::Cells::BuiltinStyleType

Represents all built-in style type

Enumerator
BuiltinStyleType_TwentyPercentAccent1
BuiltinStyleType_TwentyPercentAccent2
BuiltinStyleType_TwentyPercentAccent3
BuiltinStyleType_TwentyPercentAccent4
BuiltinStyleType_TwentyPercentAccent5
BuiltinStyleType_TwentyPercentAccent6
BuiltinStyleType_FortyPercentAccent1
BuiltinStyleType_FortyPercentAccent2
BuiltinStyleType_FortyPercentAccent3
BuiltinStyleType_FortyPercentAccent4
BuiltinStyleType_FortyPercentAccent5
BuiltinStyleType_FortyPercentAccent6
BuiltinStyleType_SixtyPercentAccent1
BuiltinStyleType_SixtyPercentAccent2
BuiltinStyleType_SixtyPercentAccent3
BuiltinStyleType_SixtyPercentAccent4
BuiltinStyleType_SixtyPercentAccent5
BuiltinStyleType_SixtyPercentAccent6
BuiltinStyleType_Accent1
BuiltinStyleType_Accent2
BuiltinStyleType_Accent3
BuiltinStyleType_Accent4
BuiltinStyleType_Accent5
BuiltinStyleType_Accent6
BuiltinStyleType_Bad
BuiltinStyleType_Calculation
BuiltinStyleType_CheckCell
BuiltinStyleType_Comma
BuiltinStyleType_Comma1
BuiltinStyleType_Currency
BuiltinStyleType_Currency1
BuiltinStyleType_ExplanatoryText
BuiltinStyleType_Good
BuiltinStyleType_Header1
BuiltinStyleType_Header2
BuiltinStyleType_Header3
BuiltinStyleType_Header4
BuiltinStyleType_Hyperlink
BuiltinStyleType_FollowedHyperlink
BuiltinStyleType_Input
BuiltinStyleType_LinkedCell
BuiltinStyleType_Neutral
BuiltinStyleType_Normal
BuiltinStyleType_Note
BuiltinStyleType_Output
BuiltinStyleType_Percent
BuiltinStyleType_Title
BuiltinStyleType_Total
BuiltinStyleType_WarningText
BuiltinStyleType_RowLevel
BuiltinStyleType_ColumnLevel

◆ CalcModeType

enum Aspose::Cells::CalcModeType

Represents the mode type of calculating formulas.

Only sets for MS Excel.

Enumerator
CalcModeType_Automatic
CalcModeType_AutomaticExceptTable
CalcModeType_Manual

◆ CalculationPrecisionStrategy

enum Aspose::Cells::CalculationPrecisionStrategy

Enumerates strategies for handling calculation precision. Because of the precision issue of IEEE 754 Floating-Point Arithmetic, some "seemingly simple" formulas may not be calculated as the expected result. Such as formula "=-0.45+0.43+0.02", when calculating operands by '+' operator directly, the result is not zero. For such kind of precision issue, some special strategies may give the expected result.

Enumerator
CalculationPrecisionStrategy_None	No strategy applied on calculation. When calculating just use the original double value as operand and return the result directly. Most efficient for performance and applicable for most cases.
CalculationPrecisionStrategy_Round	Rounds the calculation result according with significant digits.
CalculationPrecisionStrategy_Decimal	Uses decimal as operands when possible. Most inefficient for performance.

◆ CellBorderType

enum Aspose::Cells::CellBorderType

Enumerates a cell's border type.

Enumerator
CellBorderType_DashDot	Represents thin dash-dotted line.
CellBorderType_DashDotDot	Represents thin dash-dot-dotted line.
CellBorderType_Dashed	Represents dashed line.
CellBorderType_Dotted	Represents dotted line.
CellBorderType_Double	Represents double line.
CellBorderType_Hair	Represents hair line.
CellBorderType_MediumDashDot	Represents medium dash-dotted line.
CellBorderType_MediumDashDotDot	Represents medium dash-dot-dotted line.
CellBorderType_MediumDashed	Represents medium dashed line.
CellBorderType_None	Represents no line.
CellBorderType_Medium	Represents medium line.
CellBorderType_SlantedDashDot	Represents slanted medium dash-dotted line.
CellBorderType_Thick	Represents thick line.
CellBorderType_Thin	Represents thin line.

◆ CellValueFormatStrategy

enum Aspose::Cells::CellValueFormatStrategy

Specifies how to apply style for the value of the cell.

Enumerator
CellValueFormatStrategy_None	Not formatted.
CellValueFormatStrategy_CellStyle	Only formatted with the cell's original style.
CellValueFormatStrategy_DisplayStyle	Formatted with the cell's displayed style.
CellValueFormatStrategy_DisplayString	Gets the displayed string shown in ms excel. The main difference from DisplayStyle is this option also considers the effect of column width. If the column width is too small to show the formatted string completely, "#" may be shown, just like what ms excel does.

◆ CellValueType

enum Aspose::Cells::CellValueType

Specifies a cell value type.

Enumerator
CellValueType_IsUnknown	Cell value type is unknown.
CellValueType_IsNull	Blank cell. Corresponding value should be null.
CellValueType_IsNumeric	Cell value is numeric. Corresponding value must be int or double.
CellValueType_IsDateTime	Cell value is datetime. Corresponding value must be DateTime.
CellValueType_IsString	Cell value is string. Corresponding value must be string.
CellValueType_IsBool	Cell value is boolean. Corresponding value must be bool.
CellValueType_IsError	Cell contains error value. Corresponding value must be error string.

◆ ColorType

enum Aspose::Cells::ColorType

Represents all color type

Enumerator
ColorType_Automatic	Automatic color.
ColorType_AutomaticIndex	It's automatic color,but the displayed color depends the setting of the OS System. Not supported.
ColorType_RGB	The RGB color.
ColorType_IndexedColor	The color index in the color palette.
ColorType_Theme	The theme color.

◆ ConsolidationFunction

enum Aspose::Cells::ConsolidationFunction

Represents consolidation function.

Enumerator
ConsolidationFunction_Sum	Represents Sum function.
ConsolidationFunction_Count	Represents Count function.
ConsolidationFunction_Average	Represents Average function.
ConsolidationFunction_Max	Represents Max function.
ConsolidationFunction_Min	Represents Min function.
ConsolidationFunction_Product	Represents Product function.
ConsolidationFunction_CountNums	Represents Count Nums function.
ConsolidationFunction_StdDev	Represents StdDev function.
ConsolidationFunction_StdDevp	Represents StdDevp function.
ConsolidationFunction_Var	Represents Var function.
ConsolidationFunction_Varp	Represents Varp function.
ConsolidationFunction_DistinctCount	Represents Distinct Count function. Only valid for PivotTable with Data Module created since by 2013.

◆ CountryCode

enum Aspose::Cells::CountryCode

Represents Excel country identifiers.

Enumerator
CountryCode_Default	Default
CountryCode_USA	United States
CountryCode_Canada	Canada
CountryCode_LatinAmeric	Latin America, except Brazil
CountryCode_Russia	Russia
CountryCode_Egypt	Egypt
CountryCode_Greece	Greece
CountryCode_Netherlands	Netherlands
CountryCode_Belgium	Belgium
CountryCode_France	France
CountryCode_Spain	Spain
CountryCode_Hungary	Hungary
CountryCode_Italy	Italy
CountryCode_Switzerland	Switzerland
CountryCode_Austria	Austria
CountryCode_UnitedKingdom	United Kingdom
CountryCode_Denmark	Denmark
CountryCode_Sweden	Sweden
CountryCode_Norway	Norway
CountryCode_Poland	Poland
CountryCode_Germany	Germany
CountryCode_Mexico	Mexico
CountryCode_Brazil	Brazil
CountryCode_Australia	Australia
CountryCode_NewZealand	New Zealand
CountryCode_Thailand	Thailand
CountryCode_Japan	Japan
CountryCode_SouthKorea	SouthKorea
CountryCode_VietNam	Viet Nam
CountryCode_China	People's Republic of China
CountryCode_Turkey	Turkey
CountryCode_India	India
CountryCode_Algeria	Algeria
CountryCode_Morocco	Morocco
CountryCode_Libya	Libya
CountryCode_Portugal	Portugal
CountryCode_Iceland	Iceland
CountryCode_Finland	Finland
CountryCode_Czech	Czech Republic
CountryCode_Taiwan	Taiwan
CountryCode_Lebanon	Lebanon
CountryCode_Jordan	Jordan
CountryCode_Syria	Syria
CountryCode_Iraq	Iraq
CountryCode_Kuwait	Kuwait
CountryCode_Saudi	Saudi Arabia
CountryCode_UnitedArabEmirates	United Arab Emirates
CountryCode_Israel	Israel
CountryCode_Qatar	Qatar
CountryCode_Iran	Iran

◆ DataBarAxisPosition

enum Aspose::Cells::DataBarAxisPosition

Specifies the axis position for a range of cells with conditional formatting as data bars.

Enumerator
DataBarAxisPosition_Automatic	Display the axis at a variable position based on the ratio of the minimum negative value to the maximum positive value in the range. Positive values are displayed in a left-to-right direction. Negative values are displayed in a right-to-left direction. When all values are positive or all values are negative, no axis is displayed.
DataBarAxisPosition_Midpoint	Display the axis at the midpoint of the cell regardless of the set of values in the range. Positive values are displayed in a left-to-right direction. Negative values are displayed in a right-to-left direction.
DataBarAxisPosition_None	No axis is displayed, and both positive and negative values are displayed in the left-to-right direction.

◆ DataBarBorderType

enum Aspose::Cells::DataBarBorderType

Specifies the border type of a data bar.

Enumerator
DataBarBorderType_None	The data bar has no border.
DataBarBorderType_Solid	The data bar has a solid border.

◆ DataBarFillType

enum Aspose::Cells::DataBarFillType

Specifies how a data bar is filled with color.

Enumerator
DataBarFillType_Solid	The data bar is filled with solid color.
DataBarFillType_Gradient	The data bar is filled with a color gradient.

◆ DataBarNegativeColorType

enum Aspose::Cells::DataBarNegativeColorType

Specifies whether to use the same border and fill color as positive data bars.

Enumerator
DataBarNegativeColorType_Color	Use the color specified in the Negative Value and Axis Setting dialog box or by using the ColorType and BorderColorType properties of the NegativeBarFormat object.
DataBarNegativeColorType_SameAsPositive	Use the same color as positive data bars.

◆ DateTimeGroupingType

enum Aspose::Cells::DateTimeGroupingType

Specifies how to group dateTime values.

Enumerator
DateTimeGroupingType_Day	Group by day.
DateTimeGroupingType_Hour	Group by hour.
DateTimeGroupingType_Minute	Group by Minute.
DateTimeGroupingType_Month	Group by Month.
DateTimeGroupingType_Second	Group by Second.
DateTimeGroupingType_Year	Group by Year.

◆ DirectoryType

enum Aspose::Cells::DirectoryType

Represents the directory type of the file name.

Enumerator
DirectoryType_Volume	Represents an MS-DOS drive letter. It is followed by the drive letter. Or UNC file names, such as \server\share\myfile.xls
DirectoryType_SameVolume	Indicates that the source workbook is on the same drive as the dependent workbook (the drive letter is omitted)
DirectoryType_DownDirectory	Indicates that the source workbook is in a subdirectory of the current directory.
DirectoryType_UpDirectory	Indicates that the source workbook is in the parent directory of the current directory.

◆ DisplayDrawingObjects

enum Aspose::Cells::DisplayDrawingObjects

Represents whether and how to show objects in the workbook.

Enumerator
DisplayDrawingObjects_DisplayShapes	Show all objects
DisplayDrawingObjects_Placeholders	Show placeholders
DisplayDrawingObjects_Hide	Hide all shapes.

◆ DynamicFilterType

enum Aspose::Cells::DynamicFilterType

Dynamic filter type.

Enumerator
DynamicFilterType_AboveAverage	Shows values that are above average.
DynamicFilterType_BelowAverage	Shows values that are below average.
DynamicFilterType_LastMonth	Shows last month's dates.
DynamicFilterType_LastQuarter	Shows last quarter's dates.
DynamicFilterType_LastWeek	Shows last week's dates.
DynamicFilterType_LastYear	Shows last year's dates.
DynamicFilterType_January	Shows the dates that are in January, regardless of year.
DynamicFilterType_October	Shows the dates that are in October, regardless of year.
DynamicFilterType_November	Shows the dates that are in November, regardless of year.
DynamicFilterType_December	Shows the dates that are in December, regardless of year.
DynamicFilterType_February	Shows the dates that are in February, regardless of year.
DynamicFilterType_March	Shows the dates that are in March, regardless of year.
DynamicFilterType_April	Shows the dates that are in April, regardless of year.
DynamicFilterType_May	Shows the dates that are in May, regardless of year.
DynamicFilterType_June	Shows the dates that are in June, regardless of year.
DynamicFilterType_July	Shows the dates that are in July, regardless of year.
DynamicFilterType_August	Shows the dates that are in August, regardless of year.
DynamicFilterType_September	Shows the dates that are in September, regardless of year.
DynamicFilterType_NextMonth	Shows next month's dates.
DynamicFilterType_NextQuarter	Shows next quarter's dates.
DynamicFilterType_NextWeek	Shows next week's dates.
DynamicFilterType_NextYear	Shows next year's dates.
DynamicFilterType_None	None.
DynamicFilterType_Quarter1	Shows the dates that are in the 1st quarter, regardless of year.
DynamicFilterType_Quarter2	Shows the dates that are in the 2nd quarter, regardless of year.
DynamicFilterType_Quarter3	Shows the dates that are in the 3rd quarter, regardless of year.
DynamicFilterType_Quarter4	Shows the dates that are in the 4th quarter, regardless of year.
DynamicFilterType_ThisMonth	Shows this month's dates.
DynamicFilterType_ThisQuarter	Shows this quarter's dates.
DynamicFilterType_ThisWeek	Shows this week's dates.
DynamicFilterType_ThisYear	Shows this year's dates.
DynamicFilterType_Today	Shows today's dates.
DynamicFilterType_Tomorrow	Shows tomorrow's dates.
DynamicFilterType_YearToDate	Shows the dates between the beginning of the year and today, inclusive.
DynamicFilterType_Yesterday	Shows yesterday's dates.

◆ EncryptionType

enum Aspose::Cells::EncryptionType

Encryption Type. Only used by excel2003. We will encrypt 2007/2010 workbook using SHA AES the same as Excel does, and this EncryptionType will be ignored.

Enumerator
EncryptionType_XOR
EncryptionType_Compatible	Office 97/2000 compatible.
EncryptionType_EnhancedCryptographicProviderV1
EncryptionType_StrongCryptographicProvider

◆ ErrorCheckType

enum Aspose::Cells::ErrorCheckType

Represents all error check type.

Enumerator
ErrorCheckType_Calc	check for calculation errors
ErrorCheckType_EmptyCellRef	check for references to empty cells
ErrorCheckType_TextNumber	check the format of numeric values
ErrorCheckType_InconsistRange	check formulas with references to less than the entirety of a range containing continuous data
ErrorCheckType_InconsistFormula	check formulas that are inconsistent with formulas in neighboring cells.
ErrorCheckType_TextDate	check the format of date/time values
ErrorCheckType_UnproctedFormula	check for unprotected formulas
ErrorCheckType_Validation	whether to perform data validation
ErrorCheckType_CalculatedColumn	Ignore errors when cells contain a value different from a calculated column formula.

◆ ErrorType

enum Aspose::Cells::ErrorType

Summary description for ErrorType.

Enumerator
ErrorType_Div	Division by zero.
ErrorType_NA	Cell values doesn't exist.
ErrorType_Name	Text cannot be identified.
ErrorType_Null	Null error..
ErrorType_Number	Invalid number.
ErrorType_Ref	Invalid reference.
ErrorType_Recursive	Recursive reference.
ErrorType_Value	Invalid parameter or operand type.

◆ ExceptionType

enum Aspose::Cells::ExceptionType

Represents custom exception type code.

Enumerator
ExceptionType_Chart	Invalid chart setting.
ExceptionType_DataType	Invalid data type setting.
ExceptionType_DataValidation	Invalid data validation setting.
ExceptionType_ConditionalFormatting	Invalid data validation setting.
ExceptionType_FileFormat	Invalid file format.
ExceptionType_Formula	Invalid formula.
ExceptionType_InvalidData	Invalid data.
ExceptionType_InvalidOperator	Invalid operator.
ExceptionType_IncorrectPassword	Incorrect password.
ExceptionType_License	License related errors.
ExceptionType_Limitation	Out of MS Excel limitation error.
ExceptionType_PageSetup	Invalid page setup setting.
ExceptionType_PivotTable	Invalid pivotTable setting.
ExceptionType_Shape	Invalid drawing object setting.
ExceptionType_Sparkline	Invalid sparkline object setting.
ExceptionType_SheetName	Invalid worksheet name.
ExceptionType_SheetType	Invalid worksheet type.
ExceptionType_Interrupted	The process is interrupted.
ExceptionType_IO	The file is invalid.
ExceptionType_Permission	Permission is required to open this file.
ExceptionType_UnsupportedFeature	Unsupported feature.
ExceptionType_UnsupportedStream	Unsupported stream to be opened.
ExceptionType_UndisclosedInformation	Files contains some undisclosed information.
ExceptionType_FileCorrupted	File content is corrupted.

◆ ExternalCellValueType

enum Aspose::Cells::ExternalCellValueType

Enumerator
ExternalCellValueType_Blank
ExternalCellValueType_Number
ExternalCellValueType_String
ExternalCellValueType_Error
ExternalCellValueType_Bool

◆ FileFormatType

enum Aspose::Cells::FileFormatType

Represents the file format types.

Enumerator
FileFormatType_Csv	Comma-Separated Values(CSV) text file.
FileFormatType_Xlsx	Office Open XML SpreadsheetML file (macro-free).
FileFormatType_Xlsm	Office Open XML SpreadsheetML Macro-Enabled file.
FileFormatType_Xltx	Office Open XML SpreadsheetML Template (macro-free).
FileFormatType_Xltm	Office Open XML SpreadsheetML Macro-Enabled Template.
FileFormatType_Xlam	Office Open XML SpreadsheetML addinMacro-Enabled file.
FileFormatType_Tsv	Tab-Separated Values(TSV) text file.
FileFormatType_TabDelimited	Tab-Separated Values(TSV) text file, same with Tsv
FileFormatType_Html	HTML format.
FileFormatType_MHtml	MHTML (Web archive) format.
FileFormatType_Ods	Open Document Sheet(ODS) file.
FileFormatType_Excel97To2003	Excel97-2003 spreadsheet file.
FileFormatType_SpreadsheetML	Excel 2003 XML Data file.
FileFormatType_Xlsb	The Excel Binary File Format (.xlsb)
FileFormatType_Unknown	Represents unrecognized format, cannot be loaded.
FileFormatType_Pdf	PDF (Adobe Portable Document) format.
FileFormatType_Xps	XPS (XML Paper Specification) format.
FileFormatType_Tiff	Represents a TIFF file.
FileFormatType_Svg	SVG file.
FileFormatType_Excel95	Represents an Excel95 xls file.
FileFormatType_Excel4	Represents an Excel4.0 xls file. The file format is not supported
FileFormatType_Excel3	Represents an Excel3.0 xls file. The file format is not supported
FileFormatType_Excel2	Represents an Excel2.1 xls file. The file format is not supported
FileFormatType_Pptx	Represents a pptx file. The file format is not supported Only for detecting file type.
FileFormatType_Docx	Represents a docx file. The file format is not supported Only for detecting file type.
FileFormatType_Dif	Data Interchange Format.
FileFormatType_Doc	Represents a doc file. The file format is not supported Only for detecting file type.
FileFormatType_Ppt	Represents a ppt file. The file format is not supported Only for detecting file type.
FileFormatType_MapiMessage	Represents a email file. The file format is not supported Only for detecting file type.
FileFormatType_MsEquation	Represents the MS Equation 3.0 object. The file format is not supported Only for detecting file type.
FileFormatType_Ole10Native	Represents the embedded native object. The file format is not supported Only for detecting file type.
FileFormatType_Vsd	Represents MS Visio VSD binary format. The file format is not supported Only for detecting file type.
FileFormatType_Vsdx	Represents MS Visio 2013 VSDX file format. The file format is not supported Only for detecting file type.
FileFormatType_Docm	Represents a docm file. The file format is not supported Only for detecting file type.
FileFormatType_Dotx	Represents a dotx file. The file format is not supported Only for detecting file type.
FileFormatType_Dotm	Represents a dotm file. The file format is not supported Only for detecting file type.
FileFormatType_Pptm	Represents a pptm file. The file format is not supported Only for detecting file type.
FileFormatType_Potx	Represents a Potx file. The file format is not supported Only for detecting file type.
FileFormatType_Potm	Represents a Potm file. The file format is not supported Only for detecting file type.
FileFormatType_Ppsx	Represents a ppsx file. The file format is not supported Only for detecting file type.
FileFormatType_Ppsm	Represents a ppsm file. The file format is not supported Only for detecting file type.
FileFormatType_Ooxml	Represents office open xml file(such as xlsx, docx,pptx, etc). The file format is not supported Only for detecting file type. If the office open xml file is encrypted, it could not be detected as xlsx ,docx, pptx,etc.
FileFormatType_Odt	Represents an ODT file. The file format is not supported Only for detecting file type.
FileFormatType_Odp	Represents a ODP file. The file format is not supported Only for detecting file type.
FileFormatType_Odf	Represents an ODF file. The file format is not supported Only for detecting file type.
FileFormatType_Odg	Represents an ODG file. The file format is not supported Only for detecting file type.
FileFormatType_Xml	Represents a simple xml file. The file format is not supported Only for detecting file type.
FileFormatType_Xlt	Excel97-2003 spreadsheet template.
FileFormatType_Ott	Represents an OTT file. The file format is not supported Only for detecting file type.
FileFormatType_Bmp	Represents a BMP file. The file format is not supported Only for detecting file type.
FileFormatType_Ots	Represents an ots file.
FileFormatType_Numbers	Represents Numbers 9.0 file format by Apple Inc.
FileFormatType_Numbers09	Represents Numbers 9.0 file format by Apple Inc.
FileFormatType_Markdown	Represents markdown document.
FileFormatType_GraphChart	Represents embedded graph chart.
FileFormatType_Fods	Represents OpenDocument Flat XML Spreadsheet (.fods) file format.
FileFormatType_Sxc	Represents StarOffice Calc Spreadsheet (.sxc) file format.
FileFormatType_Otp	Represents a OTP file. The file format is not supported. Only for detecting file type.
FileFormatType_Numbers35	Represents Numbers 3.5 file format since 2014 by Apple Inc
FileFormatType_Emf	Windows Enhanced Metafile.
FileFormatType_Wmf	Windows Metafile.
FileFormatType_Jpg	JPEG JFIF.
FileFormatType_Png	Portable Network Graphics.
FileFormatType_Gif	Gif
FileFormatType_Json	Json
FileFormatType_SqlScript	Sql
FileFormatType_XHtml	Rrepesents XHtml file.
FileFormatType_OneNote	Rrepesents One Note file. The file format is not supported Only for detecting file type.
FileFormatType_MicrosoftCabinet	/// Rrepesents Microsoft Cabinet file. The file format is not supported Only for detecting file type.
FileFormatType_Rtf
FileFormatType_Epub	EPUB
FileFormatType_GZip	Rrepesents GZip file. The file format is not supported Only for detecting file type.

◆ FilterOperatorType

enum Aspose::Cells::FilterOperatorType

Custom Filter operator type.

Enumerator
FilterOperatorType_LessOrEqual	Represents LessOrEqual operator.
FilterOperatorType_LessThan	Represents LessThan operator.
FilterOperatorType_Equal	Represents Equal operator.
FilterOperatorType_GreaterThan	Represents GreaterThan operator.
FilterOperatorType_NotEqual	Represents NotEqual operator.
FilterOperatorType_GreaterOrEqual	Represents GreaterOrEqual operator.
FilterOperatorType_None	Represents no comparison.
FilterOperatorType_BeginsWith	Begins with the text.
FilterOperatorType_EndsWith	Ends with the text.
FilterOperatorType_Contains	Contains the text.
FilterOperatorType_NotContains	Not contains the text.

◆ FontUnderlineType

enum Aspose::Cells::FontUnderlineType

Enumerates the font underline types.

Enumerator
FontUnderlineType_None	Represents no underline.
FontUnderlineType_Single	Represents single underline.
FontUnderlineType_Double	Represents double underline.
FontUnderlineType_Accounting	Represents single accounting underline.
FontUnderlineType_DoubleAccounting	Represents double accounting underline.
FontUnderlineType_Dash	Represents Dashed Underline
FontUnderlineType_DashDotDotHeavy	Represents Thick Dash-Dot-Dot Underline
FontUnderlineType_DashDotHeavy	Represents Thick Dash-Dot Underline
FontUnderlineType_DashedHeavy	Represents Thick Dashed Underline
FontUnderlineType_DashLong	Represents Long Dashed Underline
FontUnderlineType_DashLongHeavy	Represents Thick Long Dashed Underline
FontUnderlineType_DotDash	Represents Dash-Dot Underline
FontUnderlineType_DotDotDash	Represents Dash-Dot-Dot Underline
FontUnderlineType_Dotted	Represents Dotted Underline
FontUnderlineType_DottedHeavy	Represents Thick Dotted Underline
FontUnderlineType_Heavy	Represents Thick Underline
FontUnderlineType_Wave	Represents Wave Underline
FontUnderlineType_WavyDouble	Represents Double Wave Underline
FontUnderlineType_WavyHeavy	Represents Heavy Wave Underline
FontUnderlineType_Words	Represents Underline Non-Space Characters Only

◆ FormatConditionType

enum Aspose::Cells::FormatConditionType

Conditional format rule type.

Enumerator
FormatConditionType_CellValue	This conditional formatting rule compares a cell value to a formula calculated result, using an operator.
FormatConditionType_Expression	This conditional formatting rule contains a formula to evaluate. When the formula result is true, the cell is highlighted.
FormatConditionType_ColorScale	This conditional formatting rule creates a gradated color scale on the cells.
FormatConditionType_DataBar	This conditional formatting rule displays a gradated data bar in the range of cells.
FormatConditionType_IconSet	This conditional formatting rule applies icons to cells according to their values.
FormatConditionType_Top10	This conditional formatting rule highlights cells whose values fall in the top N or bottom N bracket, as specified.
FormatConditionType_UniqueValues	This conditional formatting rule highlights unique values in the range.
FormatConditionType_DuplicateValues	This conditional formatting rule highlights duplicated values.
FormatConditionType_ContainsText	This conditional formatting rule highlights cells containing given text. Equivalent to using the SEARCH() sheet function to determine whether the cell contains the text.
FormatConditionType_NotContainsText	This conditional formatting rule highlights cells that are not blank. Equivalent of using LEN(TRIM()). This means that if the cell contains only characters that TRIM() would remove, then it is considered blank. An empty cell is also considered blank.
FormatConditionType_BeginsWith	This conditional formatting rule highlights cells in the range that begin with the given text. Equivalent to using the LEFT() sheet function and comparing values.
FormatConditionType_EndsWith	This conditional formatting rule highlights cells ending with given text. Equivalent to using the RIGHT() sheet function and comparing values.
FormatConditionType_ContainsBlanks	This conditional formatting rule highlights cells that are completely blank. Equivalent of using LEN(TRIM()). This means that if the cell contains only characters that TRIM() would remove, then it is considered blank. An empty cell is also considered blank.
FormatConditionType_NotContainsBlanks	This conditional formatting rule highlights cells that are not blank. Equivalent of using LEN(TRIM()). This means that if the cell contains only characters that TRIM() would remove, then it is considered blank. An empty cell is also considered blank.
FormatConditionType_ContainsErrors	This conditional formatting rule highlights cells with formula errors. Equivalent to using ISERROR() sheet function to determine if there is a formula error.
FormatConditionType_NotContainsErrors	This conditional formatting rule highlights cells without formula errors. Equivalent to using ISERROR() sheet function to determine if there is a formula error.
FormatConditionType_TimePeriod	This conditional formatting rule highlights cells containing dates in the specified time period. The underlying value of the cell is evaluated, therefore the cell does not need to be formatted as a date to be evaluated. For example, with a cell containing the value 38913 the conditional format shall be applied if the rule requires a value of 7/14/2006.
FormatConditionType_AboveAverage	This conditional formatting rule highlights cells that are above or below the average for all values in the range.

◆ FormatConditionValueType

enum Aspose::Cells::FormatConditionValueType

Condition value type.

Enumerator
FormatConditionValueType_Formula	The minimum/ midpoint / maximum value for the gradient is determined by a formula.
FormatConditionValueType_Max	Indicates that the maximum value in the range shall be used as the maximum value for the gradient.
FormatConditionValueType_Min	Indicates that the minimum value in the range shall be used as the minimum value for the gradient.
FormatConditionValueType_Number	Indicates that the minimum / midpoint / maximum value for the gradient is specified by a constant numeric value.
FormatConditionValueType_Percent	Value indicates a percentage between the minimum and maximum values in the range shall be used as the minimum / midpoint / maximum value for the gradient.
FormatConditionValueType_Percentile	Value indicates a percentile ranking in the range shall be used as the minimum / midpoint / maximum value for the gradient.
FormatConditionValueType_AutomaticMax	Indicates that the Automatic maximum value in the range shall be used as the Automatic maximum value for the gradient.
FormatConditionValueType_AutomaticMin	Indicates that the Automatic minimum value in the range shall be used as the Automatic minimum value for the gradient.

◆ HeaderFooterCommandType

enum Aspose::Cells::HeaderFooterCommandType

Represents the command type of header and footer.

Enumerator
HeaderFooterCommandType_Text	The text.
HeaderFooterCommandType_CurrentPage	Current page number
HeaderFooterCommandType_Pagecount	Page count
HeaderFooterCommandType_CurrentDate	Current date
HeaderFooterCommandType_CurrentTime	Current time
HeaderFooterCommandType_SheetName	Sheet name
HeaderFooterCommandType_FileName	File name without path
HeaderFooterCommandType_FilePath	File path without file name
HeaderFooterCommandType_Picture	Picture

◆ HtmlCrossType

enum Aspose::Cells::HtmlCrossType

Represents five types of html cross string.

Enumerator
HtmlCrossType_Default	Display like MS Excel,depends on the next cell. If the next cell is null,the string will cross,or it will be truncated
HtmlCrossType_MSExport	Display the string like MS Excel exporting html.
HtmlCrossType_Cross	Display HTML cross string, this performance for creating large html files will be more than ten times faster than setting the value to Default or FitToCell.
HtmlCrossType_CrossHideRight	Display HTML cross string and hide the right string when the texts overlap.
HtmlCrossType_FitToCell	Only displaying the string within the width of cell.

◆ HtmlExportDataOptions

enum Aspose::Cells::HtmlExportDataOptions

Represents the options for exporting html data.

Enumerator
HtmlExportDataOptions_Table	Export file to html which only contains table part.
HtmlExportDataOptions_All	Export all the data to html.

◆ HtmlHiddenColDisplayType

enum Aspose::Cells::HtmlHiddenColDisplayType

Represents two types of showing the hidden columns in html.

Enumerator
HtmlHiddenColDisplayType_Hidden	Hidden the hidden columns in html page.
HtmlHiddenColDisplayType_Remove	Remove the hidden columns in html page.

◆ HtmlHiddenRowDisplayType

enum Aspose::Cells::HtmlHiddenRowDisplayType

Represents two types of showing the hidden rows in html.

Enumerator
HtmlHiddenRowDisplayType_Hidden	Hidden the hidden rows in html page.
HtmlHiddenRowDisplayType_Remove	Remove the hidden rows in html page.

◆ HtmlLinkTargetType

enum Aspose::Cells::HtmlLinkTargetType

Represents the type of target attribute in HTML tag.

Enumerator
HtmlLinkTargetType_Blank	Opens the linked document in a new window or tab
HtmlLinkTargetType_Parent	Opens the linked document in the parent frame
HtmlLinkTargetType_Self	Opens the linked document in the same frame as it was clicked (this is default)
HtmlLinkTargetType_Top	Opens the linked document in the full body of the window

◆ IconSetType

enum Aspose::Cells::IconSetType

Icon set type for conditional formatting. The threshold values for triggering the different icons within a set are configurable, and the icon order is reversible.

Enumerator
IconSetType_Arrows3	3 arrows icon set.
IconSetType_ArrowsGray3	3 gray arrows icon set.
IconSetType_Flags3	3 flags icon set.
IconSetType_Signs3	3 signs icon set.
IconSetType_Symbols3	3 symbols icon set (circled).
IconSetType_Symbols32	3 Symbols icon set (uncircled).
IconSetType_TrafficLights31	3 traffic lights icon set (unrimmed).
IconSetType_TrafficLights32	3 traffic lights icon set with thick black border.
IconSetType_Arrows4	4 arrows icon set.
IconSetType_ArrowsGray4	4 gray arrows icon set.
IconSetType_Rating4	4 ratings icon set.
IconSetType_RedToBlack4	4 'red to black' icon set.
IconSetType_TrafficLights4	4 traffic lights icon set.
IconSetType_Arrows5	5 arrows icon set.
IconSetType_ArrowsGray5	5 gray arrows icon set.
IconSetType_Quarters5	5 quarters icon set.
IconSetType_Rating5	5 rating icon set.
IconSetType_Stars3	3 stars set
IconSetType_Boxes5	5 boxes set
IconSetType_Triangles3	3 triangles set
IconSetType_None	None
IconSetType_CustomSet	CustomSet. This element is read-only.
IconSetType_Smilies3	3 smilies. Only for .ods.
IconSetType_ColorSmilies3	3 color smilies. Only for .ods.

◆ LoadDataFilterOptions

enum Aspose::Cells::LoadDataFilterOptions

Represents the options to filter data when loading workbook from template.

Enumerator
LoadDataFilterOptions_None	Load nothing for sheet data NOTE: This member is now obsolete and please use Structure instead. This property will be removed 12 months later since December 2017. Aspose apologizes for any inconvenience you may have experienced.
LoadDataFilterOptions_All	Load all
LoadDataFilterOptions_CellBlank	Load cells whose value is blank
LoadDataFilterOptions_CellString	Load cells whose value is string
LoadDataFilterOptions_CellNumeric	Load cells whose value is numeric(including datetime)
LoadDataFilterOptions_CellError	Load cells whose value is error
LoadDataFilterOptions_CellBool	Load cells whose value is bool
LoadDataFilterOptions_CellValue	Load cells value(all value types) only
LoadDataFilterOptions_Formula	Load cell formulas. Generally defined Name objects(DefinedNames) also need to be loaded when loading formulas because they may be referenced by formulas. So Formula or CellData option should work with DefinedNames option together(Formula\|DefinedNames or CellData\|DefinedNames) for most scenarios.
LoadDataFilterOptions_CellData	Load cells data including values, formulas and formatting
LoadDataFilterOptions_Chart	Load charts
LoadDataFilterOptions_Shape	Load shapes NOTE: This member is now obsolete and please use Drawing instead. This property will be removed 12 months later since November 2019. Aspose apologizes for any inconvenience you may have experienced.
LoadDataFilterOptions_Drawing	Drawing objects(including Chart, Picture, OleObject and all other drawing objects)
LoadDataFilterOptions_MergedArea	Load merged cells
LoadDataFilterOptions_ConditionalFormatting	Load conditional formatting
LoadDataFilterOptions_DataValidation	Load data validations
LoadDataFilterOptions_PivotTable	Load pivot tables
LoadDataFilterOptions_Table	Load tables
LoadDataFilterOptions_Hyperlinks	Load hyperlinks
LoadDataFilterOptions_SheetSettings	Load settings for worksheet
LoadDataFilterOptions_SheetData	Load all data of worksheet, such as cells data, settings, objects, ...etc.
LoadDataFilterOptions_BookSettings	Load settings for workbook
LoadDataFilterOptions_Settings	Load settings for workbook and worksheet
LoadDataFilterOptions_XmlMap	Load XmlMap
LoadDataFilterOptions_Structure	Load structure of the workbook
LoadDataFilterOptions_DocumentProperties	Load document properties
LoadDataFilterOptions_DefinedNames	Load defined Name objects
LoadDataFilterOptions_VBA	Load VBA projects
LoadDataFilterOptions_Style	Load styles for cell formatting
LoadDataFilterOptions_Picture	Load pictures
LoadDataFilterOptions_OleObject	Load OleObjects
LoadDataFilterOptions_Revision	Load revision logs

◆ LoadFormat

enum Aspose::Cells::LoadFormat

Represents the load file format.

Enumerator
LoadFormat_Auto	Represents recognizing the format automatically.
LoadFormat_Csv	Comma-Separated Values(CSV) text file.
LoadFormat_CSV	Comma-Separated Values(CSV) text file. NOTE: This member is now obsolete. Instead, please use Csv property. This property will be removed 6 months later since April 2021. Aspose apologizes for any inconvenience you may have experienced.
LoadFormat_Xlsx	Represents Office Open XML spreadsheetML workbook or template, with or without macros.
LoadFormat_Tsv	Tab-Separated Values(TSV) text file.
LoadFormat_TSV	Tab-Separated Values(TSV) text file. NOTE: This member is now obsolete. Instead, please use Tsv property. This property will be removed 6 months later since April 2021. Aspose apologizes for any inconvenience you may have experienced.
LoadFormat_TabDelimited	Represents a tab delimited text file, same with Tsv
LoadFormat_Html	Represents a html file.
LoadFormat_MHtml	Represents a mhtml file.
LoadFormat_Ods	Open Document Sheet(ODS) file.
LoadFormat_ODS	Open Document Sheet(ODS) file. NOTE: This member is now obsolete. Instead, please use Ods property. This property will be removed 6 months later since April 2021. Aspose apologizes for any inconvenience you may have experienced.
LoadFormat_Excel97To2003	Represents an Excel97-2003 xls file.
LoadFormat_SpreadsheetML	Represents an Excel 2003 xml file.
LoadFormat_Xlsb	Represents an xlsb file.
LoadFormat_Ots	Open Document Template Sheet(OTS) file.
LoadFormat_Numbers	Represents a numbers file.
LoadFormat_Fods	Represents OpenDocument Flat XML Spreadsheet (.fods) file format.
LoadFormat_FODS	Represents OpenDocument Flat XML Spreadsheet (.fods) file format. NOTE: This member is now obsolete. Instead, please use Fods property. This property will be removed 6 months later since April 2021. Aspose apologizes for any inconvenience you may have experienced.
LoadFormat_Sxc	Represents StarOffice Calc Spreadsheet (.sxc) file format.
LoadFormat_SXC	Represents StarOffice Calc Spreadsheet (.sxc) file format. NOTE: This member is now obsolete. Instead, please use Sxc property. This property will be removed 6 months later since April 2021. Aspose apologizes for any inconvenience you may have experienced.
LoadFormat_Xml	Represents a simple xml file.
LoadFormat_Epub	Reprents an EPUB file.
LoadFormat_Unknown	Represents unrecognized format, cannot be loaded.
LoadFormat_Image	Image
LoadFormat_Json	Json

◆ LookAtType

enum Aspose::Cells::LookAtType

Represents look at type.

Enumerator
LookAtType_Contains	Cell value Contains the find object.
LookAtType_StartWith	Cell value Starts with the find object.
LookAtType_EndWith	Cell value ends with the find object.
LookAtType_EntireContent	Cell value is same as the find object.

◆ LookInType

enum Aspose::Cells::LookInType

Represents look in type.

Enumerator
LookInType_Formulas	If the cell contains a formula, find object from formula,else find it from the value.
LookInType_Values	Only find object from the formatted values.
LookInType_ValuesExcludeFormulaCell	Only find object from the values of cells which do not contains formula.
LookInType_Comments	Only find object from the comments.
LookInType_OnlyFormulas	Only find object from formulas.
LookInType_OriginalValues	Only find object from the original values.

◆ MemorySetting

enum Aspose::Cells::MemorySetting

Memory usage options.

Enumerator

MemorySetting_Normal

Default option for cells model.

This option is applied for all versions.

MemorySetting_MemoryPreference

Memory performance preferrable. With this option the data will be held in compact format so for common scenarios it may give lower memory cost. However, this option also may degrade R/W performance a bit in some special cases.

This option is available since v 8.0.0.

◆ NumberCategoryType

enum Aspose::Cells::NumberCategoryType

Represents category type of cell's number formatting.

Enumerator
NumberCategoryType_General	General
NumberCategoryType_Text	Text
NumberCategoryType_Number	Number
NumberCategoryType_Date	Date or Date and Time
NumberCategoryType_Time	Time
NumberCategoryType_Fraction	Fraction
NumberCategoryType_Scientific	Scientific

◆ OperatorType

enum Aspose::Cells::OperatorType

Represents the operator type of conditional format and data validation.

Enumerator
OperatorType_Between	Represents Between operator of conditional format and data validation.
OperatorType_Equal	Represents Equal operator of conditional format and data validation.
OperatorType_GreaterThan	Represents GreaterThan operator of conditional format and data validation.
OperatorType_GreaterOrEqual	Represents GreaterOrEqual operator of conditional format and data validation.
OperatorType_LessThan	Represents LessThan operator of conditional format and data validation.
OperatorType_LessOrEqual	Represents LessOrEqual operator of conditional format and data validation.
OperatorType_None	Represents no comparision.
OperatorType_NotBetween	Represents NotBetween operator of conditional format and data validation.
OperatorType_NotEqual	Represents NotEqual operator of conditional format and data validation.

◆ PageOrientationType

enum Aspose::Cells::PageOrientationType

Represents print orientation constants.

Enumerator
PageOrientationType_Landscape	Landscape orientation
PageOrientationType_Portrait	Portrait orientation

◆ PaperSizeType

enum Aspose::Cells::PaperSizeType

Represents paper size constants.

Enumerator
PaperSizeType_PaperLetter	Letter (8-1/2 in. x 11 in.)
PaperSizeType_PaperLetterSmall	Letter Small (8-1/2 in. x 11 in.)
PaperSizeType_PaperTabloid	Tabloid (11 in. x 17 in.)
PaperSizeType_PaperLedger	Ledger (17 in. x 11 in.)
PaperSizeType_PaperLegal	Legal (8-1/2 in. x 14 in.)
PaperSizeType_PaperStatement	Statement (5-1/2 in. x 8-1/2 in.)
PaperSizeType_PaperExecutive	Executive (7-1/4 in. x 10-1/2 in.)
PaperSizeType_PaperA3	A3 (297 mm x 420 mm)
PaperSizeType_PaperA4	A4 (210 mm x 297 mm)
PaperSizeType_PaperA4Small	A4 Small (210 mm x 297 mm)
PaperSizeType_PaperA5	A5 (148 mm x 210 mm)
PaperSizeType_PaperB4	JIS B4 (257 mm x 364 mm)
PaperSizeType_PaperB5	JIS B5 (182 mm x 257 mm)
PaperSizeType_PaperFolio	Folio (8-1/2 in. x 13 in.)
PaperSizeType_PaperQuarto	Quarto (215 mm x 275 mm)
PaperSizeType_Paper10x14	10 in. x 14 in.
PaperSizeType_Paper11x17	11 in. x 17 in.
PaperSizeType_PaperNote	Note (8-1/2 in. x 11 in.)
PaperSizeType_PaperEnvelope9	Envelope #9 (3-7/8 in. x 8-7/8 in.)
PaperSizeType_PaperEnvelope10	Envelope #10 (4-1/8 in. x 9-1/2 in.)
PaperSizeType_PaperEnvelope11	Envelope #11 (4-1/2 in. x 10-3/8 in.)
PaperSizeType_PaperEnvelope12	Envelope #12 (4-1/2 in. x 11 in.)
PaperSizeType_PaperEnvelope14	Envelope #14 (5 in. x 11-1/2 in.)
PaperSizeType_PaperCSheet	C size sheet
PaperSizeType_PaperDSheet	D size sheet
PaperSizeType_PaperESheet	E size sheet
PaperSizeType_PaperEnvelopeDL	Envelope DL (110 mm x 220 mm)
PaperSizeType_PaperEnvelopeC5	Envelope C5 (162 mm x 229 mm)
PaperSizeType_PaperEnvelopeC3	Envelope C3 (324 mm x 458 mm)
PaperSizeType_PaperEnvelopeC4	Envelope C4 (229 mm x 324 mm)
PaperSizeType_PaperEnvelopeC6	Envelope C6 (114 mm x 162 mm)
PaperSizeType_PaperEnvelopeC65	Envelope C65 (114 mm x 229 mm)
PaperSizeType_PaperEnvelopeB4	Envelope B4 (250 mm x 353 mm)
PaperSizeType_PaperEnvelopeB5	Envelope B5 (176 mm x 250 mm)
PaperSizeType_PaperEnvelopeB6	Envelope B6 (176 mm x 125 mm)
PaperSizeType_PaperEnvelopeItaly	Envelope Italy (110 mm x 230 mm)
PaperSizeType_PaperEnvelopeMonarch	Envelope Monarch (3-7/8 in. x 7-1/2 in.)
PaperSizeType_PaperEnvelopePersonal	Envelope (3-5/8 in. x 6-1/2 in.)
PaperSizeType_PaperFanfoldUS	U.S. Standard Fanfold (14-7/8 in. x 11 in.)
PaperSizeType_PaperFanfoldStdGerman	German Standard Fanfold (8-1/2 in. x 12 in.)
PaperSizeType_PaperFanfoldLegalGerman	German Legal Fanfold (8-1/2 in. x 13 in.)
PaperSizeType_PaperISOB4	B4 (ISO) 250 x 353 mm
PaperSizeType_PaperJapanesePostcard	Japanese Postcard (100mm � 148mm)
PaperSizeType_Paper9x11	9? � 11?
PaperSizeType_Paper10x11	10? � 11?
PaperSizeType_Paper15x11	15? � 11?
PaperSizeType_PaperEnvelopeInvite	Envelope Invite(220mm � 220mm)
PaperSizeType_PaperLetterExtra	US Letter Extra 9 \275 x 12 in
PaperSizeType_PaperLegalExtra	US Legal Extra 9 \275 x 15 in
PaperSizeType_PaperTabloidExtra	US Tabloid Extra 11.69 x 18 in
PaperSizeType_PaperA4Extra	A4 Extra 9.27 x 12.69 in
PaperSizeType_PaperLetterTransverse	Letter Transverse 8 \275 x 11 in
PaperSizeType_PaperA4Transverse	A4 Transverse 210 x 297 mm
PaperSizeType_PaperLetterExtraTransverse	Letter Extra Transverse 9\275 x 12 in
PaperSizeType_PaperSuperA	SuperA/SuperA/A4 227 x 356 mm
PaperSizeType_PaperSuperB	SuperB/SuperB/A3 305 x 487 mm
PaperSizeType_PaperLetterPlus	US Letter Plus 8.5 x 12.69 in
PaperSizeType_PaperA4Plus	A4 Plus 210 x 330 mm
PaperSizeType_PaperA5Transverse	A5 Transverse 148 x 210 mm
PaperSizeType_PaperJISB5Transverse	B5 (JIS) Transverse 182 x 257 mm
PaperSizeType_PaperA3Extra	A3 Extra 322 x 445 mm
PaperSizeType_PaperA5Extra	A5 Extra 174 x 235 mm
PaperSizeType_PaperISOB5Extra	B5 (ISO) Extra 201 x 276 mm
PaperSizeType_PaperA2	A2 420 x 594 mm
PaperSizeType_PaperA3Transverse	A3 Transverse 297 x 420 mm
PaperSizeType_PaperA3ExtraTransverse	A3 Extra Transverse 322 x 445 mm
PaperSizeType_PaperJapaneseDoublePostcard	Japanese Double Postcard 200 x 148 mm
PaperSizeType_PaperA6	A6 105 x 148 mm
PaperSizeType_PaperJapaneseEnvelopeKaku2	Japanese Envelope Kaku #2
PaperSizeType_PaperJapaneseEnvelopeKaku3	Japanese Envelope Kaku #3
PaperSizeType_PaperJapaneseEnvelopeChou3	Japanese Envelope Chou #3
PaperSizeType_PaperJapaneseEnvelopeChou4	Japanese Envelope Chou #4
PaperSizeType_PaperLetterRotated	11in � 8.5in
PaperSizeType_PaperA3Rotated	420mm � 297mm
PaperSizeType_PaperA4Rotated	297mm � 210mm
PaperSizeType_PaperA5Rotated	210mm � 148mm
PaperSizeType_PaperJISB4Rotated	B4 (JIS) Rotated 364 x 257 mm
PaperSizeType_PaperJISB5Rotated	B5 (JIS) Rotated 257 x 182 mm
PaperSizeType_PaperJapanesePostcardRotated	Japanese Postcard Rotated 148 x 100 mm
PaperSizeType_PaperJapaneseDoublePostcardRotated	Double Japanese Postcard Rotated 148 x 200 mm
PaperSizeType_PaperA6Rotated	A6 Rotated 148 x 105 mm
PaperSizeType_PaperJapaneseEnvelopeKaku2Rotated	Japanese Envelope Kaku #2 Rotated
PaperSizeType_PaperJapaneseEnvelopeKaku3Rotated	Japanese Envelope Kaku #3 Rotated
PaperSizeType_PaperJapaneseEnvelopeChou3Rotated	Japanese Envelope Chou #3 Rotated
PaperSizeType_PaperJapaneseEnvelopeChou4Rotated	Japanese Envelope Chou #4 Rotated
PaperSizeType_PaperJISB6	B6 (JIS) 128 x 182 mm
PaperSizeType_PaperJISB6Rotated	B6 (JIS) Rotated 182 x 128 mm
PaperSizeType_Paper12x11	12 x 11 in
PaperSizeType_PaperJapaneseEnvelopeYou4	Japanese Envelope You #4
PaperSizeType_PaperJapaneseEnvelopeYou4Rotated	Japanese Envelope You #4 Rotated
PaperSizeType_PaperPRC16K	PRC 16K 146 x 215 mm
PaperSizeType_PaperPRC32K	PRC 32K 97 x 151 mm
PaperSizeType_PaperPRCBig32K	PRC 32K(Big) 97 x 151 mm
PaperSizeType_PaperPRCEnvelope1	PRC Envelope #1 102 x 165 mm
PaperSizeType_PaperPRCEnvelope2	PRC Envelope #2 102 x 176 mm
PaperSizeType_PaperPRCEnvelope3	PRC Envelope #3 125 x 176 mm
PaperSizeType_PaperPRCEnvelope4	PRC Envelope #4 110 x 208 mm
PaperSizeType_PaperPRCEnvelope5	PRC Envelope #5 110 x 220 mm
PaperSizeType_PaperPRCEnvelope6	PRC Envelope #6 120 x 230 mm
PaperSizeType_PaperPRCEnvelope7	PRC Envelope #7 160 x 230 mm
PaperSizeType_PaperPRCEnvelope8	PRC Envelope #8 120 x 309 mm
PaperSizeType_PaperPRCEnvelope9	PRC Envelope #9 229 x 324 mm
PaperSizeType_PaperPRCEnvelope10	PRC Envelope #10 324 x 458 mm
PaperSizeType_PaperPRC16KRotated	PRC 16K Rotated
PaperSizeType_PaperPRC32KRotated	PRC 32K Rotated
PaperSizeType_PaperPRCBig32KRotated	PRC 32K(Big) Rotated
PaperSizeType_PaperPRCEnvelope1Rotated	PRC Envelope #1 Rotated 165 x 102 mm
PaperSizeType_PaperPRCEnvelope2Rotated	PRC Envelope #2 Rotated 176 x 102 mm
PaperSizeType_PaperPRCEnvelope3Rotated	PRC Envelope #3 Rotated 176 x 125 mm
PaperSizeType_PaperPRCEnvelope4Rotated	PRC Envelope #4 Rotated 208 x 110 mm
PaperSizeType_PaperPRCEnvelope5Rotated	PRC Envelope #5 Rotated 220 x 110 mm
PaperSizeType_PaperPRCEnvelope6Rotated	PRC Envelope #6 Rotated 230 x 120 mm
PaperSizeType_PaperPRCEnvelope7Rotated	PRC Envelope #7 Rotated 230 x 160 mm
PaperSizeType_PaperPRCEnvelope8Rotated	PRC Envelope #8 Rotated 309 x 120 mm
PaperSizeType_PaperPRCEnvelope9Rotated	PRC Envelope #9 Rotated 324 x 229 mm
PaperSizeType_PaperPRCEnvelope10Rotated	PRC Envelope #10 Rotated 458 x 324 mm
PaperSizeType_PaperB3	usual B3(13.9 x 19.7 in)
PaperSizeType_PaperBusinessCard	Business Card(90mm x 55 mm)
PaperSizeType_PaperThermal	Thermal(3 x 11 in)
PaperSizeType_Custom	Represents the custom paper size.

◆ ParameterType

enum Aspose::Cells::ParameterType

Represent all parameters' type or return value type of function.

Enumerator
ParameterType_Reference
ParameterType_Value
ParameterType_Array

◆ PasteType

enum Aspose::Cells::PasteType

Represents the paste special type.

Enumerator
PasteType_All	Copies all data of the range.
PasteType_Default	It works as "All" behavior of MS Excel.
PasteType_AllExceptBorders	Copies all data of the range without the range.
PasteType_DefaultExceptBorders	It works as "All except borders" behavior of MS Excel.
PasteType_ColumnWidths	Only copies the widths of the range.
PasteType_RowHeights	Only copies the heights of the range.
PasteType_Comments
PasteType_Formats
PasteType_Formulas
PasteType_FormulasAndNumberFormats
PasteType_Validation
PasteType_Values
PasteType_ValuesAndFormats
PasteType_ValuesAndNumberFormats

◆ PrintCommentsType

enum Aspose::Cells::PrintCommentsType

Represents the way comments are printed with the sheet.

Enumerator
PrintCommentsType_PrintInPlace	Represents to print comments as displayed on sheet.
PrintCommentsType_PrintNoComments	Represents not to print comments.
PrintCommentsType_PrintSheetEnd	Represents to print comments at end of sheet.

◆ PrintErrorsType

enum Aspose::Cells::PrintErrorsType

Represents print errors constants.

Enumerator
PrintErrorsType_PrintErrorsBlank	Represents not to print errors.
PrintErrorsType_PrintErrorsDash	Represents to print errors as "--".
PrintErrorsType_PrintErrorsDisplayed	Represents to print errors as displayed.
PrintErrorsType_PrintErrorsNA	Represents to print errors as "#N/A".

◆ PrintingPageType

enum Aspose::Cells::PrintingPageType

Indicates which pages will not be printed.

Enumerator
PrintingPageType_Default	Prints all pages.
PrintingPageType_IgnoreBlank	Don't print the pages which the cells are blank.
PrintingPageType_IgnoreStyle	Don't print the pages which cells only contain styles.

◆ PrintOrderType

enum Aspose::Cells::PrintOrderType

Represent print order constants.

Enumerator
PrintOrderType_DownThenOver	Down, then over
PrintOrderType_OverThenDown	Over, then down

◆ PrintSizeType

enum Aspose::Cells::PrintSizeType

Represents the printed chart size.

Enumerator
PrintSizeType_Full	Use full page.
PrintSizeType_Fit	Scale to fit page.
PrintSizeType_Custom	Custom.

◆ ProtectionType

enum Aspose::Cells::ProtectionType

Represents workbook/worksheet protection type.

Enumerator
ProtectionType_All	Represents to protect all.
ProtectionType_Contents	Represents to protect contents, used in Worksheet protection.
ProtectionType_Objects	Represents to protect objects, used in Worksheet protection.
ProtectionType_Scenarios	Represents to protect scenarios, used in Worksheet protection.
ProtectionType_Structure	Represents to protect structure, used in Workbook protection.
ProtectionType_Windows	Represents to protect window, used in Workbook protection.
ProtectionType_None	Represents no protection. Only for Reading property.

◆ SaveFormat

enum Aspose::Cells::SaveFormat

Represents the format in which the workbook is saved.

Enumerator
SaveFormat_Csv	Comma-Separated Values(CSV) text file.
SaveFormat_CSV	Comma-Separated Values(CSV) text file. NOTE: This member is now obsolete. Instead, please use Csv property. This property will be removed 6 months later since April 2021. Aspose apologizes for any inconvenience you may have experienced.
SaveFormat_Xlsx	Represents an xlsx file.
SaveFormat_Xlsm	Represents an xlsm file which enable macros.
SaveFormat_Xltx	Represents an xltx file.
SaveFormat_Xltm	Represents an xltm file which enable macros.
SaveFormat_Xlam	Represents an xltm file which enable addin macros.
SaveFormat_Tsv	Tab-Separated Values(TSV) text file.
SaveFormat_TSV	Tab-Separated Values(TSV) text file. NOTE: This member is now obsolete. Instead, please use Tsv property.
SaveFormat_TabDelimited	Represents a tab delimited text file, same with Tsv
SaveFormat_Html	Represents a html file.
SaveFormat_MHtml	Represents a mhtml file.
SaveFormat_Ods	Open Document Sheet(ODS) file.
SaveFormat_ODS	Open Document Sheet(ODS) file. NOTE: This member is now obsolete. Instead, please use Ods property.
SaveFormat_Excel97To2003	Represents an Excel97-2003 xls file.
SaveFormat_SpreadsheetML	Represents an Excel 2003 xml file.
SaveFormat_Xlsb	Represents an xlsb file.
SaveFormat_Auto	If saving the file to the disk,the file format accords to the extension of the file name. If saving the file to the stream, the file format is xlsx.
SaveFormat_Unknown	Represents unrecognized format, cannot be saved.
SaveFormat_Pdf	Represents a Pdf file.
SaveFormat_Xps	XPS (XML Paper Specification) format.
SaveFormat_XPS	XPS (XML Paper Specification) format. NOTE: This member is now obsolete. Instead, please use SaveFormat_Xps property.
SaveFormat_Tiff	Represents a TIFF file.
SaveFormat_TIFF	Represents a TIFF file. NOTE: This member is now obsolete. Instead, please use SaveFormat_Tiff property.
SaveFormat_Svg	SVG file.
SaveFormat_SVG	SVG file. NOTE: This member is now obsolete. Instead, please use SaveFormat_Svg property.
SaveFormat_Dif	Data Interchange Format.
SaveFormat_Ots	Open Document Template Sheet(OTS) file.
SaveFormat_Xlt	Excel 97-2003 template file.
SaveFormat_Xml	Represents a simple xml file.
SaveFormat_Numbers	Represents a numbers file. Not supported.
SaveFormat_Markdown	Represents markdown document.
SaveFormat_Fods	Represents OpenDocument Flat XML Spreadsheet (.fods) file format.
SaveFormat_FODS	Represents OpenDocument Flat XML Spreadsheet (.fods) file format. NOTE: This member is now obsolete. Instead, please use Fods property.
SaveFormat_Sxc	Represents StarOffice Calc Spreadsheet (.sxc) file format.
SaveFormat_SXC	Represents StarOffice Calc Spreadsheet (.sxc) file format. NOTE: This member is now obsolete. Instead, please use Sxc property.
SaveFormat_Pptx	Represents .pptx file.
SaveFormat_Docx	Represents .docx file.
SaveFormat_Emf	Windows Enhanced Metafile.
SaveFormat_Jpg	JPEG JFIF.
SaveFormat_Png	Portable Network Graphics.
SaveFormat_Bmp	Windows Bitmap
SaveFormat_Gif	Gif
SaveFormat_Json	Json
SaveFormat_SqlScript	Sql
SaveFormat_XHtml	Rrepesents XHtml file.
SaveFormat_Epub	Represents Epub file.

◆ SheetType

enum Aspose::Cells::SheetType

Specifies the worksheet type.

Enumerator
SheetType_VB	Visual Basic module
SheetType_Worksheet
SheetType_Chart	Chart
SheetType_BIFF4Macro	BIFF4 Macro sheet
SheetType_InternationalMacro	International Macro sheet
SheetType_Other
SheetType_Dialog	Dialog worksheet

◆ ShiftType

enum Aspose::Cells::ShiftType

Represent the shift options when deleting a range of cells.

Enumerator
ShiftType_Down	Shift cells down.
ShiftType_Left	Shift cells left.
ShiftType_None	Do not shift cells.
ShiftType_Right	Shift cells right.
ShiftType_Up	Shift cells up.

◆ SortOrder

enum Aspose::Cells::SortOrder

Represents sort order for the data range.

Enumerator
SortOrder_Ascending
SortOrder_Descending

◆ StyleModifyFlag

enum Aspose::Cells::StyleModifyFlag

The style modified flags.

Enumerator
StyleModifyFlag_LeftBorder	Indicates whether left border has been modified for the style.
StyleModifyFlag_RightBorder	Indicates whether right border has been modified for the style.
StyleModifyFlag_TopBorder	Indicates whether top border has been modified for the style.
StyleModifyFlag_BottomBorder	Indicates whether bottom border has been modified for the style.
StyleModifyFlag_DiagonalDownBorder	Indicates whether diagonal-down border has been modified for the style.
StyleModifyFlag_DiagonalUpBorder	Indicates whether diagonal-up border has been modified for the style.
StyleModifyFlag_Diagonal	Indicates whether one or more diagonal borders(DiagonalDownBorder , DiagonalUpBorder ) have been modified for the style.
StyleModifyFlag_HorizontalBorder	Indicates whether horizontal border has been modified for the style. Only for dynamic style, such as conditional formatting.
StyleModifyFlag_VerticalBorder	Indicates whether vertical border has been modified for the style. Only for dynamic style, such as conditional formatting.
StyleModifyFlag_Borders	Indicates whether one or more borders(LeftBorder , RightBorder , TopBorder , BottomBorder , Diagonal , HorizontalBorder , VerticalBorder ) have been modified for the style.
StyleModifyFlag_NumberFormat	Indicates whether numberformat has been modified.
StyleModifyFlag_HorizontalAlignment	Indicates whether horizontal alignment has been modified.
StyleModifyFlag_VerticalAlignment	Indicates whether vertical alignment has been modified.
StyleModifyFlag_Indent	Indicates whether indent property has been modified.
StyleModifyFlag_Rotation	Indicates whether rotation property has been modified.
StyleModifyFlag_WrapText	Indicates whether wrap text property has been modified.
StyleModifyFlag_ShrinkToFit	Indicates whether shrink to fit property has been modified.
StyleModifyFlag_TextDirection	Indicates whether text direction property has been modified.
StyleModifyFlag_RelativeIndent	Indicates whether relative indent property has been modified for the style. Only for dynamic style, such as conditional formatting.
StyleModifyFlag_AlignmentSettings	Indicates whether one or more alignment-related properties(HorizontalAlignment , VerticalAlignment , Rotation , WrapText , WrapText , Indent , ShrinkToFit , TextDirection , RelativeIndent ) have been modified.
StyleModifyFlag_Pattern	Indicates whether pattern of the shading has been modified.
StyleModifyFlag_ForegroundColor	Indicates whether foreground color has been modified.
StyleModifyFlag_BackgroundColor	Indicates whether background color has been modified.
StyleModifyFlag_CellShading	Indicates whether one or more shading-related properties(Pattern , ForegroundColor , BackgroundColor ) have been modified.
StyleModifyFlag_Locked	Indicates whether locked property has been modified.
StyleModifyFlag_HideFormula	Indicates whether hide formula has been modified.
StyleModifyFlag_ProtectionSettings	Indicates whether one or more protection-related properties(Locked , HideFormula ) have been modified.
StyleModifyFlag_FontSize	Indicates whether font size has been modified.
StyleModifyFlag_FontName	Indicates whether font name has been modified.
StyleModifyFlag_FontColor	Indicates whether font color has been modified.
StyleModifyFlag_FontWeight	Indicates whether font weight has been modified.
StyleModifyFlag_FontItalic	Indicates whether italic property of font has been modified.
StyleModifyFlag_FontUnderline	Indicates whether underline property of font has been modified.
StyleModifyFlag_FontStrike	Indicates whether strike property font has been modified.
StyleModifyFlag_FontScript	Indicates whether subscript or superscript property of font has been modified.
StyleModifyFlag_FontFamily	Indicates whether font family has been modified.
StyleModifyFlag_FontCharset	Indicates whether charset of the font has been modified.
StyleModifyFlag_FontScheme	unused.
StyleModifyFlag_FontDirty	unused.
StyleModifyFlag_FontSpellingError	unused.
StyleModifyFlag_FontUFillTx	unused.
StyleModifyFlag_FontSpacing	unused.
StyleModifyFlag_FontKerning	unused.
StyleModifyFlag_FontEqualize	unused.
StyleModifyFlag_FontCap	unused.
StyleModifyFlag_FontVerticalText
StyleModifyFlag_Font	Indicates whether one or more properties have been modified for the font of the style.
StyleModifyFlag_All	Indicates whether one or more properties have been modified for the style.

◆ TextAlignmentType

enum Aspose::Cells::TextAlignmentType

Enumerates text alignment types.

Enumerator
TextAlignmentType_General	Represents general text alignment.
TextAlignmentType_Bottom	Represents bottom text alignment.
TextAlignmentType_Center	Represents center text alignment.
TextAlignmentType_CenterAcross	Represents center across text alignment.
TextAlignmentType_Distributed	Represents distributed text alignment.
TextAlignmentType_Fill	Represents fill text alignment.
TextAlignmentType_Justify	Represents justify text alignment.
TextAlignmentType_Left	Represents left text alignment.
TextAlignmentType_Right	Represents right text alignment.
TextAlignmentType_Top	Represents top text alignment.
TextAlignmentType_JustifiedLow	Aligns the text with an adjusted kashida length for Arabic text.
TextAlignmentType_ThaiDistributed	Distributes Thai text specially, because each character is treated as a word.

◆ TextCapsType

enum Aspose::Cells::TextCapsType

This type specifies the cap types of the text.

Enumerator
TextCapsType_None	None caps
TextCapsType_All	Apply all caps on the text.
TextCapsType_Small	Apply small caps to the text.

◆ TextDirectionType

enum Aspose::Cells::TextDirectionType

Represents the direction of the text flow for this paragraph.

Enumerator
TextDirectionType_Context
TextDirectionType_LeftToRight
TextDirectionType_RightToLeft

◆ TextOrientationType

enum Aspose::Cells::TextOrientationType

Enumerates text orientation types.

Enumerator
TextOrientationType_ClockWise	Rotates text with 90 degrees clockwise.
TextOrientationType_CounterClockWise	Rotates text with 90 degrees counterclockwise.
TextOrientationType_NoRotation	Represents the default value.
TextOrientationType_TopToBottom	Displays text from top to bottom of the cell. Stacked text.

◆ TextStrikeType

enum Aspose::Cells::TextStrikeType

This type specifies the strike type.

Enumerator
TextStrikeType_Single	A single strikethrough applied on the text.
TextStrikeType_Double	A double strikethrough applied on the text.
TextStrikeType_None	No strike is applied to the text.

◆ ThemeColorType

enum Aspose::Cells::ThemeColorType

Enumerates the theme color types.

Enumerator
ThemeColorType_Background1
ThemeColorType_Text1
ThemeColorType_Background2
ThemeColorType_Text2
ThemeColorType_Accent1
ThemeColorType_Accent2
ThemeColorType_Accent3
ThemeColorType_Accent4
ThemeColorType_Accent5
ThemeColorType_Accent6
ThemeColorType_Hyperlink
ThemeColorType_FollowedHyperlink
ThemeColorType_StyleColor	Inner used. A color used in theme definitions which means to use the color of the style.

◆ TimePeriodType

enum Aspose::Cells::TimePeriodType

Used in a FormatConditionType.TimePeriod conditional formatting rule. These are dynamic time periods, which change based on the date the conditional formatting is refreshed / applied.

Enumerator
TimePeriodType_Today	Today's date.
TimePeriodType_Yesterday	Yesterday's date.
TimePeriodType_Tomorrow	Tomorrow's date.
TimePeriodType_Last7Days	A date in the last seven days.
TimePeriodType_ThisMonth	A date occurring in this calendar month.
TimePeriodType_LastMonth	A date occurring in the last calendar month.
TimePeriodType_NextMonth	A date occurring in the next calendar month.
TimePeriodType_ThisWeek	A date occurring this week.
TimePeriodType_LastWeek	A date occurring last week.
TimePeriodType_NextWeek	A date occurring next week.
TimePeriodType_ThisYear	A date occurring this year. Only for .ods.
TimePeriodType_LastYear	A date occurring last year. Only for .ods.
TimePeriodType_NextYear	A date occurring next year. Only for .ods.

◆ TxtLoadStyleStrategy

enum Aspose::Cells::TxtLoadStyleStrategy

Specifies how to apply style for parsed values when converting string value to number or datetime.

Enumerator

TxtLoadStyleStrategy_None

Does not set style for the parsed value.

TxtLoadStyleStrategy_BuiltIn

Set the style as built-in number/datetime when the parsed value are plain numeric/datetime values.

When ms excel parsing datetime or numeric values according to user's input(such as CSV file), the formatting of those values may be changed, such as leading/tailing zeros of number, year/month/day order of datetime, ...etc. This type is for simulating ms excel's behavior.

TxtLoadStyleStrategy_ExactFormat

Set the exact custom format for the parsed value to make the formatted value be same with the original input one.

◆ TxtValueQuoteType

enum Aspose::Cells::TxtValueQuoteType

Specifies the type of using quotation marks for values in text format files.

Enumerator
TxtValueQuoteType_Normal	All values that contain special characters such as quotation mark, separator character will be quoted. Same with the behavior of ms excel for exporting text file.
TxtValueQuoteType_Always	All values will be quoted always.
TxtValueQuoteType_Minimum	Only quote values when needed. Such as, if one value contains quotation mark but the quotation mark is not at the begin of this value, this value will not be quoted.
TxtValueQuoteType_Never	All values will not be quoted. The exported text file with this type may not be read back correctly because the needed quotation marks being absent.

◆ UpdateLinksType

enum Aspose::Cells::UpdateLinksType

Represents how to update links to other workbooks when the workbook is opened.

Enumerator
UpdateLinksType_UserSet	Prompt user to update.
UpdateLinksType_Never	Do not update, and do not prompt user.
UpdateLinksType_Always	Always update.

◆ ValidationAlertType

enum Aspose::Cells::ValidationAlertType

Represents the data validation alert style.

Enumerator
ValidationAlertType_Information	Information alert style.
ValidationAlertType_Stop	Stop alert style.
ValidationAlertType_Warning	Warning alert style.

◆ ValidationType

enum Aspose::Cells::ValidationType

Represents data validation type.

Enumerator
ValidationType_AnyValue	Any value validation type.
ValidationType_WholeNumber	Whole number validation type.
ValidationType_Decimal	Decimal validation type.
ValidationType_List	List validation type.
ValidationType_Date	Date validation type.
ValidationType_Time	Time validation type.
ValidationType_TextLength	Text length validation type.
ValidationType_Custom	Custom validation type.

◆ ViewType

enum Aspose::Cells::ViewType

Represents the view type of the worksheet.

Enumerator
ViewType_NormalView
ViewType_PageBreakPreview
ViewType_PageLayoutView

◆ VisibilityType

enum Aspose::Cells::VisibilityType

Represents the states for sheet visibility.

Enumerator
VisibilityType_Visible	Indicates the sheet is visible.
VisibilityType_Hidden	Indicates the sheet is hidden, but can be shown by the user via the user interface.
VisibilityType_VeryHidden	Indicates the sheet is hidden and cannot be shown in the user interface (UI). This state is only available programmatically.

Namespaces

Classes

Enumerations

Enumeration Type Documentation

◆ BackgroundType

◆ BorderType

◆ BuiltinStyleType

◆ CalcModeType

◆ CalculationPrecisionStrategy

◆ CellBorderType

◆ CellValueFormatStrategy

◆ CellValueType

◆ ColorType

◆ ConsolidationFunction

◆ CountryCode

◆ DataBarAxisPosition

◆ DataBarBorderType

◆ DataBarFillType

◆ DataBarNegativeColorType

◆ DateTimeGroupingType

◆ DirectoryType

◆ DisplayDrawingObjects

◆ DynamicFilterType

◆ EncryptionType

◆ ErrorCheckType

◆ ErrorType

◆ ExceptionType

◆ ExternalCellValueType

◆ FileFormatType

◆ FilterOperatorType

◆ FontUnderlineType

◆ FormatConditionType

◆ FormatConditionValueType

◆ HeaderFooterCommandType

◆ HtmlCrossType

◆ HtmlExportDataOptions

◆ HtmlHiddenColDisplayType

◆ HtmlHiddenRowDisplayType

◆ HtmlLinkTargetType

◆ IconSetType

◆ LoadDataFilterOptions

◆ LoadFormat

◆ LookAtType

◆ LookInType

◆ MemorySetting

◆ NumberCategoryType

◆ OperatorType

◆ PageOrientationType

◆ PaperSizeType

◆ ParameterType

◆ PasteType

◆ PrintCommentsType

◆ PrintErrorsType

◆ PrintingPageType

◆ PrintOrderType

◆ PrintSizeType

◆ ProtectionType

◆ SaveFormat

◆ SheetType

◆ ShiftType

◆ SortOrder

◆ StyleModifyFlag

◆ TextAlignmentType

◆ TextCapsType

◆ TextDirectionType

◆ TextOrientationType

◆ TextStrikeType

◆ ThemeColorType

◆ TimePeriodType

◆ TxtLoadStyleStrategy

◆ TxtValueQuoteType

◆ UpdateLinksType

◆ ValidationAlertType

◆ ValidationType

◆ ViewType

◆ VisibilityType