• 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
        • Limitations
        • Breaking Changes
      • SpreadsheetGear 2017
        • New Features
        • Issues Resolved
        • Limitations
        • Breaking Changes
      • 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
                  • 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
                  • 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
                  • 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
                  • 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