Overview

• Getting Started
• License Agreement

Properties

• AllowBigSelection
• AllowDragDrop
• AllowSelection
• AllowUserReorder
• AllowUserResizing
• AllowUserSort
• AllowUserToAddRows
• AllowUserToDeleteRows
• ApplySelectionToImage
• AutoClipboard
• AutoGenerateColumns
• AutoRedraw
• BackColor
• BackColorAlternate
• BackColorBkg
• BackColorFrozen
• BackColorSel
• BorderStyle
• BottomRow
• ButtonLocked
• CacheIncrement
• CellImagePadding
• CellPadding
• ColCount
• CommentIndicatorColor
• CommentIndicatorSize
• CurrentColIndex
• CurrentRowIndex
• DataMember
• DataSource
• DateFormat
• DateSeparator
• DecimalSeparator
• DefaultColWidth
• DefaultRowHeight
• DragDropMode
• Editable
• EditSelectedText
• EditSelectionLength
• EditSelectionStart
• EditText
• EditValue
• Ellipsis
• EnterKeyBehavior
• ExtendLastCol
• FixedCols
• FixedRows
• FocusRect
• Font
• ForeColor
• ForeColorFixed
• ForeColorFrozen
• ForeColorSel
• FrozenCols
• FrozenRows
• GetLastErrorMessage
• GetLastErrorNumber
• GridColor
• GridLines
• HighLight
• HighlightHeaders
• HScrollBarIsVisible
• ImageList
• IsCurrentCellInEditMode
• IsSelected
• LanguageConfig
• LeftCol
• MouseCol
• MouseRow
• OwnerDraw
• PicturesOver
• RightCol
• RowCount
• ScrollBars
• ScrollBarStyle
• ScrollBarWidth
• SelectedRow
• SelectedRows
• SelectionMode
• SheetBorder
• SheetBorderColor
• ShowCellErrors
• ShowCellToolTips
• ShowComboButton
• ShowCommentIndicator
• ShowContextMenu
• ShowHeaderAutoText
• ShowResizeTips
• ShowRowErrors
• ShowRowHeaderImage
• ShowSortIndicator
• TabKeyBehavior
• ThemeColor
• ThemeCustomColorFrom
• ThemeCustomColorTo
• ThemeStyle
• TopRow
• UseBackColorAlternate
• VirtualMode
• VScrollBarIsVisible
• WrapText

Methods

• AboutBox
• AddCol
• AddItem
• BeginEdit
• CancelEdit
• DeleteCols
• DeleteRows
• EndEdit
• ExportToCSV
• ExportToExcel
• InsertCols
• InsertRows
• MergeCells
• NewFile
• OpenFile
• PrintOut
• PrintPreview
• Refresh
• RemoveCol
• RemoveItem
• SaveFile
• ShowPageSetupDialog
• ShowPrintDialog
• Sort
• UnMergeCells

Events

• AfterDeleteRow
• AfterDrop
• AfterEdit
• AfterMoveColumn
• AfterMoveRow
• AfterPaste
• AfterRowColChange
• AfterSelectionChange
• AfterSort
• AfterUserResize
• BeforeDeleteRow
• BeforeDrag
• BeforeDrop
• BeforeEdit
• BeforeHyperlinkClick
• BeforeMoveColumn
• BeforeMoveRow
• BeforePaste
• BeforeRowColChange
• BeforeSelectionChange
• BeforeSort
• BeforeUserResize
• CellButtonClick
• CellClick
• CellCommentTextNeeded
• CellDoubleClick
• CellEnter
• CellErrorTextNeeded
• CellLeave
• CellMouseClick
• CellMouseDoubleClick
• CellMouseDown
• CellMouseEnter
• CellMouseLeave
• CellMouseMove
• CellMouseUp
• CellPainting
• CellToolTipTextNeeded
• CellValidating
• CellValueChanged
• CellValueChanging
• CellValueNeeded
• CellValuePushed
• ComboDropDown
• ComboDropDownClosed
• ComboSelectedIndexChanged
• DataError
• DefaultValuesNeeded
• ErrorInfo
• EscapeEditing
• HyperlinkClick
• KeyDownEdit
• KeyPressEdit
• KeyUpEdit
• NewRowNeeded
• RowEnter
• RowErrorTextNeeded
• RowLeave
• Scroll

