• SpreadsheetGear 2023
  • Getting Started
    • Installing SpreadsheetGear 2023
      • Add WorkbookView and FormulaBar to Visual Studio Toolbox
    • Using Help
    • Using the Samples
      • SpreadsheetGear Explorer for .NET Sample Solution
    • Getting Support
  • What's New
    • SpreadsheetGear 2023
      • New Features
      • Issues Resolved
      • Breaking Changes
      • Limitations
    • SpreadsheetGear 2017
      • New Features
      • Issues Resolved
      • Breaking Changes
      • Limitations
    • SpreadsheetGear 2012
      • New Features
      • Issues Resolved
      • Breaking Changes
      • Limitations
    • SpreadsheetGear 2010
      • New Features
      • Issues Resolved
      • Limitations
    • SpreadsheetGear 2009
      • New Features
      • Issues Resolved
      • Limitations
    • SpreadsheetGear 2008
      • New Features
      • Issues Resolved
      • Breaking Changes
      • Limitations
    • Previous Versions
  • Tutorials
    • Key Concepts
      • Workbook Sets
      • Workbooks, Worksheets and Ranges
      • Shapes, Form Controls and Cell Comments
      • Charts
      • Workbook Views
      • GetLock and ReleaseLock
      • Easily Take Advantage of Multi-Core CPUs
      • SpreadsheetGear Assemblies
      • SpreadsheetGear API
    • Core Spreadsheet Engine
    • Windows Forms
    • WPF
    • ASP.NET
    • ASP.NET Code Behind
    • Deploying SpreadsheetGear 2023
  • Reference
    • SpreadsheetGear2023 Assembly
      • Overview
      • Namespaces
        • SpreadsheetGear Namespace
          • Overview
          • Classes
            • AutoFilterDateTimeGroupItem
              • Overview
              • Members
              • AutoFilterDateTimeGroupItem Constructor
              • Methods
                • Equals Method
                • GetHashCode Method
              • Properties
                • DateTime Property
                • DateTimeGrouping Property
            • ColorIndex
              • Overview
              • Members
              • Fields
                • Automatic Field
                • None Field
            • Colors
              • Overview
              • Members
              • Colors Constructor
              • Fields
                • AliceBlue Field
                • AntiqueWhite Field
                • Aqua Field
                • Aquamarine Field
                • Azure Field
                • Beige Field
                • Bisque Field
                • Black Field
                • BlanchedAlmond Field
                • Blue Field
                • BlueViolet Field
                • Brown Field
                • BurlyWood Field
                • CadetBlue Field
                • Chartreuse Field
                • Chocolate Field
                • Coral Field
                • CornflowerBlue Field
                • Cornsilk Field
                • Crimson Field
                • Cyan Field
                • DarkBlue Field
                • DarkCyan Field
                • DarkGoldenrod Field
                • DarkGray Field
                • DarkGreen Field
                • DarkKhaki Field
                • DarkMagenta Field
                • DarkOliveGreen Field
                • DarkOrange Field
                • DarkOrchid Field
                • DarkRed Field
                • DarkSalmon Field
                • DarkSeaGreen Field
                • DarkSlateBlue Field
                • DarkSlateGray Field
                • DarkTurquoise Field
                • DarkViolet Field
                • DeepPink Field
                • DeepSkyBlue Field
                • DimGray Field
                • DodgerBlue Field
                • FireBrick Field
                • FloralWhite Field
                • ForestGreen Field
                • Fuchsia Field
                • Gainsboro Field
                • GhostWhite Field
                • Gold Field
                • Goldenrod Field
                • Gray Field
                • Green Field
                • GreenYellow Field
                • Honeydew Field
                • HotPink Field
                • IndianRed Field
                • Indigo Field
                • Ivory Field
                • Khaki Field
                • Lavender Field
                • LavenderBlush Field
                • LawnGreen Field
                • LemonChiffon Field
                • LightBlue Field
                • LightCoral Field
                • LightCyan Field
                • LightGoldenrodYellow Field
                • LightGray Field
                • LightGreen Field
                • LightPink Field
                • LightSalmon Field
                • LightSeaGreen Field
                • LightSkyBlue Field
                • LightSlateGray Field
                • LightSteelBlue Field
                • LightYellow Field
                • Lime Field
                • LimeGreen Field
                • Linen Field
                • Magenta Field
                • Maroon Field
                • MediumAquamarine Field
                • MediumBlue Field
                • MediumOrchid Field
                • MediumPurple Field
                • MediumSeaGreen Field
                • MediumSlateBlue Field
                • MediumSpringGreen Field
                • MediumTurquoise Field
                • MediumVioletRed Field
                • MidnightBlue Field
                • MintCream Field
                • MistyRose Field
                • Moccasin Field
                • NavajoWhite Field
                • Navy Field
                • OldLace Field
                • Olive Field
                • OliveDrab Field
                • Orange Field
                • OrangeRed Field
                • Orchid Field
                • PaleGoldenrod Field
                • PaleGreen Field
                • PaleTurquoise Field
                • PaleVioletRed Field
                • PapayaWhip Field
                • PeachPuff Field
                • Peru Field
                • Pink Field
                • Plum Field
                • PowderBlue Field
                • Purple Field
                • Red Field
                • RosyBrown Field
                • RoyalBlue Field
                • SaddleBrown Field
                • Salmon Field
                • SandyBrown Field
                • SeaGreen Field
                • Seashell Field
                • Sienna Field
                • Silver Field
                • SkyBlue Field
                • SlateBlue Field
                • SlateGray Field
                • Snow Field
                • SpringGreen Field
                • SteelBlue Field
                • Tan Field
                • Teal Field
                • Thistle Field
                • Tomato Field
                • Transparent Field
                • Turquoise Field
                • Violet Field
                • Wheat Field
                • White Field
                • WhiteSmoke Field
                • Yellow Field
                • YellowGreen Field
            • DefaultSystemColors
              • Overview
              • Members
              • DefaultSystemColors Constructor
              • Fields
                • Window Field
                • WindowText Field
            • EndCalculateEventArgs
              • Overview
              • Members
              • Properties
                • BackgroundCalculation Property
            • Factory
              • Overview
              • Members
              • Methods
                • CheckFramework Method
                • GetWorkbook Method
                  • GetWorkbook() Method
                  • GetWorkbook(CultureInfo) Method
                  • GetWorkbook(String) Method
                  • GetWorkbook(String,CultureInfo) Method
                • GetWorkbookSet Method
                  • GetWorkbookSet() Method
                  • GetWorkbookSet(CultureInfo) Method
            • Orientation
              • Overview
              • Members
              • Orientation Constructor
              • Fields
                • Downward Field
                • Horizontal Field
                • Upward Field
                • Vertical Field
            • SortKey
              • Overview
              • Members
              • SortKey Constructor
              • Properties
                • DataOption Property
                • Key Property
                • Order Property
            • SystemColors
              • Overview
              • Members
              • SystemColors Constructor
              • Fields
                • Window Field
                • WindowText Field
          • Enumerations
            • AboveBelow
            • AutoFillType
            • AutoFilterDateTimeGrouping
            • AutoFilterOperator
            • BordersIndex
            • BorderWeight
            • Calculation
            • ConditionValueTypes
            • ContainsOperator
            • DataBarAxisPosition
            • DataBarBorderType
            • DataBarFillType
            • DataBarNegativeColorType
            • DataSeriesDate
            • DataSeriesType
            • DeleteShiftDirection
            • DisplayDrawingObjects
            • DupeUnique
            • DynamicFilterCriteria
            • EnableSelection
            • FileFormat
            • FindLookIn
            • FormatConditionOperator
            • FormatConditionType
            • HAlign
            • Icon
            • IconSet
            • InsertShiftDirection
            • LineStyle
            • LookAt
            • NumberFormatType
            • Order
            • PageBreak
            • PageBreakExtent
            • PageOrientation
            • PaperSize
            • PasteOperation
            • PasteType
            • Pattern
            • PrintErrors
            • PrintLocation
            • ReferenceStyle
            • SearchDirection
            • SearchOrder
            • SheetType
            • SheetVisibility
            • SortDataOption
            • SortOrder
            • SortOrientation
            • SummaryColumn
            • SummaryRow
            • TimePeriods
            • TopBottom
            • UnderlineStyle
            • UpdateLinks
            • ValidationAlertStyle
            • ValidationOperator
            • ValidationType
            • VAlign
            • ValueError
            • ValueType
            • WindowView
          • Structures
            • Color
              • Overview
              • Members
              • Methods
                • Equals Method
                  • Equals(Color) Method
                  • Equals(Object) Method
                • FromArgb Method
                  • FromArgb(Int32) Method
                  • FromArgb(Int32,Int32,Int32,Int32) Method
                  • FromArgb(Int32,Int32,Int32) Method
                • GetHashCode Method
                • ToArgb Method
                • ToString Method
              • Properties
                • A Property
                • B Property
                • G Property
                • R Property
              • Operators
                • Equality Operator
                • Inequality Operator
          • Interfaces
            • IAboveAverage
              • Overview
              • Members
              • Properties
                • AboveBelow Property
                • NumStdDev Property
            • IAreas
              • Overview
              • Members
              • Properties
                • Count Property
                • Item Property
                • WorkbookSet Property
            • IAutoFilter
              • Overview
              • Members
              • Methods
                • ApplyFilter Method
                • ShowAllData Method
              • Properties
                • Filters Property
                • Range Property
            • IBorder
              • Overview
              • Members
              • Properties
                • Color Property
                • ColorDefined Property
                • ColorIndex Property
                • LineStyle Property
                • LineStyleDefined Property
                • ThemeColor Property
                • TintAndShade Property
                • Weight Property
                • WeightDefined Property
                • WorkbookSet Property
            • IBorders
              • Overview
              • Members
              • Properties
                • Color Property
                • ColorDefined Property
                • ColorIndex Property
                • Count Property
                • Item Property
                • LineStyle Property
                • LineStyleDefined Property
                • ThemeColor Property
                • TintAndShade Property
                • Weight Property
                • WeightDefined Property
                • WorkbookSet Property
            • IBuiltinDocumentProperties
              • Overview
              • Members
              • Methods
                • InitializeDefaults Method
              • Properties
                • Author Property
                • Category Property
                • Comments Property
                • ContentStatus Property
                • CreationDate Property
                • DocumentVersion Property
                • Keywords Property
                • Language Property
                • LastAuthor Property
                • LastPrintDate Property
                • LastSaveTime Property
                • RevisionNumber Property
                • Subject Property
                • Title Property
            • ICharacters
              • Overview
              • Members
              • Methods
                • Delete Method
                • Insert Method
              • Properties
                • Count Property
                • Font Property
                • Text Property
                • WorkbookSet Property
            • IChartSheet
              • Overview
              • Members
              • Methods
                • Protect Method
                • Unprotect Method
              • Properties
                • Chart Property
                • ProtectContents Property
                • ProtectDrawingObjects Property
                • ProtectionMode Property
                • WindowInfo Property
                • WindowInfos Property
            • IChartSheets
              • Overview
              • Members
              • Methods
                • Add Method
                • AddAfter Method
                • AddBefore Method
                • Contains Method
              • Properties
                • Count Property
                • Item Property
                  • Item(Int32) Property
                  • Item(String) Property
                • WorkbookSet Property
            • IChartSheetWindowInfo
              • Overview
              • Members
              • Methods
                • SetSelection Method
              • Properties
                • ChartSheet Property
                • Index Property
                • ShapeSelection Property
                • Zoom Property
                • ZoomToFit Property
            • IChartSheetWindowInfos
              • Overview
              • Members
              • Properties
                • ChartSheet Property
                • Count Property
                • Item Property
            • IColors
              • Overview
              • Members
              • Properties
                • Count Property
                • Item Property
            • IColorScale
              • Overview
              • Members
              • Properties
                • ColorScaleCriteria Property
                • Formula Property
            • IColorScaleCriteria
              • Overview
              • Members
              • Properties
                • Count Property
                • Item Property
            • IColorScaleCriterion
              • Overview
              • Members
              • Properties
                • FormatColor Property
                • Index Property
                • Type Property
                • Value Property
            • IColorStop
              • Overview
              • Members
              • Methods
                • Delete Method
              • Properties
                • Color Property
                • Position Property
                • ThemeColor Property
                • TintAndShade Property
            • IColorStops
              • Overview
              • Members
              • Methods
                • Add Method
                • Clear Method
              • Properties
                • Count Property
                • Item Property
            • IComment
              • Overview
              • Members
              • Properties
                • Author Property
                • Shape Property
                • Visible Property
            • IComments
              • Overview
              • Members
              • Properties
                • Count Property
                • Item Property
                • Sheet Property
            • IConditionValue
              • Overview
              • Members
              • Methods
                • Modify Method
              • Properties
                • Type Property
                • Value Property
            • IDatabar
              • Overview
              • Members
              • Properties
                • AxisColor Property
                • AxisPosition Property
                • BarBorder Property
                • BarColor Property
                • BarFillType Property
                • Formula Property
                • MaxPoint Property
                • MinPoint Property
                • NegativeBarFormat Property
                • PercentMax Property
                • PercentMin Property
                • ShowValue Property
            • IDataBarBorder
              • Overview
              • Members
              • Properties
                • Color Property
                • Type Property
            • IDialogSheet
              • Overview
              • Members
            • IDocumentProperties
              • Overview
              • Members
              • Methods
                • Add Method
                • Clear Method
              • Properties
                • Count Property
                • Item Property
                  • Item(Int32) Property
                  • Item(String) Property
                • Parent Property
            • IDocumentProperty
              • Overview
              • Members
              • Methods
                • Delete Method
              • Properties
                • Name Property
                • Parent Property
                • Value Property
            • IFactory
              • Overview
              • Members
            • IFactoryChild
              • Overview
              • Members
              • Properties
                • Factory Property
            • IFilter
              • Overview
              • Members
              • Properties
                • Criteria1 Property
                • Criteria2 Property
                • On Property
                • Operator Property
            • IFilters
              • Overview
              • Members
              • Properties
                • Count Property
                • Item Property
            • IFont
              • Overview
              • Members
              • Properties
                • Bold Property
                • BoldDefined Property
                • Color Property
                • ColorDefined Property
                • ColorIndex Property
                • Italic Property
                • ItalicDefined Property
                • Name Property
                • NameDefined Property
                • OutlineFont Property
                • OutlineFontDefined Property
                • Shadow Property
                • ShadowDefined Property
                • Size Property
                • SizeDefined Property
                • Strikethrough Property
                • StrikethroughDefined Property
                • Subscript Property
                • SubscriptDefined Property
                • Superscript Property
                • SuperscriptDefined Property
                • ThemeColor Property
                • TintAndShade Property
                • Underline Property
                • UnderlineDefined Property
                • WorkbookSet Property
            • IFormatColor
              • Overview
              • Members
              • Properties
                • Color Property
                • ColorIndex Property
                • ThemeColor Property
                • TintAndShade Property
            • IFormatCondition
              • Overview
              • Members
              • Methods
                • Delete Method
                • Modify Method
                  • Modify(FormatConditionType) Method
                  • Modify(FormatConditionType,FormatConditionOperator,String,String) Method
                  • Modify(FormatConditionType,ContainsOperator,String) Method
                  • Modify(FormatConditionType,TimePeriods) Method
                • ModifyAppliesToRange Method
              • Properties
                • AboveAverage Property
                • AppliesTo Property
                • Borders Property
                • ColorScale Property
                • Databar Property
                • DateOperator Property
                • Font Property
                • Formula1 Property
                • Formula2 Property
                • IconSetCondition Property
                • Interior Property
                • NumberFormat Property
                • Operator Property
                • StopIfTrue Property
                • Text Property
                • TextOperator Property
                • Top10 Property
                • Type Property
                • UniqueValues Property
            • IFormatConditions
              • Overview
              • Members
              • Methods
                • Add Method
                  • Add(FormatConditionType) Method
                  • Add(FormatConditionType,FormatConditionOperator,String,String) Method
                  • Add(FormatConditionType,ContainsOperator,String) Method
                  • Add(FormatConditionType,TimePeriods) Method
                • AddAboveAverage Method
                • AddColorScale Method
                • AddDatabar Method
                • AddIconSetCondition Method
                • AddTop10 Method
                • AddUniqueValues Method
                • Delete Method
              • Properties
                • Count Property
                • Item Property
            • IGradient
              • Overview
              • Members
              • Properties
                • ColorStops Property
            • IHPageBreak
              • Overview
              • Members
              • Methods
                • Delete Method
              • Properties
                • Extent Property
                • Location Property
            • IHPageBreaks
              • Overview
              • Members
              • Methods
                • Add Method
              • Properties
                • Count Property
                • Item Property
            • IHyperlink
              • Overview
              • Members
              • Methods
                • Delete Method
              • Properties
                • Address Property
                • EmailSubject Property
                • Range Property
                • ScreenTip Property
                • SubAddress Property
                • TextToDisplay Property
            • IHyperlinks
              • Overview
              • Members
              • Methods
                • Add Method
                • Delete Method
              • Properties
                • Count Property
                • Item Property
            • IIcon
              • Overview
              • Members
              • Properties
                • Index Property
            • IIconCriteria
              • Overview
              • Members
              • Properties
                • Count Property
                • Item Property
            • IIconCriterion
              • Overview
              • Members
              • Properties
                • Icon Property
                • Index Property
                • Operator Property
                • Type Property
                • Value Property
            • IIconSet
              • Overview
              • Members
              • Properties
                • Count Property
                • ID Property
                • Item Property
            • IIconSetCondition
              • Overview
              • Members
              • Properties
                • Formula Property
                • IconCriteria Property
                • IconSet Property
                • ReverseOrder Property
                • ShowIconOnly Property
            • IIconSets
              • Overview
              • Members
              • Properties
                • Count Property
                • Item Property
            • IInterior
              • Overview
              • Members
              • Properties
                • Color Property
                • ColorDefined Property
                • ColorIndex Property
                • Gradient Property
                • GradientDefined Property
                • Pattern Property
                • PatternColor Property
                • PatternColorDefined Property
                • PatternColorIndex Property
                • PatternDefined Property
                • PatternThemeColor Property
                • PatternTintAndShade Property
                • ThemeColor Property
                • TintAndShade Property
            • ILinearGradient
              • Overview
              • Members
              • Properties
                • Degree Property
            • IModule
              • Overview
              • Members
            • IName
              • Overview
              • Members
              • Methods
                • Delete Method
              • Properties
                • Comment Property
                • Index Property
                • Name Property
                • RefersTo Property
                • RefersToR1C1 Property
                • RefersToRange Property
                • Visible Property
            • INames
              • Overview
              • Members
              • Methods
                • Add Method
                  • Add(String,String) Method
                  • Add(String,String,ReferenceStyle) Method
                • Contains Method
              • Properties
                • Count Property
                • Item Property
                  • Item(Int32) Property
                  • Item(String) Property
            • INegativeBarFormat
              • Overview
              • Members
              • Properties
                • BorderColor Property
                • BorderColorType Property
                • Color Property
                • ColorType Property
            • IOutline
              • Overview
              • Members
              • Methods
                • ShowLevels Method
              • Properties
                • SummaryColumn Property
                • SummaryRow Property
            • IPageSetup
              • Overview
              • Members
              • Properties
                • BlackAndWhite Property
                • BottomMargin Property
                • CenterFooter Property
                • CenterFooterPicture Property
                • CenterHeader Property
                • CenterHeaderPicture Property
                • CenterHorizontally Property
                • CenterVertically Property
                • Draft Property
                • FirstPageNumber Property
                • FitToPages Property
                • FitToPagesTall Property
                • FitToPagesWide Property
                • FooterMargin Property
                • HeaderMargin Property
                • LeftFooter Property
                • LeftFooterPicture Property
                • LeftHeader Property
                • LeftHeaderPicture Property
                • LeftMargin Property
                • Order Property
                • Orientation Property
                • PaperSize Property
                • PrintArea Property
                • PrintComments Property
                • PrintErrors Property
                • PrintGridlines Property
                • PrintHeadings Property
                • PrintNotes Property
                • PrintQuality Property
                • PrintQualityVertical Property
                • PrintTitleColumns Property
                • PrintTitleRows Property
                • RightFooter Property
                • RightFooterPicture Property
                • RightHeader Property
                • RightHeaderPicture Property
                • RightMargin Property
                • TopMargin Property
                • Zoom Property
            • IPane
              • Overview
              • Members
              • Methods
                • Activate Method
              • Properties
                • Index Property
                • ScrollColumn Property
                • ScrollRow Property
            • IPanes
              • Overview
              • Members
              • Properties
                • Count Property
                • Item Property
            • IPrintable
              • Overview
              • Members
            • IProtection
              • Overview
              • Members
              • Properties
                • AllowDeletingColumns Property
                • AllowDeletingRows Property
                • AllowFiltering Property
                • AllowFormattingCells Property
                • AllowFormattingColumns Property
                • AllowFormattingRows Property
                • AllowInsertingColumns Property
                • AllowInsertingHyperlinks Property
                • AllowInsertingRows Property
                • AllowSorting Property
                • AllowUsingPivotTables Property
            • IRange
              • Overview
              • Members
              • Methods
                • Activate Method
                • AddComment Method
                • AutoFill Method
                • AutoFilter Method
                  • AutoFilter() Method
                  • AutoFilter(Int32,Object,AutoFilterOperator,Object,Boolean) Method
                • AutoFit Method
                • Clear Method
                • ClearComments Method
                • ClearContents Method
                • ClearFormats Method
                • ClearOutline Method
                • Copy Method
                  • Copy(IRange) Method
                  • Copy(IRange,PasteType,PasteOperation,Boolean,Boolean) Method
                • CopyDown Method
                • CopyFromDataTable Method
                • CopyRight Method
                • DataSeries Method
                • Delete Method
                  • Delete() Method
                  • Delete(DeleteShiftDirection) Method
                • FillDown Method
                • FillLeft Method
                • FillRight Method
                • FillUp Method
                • Find Method
                • FindUnlockedAndVisible Method
                • GetAddress Method
                • GetArea Method
                • GetCharacters Method
                • GetDataSet Method
                • GetDataTable Method
                • GoalSeek Method
                • Group Method
                • Insert Method
                  • Insert() Method
                  • Insert(InsertShiftDirection) Method
                • Intersect Method
                • Merge Method
                • Offset Method
                • Replace Method
                • SaveAs Method
                • SaveToMemory Method
                • SaveToStream Method
                • Select Method
                • Sort Method
                • Subtract Method
                • Table Method
                • Ungroup Method
                • Union Method
                • UnMerge Method
              • Properties
                • AddIndent Property
                • AddIndentDefined Property
                • Address Property
                • AllowEdit Property
                • AreaCount Property
                • Areas Property
                • Borders Property
                • CellCount Property
                • Cells Property
                • Column Property
                • ColumnCount Property
                • Columns Property
                • ColumnWidth Property
                • ColumnWidthDefined Property
                • Comment Property
                • Count Property
                • CurrentArray Property
                • CurrentRegion Property
                • EndDown Property
                • EndLeft Property
                • EndRight Property
                • EndUp Property
                • EntireColumn Property
                • EntireMergeArea Property
                • EntireRow Property
                • Entry Property
                • Font Property
                • FormatConditions Property
                • FormatConditionsDefined Property
                • Formula Property
                • FormulaArray Property
                • FormulaHidden Property
                • FormulaHiddenDefined Property
                • FormulaR1C1 Property
                • HasArray Property
                • HasArrayDefined Property
                • HasFormula Property
                • HasFormulaDefined Property
                • HasValidation Property
                • Height Property
                • Hidden Property
                • HorizontalAlignment Property
                • HorizontalAlignmentDefined Property
                • Hyperlinks Property
                • IndentLevel Property
                • Interior Property
                • IsDisposed Property
                • IsEntireColumns Property
                • IsEntireRows Property
                • IsVolatileOrCircularFormula Property
                • Item Property
                  • Item(String) Property
                  • Item(Int32,Int32) Property
                  • Item(Int32,Int32,Int32,Int32) Property
                • Locked Property
                • LockedDefined Property
                • MergeArea Property
                • MergeCells Property
                • MergeCellsDefined Property
                • Name Property
                • NumberFormat Property
                • NumberFormatDefined Property
                • NumberFormatType Property
                • Orientation Property
                • OrientationDefined Property
                • OutlineLevel Property
                • OutlineLevelDefined Property
                • PageBreak Property
                • PrefixCharacter Property
                • PrefixCharacterDefined Property
                • Range Property
                • Row Property
                • RowCount Property
                • RowHeight Property
                • RowHeightDefined Property
                • Rows Property
                • ShowDetail Property
                • ShrinkToFit Property
                • ShrinkToFitDefined Property
                • Style Property
                • StyleDefined Property
                • Text Property
                • Validation Property
                • ValidationDefined Property
                • Value Property
                • ValueType Property
                • VerticalAlignment Property
                • VerticalAlignmentDefined Property
                • Width Property
                • WorkbookSet Property
                • Worksheet Property
                • WrapText Property
                • WrapTextDefined Property
            • IRectangularGradient
              • Overview
              • Members
              • Properties
                • RectangleBottom Property
                • RectangleLeft Property
                • RectangleRight Property
                • RectangleTop Property
            • ISheet
              • Overview
              • Members
              • Methods
                • CopyAfter Method
                • CopyBefore Method
                • Delete Method
                • EvaluateRange Method
                • EvaluateRanges Method
                • EvaluateValue Method
                • EvaluateValues Method
                • MoveAfter Method
                • MoveBefore Method
                • Select Method
              • Properties
                • Index Property
                • IsDisposed Property
                • Name Property
                • Tab Property
                • Type Property
                • Visible Property
                • Workbook Property
                • WorkbookSet Property
            • ISheets
              • Overview
              • Members
              • Methods
                • Contains Method
              • Properties
                • Count Property
                • Item Property
                  • Item(Int32) Property
                  • Item(String) Property
                • WorkbookSet Property
            • IStyle
              • Overview
              • Members
              • Methods
                • Delete Method
              • Properties
                • AddIndent Property
                • Borders Property
                • BuiltIn Property
                • Font Property
                • FormulaHidden Property
                • HorizontalAlignment Property
                • IncludeAlignment Property
                • IncludeBorder Property
                • IncludeFont Property
                • IncludeNumber Property
                • IncludePatterns Property
                • IncludeProtection Property
                • IndentLevel Property
                • Interior Property
                • Locked Property
                • Name Property
                • NumberFormat Property
                • Orientation Property
                • ShrinkToFit Property
                • VerticalAlignment Property
                • WrapText Property
            • IStyles
              • Overview
              • Members
              • Methods
                • Add Method
              • Properties
                • Count Property
                • Item Property
                  • Item(Int32) Property
                  • Item(String) Property
            • ITab
              • Overview
              • Members
              • Properties
                • Color Property
                • ColorIndex Property
                • ThemeColor Property
                • TintAndShade Property
            • ITop10
              • Overview
              • Members
              • Properties
                • Percent Property
                • Rank Property
                • TopBottom Property
            • IUniqueValues
              • Overview
              • Members
              • Properties
                • DupeUnique Property
            • IValidation
              • Overview
              • Members
              • Methods
                • Add Method
                • Delete Method
                • Modify Method
              • Properties
                • AlertStyle Property
                • ErrorMessage Property
                • ErrorTitle Property
                • Formula1 Property
                • Formula2 Property
                • IgnoreBlank Property
                • InCellDropdown Property
                • InputMessage Property
                • InputTitle Property
                • Operator Property
                • ShowError Property
                • ShowInputMessage Property
                • Type Property
                • Value Property
            • IVPageBreak
              • Overview
              • Members
              • Methods
                • Delete Method
              • Properties
                • Extent Property
                • Location Property
            • IVPageBreaks
              • Overview
              • Members
              • Methods
                • Add Method
              • Properties
                • Count Property
                • Item Property
            • IWorkbook
              • Overview
              • Members
              • Methods
                • Close Method
                • DateTimeToNumber Method
                • GetDataSet Method
                  • GetDataSet(GetDataFlags) Method
                  • GetDataSet(String,GetDataFlags) Method
                • NumberToDateTime Method
                • Protect Method
                • Save Method
                • SaveAs Method
                  • SaveAs(String,FileFormat) Method
                  • SaveAs(String,FileFormat,String) Method
                • SaveToMemory Method
                  • SaveToMemory(FileFormat) Method
                  • SaveToMemory(FileFormat,String) Method
                • SaveToStream Method
                  • SaveToStream(Stream,FileFormat) Method
                  • SaveToStream(Stream,FileFormat,String) Method
                  • SaveToStream(FileFormat) Method
                • Unprotect Method
              • Properties
                • ActiveChartSheet Property
                • ActiveSheet Property
                • ActiveWorksheet Property
                • BuiltinDocumentProperties Property
                • ChartSheets Property
                • Colors Property
                • CustomDocumentProperties Property
                • Date1904 Property
                • DisplayDrawingObjects Property
                • FileFormat Property
                • FullName Property
                • IconSets Property
                • IsDisposed Property
                • IsModified Property
                • Name Property
                • Names Property
                • PrecisionAsDisplayed Property
                • ProtectStructure Property
                • ProtectWindows Property
                • ReadOnlyRecommended Property
                • SaveLinkValues Property
                • Sheets Property
                • Styles Property
                • Theme Property
                • UpdateLinks Property
                • WindowInfo Property
                • WindowInfos Property
                • WorkbookSet Property
                • Worksheets Property
                • WriteReserved Property
                • WriteReservedBy Property
            • IWorkbooks
              • Overview
              • Members
              • Methods
                • Add Method
                • Close Method
                • Contains Method
                • Open Method
                  • Open(String) Method
                  • Open(String,String) Method
                • OpenFromMemory Method
                  • OpenFromMemory(Byte[]) Method
                  • OpenFromMemory(Byte[],String) Method
                • OpenFromStream Method
                  • OpenFromStream(Stream) Method
                  • OpenFromStream(Stream,String) Method
              • Properties
                • Count Property
                • Item Property
                  • Item(Int32) Property
                  • Item(String) Property
                • WorkbookSet Property
            • IWorkbookSet
              • Overview
              • Members
              • Methods
                • Add Method
                • BeginUpdate Method
                • Calculate Method
                • CalculateFull Method
                • CalculateFullRebuild Method
                • EndUpdate Method
                • GC Method
                • GetAddress Method
                  • GetAddress(Int32,Int32) Method
                  • GetAddress(Int32,Int32,Int32,Int32,Int32,Int32,Boolean,Boolean,Boolean,Boolean,Boolean,ReferenceStyle) Method
                • GetLock Method
                • ReleaseLock Method
                • Remove Method
                • RewindLock Method
                • UnwindLock Method
              • Properties
                • AltStartupPath Property
                • BackgroundCalculation Property
                • CalculateBeforeSave Property
                • Calculation Property
                • CalculationOnDemand Property
                • Culture Property
                • CustomLists Property
                • DefaultFontName Property
                • DefaultFontSize Property
                • EnableWebService Property
                • Experimental Property
                • HasLock Property
                • IsDisposed Property
                • IsTrial Property
                • Iteration Property
                • LibraryPath Property
                • MaxChange Property
                • MaxColumns Property
                • MaxIterations Property
                • MaxRecursions Property
                • MaxRows Property
                • MaxWorksheets Property
                • NeverRecalc Property
                • ReadObjects Property
                • ReadVBA Property
                • ReferenceStyle Property
                • SheetsInNewWorkbook Property
                • StartupPath Property
                • UserName Property
                • Workbooks Property
              • Events
                • EndCalculate Event
            • IWorkbookWindowInfo
              • Overview
              • Members
              • Methods
                • Delete Method
              • Properties
                • ActiveChartSheet Property
                • ActiveSheet Property
                • ActiveWorksheet Property
                • DisplayHorizontalScrollBar Property
                • DisplayVerticalScrollBar Property
                • DisplayWorkbookTabs Property
                • Index Property
                • TabRatio Property
                • Workbook Property
            • IWorkbookWindowInfos
              • Overview
              • Members
              • Methods
                • Add Method
              • Properties
                • Count Property
                • Item Property
                • Workbook Property
            • IWorksheet
              • Overview
              • Members
              • Methods
                • Protect Method
                • SaveAs Method
                • SaveToMemory Method
                • SaveToStream Method
                • Unprotect Method
              • Properties
                • AutoFilter Property
                • AutoFilterMode Property
                • Cells Property
                • Comments Property
                • DisplayAutomaticPageBreaks Property
                • EnableSelection Property
                • HPageBreaks Property
                • Hyperlinks Property
                • Names Property
                • Outline Property
                • PageSetup Property
                • ProtectContents Property
                • ProtectDrawingObjects Property
                • Protection Property
                • ProtectionMode Property
                • ProtectScenarios Property
                • Range Property
                • Shapes Property
                • StandardWidth Property
                • TransitionExpEval Property
                • TransitionFormEntry Property
                • UsedRange Property
                • VPageBreaks Property
                • WindowInfo Property
                • WindowInfos Property
            • IWorksheets
              • Overview
              • Members
              • Methods
                • Add Method
                • AddAfter Method
                • AddBefore Method
                • Contains Method
              • Properties
                • Count Property
                • Item Property
                  • Item(Int32) Property
                  • Item(String) Property
                • WorkbookSet Property
            • IWorksheetWindowInfo
              • Overview
              • Members
              • Methods
                • ColumnToPoints Method
                • PointsToColumn Method
                • PointsToRow Method
                • RowToPoints Method
                • SetSelection Method
                  • SetSelection(IRange,IRange,Int32) Method
                  • SetSelection(IShapeRange,Boolean) Method
              • Properties
                • ActiveCell Property
                • ActiveCellAreaIndex Property
                • ActivePane Property
                • DisplayFormulas Property
                • DisplayGridlines Property
                • DisplayHeadings Property
                • DisplayOutline Property
                • DisplayRightToLeft Property
                • DisplayZeros Property
                • FreezePanes Property
                • GridlineColor Property
                • GridlineColorIndex Property
                • Index Property
                • Panes Property
                • RangeSelection Property
                • ScrollColumn Property
                • ScrollRow Property
                • ShapeSelection Property
                • SplitColumns Property
                • SplitHorizontal Property
                • SplitRows Property
                • SplitVertical Property
                • View Property
                • Worksheet Property
                • Zoom Property
            • IWorksheetWindowInfos
              • Overview
              • Members
              • Properties
                • Count Property
                • Item Property
                • Worksheet Property
          • Delegates
            • EndCalculateEventHandler
        • SpreadsheetGear.Advanced.Cells Namespace
          • Overview
          • Enumerations
            • ValueType
          • Interfaces
            • IValue
              • Overview
              • Members
              • Methods
                • GetFormula Method
                • GetText Method
              • Properties
                • Error Property
                • Formula Property
                • HasFormula Property
                • Logical Property
                • Number Property
                • Text Property
                • Type Property
            • IValues
              • Overview
              • Members
              • Methods
                • Clear Method
                • ForEachNumber Method
                • IsValidNumber Method
                • SetError Method
                • SetFormula Method
                  • SetFormula(Int32,Int32,String) Method
                  • SetFormula(Int32,Int32,StringBuilder) Method
                • SetLogical Method
                • SetNumber Method
                • SetText Method
                  • SetText(Int32,Int32,String) Method
                  • SetText(Int32,Int32,StringBuilder) Method
                • ValidateNumber Method
              • Properties
                • Item Property
        • SpreadsheetGear.Charts Namespace
          • Overview
          • Classes
            • TickLabelOrientation
              • Overview
              • Members
              • TickLabelOrientation Constructor
              • Fields
                • Automatic Field
                • Downward Field
                • Horizontal Field
                • Upward Field
                • Vertical Field
          • Enumerations
            • AxisCrosses
            • AxisGroup
            • AxisType
            • BarShape
            • CategoryType
            • ChartElementPosition
            • ChartSplitType
            • ChartType
            • DataLabelPosition
            • DisplayBlanksAs
            • EndStyleCap
            • ErrorBarDirection
            • ErrorBarInclude
            • ErrorBarType
            • LegendPosition
            • MarkerStyle
            • RowCol
            • ScaleType
            • SizeRepresents
            • TickLabelPosition
            • TickMark
            • TimeUnit
            • TrendlineType
          • Interfaces
            • IAxes
              • Overview
              • Members
              • Properties
                • Item Property
                  • Item(AxisType) Property
                  • Item(AxisType,AxisGroup) Property
            • IAxis
              • Overview
              • Members
              • Properties
                • AxisBetweenCategories Property
                • AxisGroup Property
                • AxisTitle Property
                • BaseUnit Property
                • BaseUnitIsAuto Property
                • CategoryType Property
                • Crosses Property
                • CrossesAt Property
                • Format Property
                • HasMajorGridlines Property
                • HasMinorGridlines Property
                • HasTitle Property
                • LogBase Property
                • MajorGridlines Property
                • MajorTickMark Property
                • MajorUnit Property
                • MajorUnitIsAuto Property
                • MajorUnitScale Property
                • MaximumScale Property
                • MaximumScaleIsAuto Property
                • MinimumScale Property
                • MinimumScaleIsAuto Property
                • MinorGridlines Property
                • MinorTickMark Property
                • MinorUnit Property
                • MinorUnitIsAuto Property
                • MinorUnitScale Property
                • ReversePlotOrder Property
                • ScaleType Property
                • TickLabelPosition Property
                • TickLabels Property
                • TickLabelSpacing Property
                • TickLabelSpacingIsAuto Property
                • TickMarkSpacing Property
                • Type Property
            • IAxisTitle
              • Overview
              • Members
              • Properties
                • Font Property
                • Format Property
                • IncludeInLayout Property
                • Orientation Property
                • Position Property
                • Text Property
            • IChart
              • Overview
              • Members
              • Methods
                • SetSourceData Method
              • Properties
                • AutoScaling Property
                • Axes Property
                • BackWall Property
                • ChartArea Property
                • ChartGroups Property
                • ChartTitle Property
                • ChartType Property
                • DataTable Property
                • DepthPercent Property
                • DisplayBlanksAs Property
                • Elevation Property
                • Floor Property
                • GapDepth Property
                • HasAxis Property
                • HasDataTable Property
                • HasLegend Property
                • HasTitle Property
                • HeightPercent Property
                • Legend Property
                • PageSetup Property
                • Perspective Property
                • PlotArea Property
                • PlotVisibleOnly Property
                • ProtectData Property
                • ProtectFormatting Property
                • ProtectSelection Property
                • RightAngleAxes Property
                • Rotation Property
                • SeriesCollection Property
                • Shapes Property
                • Sheet Property
                • SideWall Property
            • IChartArea
              • Overview
              • Members
              • Properties
                • Font Property
                • Format Property
            • IChartFormat
              • Overview
              • Members
              • Properties
                • Fill Property
                • Line Property
            • IChartGroup
              • Overview
              • Members
              • Properties
                • AxisGroup Property
                • BubbleScale Property
                • Chart Property
                • DoughnutHoleSize Property
                • DownBars Property
                • DropLines Property
                • FirstSliceAngle Property
                • GapWidth Property
                • Has3DShading Property
                • HasDropLines Property
                • HasHiLoLines Property
                • HasRadarAxisLabels Property
                • HasSeriesLines Property
                • HasUpDownBars Property
                • HiLoLines Property
                • Index Property
                • Overlap Property
                • RadarAxisLabels Property
                • SecondPlotSize Property
                • SeriesCollection Property
                • SeriesLines Property
                • ShowNegativeBubbles Property
                • SizeRepresents Property
                • SplitType Property
                • SplitValue Property
                • UpBars Property
                • VaryByCategories Property
            • IChartGroups
              • Overview
              • Members
              • Properties
                • Count Property
                • Item Property
            • IChartTitle
              • Overview
              • Members
              • Properties
                • Font Property
                • Format Property
                • IncludeInLayout Property
                • Left Property
                • Orientation Property
                • Position Property
                • Text Property
                • Top Property
            • IDataLabel
              • Overview
              • Members
              • Properties
                • AutoText Property
                • Font Property
                • Format Property
                • NumberFormat Property
                • NumberFormatLinked Property
                • Orientation Property
                • Position Property
                • ShowBubbleSize Property
                • ShowCategoryName Property
                • ShowLegendKey Property
                • ShowPercentage Property
                • ShowValue Property
                • Text Property
            • IDataLabels
              • Overview
              • Members
              • Properties
                • AutoText Property
                • Count Property
                • Font Property
                • Format Property
                • Item Property
                • NumberFormat Property
                • NumberFormatLinked Property
                • Orientation Property
                • Position Property
                • ShowBubbleSize Property
                • ShowCategoryName Property
                • ShowLegendKey Property
                • ShowPercentage Property
                • ShowValue Property
            • IDataTable
              • Overview
              • Members
              • Properties
                • Format Property
                • HasBorderHorizontal Property
                • HasBorderOutline Property
                • HasBorderVertical Property
                • ShowLegendKey Property
            • IDownBars
              • Overview
              • Members
              • Properties
                • Format Property
            • IDropLines
              • Overview
              • Members
              • Properties
                • Format Property
            • IErrorBars
              • Overview
              • Members
              • Properties
                • EndStyle Property
                • Format Property
            • IFloor
              • Overview
              • Members
              • Properties
                • Format Property
            • IGridlines
              • Overview
              • Members
              • Properties
                • Format Property
            • IHasAxis
              • Overview
              • Members
              • Properties
                • Item Property
                  • Item(AxisType) Property
                  • Item(AxisType,AxisGroup) Property
            • IHiLoLines
              • Overview
              • Members
              • Properties
                • Format Property
            • ILeaderLines
              • Overview
              • Members
              • Properties
                • Format Property
            • ILegend
              • Overview
              • Members
              • Properties
                • Font Property
                • Format Property
                • Height Property
                • IncludeInLayout Property
                • Left Property
                • Position Property
                • Top Property
                • Width Property
            • IPlotArea
              • Overview
              • Members
              • Properties
                • Format Property
                • Height Property
                • Left Property
                • Position Property
                • Top Property
                • Width Property
            • IPoint
              • Overview
              • Members
              • Properties
                • DataLabel Property
                • Explosion Property
                • Format Property
                • HasDataLabel Property
                • InvertIfNegative Property
                • MarkerBackgroundColor Property
                • MarkerForegroundColor Property
                • MarkerSize Property
                • MarkerStyle Property
                • SecondaryPlot Property
            • IPoints
              • Overview
              • Members
              • Properties
                • Count Property
                • Item Property
            • ISeries
              • Overview
              • Members
              • Methods
                • Delete Method
                • ErrorBar Method
                  • ErrorBar(ErrorBarDirection,ErrorBarInclude,ErrorBarType,Double) Method
                  • ErrorBar(ErrorBarDirection,ErrorBarInclude,ErrorBarType,String,String) Method
              • Properties
                • AxisGroup Property
                • BarShape Property
                • BubbleSizes Property
                • ChartType Property
                • DataLabels Property
                • ErrorBars Property
                • Explosion Property
                • Format Property
                • Has3DEffect Property
                • HasDataLabels Property
                • HasErrorBars Property
                • HasLeaderLines Property
                • InvertIfNegative Property
                • LeaderLines Property
                • MarkerBackgroundColor Property
                • MarkerForegroundColor Property
                • MarkerSize Property
                • MarkerStyle Property
                • Name Property
                • Points Property
                • Smooth Property
                • Trendlines Property
                • Values Property
                • XValues Property
            • ISeriesCollection
              • Overview
              • Members
              • Methods
                • Add Method
              • Properties
                • Count Property
                • Item Property
            • ISeriesLines
              • Overview
              • Members
              • Properties
                • Format Property
            • ITickLabels
              • Overview
              • Members
              • Properties
                • Font Property
                • NumberFormat Property
                • NumberFormatLinked Property
                • Orientation Property
            • ITrendline
              • Overview
              • Members
              • Methods
                • Delete Method
              • Properties
                • Backward Property
                • DataLabel Property
                • DisplayEquation Property
                • DisplayRSquared Property
                • Format Property
                • Forward Property
                • Index Property
                • Intercept Property
                • InterceptIsAuto Property
                • Name Property
                • NameIsAuto Property
                • Order Property
                • Period Property
                • Type Property
            • ITrendlines
              • Overview
              • Members
              • Methods
                • Add Method
              • Properties
                • Count Property
                • Item Property
            • IUpBars
              • Overview
              • Members
              • Properties
                • Format Property
            • IWalls
              • Overview
              • Members
              • Properties
                • Format Property
        • SpreadsheetGear.Commands Namespace
          • Overview
          • Classes
            • Command
              • Overview
              • Members
              • Methods
                • Dispose Method
                • Execute Method
                • Undo Method
              • Properties
                • DisplayText Property
                • UndoSupport Property
            • CommandManager
              • Overview
              • Members
              • CommandManager Constructor
              • Methods
                • ClearCommands Method
                  • ClearCommands() Method
                  • ClearCommands(IWorkbook) Method
                • CreateCommandClear Method
                • CreateCommandClearContents Method
                • CreateCommandClearFormats Method
                • CreateCommandCopy Method
                • CreateCommandCut Method
                • CreateCommandDelete Method
                  • CreateCommandDelete(IRange) Method
                  • CreateCommandDelete(IRange,DeleteShiftDirection) Method
                • CreateCommandInsert Method
                  • CreateCommandInsert(IRange) Method
                  • CreateCommandInsert(IRange,InsertShiftDirection) Method
                • CreateCommandPaste Method
                • CreateCommandPasteSpecial Method
                • CreateCommandPrint Method
                  • CreateCommandPrint(ISheet,PrintWhat,Boolean,Boolean) Method
                  • CreateCommandPrint(ICollection<IPrintable>,Boolean,Boolean) Method
                • Execute Method
                • Redo Method
                • Undo Method
              • Properties
                • CanRedo Property
                • CanUndo Property
                • RedoDisplayText Property
                • UndoDisplayText Property
                • UndoLimit Property
            • CommandPrint
              • Overview
              • Members
              • Properties
                • DisplayText Property
                • IsPrintPreview Property
                • IsShowPrintDialog Property
                • Printables Property
                • PrintWhat Property
                • Sheet Property
                • UndoSupport Property
            • CommandRange
              • Overview
              • Members
              • Methods
                • Dispose Method
                • Undo Method
              • Properties
                • Range Property
                • UndoFlags Property
                • UndoSupport Property
            • CommandRange.Clear
              • Overview
              • Members
              • CommandRange.Clear Constructor
              • Methods
                • Execute Method
              • Properties
                • DisplayText Property
                • UndoFlags Property
            • CommandRange.ClearContents
              • Overview
              • Members
              • CommandRange.ClearContents Constructor
              • Methods
                • Execute Method
              • Properties
                • DisplayText Property
                • UndoFlags Property
            • CommandRange.ClearFormats
              • Overview
              • Members
              • CommandRange.ClearFormats Constructor
              • Methods
                • Execute Method
              • Properties
                • DisplayText Property
                • UndoFlags Property
            • CommandRange.Copy
              • Overview
              • Members
              • CommandRange.Copy Constructor
              • Methods
                • Execute Method
              • Properties
                • DisplayText Property
                • UndoSupport Property
            • CommandRange.Cut
              • Overview
              • Members
              • CommandRange.Cut Constructor
              • Methods
                • Execute Method
              • Properties
                • DisplayText Property
                • UndoFlags Property
            • CommandRange.Delete
              • Overview
              • Members
              • CommandRange.Delete Constructor
                • CommandRange.Delete Constructor(IRange)
                • CommandRange.Delete Constructor(IRange,DeleteShiftDirection)
              • Methods
                • Execute Method
                • Undo Method
              • Properties
                • DisplayText Property
                • UndoFlags Property
            • CommandRange.Insert
              • Overview
              • Members
              • CommandRange.Insert Constructor
                • CommandRange.Insert Constructor(IRange)
                • CommandRange.Insert Constructor(IRange,InsertShiftDirection)
              • Methods
                • Execute Method
                • Undo Method
              • Properties
                • DisplayText Property
                • UndoFlags Property
            • CommandRange.Paste
              • Overview
              • Members
              • CommandRange.Paste Constructor
              • Properties
                • DisplayText Property
            • CommandRange.PasteSpecial
              • Overview
              • Members
              • CommandRange.PasteSpecial Constructor
              • Methods
                • Execute Method
                • Pasting Method
                • Undo Method
              • Properties
                • DisplayText Property
                • UndoFlags Property
                • UndoSupport Property
          • Enumerations
            • CommandRangeUndoFlags
            • CommandUndoSupport
        • SpreadsheetGear.Controls Namespace
          • Overview
          • Enumerations
            • RangeLocationFlags
        • SpreadsheetGear.CustomFunctions Namespace
          • Overview
          • Classes
            • Function
              • Overview
              • Members
              • Methods
                • Evaluate Method
              • Properties
                • Name Property
                • ReturnType Property
                • Volatility Property
          • Enumerations
            • ValueType
            • Volatility
          • Interfaces
            • IArguments
              • Overview
              • Members
              • Methods
                • ClearError Method
                • GetArrayDimensions Method
                • GetArrayFormulaInfo Method
                • GetArrayValue Method
                • GetLogical Method
                • GetNumber Method
                • GetText Method
              • Properties
                • Count Property
                • CurrentColumn Property
                • CurrentFormula Property
                • CurrentFunctionName Property
                • CurrentRow Property
                • CurrentWorksheet Property
                • Item Property
            • IValue
              • Overview
              • Members
              • Methods
                • SetArray Method
                  • SetArray(Double[,]) Method
                  • SetArray(Object[,]) Method
                • SetEmpty Method
              • Properties
                • Error Property
                • IsEmpty Property
                • IsError Property
                • IsLogical Property
                • IsNumber Property
                • IsText Property
                • Logical Property
                • Number Property
                • Text Property
                • Type Property
        • SpreadsheetGear.Data Namespace
          • Overview
          • Enumerations
            • GetDataFlags
            • SetDataFlags
        • SpreadsheetGear.Drawing Namespace
          • Overview
          • Classes
            • Image
              • Overview
              • Members
              • Image Constructor
                • Image Constructor(IRange)
                • Image Constructor(IShape)
                • Image Constructor(IChart)
              • Methods
                • Draw Method
                • GetBitmap Method
                  • GetBitmap() Method
                  • GetBitmap(PixelFormat) Method
                • GetImage Method
                • GetSize Method
                  • GetSize() Method
                  • GetSize(Graphics) Method
              • Properties
                • BackgroundBrush Property
                • Dpi Property
          • Structures
            • Color
              • Overview
              • Members
              • Methods
                • Equals Method
                  • Equals(Color) Method
                  • Equals(Object) Method
                • FromArgb Method
                  • FromArgb(Int32) Method
                  • FromArgb(Int32,Int32,Int32) Method
                  • FromArgb(Int32,Int32,Int32,Int32) Method
                • GetDrawingColor Method
                • GetHashCode Method
                • GetSpreadsheetGearColor Method
                • ToArgb Method
                • ToString Method
              • Properties
                • A Property
                • B Property
                • G Property
                • IsEmpty Property
                • IsKnownColor Property
                • IsSystemColor Property
                • R Property
              • Operators
                • Equality Operator
                • Implicit Type Conversion Operator
                • Inequality Operator
        • SpreadsheetGear.Drawing.Printing Namespace
          • Overview
          • Classes
            • WorkbookPrintDocument
              • Overview
              • Members
              • WorkbookPrintDocument Constructor
                • WorkbookPrintDocument Constructor(ICollection<IPrintable>)
                • WorkbookPrintDocument Constructor(ISheet,PrintWhat)
              • Methods
                • OnBeginPrint Method
                • OnEndPrint Method
                • OnPrintPage Method
                • OnQueryPageSettings Method
        • SpreadsheetGear.Printing Namespace
          • Overview
          • Enumerations
            • PrintWhat
          • Interfaces
            • IGraphic
              • Overview
              • Members
              • Methods
                • Add Method
                  • Add(String,Double,Double) Method
                  • Add(String) Method
                  • Add(Byte[],Double,Double) Method
                • Delete Method
              • Properties
                • CropBottom Property
                • CropLeft Property
                • CropRight Property
                • CropTop Property
                • Height Property
                • LockAspectRatio Property
                • Width Property
        • SpreadsheetGear.Shapes Namespace
          • Overview
          • Classes
            • ControlFormatValues
              • Overview
              • Members
              • ControlFormatValues Constructor
              • Fields
                • CheckBoxFalse Field
                • CheckBoxNA Field
                • CheckBoxTrue Field
                • ListIndexNone Field
          • Enumerations
            • ArrowheadLength
            • ArrowheadStyle
            • ArrowheadWidth
            • AutoShapeType
            • FillType
            • FormControlType
            • GradientColorType
            • GradientStyle
            • LineDashStyle
            • PictureColorType
            • Placement
            • PresetGradientType
            • ScaleFrom
            • ShapeType
            • TextOrientation
          • Interfaces
            • IColorFormat
              • Overview
              • Members
              • Properties
                • RGB Property
                • RGBDefined Property
                • SchemeColor Property
                • SchemeColorDefined Property
                • ThemeColor Property
                • TintAndShade Property
            • IControlFormat
              • Overview
              • Members
              • Methods
                • AddItem Method
                  • AddItem(String) Method
                  • AddItem(String,Int32) Method
                • RemoveAllItems Method
                • RemoveItem Method
              • Properties
                • DropDownLines Property
                • LargeChange Property
                • LinkedCell Property
                • List Property
                • ListCount Property
                • ListFillRange Property
                • ListIndex Property
                • Max Property
                • Min Property
                • SmallChange Property
                • Value Property
            • IFillFormat
              • Overview
              • Members
              • Methods
                • OneColorGradient Method
                • PresetGradient Method
                • Solid Method
                • TwoColorGradient Method
              • Properties
                • BackColor Property
                • ForeColor Property
                • GradientColorType Property
                • GradientDegree Property
                • GradientDegreeDefined Property
                • GradientStops Property
                • GradientStyle Property
                • PresetGradientType Property
                • Transparency Property
                • TransparencyDefined Property
                • Type Property
                • TypeDefined Property
                • Visible Property
                • VisibleDefined Property
            • IGradientStop
              • Overview
              • Members
              • Properties
                • Color Property
                • Position Property
                • Transparency Property
            • IGradientStops
              • Overview
              • Members
              • Methods
                • Delete Method
                • Insert Method
                  • Insert(Color,Double) Method
                  • Insert(Color,Double,Double) Method
                • InsertAt Method
                  • InsertAt(Int32,Color,Double) Method
                  • InsertAt(Int32,Color,Double,Double) Method
              • Properties
                • Count Property
                • Item Property
            • IGroupShapes
              • Overview
              • Members
              • Properties
                • Count Property
                • Item Property
                  • Item(Int32) Property
                  • Item(String) Property
                • Range Property
            • ILineFormat
              • Overview
              • Members
              • Properties
                • BackColor Property
                • BeginArrowheadLength Property
                • BeginArrowheadStyle Property
                • BeginArrowheadWidth Property
                • DashStyle Property
                • EndArrowheadLength Property
                • EndArrowheadStyle Property
                • EndArrowheadWidth Property
                • ForeColor Property
                • Transparency Property
                • TransparencyDefined Property
                • Visible Property
                • VisibleDefined Property
                • Weight Property
                • WeightDefined Property
            • IPictureFormat
              • Overview
              • Members
              • Properties
                • Brightness Property
                • ColorType Property
                • Contrast Property
                • CropBottom Property
                • CropLeft Property
                • CropRight Property
                • CropTop Property
                • TransparencyColor Property
            • IShape
              • Overview
              • Members
              • Methods
                • BringForward Method
                • BringToFront Method
                • Delete Method
                • IncrementLeft Method
                • IncrementTop Method
                • ScaleHeight Method
                • ScaleWidth Method
                • Select Method
                • SendBackward Method
                • SendToBack Method
                • Ungroup Method
              • Properties
                • AutoShapeType Property
                • BottomRightCell Property
                • Chart Property
                • ControlFormat Property
                • Fill Property
                • FormControlType Property
                • GroupItems Property
                • HasChart Property
                • Height Property
                • HorizontalFlip Property
                • ID Property
                • IsChild Property
                • IsDisposed Property
                • Left Property
                • Line Property
                • LockAspectRatio Property
                • Locked Property
                • Name Property
                • ParentGroup Property
                • PictureFormat Property
                • Placement Property
                • PrintObject Property
                • Sheet Property
                • TextFrame Property
                • Top Property
                • TopLeftCell Property
                • Type Property
                • VerticalFlip Property
                • Visible Property
                • Width Property
                • ZOrderPosition Property
            • IShapeRange
              • Overview
              • Members
              • Methods
                • BringForward Method
                • BringToFront Method
                • Delete Method
                • Group Method
                • IncrementLeft Method
                • IncrementTop Method
                • ScaleHeight Method
                • ScaleWidth Method
                • Select Method
                • SendBackward Method
                • SendToBack Method
                • Ungroup Method
              • Properties
                • AutoShapeType Property
                • AutoShapeTypeDefined Property
                • Count Property
                • Fill Property
                • Height Property
                • HeightDefined Property
                • IsDisposed Property
                • Item Property
                • Left Property
                • LeftDefined Property
                • Line Property
                • LockAspectRatio Property
                • LockAspectRatioDefined Property
                • Locked Property
                • LockedDefined Property
                • Placement Property
                • PlacementDefined Property
                • PrintObject Property
                • PrintObjectDefined Property
                • ShapeType Property
                • Sheet Property
                • TextFrame Property
                • Top Property
                • TopDefined Property
                • Width Property
                • WidthDefined Property
            • IShapes
              • Overview
              • Members
              • Methods
                • AddChart Method
                • AddFormControl Method
                • AddLine Method
                • AddPicture Method
                  • AddPicture(String,Double,Double,Double,Double) Method
                  • AddPicture(String,Double,Double) Method
                  • AddPicture(Byte[],Double,Double,Double,Double) Method
                • AddShape Method
                • AddTextBox Method
                • GetShapeRange Method
              • Properties
                • Count Property
                • Item Property
                  • Item(Int32) Property
                  • Item(String) Property
                • Sheet Property
            • ITextFrame
              • Overview
              • Members
              • Methods
                • GetCharacters Method
              • Properties
                • AutoMargins Property
                • AutoMarginsDefined Property
                • AutoSize Property
                • AutoSizeDefined Property
                • Characters Property
                • HorizontalAlignment Property
                • HorizontalAlignmentDefined Property
                • LockText Property
                • LockTextDefined Property
                • MarginBottom Property
                • MarginBottomDefined Property
                • MarginLeft Property
                • MarginLeftDefined Property
                • MarginRight Property
                • MarginRightDefined Property
                • MarginTop Property
                • MarginTopDefined Property
                • Orientation Property
                • OrientationDefined Property
                • VerticalAlignment Property
                • VerticalAlignmentDefined Property
        • SpreadsheetGear.Themes Namespace
          • Overview
          • Enumerations
            • ColorSchemeIndex
            • FontLanguageIndex
            • ThemeFont
          • Interfaces
            • IColor
              • Overview
              • Members
              • Properties
                • ColorSchemeIndex Property
                • RGB Property
            • IColorScheme
              • Overview
              • Members
              • Properties
                • Count Property
                • Item Property
            • IEffectScheme
              • Overview
              • Members
            • IFontScheme
              • Overview
              • Members
              • Properties
                • MajorFont Property
                • MinorFont Property
            • ITheme
              • Overview
              • Members
              • Properties
                • ColorScheme Property
                • EffectScheme Property
                • FontScheme Property
            • IThemeFont
              • Overview
              • Members
              • Properties
                • Name Property
            • IThemeFonts
              • Overview
              • Members
              • Properties
                • Count Property
                • Item Property
        • SpreadsheetGear.Windows.Forms Namespace
          • Overview
          • Classes
            • ActiveTabChangedEventArgs
              • Overview
              • Members
              • Properties
                • Sheet Property
                • TabIndex Property
            • ActiveTabChangingEventArgs
              • Overview
              • Members
              • Properties
                • Cancel Property
                • Sheet Property
                • TabIndex Property
            • CalculateEventArgs
              • Overview
              • Members
            • CellBeginEditEventArgs
              • Overview
              • Members
              • Properties
                • Cancel Property
                • Entry Property
                • Reason Property
            • CellCancelEditEventArgs
              • Overview
              • Members
              • Properties
                • ActiveCell Property
                • Cancel Property
                • Entry Property
                • RangeSelection Property
            • CellEndEditEventArgs
              • Overview
              • Members
              • Properties
                • ActiveCell Property
                • Cancel Property
                • Entry Property
                • RangeSelection Property
            • CommandPrint
              • Overview
              • Members
              • CommandPrint Constructor
                • CommandPrint Constructor(ISheet,PrintWhat,Boolean,Boolean)
                • CommandPrint Constructor(ICollection<IPrintable>,Boolean,Boolean)
              • Methods
                • CreatePrintDocument Method
                  • CreatePrintDocument(ISheet,PrintWhat) Method
                  • CreatePrintDocument(ICollection<IPrintable>) Method
                • Execute Method
            • FormulaBar
              • Overview
              • Members
              • FormulaBar Constructor
              • Methods
                • Dispose Method
                  • Dispose(Boolean) Method
                • OnLayout Method
                • OnPaint Method
                • OnPaintBackground Method
                • SetBoundsCore Method
              • Properties
                • DefaultSize Property
            • RangeChangedEventArgs
              • Overview
              • Members
              • Properties
                • Range Property
            • RangeSelectionChangedEventArgs
              • Overview
              • Members
              • Properties
                • RangeSelection Property
            • RangeSelectionChangingEventArgs
              • Overview
              • Members
              • Properties
                • Cancel Property
                • RangeSelection Property
            • ScrollPositionChangedEventArgs
              • Overview
              • Members
            • ShapeActionEventArgs
              • Overview
              • Members
              • Properties
                • Control Property
                • Shape Property
                • ShapeActionType Property
            • ShapeSelectionChangedEventArgs
              • Overview
              • Members
              • Properties
                • ShapeSelection Property
            • ShapeSelectionChangingEventArgs
              • Overview
              • Members
              • Properties
                • Cancel Property
                • ShapeSelection Property
            • ShowErrorEventArgs
              • Overview
              • Members
              • Properties
                • Caption Property
                • Handled Property
                • Message Property
            • UIManager
              • Overview
              • Members
              • UIManager Constructor
              • Methods
                • CreateCustomControl Method
            • WorkbookDesigner
              • Overview
              • Members
              • WorkbookDesigner Constructor
                • WorkbookDesigner Constructor()
                • WorkbookDesigner Constructor(String[])
                • WorkbookDesigner Constructor(IWorkbookSet)
              • Methods
                • Dispose Method
                  • Dispose(Boolean) Method
                • OnLayout Method
                • ProcessCmdKey Method
              • Properties
                • ActiveCell Property
                • ActiveSheet Property
                • ActiveWorkbook Property
                • ActiveWorkbookSet Property
                • ActiveWorksheet Property
                • RangeSelection Property
                • ShapeSelection Property
            • WorkbookView
              • Overview
              • Members
              • WorkbookView Constructor
                • WorkbookView Constructor()
                • WorkbookView Constructor(IWorkbook)
              • Methods
                • BeginEdit Method
                • BeginUpdate Method
                • CancelEdit Method
                • Copy Method
                • Cut Method
                • Dispose Method
                  • Dispose(Boolean) Method
                • EndEdit Method
                • EndUpdate Method
                • GetLock Method
                • Invalidate Method
                  • Invalidate() Method
                • IsInputChar Method
                • IsInputKey Method
                • LocationToRange Method
                  • LocationToRange(Point) Method
                  • LocationToRange(Double,Double,Double,Double) Method
                  • LocationToRange(Double,Double,Double,Double,RangeLocationFlags) Method
                • OnActiveTabChanged Method
                • OnActiveTabChanging Method
                • OnCalculate Method
                • OnCellBeginEdit Method
                • OnCellCancelEdit Method
                • OnCellEndEdit Method
                • OnGotFocus Method
                • OnHandleDestroyed Method
                • OnKeyDown Method
                • OnKeyPress Method
                • OnKeyUp Method
                • OnLayout Method
                • OnLostFocus Method
                • OnMouseClick Method
                • OnMouseDoubleClick Method
                • OnMouseDown Method
                • OnMouseEnter Method
                • OnMouseLeave Method
                • OnMouseMove Method
                • OnMouseUp Method
                • OnMouseWheel Method
                • OnPaint Method
                • OnPaintBackground Method
                • OnRangeChanged Method
                • OnRangeSelectionChanged Method
                • OnRangeSelectionChanging Method
                • OnScrollPositionChanged Method
                • OnShapeAction Method
                • OnShapeSelectionChanged Method
                • OnShapeSelectionChanging Method
                • OnShowError Method
                • OnSizeChanged Method
                • OnSystemColorsChanged Method
                • Paste Method
                • PasteSpecial Method
                • Print Method
                  • Print(Boolean) Method
                  • Print(PrintWhat,Boolean) Method
                • PrintPreview Method
                  • PrintPreview() Method
                  • PrintPreview(PrintWhat) Method
                • RangeToLocation Method
                  • RangeToLocation(Double,Double,Double,Double) Method
                  • RangeToLocation(Double,Double,Double,Double,RangeLocationFlags) Method
                • Refresh Method
                • ReleaseLock Method
                • RewindLock Method
                • UnwindLock Method
                • Update Method
              • Properties
                • ActiveCell Property
                • ActiveChartSheet Property
                • ActiveCommandManager Property
                • ActiveSheet Property
                • ActiveTabIndex Property
                • ActiveWorkbook Property
                • ActiveWorkbookSet Property
                • ActiveWorkbookWindowInfo Property
                • ActiveWorksheet Property
                • ActiveWorksheetWindowInfo Property
                • AllowChartExplorer Property
                • AllowEditCommands Property
                • AllowRangeExplorer Property
                • AllowShapeExplorer Property
                • AllowWorkbookDesigner Property
                • AllowWorkbookExplorer Property
                • BackgroundCalculation Property
                • DefaultSize Property
                • DisplayReference Property
                • DisplayReferenceName Property
                • ExtraColor Property
                • Focused Property
                • FormulaBar Property
                • HollowSelection Property
                • IsEditing Property
                • RangeSelection Property
                • ShapeSelection Property
                • WorkbookSetState Property
              • Events
                • ActiveTabChanged Event
                • ActiveTabChanging Event
                • Calculate Event
                • CellBeginEdit Event
                • CellCancelEdit Event
                • CellEndEdit Event
                • RangeChanged Event
                • RangeSelectionChanged Event
                • RangeSelectionChanging Event
                • ScrollPositionChanged Event
                • ShapeAction Event
                • ShapeSelectionChanged Event
                • ShapeSelectionChanging Event
                • ShowError Event
            • WorkbookViewEventArgs
              • Overview
              • Members
          • Enumerations
            • CellBeginEditReason
            • ChartExplorerCategoryFlags
            • RangeExplorerCategoryFlags
            • ShapeActionType
            • ShapeExplorerCategoryFlags
          • Delegates
            • ActiveTabChangedEventHandler
            • ActiveTabChangingEventHandler
            • CalculateEventHandler
            • CellBeginEditEventHandler
            • CellCancelEditEventHandler
            • CellEndEditEventHandler
            • RangeChangedEventHandler
            • RangeSelectionChangedEventHandler
            • RangeSelectionChangingEventHandler
            • ScrollPositionChangedEventHandler
            • ShapeActionEventHandler
            • ShapeSelectionChangedEventHandler
            • ShapeSelectionChangingEventHandler
            • ShowErrorEventHandler
    • SpreadsheetGear2023.Core Assembly
      • Overview
      • Namespaces
        • SpreadsheetGear Namespace
          • Overview
          • Classes
            • AutoFilterDateTimeGroupItem
              • Overview
              • Members
              • AutoFilterDateTimeGroupItem Constructor
              • Methods
                • Equals Method
                • GetHashCode Method
              • Properties
                • DateTime Property
                • DateTimeGrouping Property
            • ColorIndex
              • Overview
              • Members
              • Fields
                • Automatic Field
                • None Field
            • Colors
              • Overview
              • Members
              • Colors Constructor
              • Fields
                • AliceBlue Field
                • AntiqueWhite Field
                • Aqua Field
                • Aquamarine Field
                • Azure Field
                • Beige Field
                • Bisque Field
                • Black Field
                • BlanchedAlmond Field
                • Blue Field
                • BlueViolet Field
                • Brown Field
                • BurlyWood Field
                • CadetBlue Field
                • Chartreuse Field
                • Chocolate Field
                • Coral Field
                • CornflowerBlue Field
                • Cornsilk Field
                • Crimson Field
                • Cyan Field
                • DarkBlue Field
                • DarkCyan Field
                • DarkGoldenrod Field
                • DarkGray Field
                • DarkGreen Field
                • DarkKhaki Field
                • DarkMagenta Field
                • DarkOliveGreen Field
                • DarkOrange Field
                • DarkOrchid Field
                • DarkRed Field
                • DarkSalmon Field
                • DarkSeaGreen Field
                • DarkSlateBlue Field
                • DarkSlateGray Field
                • DarkTurquoise Field
                • DarkViolet Field
                • DeepPink Field
                • DeepSkyBlue Field
                • DimGray Field
                • DodgerBlue Field
                • FireBrick Field
                • FloralWhite Field
                • ForestGreen Field
                • Fuchsia Field
                • Gainsboro Field
                • GhostWhite Field
                • Gold Field
                • Goldenrod Field
                • Gray Field
                • Green Field
                • GreenYellow Field
                • Honeydew Field
                • HotPink Field
                • IndianRed Field
                • Indigo Field
                • Ivory Field
                • Khaki Field
                • Lavender Field
                • LavenderBlush Field
                • LawnGreen Field
                • LemonChiffon Field
                • LightBlue Field
                • LightCoral Field
                • LightCyan Field
                • LightGoldenrodYellow Field
                • LightGray Field
                • LightGreen Field
                • LightPink Field
                • LightSalmon Field
                • LightSeaGreen Field
                • LightSkyBlue Field
                • LightSlateGray Field
                • LightSteelBlue Field
                • LightYellow Field
                • Lime Field
                • LimeGreen Field
                • Linen Field
                • Magenta Field
                • Maroon Field
                • MediumAquamarine Field
                • MediumBlue Field
                • MediumOrchid Field
                • MediumPurple Field
                • MediumSeaGreen Field
                • MediumSlateBlue Field
                • MediumSpringGreen Field
                • MediumTurquoise Field
                • MediumVioletRed Field
                • MidnightBlue Field
                • MintCream Field
                • MistyRose Field
                • Moccasin Field
                • NavajoWhite Field
                • Navy Field
                • OldLace Field
                • Olive Field
                • OliveDrab Field
                • Orange Field
                • OrangeRed Field
                • Orchid Field
                • PaleGoldenrod Field
                • PaleGreen Field
                • PaleTurquoise Field
                • PaleVioletRed Field
                • PapayaWhip Field
                • PeachPuff Field
                • Peru Field
                • Pink Field
                • Plum Field
                • PowderBlue Field
                • Purple Field
                • Red Field
                • RosyBrown Field
                • RoyalBlue Field
                • SaddleBrown Field
                • Salmon Field
                • SandyBrown Field
                • SeaGreen Field
                • Seashell Field
                • Sienna Field
                • Silver Field
                • SkyBlue Field
                • SlateBlue Field
                • SlateGray Field
                • Snow Field
                • SpringGreen Field
                • SteelBlue Field
                • Tan Field
                • Teal Field
                • Thistle Field
                • Tomato Field
                • Transparent Field
                • Turquoise Field
                • Violet Field
                • Wheat Field
                • White Field
                • WhiteSmoke Field
                • Yellow Field
                • YellowGreen Field
            • DefaultSystemColors
              • Overview
              • Members
              • DefaultSystemColors Constructor
              • Fields
                • Window Field
                • WindowText Field
            • EndCalculateEventArgs
              • Overview
              • Members
              • Properties
                • BackgroundCalculation Property
            • Factory
              • Overview
              • Members
              • Methods
                • CheckFramework Method
                • GetWorkbook Method
                  • GetWorkbook() Method
                  • GetWorkbook(CultureInfo) Method
                  • GetWorkbook(String) Method
                  • GetWorkbook(String,CultureInfo) Method
                • GetWorkbookSet Method
                  • GetWorkbookSet() Method
                  • GetWorkbookSet(CultureInfo) Method
            • Orientation
              • Overview
              • Members
              • Orientation Constructor
              • Fields
                • Downward Field
                • Horizontal Field
                • Upward Field
                • Vertical Field
            • SortKey
              • Overview
              • Members
              • SortKey Constructor
              • Properties
                • DataOption Property
                • Key Property
                • Order Property
            • SystemColors
              • Overview
              • Members
              • SystemColors Constructor
              • Fields
                • Window Field
                • WindowText Field
          • Enumerations
            • AboveBelow
            • AutoFillType
            • AutoFilterDateTimeGrouping
            • AutoFilterOperator
            • BordersIndex
            • BorderWeight
            • Calculation
            • ConditionValueTypes
            • ContainsOperator
            • DataBarAxisPosition
            • DataBarBorderType
            • DataBarFillType
            • DataBarNegativeColorType
            • DataSeriesDate
            • DataSeriesType
            • DeleteShiftDirection
            • DisplayDrawingObjects
            • DupeUnique
            • DynamicFilterCriteria
            • EnableSelection
            • FileFormat
            • FindLookIn
            • FormatConditionOperator
            • FormatConditionType
            • HAlign
            • Icon
            • IconSet
            • InsertShiftDirection
            • LineStyle
            • LookAt
            • NumberFormatType
            • Order
            • PageBreak
            • PageBreakExtent
            • PageOrientation
            • PaperSize
            • PasteOperation
            • PasteType
            • Pattern
            • PrintErrors
            • PrintLocation
            • ReferenceStyle
            • SearchDirection
            • SearchOrder
            • SheetType
            • SheetVisibility
            • SortDataOption
            • SortOrder
            • SortOrientation
            • SummaryColumn
            • SummaryRow
            • TimePeriods
            • TopBottom
            • UnderlineStyle
            • UpdateLinks
            • ValidationAlertStyle
            • ValidationOperator
            • ValidationType
            • VAlign
            • ValueError
            • ValueType
            • WindowView
          • Structures
            • Color
              • Overview
              • Members
              • Methods
                • Equals Method
                  • Equals(Color) Method
                  • Equals(Object) Method
                • FromArgb Method
                  • FromArgb(Int32) Method
                  • FromArgb(Int32,Int32,Int32,Int32) Method
                  • FromArgb(Int32,Int32,Int32) Method
                • GetHashCode Method
                • ToArgb Method
                • ToString Method
              • Properties
                • A Property
                • B Property
                • G Property
                • R Property
              • Operators
                • Equality Operator
                • Inequality Operator
          • Interfaces
            • IAboveAverage
              • Overview
              • Members
              • Properties
                • AboveBelow Property
                • NumStdDev Property
            • IAreas
              • Overview
              • Members
              • Properties
                • Count Property
                • Item Property
                • WorkbookSet Property
            • IAutoFilter
              • Overview
              • Members
              • Methods
                • ApplyFilter Method
                • ShowAllData Method
              • Properties
                • Filters Property
                • Range Property
            • IBorder
              • Overview
              • Members
              • Properties
                • Color Property
                • ColorDefined Property
                • ColorIndex Property
                • LineStyle Property
                • LineStyleDefined Property
                • ThemeColor Property
                • TintAndShade Property
                • Weight Property
                • WeightDefined Property
                • WorkbookSet Property
            • IBorders
              • Overview
              • Members
              • Properties
                • Color Property
                • ColorDefined Property
                • ColorIndex Property
                • Count Property
                • Item Property
                • LineStyle Property
                • LineStyleDefined Property
                • ThemeColor Property
                • TintAndShade Property
                • Weight Property
                • WeightDefined Property
                • WorkbookSet Property
            • IBuiltinDocumentProperties
              • Overview
              • Members
              • Methods
                • InitializeDefaults Method
              • Properties
                • Author Property
                • Category Property
                • Comments Property
                • ContentStatus Property
                • CreationDate Property
                • DocumentVersion Property
                • Keywords Property
                • Language Property
                • LastAuthor Property
                • LastPrintDate Property
                • LastSaveTime Property
                • RevisionNumber Property
                • Subject Property
                • Title Property
            • ICharacters
              • Overview
              • Members
              • Methods
                • Delete Method
                • Insert Method
              • Properties
                • Count Property
                • Font Property
                • Text Property
                • WorkbookSet Property
            • IChartSheet
              • Overview
              • Members
              • Methods
                • Protect Method
                • Unprotect Method
              • Properties
                • Chart Property
                • ProtectContents Property
                • ProtectDrawingObjects Property
                • ProtectionMode Property
                • WindowInfo Property
                • WindowInfos Property
            • IChartSheets
              • Overview
              • Members
              • Methods
                • Add Method
                • AddAfter Method
                • AddBefore Method
                • Contains Method
              • Properties
                • Count Property
                • Item Property
                  • Item(Int32) Property
                  • Item(String) Property
                • WorkbookSet Property
            • IChartSheetWindowInfo
              • Overview
              • Members
              • Methods
                • SetSelection Method
              • Properties
                • ChartSheet Property
                • Index Property
                • ShapeSelection Property
                • Zoom Property
                • ZoomToFit Property
            • IChartSheetWindowInfos
              • Overview
              • Members
              • Properties
                • ChartSheet Property
                • Count Property
                • Item Property
            • IColors
              • Overview
              • Members
              • Properties
                • Count Property
                • Item Property
            • IColorScale
              • Overview
              • Members
              • Properties
                • ColorScaleCriteria Property
                • Formula Property
            • IColorScaleCriteria
              • Overview
              • Members
              • Properties
                • Count Property
                • Item Property
            • IColorScaleCriterion
              • Overview
              • Members
              • Properties
                • FormatColor Property
                • Index Property
                • Type Property
                • Value Property
            • IColorStop
              • Overview
              • Members
              • Methods
                • Delete Method
              • Properties
                • Color Property
                • Position Property
                • ThemeColor Property
                • TintAndShade Property
            • IColorStops
              • Overview
              • Members
              • Methods
                • Add Method
                • Clear Method
              • Properties
                • Count Property
                • Item Property
            • IComment
              • Overview
              • Members
              • Properties
                • Author Property
                • Shape Property
                • Visible Property
            • IComments
              • Overview
              • Members
              • Properties
                • Count Property
                • Item Property
                • Sheet Property
            • IConditionValue
              • Overview
              • Members
              • Methods
                • Modify Method
              • Properties
                • Type Property
                • Value Property
            • IDatabar
              • Overview
              • Members
              • Properties
                • AxisColor Property
                • AxisPosition Property
                • BarBorder Property
                • BarColor Property
                • BarFillType Property
                • Formula Property
                • MaxPoint Property
                • MinPoint Property
                • NegativeBarFormat Property
                • PercentMax Property
                • PercentMin Property
                • ShowValue Property
            • IDataBarBorder
              • Overview
              • Members
              • Properties
                • Color Property
                • Type Property
            • IDialogSheet
              • Overview
              • Members
            • IDocumentProperties
              • Overview
              • Members
              • Methods
                • Add Method
                • Clear Method
              • Properties
                • Count Property
                • Item Property
                  • Item(Int32) Property
                  • Item(String) Property
                • Parent Property
            • IDocumentProperty
              • Overview
              • Members
              • Methods
                • Delete Method
              • Properties
                • Name Property
                • Parent Property
                • Value Property
            • IFactory
              • Overview
              • Members
            • IFactoryChild
              • Overview
              • Members
              • Properties
                • Factory Property
            • IFilter
              • Overview
              • Members
              • Properties
                • Criteria1 Property
                • Criteria2 Property
                • On Property
                • Operator Property
            • IFilters
              • Overview
              • Members
              • Properties
                • Count Property
                • Item Property
            • IFont
              • Overview
              • Members
              • Properties
                • Bold Property
                • BoldDefined Property
                • Color Property
                • ColorDefined Property
                • ColorIndex Property
                • Italic Property
                • ItalicDefined Property
                • Name Property
                • NameDefined Property
                • OutlineFont Property
                • OutlineFontDefined Property
                • Shadow Property
                • ShadowDefined Property
                • Size Property
                • SizeDefined Property
                • Strikethrough Property
                • StrikethroughDefined Property
                • Subscript Property
                • SubscriptDefined Property
                • Superscript Property
                • SuperscriptDefined Property
                • ThemeColor Property
                • TintAndShade Property
                • Underline Property
                • UnderlineDefined Property
                • WorkbookSet Property
            • IFormatColor
              • Overview
              • Members
              • Properties
                • Color Property
                • ColorIndex Property
                • ThemeColor Property
                • TintAndShade Property
            • IFormatCondition
              • Overview
              • Members
              • Methods
                • Delete Method
                • Modify Method
                  • Modify(FormatConditionType) Method
                  • Modify(FormatConditionType,FormatConditionOperator,String,String) Method
                  • Modify(FormatConditionType,ContainsOperator,String) Method
                  • Modify(FormatConditionType,TimePeriods) Method
                • ModifyAppliesToRange Method
              • Properties
                • AboveAverage Property
                • AppliesTo Property
                • Borders Property
                • ColorScale Property
                • Databar Property
                • DateOperator Property
                • Font Property
                • Formula1 Property
                • Formula2 Property
                • IconSetCondition Property
                • Interior Property
                • NumberFormat Property
                • Operator Property
                • StopIfTrue Property
                • Text Property
                • TextOperator Property
                • Top10 Property
                • Type Property
                • UniqueValues Property
            • IFormatConditions
              • Overview
              • Members
              • Methods
                • Add Method
                  • Add(FormatConditionType) Method
                  • Add(FormatConditionType,FormatConditionOperator,String,String) Method
                  • Add(FormatConditionType,ContainsOperator,String) Method
                  • Add(FormatConditionType,TimePeriods) Method
                • AddAboveAverage Method
                • AddColorScale Method
                • AddDatabar Method
                • AddIconSetCondition Method
                • AddTop10 Method
                • AddUniqueValues Method
                • Delete Method
              • Properties
                • Count Property
                • Item Property
            • IGradient
              • Overview
              • Members
              • Properties
                • ColorStops Property
            • IHPageBreak
              • Overview
              • Members
              • Methods
                • Delete Method
              • Properties
                • Extent Property
                • Location Property
            • IHPageBreaks
              • Overview
              • Members
              • Methods
                • Add Method
              • Properties
                • Count Property
                • Item Property
            • IHyperlink
              • Overview
              • Members
              • Methods
                • Delete Method
              • Properties
                • Address Property
                • EmailSubject Property
                • Range Property
                • ScreenTip Property
                • SubAddress Property
                • TextToDisplay Property
            • IHyperlinks
              • Overview
              • Members
              • Methods
                • Add Method
                • Delete Method
              • Properties
                • Count Property
                • Item Property
            • IIcon
              • Overview
              • Members
              • Properties
                • Index Property
            • IIconCriteria
              • Overview
              • Members
              • Properties
                • Count Property
                • Item Property
            • IIconCriterion
              • Overview
              • Members
              • Properties
                • Icon Property
                • Index Property
                • Operator Property
                • Type Property
                • Value Property
            • IIconSet
              • Overview
              • Members
              • Properties
                • Count Property
                • ID Property
                • Item Property
            • IIconSetCondition
              • Overview
              • Members
              • Properties
                • Formula Property
                • IconCriteria Property
                • IconSet Property
                • ReverseOrder Property
                • ShowIconOnly Property
            • IIconSets
              • Overview
              • Members
              • Properties
                • Count Property
                • Item Property
            • IInterior
              • Overview
              • Members
              • Properties
                • Color Property
                • ColorDefined Property
                • ColorIndex Property
                • Gradient Property
                • GradientDefined Property
                • Pattern Property
                • PatternColor Property
                • PatternColorDefined Property
                • PatternColorIndex Property
                • PatternDefined Property
                • PatternThemeColor Property
                • PatternTintAndShade Property
                • ThemeColor Property
                • TintAndShade Property
            • ILinearGradient
              • Overview
              • Members
              • Properties
                • Degree Property
            • IModule
              • Overview
              • Members
            • IName
              • Overview
              • Members
              • Methods
                • Delete Method
              • Properties
                • Comment Property
                • Index Property
                • Name Property
                • RefersTo Property
                • RefersToR1C1 Property
                • RefersToRange Property
                • Visible Property
            • INames
              • Overview
              • Members
              • Methods
                • Add Method
                  • Add(String,String) Method
                  • Add(String,String,ReferenceStyle) Method
                • Contains Method
              • Properties
                • Count Property
                • Item Property
                  • Item(Int32) Property
                  • Item(String) Property
            • INegativeBarFormat
              • Overview
              • Members
              • Properties
                • BorderColor Property
                • BorderColorType Property
                • Color Property
                • ColorType Property
            • IOutline
              • Overview
              • Members
              • Methods
                • ShowLevels Method
              • Properties
                • SummaryColumn Property
                • SummaryRow Property
            • IPageSetup
              • Overview
              • Members
              • Properties
                • BlackAndWhite Property
                • BottomMargin Property
                • CenterFooter Property
                • CenterFooterPicture Property
                • CenterHeader Property
                • CenterHeaderPicture Property
                • CenterHorizontally Property
                • CenterVertically Property
                • Draft Property
                • FirstPageNumber Property
                • FitToPages Property
                • FitToPagesTall Property
                • FitToPagesWide Property
                • FooterMargin Property
                • HeaderMargin Property
                • LeftFooter Property
                • LeftFooterPicture Property
                • LeftHeader Property
                • LeftHeaderPicture Property
                • LeftMargin Property
                • Order Property
                • Orientation Property
                • PaperSize Property
                • PrintArea Property
                • PrintComments Property
                • PrintErrors Property
                • PrintGridlines Property
                • PrintHeadings Property
                • PrintNotes Property
                • PrintQuality Property
                • PrintQualityVertical Property
                • PrintTitleColumns Property
                • PrintTitleRows Property
                • RightFooter Property
                • RightFooterPicture Property
                • RightHeader Property
                • RightHeaderPicture Property
                • RightMargin Property
                • TopMargin Property
                • Zoom Property
            • IPane
              • Overview
              • Members
              • Methods
                • Activate Method
              • Properties
                • Index Property
                • ScrollColumn Property
                • ScrollRow Property
            • IPanes
              • Overview
              • Members
              • Properties
                • Count Property
                • Item Property
            • IPrintable
              • Overview
              • Members
            • IProtection
              • Overview
              • Members
              • Properties
                • AllowDeletingColumns Property
                • AllowDeletingRows Property
                • AllowFiltering Property
                • AllowFormattingCells Property
                • AllowFormattingColumns Property
                • AllowFormattingRows Property
                • AllowInsertingColumns Property
                • AllowInsertingHyperlinks Property
                • AllowInsertingRows Property
                • AllowSorting Property
                • AllowUsingPivotTables Property
            • IRange
              • Overview
              • Members
              • Methods
                • Activate Method
                • AddComment Method
                • AutoFill Method
                • AutoFilter Method
                  • AutoFilter() Method
                  • AutoFilter(Int32,Object,AutoFilterOperator,Object,Boolean) Method
                • AutoFit Method
                • Clear Method
                • ClearComments Method
                • ClearContents Method
                • ClearFormats Method
                • ClearOutline Method
                • Copy Method
                  • Copy(IRange) Method
                  • Copy(IRange,PasteType,PasteOperation,Boolean,Boolean) Method
                • CopyDown Method
                • CopyFromDataTable Method
                • CopyRight Method
                • DataSeries Method
                • Delete Method
                  • Delete() Method
                  • Delete(DeleteShiftDirection) Method
                • FillDown Method
                • FillLeft Method
                • FillRight Method
                • FillUp Method
                • Find Method
                • FindUnlockedAndVisible Method
                • GetAddress Method
                • GetArea Method
                • GetCharacters Method
                • GetDataSet Method
                • GetDataTable Method
                • GoalSeek Method
                • Group Method
                • Insert Method
                  • Insert() Method
                  • Insert(InsertShiftDirection) Method
                • Intersect Method
                • Merge Method
                • Offset Method
                • Replace Method
                • SaveAs Method
                • SaveToMemory Method
                • SaveToStream Method
                • Select Method
                • Sort Method
                • Subtract Method
                • Table Method
                • Ungroup Method
                • Union Method
                • UnMerge Method
              • Properties
                • AddIndent Property
                • AddIndentDefined Property
                • Address Property
                • AllowEdit Property
                • AreaCount Property
                • Areas Property
                • Borders Property
                • CellCount Property
                • Cells Property
                • Column Property
                • ColumnCount Property
                • Columns Property
                • ColumnWidth Property
                • ColumnWidthDefined Property
                • Comment Property
                • Count Property
                • CurrentArray Property
                • CurrentRegion Property
                • EndDown Property
                • EndLeft Property
                • EndRight Property
                • EndUp Property
                • EntireColumn Property
                • EntireMergeArea Property
                • EntireRow Property
                • Entry Property
                • Font Property
                • FormatConditions Property
                • FormatConditionsDefined Property
                • Formula Property
                • FormulaArray Property
                • FormulaHidden Property
                • FormulaHiddenDefined Property
                • FormulaR1C1 Property
                • HasArray Property
                • HasArrayDefined Property
                • HasFormula Property
                • HasFormulaDefined Property
                • HasValidation Property
                • Height Property
                • Hidden Property
                • HorizontalAlignment Property
                • HorizontalAlignmentDefined Property
                • Hyperlinks Property
                • IndentLevel Property
                • Interior Property
                • IsDisposed Property
                • IsEntireColumns Property
                • IsEntireRows Property
                • IsVolatileOrCircularFormula Property
                • Item Property
                  • Item(String) Property
                  • Item(Int32,Int32) Property
                  • Item(Int32,Int32,Int32,Int32) Property
                • Locked Property
                • LockedDefined Property
                • MergeArea Property
                • MergeCells Property
                • MergeCellsDefined Property
                • Name Property
                • NumberFormat Property
                • NumberFormatDefined Property
                • NumberFormatType Property
                • Orientation Property
                • OrientationDefined Property
                • OutlineLevel Property
                • OutlineLevelDefined Property
                • PageBreak Property
                • PrefixCharacter Property
                • PrefixCharacterDefined Property
                • Range Property
                • Row Property
                • RowCount Property
                • RowHeight Property
                • RowHeightDefined Property
                • Rows Property
                • ShowDetail Property
                • ShrinkToFit Property
                • ShrinkToFitDefined Property
                • Style Property
                • StyleDefined Property
                • Text Property
                • Validation Property
                • ValidationDefined Property
                • Value Property
                • ValueType Property
                • VerticalAlignment Property
                • VerticalAlignmentDefined Property
                • Width Property
                • WorkbookSet Property
                • Worksheet Property
                • WrapText Property
                • WrapTextDefined Property
            • IRectangularGradient
              • Overview
              • Members
              • Properties
                • RectangleBottom Property
                • RectangleLeft Property
                • RectangleRight Property
                • RectangleTop Property
            • ISheet
              • Overview
              • Members
              • Methods
                • CopyAfter Method
                • CopyBefore Method
                • Delete Method
                • EvaluateRange Method
                • EvaluateRanges Method
                • EvaluateValue Method
                • EvaluateValues Method
                • MoveAfter Method
                • MoveBefore Method
                • Select Method
              • Properties
                • Index Property
                • IsDisposed Property
                • Name Property
                • Tab Property
                • Type Property
                • Visible Property
                • Workbook Property
                • WorkbookSet Property
            • ISheets
              • Overview
              • Members
              • Methods
                • Contains Method
              • Properties
                • Count Property
                • Item Property
                  • Item(Int32) Property
                  • Item(String) Property
                • WorkbookSet Property
            • IStyle
              • Overview
              • Members
              • Methods
                • Delete Method
              • Properties
                • AddIndent Property
                • Borders Property
                • BuiltIn Property
                • Font Property
                • FormulaHidden Property
                • HorizontalAlignment Property
                • IncludeAlignment Property
                • IncludeBorder Property
                • IncludeFont Property
                • IncludeNumber Property
                • IncludePatterns Property
                • IncludeProtection Property
                • IndentLevel Property
                • Interior Property
                • Locked Property
                • Name Property
                • NumberFormat Property
                • Orientation Property
                • ShrinkToFit Property
                • VerticalAlignment Property
                • WrapText Property
            • IStyles
              • Overview
              • Members
              • Methods
                • Add Method
              • Properties
                • Count Property
                • Item Property
                  • Item(Int32) Property
                  • Item(String) Property
            • ITab
              • Overview
              • Members
              • Properties
                • Color Property
                • ColorIndex Property
                • ThemeColor Property
                • TintAndShade Property
            • ITop10
              • Overview
              • Members
              • Properties
                • Percent Property
                • Rank Property
                • TopBottom Property
            • IUniqueValues
              • Overview
              • Members
              • Properties
                • DupeUnique Property
            • IValidation
              • Overview
              • Members
              • Methods
                • Add Method
                • Delete Method
                • Modify Method
              • Properties
                • AlertStyle Property
                • ErrorMessage Property
                • ErrorTitle Property
                • Formula1 Property
                • Formula2 Property
                • IgnoreBlank Property
                • InCellDropdown Property
                • InputMessage Property
                • InputTitle Property
                • Operator Property
                • ShowError Property
                • ShowInputMessage Property
                • Type Property
                • Value Property
            • IVPageBreak
              • Overview
              • Members
              • Methods
                • Delete Method
              • Properties
                • Extent Property
                • Location Property
            • IVPageBreaks
              • Overview
              • Members
              • Methods
                • Add Method
              • Properties
                • Count Property
                • Item Property
            • IWorkbook
              • Overview
              • Members
              • Methods
                • Close Method
                • DateTimeToNumber Method
                • GetDataSet Method
                  • GetDataSet(GetDataFlags) Method
                  • GetDataSet(String,GetDataFlags) Method
                • NumberToDateTime Method
                • Protect Method
                • Save Method
                • SaveAs Method
                  • SaveAs(String,FileFormat) Method
                  • SaveAs(String,FileFormat,String) Method
                • SaveToMemory Method
                  • SaveToMemory(FileFormat) Method
                  • SaveToMemory(FileFormat,String) Method
                • SaveToStream Method
                  • SaveToStream(Stream,FileFormat) Method
                  • SaveToStream(Stream,FileFormat,String) Method
                  • SaveToStream(FileFormat) Method
                • Unprotect Method
              • Properties
                • ActiveChartSheet Property
                • ActiveSheet Property
                • ActiveWorksheet Property
                • BuiltinDocumentProperties Property
                • ChartSheets Property
                • Colors Property
                • CustomDocumentProperties Property
                • Date1904 Property
                • DisplayDrawingObjects Property
                • FileFormat Property
                • FullName Property
                • IconSets Property
                • IsDisposed Property
                • IsModified Property
                • Name Property
                • Names Property
                • PrecisionAsDisplayed Property
                • ProtectStructure Property
                • ProtectWindows Property
                • ReadOnlyRecommended Property
                • SaveLinkValues Property
                • Sheets Property
                • Styles Property
                • Theme Property
                • UpdateLinks Property
                • WindowInfo Property
                • WindowInfos Property
                • WorkbookSet Property
                • Worksheets Property
                • WriteReserved Property
                • WriteReservedBy Property
            • IWorkbooks
              • Overview
              • Members
              • Methods
                • Add Method
                • Close Method
                • Contains Method
                • Open Method
                  • Open(String) Method
                  • Open(String,String) Method
                • OpenFromMemory Method
                  • OpenFromMemory(Byte[]) Method
                  • OpenFromMemory(Byte[],String) Method
                • OpenFromStream Method
                  • OpenFromStream(Stream) Method
                  • OpenFromStream(Stream,String) Method
              • Properties
                • Count Property
                • Item Property
                  • Item(Int32) Property
                  • Item(String) Property
                • WorkbookSet Property
            • IWorkbookSet
              • Overview
              • Members
              • Methods
                • Add Method
                • BeginUpdate Method
                • Calculate Method
                • CalculateFull Method
                • CalculateFullRebuild Method
                • EndUpdate Method
                • GC Method
                • GetAddress Method
                  • GetAddress(Int32,Int32) Method
                  • GetAddress(Int32,Int32,Int32,Int32,Int32,Int32,Boolean,Boolean,Boolean,Boolean,Boolean,ReferenceStyle) Method
                • GetLock Method
                • ReleaseLock Method
                • Remove Method
                • RewindLock Method
                • UnwindLock Method
                • WithLock Method
                  • WithLock(Action) Method
                  • WithLock<TResult>(Func<TResult>) Method
              • Properties
                • AltStartupPath Property
                • BackgroundCalculation Property
                • CalculateBeforeSave Property
                • Calculation Property
                • CalculationOnDemand Property
                • Culture Property
                • CustomLists Property
                • DefaultFontName Property
                • DefaultFontSize Property
                • EnableWebService Property
                • Experimental Property
                • HasLock Property
                • IsDisposed Property
                • IsTrial Property
                • Iteration Property
                • LibraryPath Property
                • MaxChange Property
                • MaxColumns Property
                • MaxIterations Property
                • MaxRecursions Property
                • MaxRows Property
                • MaxWorksheets Property
                • NeverRecalc Property
                • ReadObjects Property
                • ReadVBA Property
                • ReferenceStyle Property
                • SheetsInNewWorkbook Property
                • StartupPath Property
                • UserName Property
                • Workbooks Property
              • Events
                • EndCalculate Event
            • IWorkbookWindowInfo
              • Overview
              • Members
              • Methods
                • Delete Method
              • Properties
                • ActiveChartSheet Property
                • ActiveSheet Property
                • ActiveWorksheet Property
                • DisplayHorizontalScrollBar Property
                • DisplayVerticalScrollBar Property
                • DisplayWorkbookTabs Property
                • Index Property
                • TabRatio Property
                • Workbook Property
            • IWorkbookWindowInfos
              • Overview
              • Members
              • Methods
                • Add Method
              • Properties
                • Count Property
                • Item Property
                • Workbook Property
            • IWorksheet
              • Overview
              • Members
              • Methods
                • Protect Method
                • SaveAs Method
                • SaveToMemory Method
                • SaveToStream Method
                • Unprotect Method
              • Properties
                • AutoFilter Property
                • AutoFilterMode Property
                • Cells Property
                • Comments Property
                • DisplayAutomaticPageBreaks Property
                • EnableSelection Property
                • HPageBreaks Property
                • Hyperlinks Property
                • Names Property
                • Outline Property
                • PageSetup Property
                • ProtectContents Property
                • ProtectDrawingObjects Property
                • Protection Property
                • ProtectionMode Property
                • ProtectScenarios Property
                • Range Property
                • Shapes Property
                • StandardWidth Property
                • TransitionExpEval Property
                • TransitionFormEntry Property
                • UsedRange Property
                • VPageBreaks Property
                • WindowInfo Property
                • WindowInfos Property
            • IWorksheets
              • Overview
              • Members
              • Methods
                • Add Method
                • AddAfter Method
                • AddBefore Method
                • Contains Method
              • Properties
                • Count Property
                • Item Property
                  • Item(Int32) Property
                  • Item(String) Property
                • WorkbookSet Property
            • IWorksheetWindowInfo
              • Overview
              • Members
              • Methods
                • ColumnToPoints Method
                • PointsToColumn Method
                • PointsToRow Method
                • RowToPoints Method
                • SetSelection Method
                  • SetSelection(IRange,IRange,Int32) Method
                  • SetSelection(IShapeRange,Boolean) Method
              • Properties
                • ActiveCell Property
                • ActiveCellAreaIndex Property
                • ActivePane Property
                • DisplayFormulas Property
                • DisplayGridlines Property
                • DisplayHeadings Property
                • DisplayOutline Property
                • DisplayRightToLeft Property
                • DisplayZeros Property
                • FreezePanes Property
                • GridlineColor Property
                • GridlineColorIndex Property
                • Index Property
                • Panes Property
                • RangeSelection Property
                • ScrollColumn Property
                • ScrollRow Property
                • ShapeSelection Property
                • SplitColumns Property
                • SplitHorizontal Property
                • SplitRows Property
                • SplitVertical Property
                • View Property
                • Worksheet Property
                • Zoom Property
            • IWorksheetWindowInfos
              • Overview
              • Members
              • Properties
                • Count Property
                • Item Property
                • Worksheet Property
          • Delegates
            • EndCalculateEventHandler
        • SpreadsheetGear.Advanced.Cells Namespace
          • Overview
          • Enumerations
            • ValueType
          • Interfaces
            • IValue
              • Overview
              • Members
              • Methods
                • GetFormula Method
                • GetText Method
              • Properties
                • Error Property
                • Formula Property
                • HasFormula Property
                • Logical Property
                • Number Property
                • Text Property
                • Type Property
            • IValues
              • Overview
              • Members
              • Methods
                • Clear Method
                • ForEachNumber Method
                • IsValidNumber Method
                • SetError Method
                • SetFormula Method
                  • SetFormula(Int32,Int32,String) Method
                  • SetFormula(Int32,Int32,StringBuilder) Method
                • SetLogical Method
                • SetNumber Method
                • SetText Method
                  • SetText(Int32,Int32,String) Method
                  • SetText(Int32,Int32,StringBuilder) Method
                • ValidateNumber Method
              • Properties
                • Item Property
        • SpreadsheetGear.Charts Namespace
          • Overview
          • Classes
            • TickLabelOrientation
              • Overview
              • Members
              • TickLabelOrientation Constructor
              • Fields
                • Automatic Field
                • Downward Field
                • Horizontal Field
                • Upward Field
                • Vertical Field
          • Enumerations
            • AxisCrosses
            • AxisGroup
            • AxisType
            • BarShape
            • CategoryType
            • ChartElementPosition
            • ChartSplitType
            • ChartType
            • DataLabelPosition
            • DisplayBlanksAs
            • EndStyleCap
            • ErrorBarDirection
            • ErrorBarInclude
            • ErrorBarType
            • LegendPosition
            • MarkerStyle
            • RowCol
            • ScaleType
            • SizeRepresents
            • TickLabelPosition
            • TickMark
            • TimeUnit
            • TrendlineType
          • Interfaces
            • IAxes
              • Overview
              • Members
              • Properties
                • Item Property
                  • Item(AxisType) Property
                  • Item(AxisType,AxisGroup) Property
            • IAxis
              • Overview
              • Members
              • Properties
                • AxisBetweenCategories Property
                • AxisGroup Property
                • AxisTitle Property
                • BaseUnit Property
                • BaseUnitIsAuto Property
                • CategoryType Property
                • Crosses Property
                • CrossesAt Property
                • Format Property
                • HasMajorGridlines Property
                • HasMinorGridlines Property
                • HasTitle Property
                • LogBase Property
                • MajorGridlines Property
                • MajorTickMark Property
                • MajorUnit Property
                • MajorUnitIsAuto Property
                • MajorUnitScale Property
                • MaximumScale Property
                • MaximumScaleIsAuto Property
                • MinimumScale Property
                • MinimumScaleIsAuto Property
                • MinorGridlines Property
                • MinorTickMark Property
                • MinorUnit Property
                • MinorUnitIsAuto Property
                • MinorUnitScale Property
                • ReversePlotOrder Property
                • ScaleType Property
                • TickLabelPosition Property
                • TickLabels Property
                • TickLabelSpacing Property
                • TickLabelSpacingIsAuto Property
                • TickMarkSpacing Property
                • Type Property
            • IAxisTitle
              • Overview
              • Members
              • Properties
                • Font Property
                • Format Property
                • IncludeInLayout Property
                • Orientation Property
                • Position Property
                • Text Property
            • IChart
              • Overview
              • Members
              • Methods
                • SetSourceData Method
              • Properties
                • AutoScaling Property
                • Axes Property
                • BackWall Property
                • ChartArea Property
                • ChartGroups Property
                • ChartTitle Property
                • ChartType Property
                • DataTable Property
                • DepthPercent Property
                • DisplayBlanksAs Property
                • Elevation Property
                • Floor Property
                • GapDepth Property
                • HasAxis Property
                • HasDataTable Property
                • HasLegend Property
                • HasTitle Property
                • HeightPercent Property
                • Legend Property
                • PageSetup Property
                • Perspective Property
                • PlotArea Property
                • PlotVisibleOnly Property
                • ProtectData Property
                • ProtectFormatting Property
                • ProtectSelection Property
                • RightAngleAxes Property
                • Rotation Property
                • SeriesCollection Property
                • Shapes Property
                • Sheet Property
                • SideWall Property
            • IChartArea
              • Overview
              • Members
              • Properties
                • Font Property
                • Format Property
            • IChartFormat
              • Overview
              • Members
              • Properties
                • Fill Property
                • Line Property
            • IChartGroup
              • Overview
              • Members
              • Properties
                • AxisGroup Property
                • BubbleScale Property
                • Chart Property
                • DoughnutHoleSize Property
                • DownBars Property
                • DropLines Property
                • FirstSliceAngle Property
                • GapWidth Property
                • Has3DShading Property
                • HasDropLines Property
                • HasHiLoLines Property
                • HasRadarAxisLabels Property
                • HasSeriesLines Property
                • HasUpDownBars Property
                • HiLoLines Property
                • Index Property
                • Overlap Property
                • RadarAxisLabels Property
                • SecondPlotSize Property
                • SeriesCollection Property
                • SeriesLines Property
                • ShowNegativeBubbles Property
                • SizeRepresents Property
                • SplitType Property
                • SplitValue Property
                • UpBars Property
                • VaryByCategories Property
            • IChartGroups
              • Overview
              • Members
              • Properties
                • Count Property
                • Item Property
            • IChartTitle
              • Overview
              • Members
              • Properties
                • Font Property
                • Format Property
                • IncludeInLayout Property
                • Left Property
                • Orientation Property
                • Position Property
                • Text Property
                • Top Property
            • IDataLabel
              • Overview
              • Members
              • Properties
                • AutoText Property
                • Font Property
                • Format Property
                • NumberFormat Property
                • NumberFormatLinked Property
                • Orientation Property
                • Position Property
                • ShowBubbleSize Property
                • ShowCategoryName Property
                • ShowLegendKey Property
                • ShowPercentage Property
                • ShowValue Property
                • Text Property
            • IDataLabels
              • Overview
              • Members
              • Properties
                • AutoText Property
                • Count Property
                • Font Property
                • Format Property
                • Item Property
                • NumberFormat Property
                • NumberFormatLinked Property
                • Orientation Property
                • Position Property
                • ShowBubbleSize Property
                • ShowCategoryName Property
                • ShowLegendKey Property
                • ShowPercentage Property
                • ShowValue Property
            • IDataTable
              • Overview
              • Members
              • Properties
                • Format Property
                • HasBorderHorizontal Property
                • HasBorderOutline Property
                • HasBorderVertical Property
                • ShowLegendKey Property
            • IDownBars
              • Overview
              • Members
              • Properties
                • Format Property
            • IDropLines
              • Overview
              • Members
              • Properties
                • Format Property
            • IErrorBars
              • Overview
              • Members
              • Properties
                • EndStyle Property
                • Format Property
            • IFloor
              • Overview
              • Members
              • Properties
                • Format Property
            • IGridlines
              • Overview
              • Members
              • Properties
                • Format Property
            • IHasAxis
              • Overview
              • Members
              • Properties
                • Item Property
                  • Item(AxisType) Property
                  • Item(AxisType,AxisGroup) Property
            • IHiLoLines
              • Overview
              • Members
              • Properties
                • Format Property
            • ILeaderLines
              • Overview
              • Members
              • Properties
                • Format Property
            • ILegend
              • Overview
              • Members
              • Properties
                • Font Property
                • Format Property
                • Height Property
                • IncludeInLayout Property
                • Left Property
                • Position Property
                • Top Property
                • Width Property
            • IPlotArea
              • Overview
              • Members
              • Properties
                • Format Property
                • Height Property
                • Left Property
                • Position Property
                • Top Property
                • Width Property
            • IPoint
              • Overview
              • Members
              • Properties
                • DataLabel Property
                • Explosion Property
                • Format Property
                • HasDataLabel Property
                • InvertIfNegative Property
                • MarkerBackgroundColor Property
                • MarkerForegroundColor Property
                • MarkerSize Property
                • MarkerStyle Property
                • SecondaryPlot Property
            • IPoints
              • Overview
              • Members
              • Properties
                • Count Property
                • Item Property
            • ISeries
              • Overview
              • Members
              • Methods
                • Delete Method
                • ErrorBar Method
                  • ErrorBar(ErrorBarDirection,ErrorBarInclude,ErrorBarType,Double) Method
                  • ErrorBar(ErrorBarDirection,ErrorBarInclude,ErrorBarType,String,String) Method
              • Properties
                • AxisGroup Property
                • BarShape Property
                • BubbleSizes Property
                • ChartType Property
                • DataLabels Property
                • ErrorBars Property
                • Explosion Property
                • Format Property
                • Has3DEffect Property
                • HasDataLabels Property
                • HasErrorBars Property
                • HasLeaderLines Property
                • InvertIfNegative Property
                • LeaderLines Property
                • MarkerBackgroundColor Property
                • MarkerForegroundColor Property
                • MarkerSize Property
                • MarkerStyle Property
                • Name Property
                • Points Property
                • Smooth Property
                • Trendlines Property
                • Values Property
                • XValues Property
            • ISeriesCollection
              • Overview
              • Members
              • Methods
                • Add Method
              • Properties
                • Count Property
                • Item Property
            • ISeriesLines
              • Overview
              • Members
              • Properties
                • Format Property
            • ITickLabels
              • Overview
              • Members
              • Properties
                • Font Property
                • NumberFormat Property
                • NumberFormatLinked Property
                • Orientation Property
            • ITrendline
              • Overview
              • Members
              • Methods
                • Delete Method
              • Properties
                • Backward Property
                • DataLabel Property
                • DisplayEquation Property
                • DisplayRSquared Property
                • Format Property
                • Forward Property
                • Index Property
                • Intercept Property
                • InterceptIsAuto Property
                • Name Property
                • NameIsAuto Property
                • Order Property
                • Period Property
                • Type Property
            • ITrendlines
              • Overview
              • Members
              • Methods
                • Add Method
              • Properties
                • Count Property
                • Item Property
            • IUpBars
              • Overview
              • Members
              • Properties
                • Format Property
            • IWalls
              • Overview
              • Members
              • Properties
                • Format Property
        • SpreadsheetGear.Commands Namespace
          • Overview
          • Classes
            • Command
              • Overview
              • Members
              • Methods
                • Dispose Method
                • Execute Method
                • Undo Method
              • Properties
                • DisplayText Property
                • UndoSupport Property
            • CommandManager
              • Overview
              • Members
              • CommandManager Constructor
              • Methods
                • ClearCommands Method
                  • ClearCommands() Method
                  • ClearCommands(IWorkbook) Method
                • CreateCommandClear Method
                • CreateCommandClearContents Method
                • CreateCommandClearFormats Method
                • CreateCommandCopy Method
                • CreateCommandCut Method
                • CreateCommandDelete Method
                  • CreateCommandDelete(IRange) Method
                  • CreateCommandDelete(IRange,DeleteShiftDirection) Method
                • CreateCommandInsert Method
                  • CreateCommandInsert(IRange) Method
                  • CreateCommandInsert(IRange,InsertShiftDirection) Method
                • CreateCommandPaste Method
                • CreateCommandPasteSpecial Method
                • CreateCommandPrint Method
                  • CreateCommandPrint(ISheet,PrintWhat,Boolean,Boolean) Method
                  • CreateCommandPrint(ICollection<IPrintable>,Boolean,Boolean) Method
                • Execute Method
                • Redo Method
                • Undo Method
              • Properties
                • CanRedo Property
                • CanUndo Property
                • RedoDisplayText Property
                • UndoDisplayText Property
                • UndoLimit Property
            • CommandPrint
              • Overview
              • Members
              • Properties
                • DisplayText Property
                • IsPrintPreview Property
                • IsShowPrintDialog Property
                • Printables Property
                • PrintWhat Property
                • Sheet Property
                • UndoSupport Property
            • CommandRange
              • Overview
              • Members
              • Methods
                • Dispose Method
                • Undo Method
              • Properties
                • Range Property
                • UndoFlags Property
                • UndoSupport Property
            • CommandRange.Clear
              • Overview
              • Members
              • CommandRange.Clear Constructor
              • Methods
                • Execute Method
              • Properties
                • DisplayText Property
                • UndoFlags Property
            • CommandRange.ClearContents
              • Overview
              • Members
              • CommandRange.ClearContents Constructor
              • Methods
                • Execute Method
              • Properties
                • DisplayText Property
                • UndoFlags Property
            • CommandRange.ClearFormats
              • Overview
              • Members
              • CommandRange.ClearFormats Constructor
              • Methods
                • Execute Method
              • Properties
                • DisplayText Property
                • UndoFlags Property
            • CommandRange.Copy
              • Overview
              • Members
              • CommandRange.Copy Constructor
              • Methods
                • Execute Method
              • Properties
                • DisplayText Property
                • UndoSupport Property
            • CommandRange.Cut
              • Overview
              • Members
              • CommandRange.Cut Constructor
              • Methods
                • Execute Method
              • Properties
                • DisplayText Property
                • UndoFlags Property
            • CommandRange.Delete
              • Overview
              • Members
              • CommandRange.Delete Constructor
                • CommandRange.Delete Constructor(IRange)
                • CommandRange.Delete Constructor(IRange,DeleteShiftDirection)
              • Methods
                • Execute Method
                • Undo Method
              • Properties
                • DisplayText Property
                • UndoFlags Property
            • CommandRange.Insert
              • Overview
              • Members
              • CommandRange.Insert Constructor
                • CommandRange.Insert Constructor(IRange)
                • CommandRange.Insert Constructor(IRange,InsertShiftDirection)
              • Methods
                • Execute Method
                • Undo Method
              • Properties
                • DisplayText Property
                • UndoFlags Property
            • CommandRange.Paste
              • Overview
              • Members
              • CommandRange.Paste Constructor
              • Properties
                • DisplayText Property
            • CommandRange.PasteSpecial
              • Overview
              • Members
              • CommandRange.PasteSpecial Constructor
              • Methods
                • Execute Method
                • Pasting Method
                • Undo Method
              • Properties
                • DisplayText Property
                • UndoFlags Property
                • UndoSupport Property
          • Enumerations
            • CommandRangeUndoFlags
            • CommandUndoSupport
        • SpreadsheetGear.Controls Namespace
          • Overview
          • Enumerations
            • RangeLocationFlags
        • SpreadsheetGear.CustomFunctions Namespace
          • Overview
          • Classes
            • Function
              • Overview
              • Members
              • Methods
                • Evaluate Method
              • Properties
                • Name Property
                • ReturnType Property
                • Volatility Property
          • Enumerations
            • ValueType
            • Volatility
          • Interfaces
            • IArguments
              • Overview
              • Members
              • Methods
                • ClearError Method
                • GetArrayDimensions Method
                • GetArrayFormulaInfo Method
                • GetArrayValue Method
                • GetLogical Method
                • GetNumber Method
                • GetText Method
              • Properties
                • Count Property
                • CurrentColumn Property
                • CurrentFormula Property
                • CurrentFunctionName Property
                • CurrentRow Property
                • CurrentWorksheet Property
                • Item Property
            • IValue
              • Overview
              • Members
              • Methods
                • SetArray Method
                  • SetArray(Double[,]) Method
                  • SetArray(Object[,]) Method
                • SetEmpty Method
              • Properties
                • Error Property
                • IsEmpty Property
                • IsError Property
                • IsLogical Property
                • IsNumber Property
                • IsText Property
                • Logical Property
                • Number Property
                • Text Property
                • Type Property
        • SpreadsheetGear.Data Namespace
          • Overview
          • Enumerations
            • GetDataFlags
            • SetDataFlags
        • SpreadsheetGear.Printing Namespace
          • Overview
          • Enumerations
            • PrintWhat
          • Interfaces
            • IGraphic
              • Overview
              • Members
              • Methods
                • Add Method
                  • Add(String,Double,Double) Method
                  • Add(String) Method
                  • Add(Byte[],Double,Double) Method
                • Delete Method
              • Properties
                • CropBottom Property
                • CropLeft Property
                • CropRight Property
                • CropTop Property
                • Height Property
                • LockAspectRatio Property
                • Width Property
        • SpreadsheetGear.Shapes Namespace
          • Overview
          • Classes
            • ControlFormatValues
              • Overview
              • Members
              • ControlFormatValues Constructor
              • Fields
                • CheckBoxFalse Field
                • CheckBoxNA Field
                • CheckBoxTrue Field
                • ListIndexNone Field
          • Enumerations
            • ArrowheadLength
            • ArrowheadStyle
            • ArrowheadWidth
            • AutoShapeType
            • FillType
            • FormControlType
            • GradientColorType
            • GradientStyle
            • LineDashStyle
            • PictureColorType
            • Placement
            • PresetGradientType
            • ScaleFrom
            • ShapeType
            • TextOrientation
          • Interfaces
            • IColorFormat
              • Overview
              • Members
              • Properties
                • RGB Property
                • RGBDefined Property
                • SchemeColor Property
                • SchemeColorDefined Property
                • ThemeColor Property
                • TintAndShade Property
            • IControlFormat
              • Overview
              • Members
              • Methods
                • AddItem Method
                  • AddItem(String) Method
                  • AddItem(String,Int32) Method
                • RemoveAllItems Method
                • RemoveItem Method
              • Properties
                • DropDownLines Property
                • LargeChange Property
                • LinkedCell Property
                • List Property
                • ListCount Property
                • ListFillRange Property
                • ListIndex Property
                • Max Property
                • Min Property
                • SmallChange Property
                • Value Property
            • IFillFormat
              • Overview
              • Members
              • Methods
                • OneColorGradient Method
                • PresetGradient Method
                • Solid Method
                • TwoColorGradient Method
              • Properties
                • BackColor Property
                • ForeColor Property
                • GradientColorType Property
                • GradientDegree Property
                • GradientDegreeDefined Property
                • GradientStops Property
                • GradientStyle Property
                • PresetGradientType Property
                • Transparency Property
                • TransparencyDefined Property
                • Type Property
                • TypeDefined Property
                • Visible Property
                • VisibleDefined Property
            • IGradientStop
              • Overview
              • Members
              • Properties
                • Color Property
                • Position Property
                • Transparency Property
            • IGradientStops
              • Overview
              • Members
              • Methods
                • Delete Method
                • Insert Method
                  • Insert(Color,Double) Method
                  • Insert(Color,Double,Double) Method
                • InsertAt Method
                  • InsertAt(Int32,Color,Double) Method
                  • InsertAt(Int32,Color,Double,Double) Method
              • Properties
                • Count Property
                • Item Property
            • IGroupShapes
              • Overview
              • Members
              • Properties
                • Count Property
                • Item Property
                  • Item(Int32) Property
                  • Item(String) Property
                • Range Property
            • ILineFormat
              • Overview
              • Members
              • Properties
                • BackColor Property
                • BeginArrowheadLength Property
                • BeginArrowheadStyle Property
                • BeginArrowheadWidth Property
                • DashStyle Property
                • EndArrowheadLength Property
                • EndArrowheadStyle Property
                • EndArrowheadWidth Property
                • ForeColor Property
                • Transparency Property
                • TransparencyDefined Property
                • Visible Property
                • VisibleDefined Property
                • Weight Property
                • WeightDefined Property
            • IPictureFormat
              • Overview
              • Members
              • Properties
                • Brightness Property
                • ColorType Property
                • Contrast Property
                • CropBottom Property
                • CropLeft Property
                • CropRight Property
                • CropTop Property
                • TransparencyColor Property
            • IShape
              • Overview
              • Members
              • Methods
                • BringForward Method
                • BringToFront Method
                • Delete Method
                • IncrementLeft Method
                • IncrementTop Method
                • ScaleHeight Method
                • ScaleWidth Method
                • Select Method
                • SendBackward Method
                • SendToBack Method
                • Ungroup Method
              • Properties
                • AutoShapeType Property
                • BottomRightCell Property
                • Chart Property
                • ControlFormat Property
                • Fill Property
                • FormControlType Property
                • GroupItems Property
                • HasChart Property
                • Height Property
                • HorizontalFlip Property
                • ID Property
                • IsChild Property
                • IsDisposed Property
                • Left Property
                • Line Property
                • LockAspectRatio Property
                • Locked Property
                • Name Property
                • ParentGroup Property
                • PictureFormat Property
                • Placement Property
                • PrintObject Property
                • Sheet Property
                • TextFrame Property
                • Top Property
                • TopLeftCell Property
                • Type Property
                • VerticalFlip Property
                • Visible Property
                • Width Property
                • ZOrderPosition Property
            • IShapeRange
              • Overview
              • Members
              • Methods
                • BringForward Method
                • BringToFront Method
                • Delete Method
                • Group Method
                • IncrementLeft Method
                • IncrementTop Method
                • ScaleHeight Method
                • ScaleWidth Method
                • Select Method
                • SendBackward Method
                • SendToBack Method
                • Ungroup Method
              • Properties
                • AutoShapeType Property
                • AutoShapeTypeDefined Property
                • Count Property
                • Fill Property
                • Height Property
                • HeightDefined Property
                • IsDisposed Property
                • Item Property
                • Left Property
                • LeftDefined Property
                • Line Property
                • LockAspectRatio Property
                • LockAspectRatioDefined Property
                • Locked Property
                • LockedDefined Property
                • Placement Property
                • PlacementDefined Property
                • PrintObject Property
                • PrintObjectDefined Property
                • ShapeType Property
                • Sheet Property
                • TextFrame Property
                • Top Property
                • TopDefined Property
                • Width Property
                • WidthDefined Property
            • IShapes
              • Overview
              • Members
              • Methods
                • AddChart Method
                • AddFormControl Method
                • AddLine Method
                • AddPicture Method
                  • AddPicture(String,Double,Double,Double,Double) Method
                  • AddPicture(String,Double,Double) Method
                  • AddPicture(Byte[],Double,Double,Double,Double) Method
                • AddShape Method
                • AddTextBox Method
                • GetShapeRange Method
              • Properties
                • Count Property
                • Item Property
                  • Item(Int32) Property
                  • Item(String) Property
                • Sheet Property
            • ITextFrame
              • Overview
              • Members
              • Methods
                • GetCharacters Method
              • Properties
                • AutoMargins Property
                • AutoMarginsDefined Property
                • AutoSize Property
                • AutoSizeDefined Property
                • Characters Property
                • HorizontalAlignment Property
                • HorizontalAlignmentDefined Property
                • LockText Property
                • LockTextDefined Property
                • MarginBottom Property
                • MarginBottomDefined Property
                • MarginLeft Property
                • MarginLeftDefined Property
                • MarginRight Property
                • MarginRightDefined Property
                • MarginTop Property
                • MarginTopDefined Property
                • Orientation Property
                • OrientationDefined Property
                • VerticalAlignment Property
                • VerticalAlignmentDefined Property
        • SpreadsheetGear.Themes Namespace
          • Overview
          • Enumerations
            • ColorSchemeIndex
            • FontLanguageIndex
            • ThemeFont
          • Interfaces
            • IColor
              • Overview
              • Members
              • Properties
                • ColorSchemeIndex Property
                • RGB Property
            • IColorScheme
              • Overview
              • Members
              • Properties
                • Count Property
                • Item Property
            • IEffectScheme
              • Overview
              • Members
            • IFontScheme
              • Overview
              • Members
              • Properties
                • MajorFont Property
                • MinorFont Property
            • ITheme
              • Overview
              • Members
              • Properties
                • ColorScheme Property
                • EffectScheme Property
                • FontScheme Property
            • IThemeFont
              • Overview
              • Members
              • Properties
                • Name Property
            • IThemeFonts
              • Overview
              • Members
              • Properties
                • Count Property
                • Item Property
    • SpreadsheetGear2023.Drawing Assembly
      • Overview
      • Namespaces
        • SpreadsheetGear.Drawing Namespace
          • Overview
          • Classes
            • Image
              • Overview
              • Members
              • Image Constructor
                • Image Constructor(IRange)
                • Image Constructor(IShape)
                • Image Constructor(IChart)
              • Methods
                • Draw Method
                • GetBitmap Method
                  • GetBitmap() Method
                  • GetBitmap(PixelFormat) Method
                • GetImage Method
                • GetSize Method
                  • GetSize() Method
                  • GetSize(Graphics) Method
              • Properties
                • BackgroundBrush Property
                • Dpi Property
          • Structures
            • Color
              • Overview
              • Members
              • Methods
                • Equals Method
                  • Equals(Color) Method
                  • Equals(Object) Method
                • FromArgb Method
                  • FromArgb(Int32) Method
                  • FromArgb(Int32,Int32,Int32) Method
                  • FromArgb(Int32,Int32,Int32,Int32) Method
                • GetDrawingColor Method
                • GetHashCode Method
                • GetSpreadsheetGearColor Method
                • ToArgb Method
                • ToString Method
              • Properties
                • A Property
                • B Property
                • G Property
                • IsEmpty Property
                • IsKnownColor Property
                • IsSystemColor Property
                • R Property
              • Operators
                • Equality Operator
                • Implicit Type Conversion Operator
                • Inequality Operator
        • SpreadsheetGear.Drawing.Printing Namespace
          • Overview
          • Classes
            • WorkbookPrintDocument
              • Overview
              • Members
              • WorkbookPrintDocument Constructor
                • WorkbookPrintDocument Constructor(ICollection<IPrintable>)
                • WorkbookPrintDocument Constructor(ISheet,PrintWhat)
              • Methods
                • OnBeginPrint Method
                • OnEndPrint Method
                • OnPrintPage Method
                • OnQueryPageSettings Method
    • SpreadsheetGear2023.Windows.Forms Assembly
      • Overview
      • Namespaces
        • SpreadsheetGear.Windows.Forms Namespace
          • Overview
          • Classes
            • ActiveTabChangedEventArgs
              • Overview
              • Members
              • Properties
                • Sheet Property
                • TabIndex Property
            • ActiveTabChangingEventArgs
              • Overview
              • Members
              • Properties
                • Cancel Property
                • Sheet Property
                • TabIndex Property
            • CalculateEventArgs
              • Overview
              • Members
            • CellBeginEditEventArgs
              • Overview
              • Members
              • Properties
                • Cancel Property
                • Entry Property
                • Reason Property
            • CellCancelEditEventArgs
              • Overview
              • Members
              • Properties
                • ActiveCell Property
                • Cancel Property
                • Entry Property
                • RangeSelection Property
            • CellEndEditEventArgs
              • Overview
              • Members
              • Properties
                • ActiveCell Property
                • Cancel Property
                • Entry Property
                • RangeSelection Property
            • CommandPrint
              • Overview
              • Members
              • CommandPrint Constructor
                • CommandPrint Constructor(ISheet,PrintWhat,Boolean,Boolean)
                • CommandPrint Constructor(ICollection<IPrintable>,Boolean,Boolean)
              • Methods
                • CreatePrintDocument Method
                  • CreatePrintDocument(ISheet,PrintWhat) Method
                  • CreatePrintDocument(ICollection<IPrintable>) Method
                • Execute Method
            • FormulaBar
              • Overview
              • Members
              • FormulaBar Constructor
              • Methods
                • Dispose Method
                  • Dispose(Boolean) Method
                • OnLayout Method
                • OnPaint Method
                • OnPaintBackground Method
                • SetBoundsCore Method
              • Properties
                • DefaultSize Property
            • RangeChangedEventArgs
              • Overview
              • Members
              • Properties
                • Range Property
            • RangeSelectionChangedEventArgs
              • Overview
              • Members
              • Properties
                • RangeSelection Property
            • RangeSelectionChangingEventArgs
              • Overview
              • Members
              • Properties
                • Cancel Property
                • RangeSelection Property
            • ScrollPositionChangedEventArgs
              • Overview
              • Members
            • ShapeActionEventArgs
              • Overview
              • Members
              • Properties
                • Control Property
                • Shape Property
                • ShapeActionType Property
            • ShapeSelectionChangedEventArgs
              • Overview
              • Members
              • Properties
                • ShapeSelection Property
            • ShapeSelectionChangingEventArgs
              • Overview
              • Members
              • Properties
                • Cancel Property
                • ShapeSelection Property
            • ShowErrorEventArgs
              • Overview
              • Members
              • Properties
                • Caption Property
                • Handled Property
                • Message Property
            • UIManager
              • Overview
              • Members
              • UIManager Constructor
              • Methods
                • CreateCustomControl Method
            • WorkbookDesigner
              • Overview
              • Members
              • WorkbookDesigner Constructor
                • WorkbookDesigner Constructor()
                • WorkbookDesigner Constructor(String[])
                • WorkbookDesigner Constructor(IWorkbookSet)
              • Methods
                • Dispose Method
                  • Dispose(Boolean) Method
                • OnLayout Method
                • ProcessCmdKey Method
              • Properties
                • ActiveCell Property
                • ActiveSheet Property
                • ActiveWorkbook Property
                • ActiveWorkbookSet Property
                • ActiveWorksheet Property
                • RangeSelection Property
                • ShapeSelection Property
            • WorkbookView
              • Overview
              • Members
              • WorkbookView Constructor
                • WorkbookView Constructor(IWorkbook)
                • WorkbookView Constructor()
              • Methods
                • BeginEdit Method
                • BeginUpdate Method
                • CancelEdit Method
                • Copy Method
                • Cut Method
                • Dispose Method
                  • Dispose(Boolean) Method
                • EndEdit Method
                • EndUpdate Method
                • GetLock Method
                • Invalidate Method
                  • Invalidate() Method
                • IsInputChar Method
                • IsInputKey Method
                • LocationToRange Method
                  • LocationToRange(Double,Double,Double,Double) Method
                  • LocationToRange(Double,Double,Double,Double,RangeLocationFlags) Method
                  • LocationToRange(Point) Method
                • OnActiveTabChanged Method
                • OnActiveTabChanging Method
                • OnCalculate Method
                • OnCellBeginEdit Method
                • OnCellCancelEdit Method
                • OnCellEndEdit Method
                • OnGotFocus Method
                • OnHandleDestroyed Method
                • OnKeyDown Method
                • OnKeyPress Method
                • OnKeyUp Method
                • OnLayout Method
                • OnLostFocus Method
                • OnMouseClick Method
                • OnMouseDoubleClick Method
                • OnMouseDown Method
                • OnMouseEnter Method
                • OnMouseLeave Method
                • OnMouseMove Method
                • OnMouseUp Method
                • OnMouseWheel Method
                • OnPaint Method
                • OnPaintBackground Method
                • OnRangeChanged Method
                • OnRangeSelectionChanged Method
                • OnRangeSelectionChanging Method
                • OnScrollPositionChanged Method
                • OnShapeAction Method
                • OnShapeSelectionChanged Method
                • OnShapeSelectionChanging Method
                • OnShowError Method
                • OnSizeChanged Method
                • OnSystemColorsChanged Method
                • Paste Method
                • PasteSpecial Method
                • Print Method
                  • Print(Boolean) Method
                  • Print(PrintWhat,Boolean) Method
                • PrintPreview Method
                  • PrintPreview() Method
                  • PrintPreview(PrintWhat) Method
                • RangeToLocation Method
                  • RangeToLocation(Double,Double,Double,Double) Method
                  • RangeToLocation(Double,Double,Double,Double,RangeLocationFlags) Method
                • Refresh Method
                • ReleaseLock Method
                • RewindLock Method
                • UnwindLock Method
                • Update Method
                • WithLock Method
                  • WithLock(Action) Method
                  • WithLock<TResult>(Func<TResult>) Method
              • Properties
                • ActiveCell Property
                • ActiveChartSheet Property
                • ActiveCommandManager Property
                • ActiveSheet Property
                • ActiveTabIndex Property
                • ActiveWorkbook Property
                • ActiveWorkbookSet Property
                • ActiveWorkbookWindowInfo Property
                • ActiveWorksheet Property
                • ActiveWorksheetWindowInfo Property
                • AllowChartExplorer Property
                • AllowEditCommands Property
                • AllowRangeExplorer Property
                • AllowShapeExplorer Property
                • AllowWorkbookDesigner Property
                • AllowWorkbookExplorer Property
                • BackgroundCalculation Property
                • DefaultSize Property
                • DisplayReference Property
                • DisplayReferenceName Property
                • ExtraColor Property
                • Focused Property
                • FormulaBar Property
                • HollowSelection Property
                • IsEditing Property
                • RangeSelection Property
                • ShapeSelection Property
                • WorkbookSetState Property
              • Events
                • ActiveTabChanged Event
                • ActiveTabChanging Event
                • Calculate Event
                • CellBeginEdit Event
                • CellCancelEdit Event
                • CellEndEdit Event
                • RangeChanged Event
                • RangeSelectionChanged Event
                • RangeSelectionChanging Event
                • ScrollPositionChanged Event
                • ShapeAction Event
                • ShapeSelectionChanged Event
                • ShapeSelectionChanging Event
                • ShowError Event
            • WorkbookViewEventArgs
              • Overview
              • Members
          • Enumerations
            • CellBeginEditReason
            • ChartExplorerCategoryFlags
            • RangeExplorerCategoryFlags
            • ShapeActionType
            • ShapeExplorerCategoryFlags
          • Delegates
            • ActiveTabChangedEventHandler
            • ActiveTabChangingEventHandler
            • CalculateEventHandler
            • CellBeginEditEventHandler
            • CellCancelEditEventHandler
            • CellEndEditEventHandler
            • RangeChangedEventHandler
            • RangeSelectionChangedEventHandler
            • RangeSelectionChangingEventHandler
            • ScrollPositionChangedEventHandler
            • ShapeActionEventHandler
            • ShapeSelectionChangedEventHandler
            • ShapeSelectionChangingEventHandler
            • ShowErrorEventHandler
    • SpreadsheetGear2023.Windows.WPF Assembly
      • Overview
      • Namespaces
        • SpreadsheetGear.Windows.Controls Namespace
          • Overview
          • Classes
            • ActiveTabChangedEventArgs
              • Overview
              • Members
              • Properties
                • Sheet Property
                • TabIndex Property
            • ActiveTabChangingEventArgs
              • Overview
              • Members
              • Properties
                • Cancel Property
                • Sheet Property
                • TabIndex Property
            • CalculateEventArgs
              • Overview
              • Members
            • CellBeginEditEventArgs
              • Overview
              • Members
              • Properties
                • Cancel Property
                • Entry Property
                • Reason Property
            • CellCancelEditEventArgs
              • Overview
              • Members
              • Properties
                • ActiveCell Property
                • Cancel Property
                • Entry Property
                • RangeSelection Property
            • CellEndEditEventArgs
              • Overview
              • Members
              • Properties
                • ActiveCell Property
                • Cancel Property
                • Entry Property
                • RangeSelection Property
            • ColumnHeader
              • Overview
              • Members
              • ColumnHeader Constructor
              • Methods
                • OnApplyTemplate Method
                • OnMouseEnter Method
                • OnMouseLeave Method
              • Properties
                • ColumnIndex Property
                • IsSelected Property
                • WorkbookView Property
              • Fields
                • IsSelectedProperty Field
              • Events
                • PropertyChanged Event
            • CommandPrint
              • Overview
              • Members
              • CommandPrint Constructor
                • CommandPrint Constructor(ISheet,PrintWhat,Boolean,Boolean)
                • CommandPrint Constructor(ICollection<IPrintable>,Boolean,Boolean)
              • Methods
                • Execute Method
            • DropDownButton
              • Overview
              • Members
              • DropDownButton Constructor
              • Methods
                • OnApplyTemplate Method
                • OnMouseLeftButtonDown Method
            • FormulaBar
              • Overview
              • Members
              • FormulaBar Constructor
              • Methods
                • ArrangeOverride Method
                • Dispose Method
                • Finalize Method
                • MeasureOverride Method
                • OnApplyTemplate Method
                • OnGotKeyboardFocus Method
                • OnKeyDown Method
                • OnKeyUp Method
                • OnLostKeyboardFocus Method
                • OnMouseDown Method
            • HorizontalScrollbarsPresenter
              • Overview
              • Members
              • HorizontalScrollbarsPresenter Constructor
              • Methods
                • ArrangeOverride Method
                • MeasureOverride Method
            • RangeChangedEventArgs
              • Overview
              • Members
              • Properties
                • Range Property
            • RangeSelectionChangedEventArgs
              • Overview
              • Members
              • Properties
                • RangeSelection Property
            • RangeSelectionChangingEventArgs
              • Overview
              • Members
              • Properties
                • Cancel Property
                • RangeSelection Property
            • RowHeader
              • Overview
              • Members
              • RowHeader Constructor
              • Methods
                • OnApplyTemplate Method
                • OnMouseEnter Method
                • OnMouseLeave Method
              • Properties
                • IsSelected Property
                • RowIndex Property
                • WorkbookView Property
              • Fields
                • IsSelectedProperty Field
              • Events
                • PropertyChanged Event
            • ScrollPositionChangedEventArgs
              • Overview
              • Members
            • ShapeActionEventArgs
              • Overview
              • Members
              • Properties
                • Shape Property
                • ShapeActionType Property
                • UIElement Property
            • ShapeSelectionChangedEventArgs
              • Overview
              • Members
              • Properties
                • ShapeSelection Property
            • ShapeSelectionChangingEventArgs
              • Overview
              • Members
              • Properties
                • Cancel Property
                • ShapeSelection Property
            • SheetPresenter
              • Overview
              • Members
              • SheetPresenter Constructor
              • Methods
                • ArrangeOverride Method
            • SheetTab
              • Overview
              • Members
              • SheetTab Constructor
              • Methods
                • OnApplyTemplate Method
                • OnMouseEnter Method
                • OnMouseLeave Method
              • Properties
                • IsSelected Property
                • Overlap Property
              • Fields
                • IsSelectedProperty Field
                • OverlapProperty Field
            • SheetTabScrollButton
              • Overview
              • Members
              • SheetTabScrollButton Constructor
              • Methods
                • OnApplyTemplate Method
                • OnMouseEnter Method
                • OnMouseLeave Method
            • ShowErrorEventArgs
              • Overview
              • Members
              • Properties
                • Caption Property
                • Handled Property
                • Message Property
            • Spinner
              • Overview
              • Members
              • Spinner Constructor
              • Methods
                • OnApplyTemplate Method
            • UIManager
              • Overview
              • Members
              • UIManager Constructor
              • Methods
                • CreateCustomControl Method
            • VerticalScrollbarsPresenter
              • Overview
              • Members
              • VerticalScrollbarsPresenter Constructor
              • Methods
                • ArrangeOverride Method
                • MeasureOverride Method
            • WorkbookView
              • Overview
              • Members
              • WorkbookView Constructor
                • WorkbookView Constructor(IWorkbook)
                • WorkbookView Constructor()
              • Methods
                • ArrangeOverride Method
                • BeginEdit Method
                • BeginUpdate Method
                • CancelEdit Method
                • Copy Method
                • Cut Method
                • Dispose Method
                • EndEdit Method
                • EndUpdate Method
                • GetLock Method
                • LocationToRange Method
                  • LocationToRange(Double,Double,Double,Double) Method
                  • LocationToRange(Double,Double,Double,Double,RangeLocationFlags) Method
                • OnActiveTabChanged Method
                • OnActiveTabChanging Method
                • OnApplyTemplate Method
                • OnCalculate Method
                • OnCellBeginEdit Method
                • OnCellCancelEdit Method
                • OnCellEndEdit Method
                • OnContextMenuOpening Method
                • OnGotKeyboardFocus Method
                • OnKeyDown Method
                • OnKeyUp Method
                • OnLostKeyboardFocus Method
                • OnLostMouseCapture Method
                • OnMouseDown Method
                • OnMouseEnter Method
                • OnMouseLeave Method
                • OnMouseMove Method
                • OnMouseUp Method
                • OnMouseWheel Method
                • OnPropertyChanged Method
                • OnRangeChanged Method
                • OnRangeSelectionChanged Method
                • OnRangeSelectionChanging Method
                • OnScrollPositionChanged Method
                • OnShapeAction Method
                • OnShapeSelectionChanged Method
                • OnShapeSelectionChanging Method
                • OnShowError Method
                • OnTextInput Method
                • Paste Method
                • PasteSpecial Method
                • Print Method
                  • Print(Boolean) Method
                  • Print(PrintWhat,Boolean) Method
                • PrintPreview Method
                  • PrintPreview() Method
                  • PrintPreview(PrintWhat) Method
                • RangeToLocation Method
                  • RangeToLocation(Double,Double,Double,Double) Method
                  • RangeToLocation(Double,Double,Double,Double,RangeLocationFlags) Method
                • ReleaseLock Method
                • RewindLock Method
                • UnwindLock Method
                • WithLock Method
                  • WithLock(Action) Method
                  • WithLock<TResult>(Func<TResult>) Method
              • Properties
                • ActiveCell Property
                • ActiveChartSheet Property
                • ActiveCommandManager Property
                • ActiveSheet Property
                • ActiveTabIndex Property
                • ActiveWorkbook Property
                • ActiveWorkbookSet Property
                • ActiveWorkbookWindowInfo Property
                • ActiveWorksheet Property
                • ActiveWorksheetWindowInfo Property
                • AllowChartExplorer Property
                • AllowEditCommands Property
                • AllowRangeExplorer Property
                • AllowShapeExplorer Property
                • AllowWorkbookDesigner Property
                • AllowWorkbookExplorer Property
                • BackgroundCalculation Property
                • ColumnHeaderStyle Property
                • ContextMenu Property
                • DisplayReference Property
                • DisplayReferenceName Property
                • FormulaBar Property
                • GridlineBrush Property
                • HollowSelection Property
                • IsEditing Property
                • RangeSelection Property
                • RangeSelectionBorderBrush Property
                • RangeSelectionBrush Property
                • RowColumnResizerBrush Property
                • RowHeaderStyle Property
                • ShapeSelection Property
                • SheetExtraBrush Property
                • SheetTabScrollButtonStyle Property
                • SheetTabStyle Property
                • WindowBrush Property
                • WindowTextBrush Property
                • WorkbookSetState Property
              • Fields
                • ActiveWorkbookSetProperty Field
                • ColumnHeaderStyleProperty Field
                • GridlineBrushProperty Field
                • RangeSelectionBorderBrushProperty Field
                • RangeSelectionBrushProperty Field
                • RowColumnResizerBrushProperty Field
                • RowHeaderStyleProperty Field
                • SheetExtraBrushProperty Field
                • SheetTabScrollButtonStyleProperty Field
                • SheetTabStyleProperty Field
                • WindowBrushProperty Field
                • WindowTextBrushProperty Field
                • WorkbookSetStateProperty Field
              • Events
                • ActiveTabChanged Event
                • ActiveTabChanging Event
                • Calculate Event
                • CellBeginEdit Event
                • CellCancelEdit Event
                • CellEndEdit Event
                • RangeChanged Event
                • RangeSelectionChanged Event
                • RangeSelectionChanging Event
                • ScrollPositionChanged Event
                • ShapeAction Event
                • ShapeSelectionChanged Event
                • ShapeSelectionChanging Event
                • ShowError Event
            • WorkbookViewEventArgs
              • Overview
              • Members
          • Enumerations
            • CellBeginEditReason
            • ShapeActionType
          • Delegates
            • ActiveTabChangedEventHandler
            • ActiveTabChangingEventHandler
            • CalculateEventHandler
            • CellBeginEditEventHandler
            • CellCancelEditEventHandler
            • CellEndEditEventHandler
            • RangeChangedEventHandler
            • RangeSelectionChangedEventHandler
            • RangeSelectionChangingEventHandler
            • ScrollPositionChangedEventHandler
            • ShapeActionEventHandler
            • ShapeSelectionChangedEventHandler
            • ShapeSelectionChangingEventHandler
            • ShowErrorEventHandler
        • SpreadsheetGear.Windows.Media Namespace
          • Overview
          • Classes
            • Image
              • Overview
              • Members
              • Image Constructor
                • Image Constructor(IRange)
                • Image Constructor(IShape)
                • Image Constructor(IChart)
              • Methods
                • GetBitmap Method
                  • GetBitmap() Method
                  • GetBitmap(PixelFormat) Method
                • GetSize Method
              • Properties
                • BackgroundBrush Property
        • SpreadsheetGear.Windows.Printing Namespace
          • Overview
          • Classes
            • WorkbookPrintDocument
              • Overview
              • Members
              • WorkbookPrintDocument Constructor
                • WorkbookPrintDocument Constructor(ICollection<IPrintable>)
                • WorkbookPrintDocument Constructor(ISheet,PrintWhat)
                • WorkbookPrintDocument Constructor(ICollection<IPrintable>,PrintTicket)
                • WorkbookPrintDocument Constructor(ISheet,PrintWhat,PrintTicket)
                • WorkbookPrintDocument Constructor(ICollection<IPrintable>,Size)
                • WorkbookPrintDocument Constructor(ISheet,PrintWhat,Size)
              • Methods
                • GetPage Method
                • Print Method
              • Properties
                • IsPageCountValid Property
                • PageCount Property
                • PageSize Property
                • Source Property
              • Fields
                • PrintTicket Field
        • SpreadsheetGear.Windows.Xps Namespace
          • Overview
          • Classes
            • WorkbookXpsDocument
              • Overview
              • Members
              • WorkbookXpsDocument Constructor
              • Methods
                • CreateXpsDocument Method
                • SaveToFile Method
                • SaveToMemory Method
                • SaveToStream Method
                  • SaveToStream() Method
                  • SaveToStream(Stream) Method