Object Model

Cell

Properties

• Alignment
• BackColor
• Borders
• CellType
• ColumnIndex
• CommentText
• DecimalLength
• EditMask
• ErrorText
• Font
• FontBold
• FontItalic
• FontName
• FontSize
• FontStrikethrough
• FontUnderline
• ForeColor
• FormatString
• Height
• ImageIndex
• IsMergeCell
• Left
• Locked
• MaxLength
• PictureAlignment
• RowIndex
• Tag
• Text
• ToolTipText
• Top
• Width
• WrapText

Methods

• EnsureVisible
• Refresh
• SetFocus

Column

Properties

• Alignment
• BackColor
• Borders
• ButtonLocked
• CellType
• DataPropertyName
• DateStyle
• DecimalLength
• EditMask
• FixedAlignment
• Font
• FontBold
• FontItalic
• FontName
• FontSize
• FontStrikethrough
• FontUnderline
• ForeColor
• FormatString
• Hidden
• ImageIndex
• IsVisible
• Locked
• MaxLength
• Name
• PictureAlignment
• Position
• SortType
• Width
• WrapText

Methods

• AutoFit

ComboBox

Properties

• AutoComplete
• DataSource
• DisplayMember
• DropDownStyle
• DropDownWidth
• DroppedDown
• ImageList
• List
• ListCount
• ListIndex
• MaxDropDownItems
• Sorted
• ValueMember

Methods

• AddItem
• AddItemWithImage
• Clear
• FindItem
• RemoveItem

PageSetup

Properties

• BlackAndWhite
• BottomMargin
• CenterFooter
• CenterFooterFont
• CenterFooterImage
• CenterHeader
• CenterHeaderFont
• CenterHeaderImage
• CenterHorizontally
• CenterVertically
• DocumentName
• FirstPageNumber
• FooterMargin
• HeaderMargin
• Landscape
• LeftFooter
• LeftFooterFont
• LeftFooterImage
• LeftHeader
• LeftHeaderFont
• LeftHeaderImage
• LeftMargin
• PaperSize
• PrintColumnsFrom
• PrintColumnsTo
• PrinterName
• PrintColumnHeader
• PrintRowHeader
• PrintGridlines
• PrintRowsFrom
• PrintRowsTo
• PrintTitleColumns
• PrintTitleRows
• RightFooter
• RightFooterFont
• RightFooterImage
• RightHeader
• RightHeaderFont
• RightHeaderImage
• RightMargin
• TopMargin
• TotalPages
• Zoom

Range

Properties

• Alignment
• BackColor
• Borders
• Font
• FontBold
• FontItalic
• FontName
• FontSize
• FontStrikethrough
• FontUnderline
• ForeColor
• FormatString
• IsMerged
• Locked
• PictureAlignment
• WrapText

Methods

• Clear
• ClearContents
• ClearFormats
• Copy
• Cut
• Merge
• Paste
• Select
• UnMerge

Row

Properties

• Alignment
• BackColor
• Borders
• ErrorText
• Font
• FontBold
• FontItalic
• FontName
• FontSize
• FontStrikethrough
• FontUnderline
• ForeColor
• Height
• Hidden
• IsVisible
• Locked
• PictureAlignment
• Position
• Tag
• WrapText

Methods

• AutoFit

Selection

Properties

• Alignment
• BackColor
• Borders
• FirstCol
• FirstRow
• Font
• FontBold
• FontItalic
• FontName
• FontSize
• FontStrikethrough
• FontUnderline
• ForeColor
• FormatString
• IsMerged
• LastCol
• LastRow
• Locked
• PictureAlignment
• WrapText

Methods

• Clear
• ClearContents
• ClearFormats
• Copy
• Cut
• DeleteCols
• DeleteRows
• InsertCols
• InsertRows
• Merge
• Paste
• UnMerge

Reference

• Error Messages