Class SfCellGrid
Represents the SfCellGrid control in which data will be displayed in the form of rows and columns.
Implements
Inherited Members
Namespace: Syncfusion.Windows.Forms.CellGrid
Assembly: Syncfusion.Spreadsheet.Windows.dll
Syntax
public class SfCellGrid : ScrollControl, IThemeProvider, IVisualStyle, ICancelModeProvider, ISplitterPaneSupport, IScrollBarWrapperContainer, ISupportUpdating, ISupportIntelliMouse, IQueryFocusInside, INonClientPaintingSupport, ICalcData, INotifyPropertyChanged, IDisposable
Remarks
This class offers events associated with selection, editing and resizing operations in grid.
Constructors
SfCellGrid()
Initializes a new instance of the SfCellGrid class.
Declaration
public SfCellGrid()
Fields
currentCell
Declaration
protected GridCurrentCell currentCell
Field Value
Type |
---|
GridCurrentCell |
Properties
AllowColumnResize
Gets or sets the value indicating whether to allow column resizing or not.
Declaration
public bool AllowColumnResize { get; set; }
Property Value
Type | Description |
---|---|
System.Boolean | True or False. |
AllowEditing
Gets or sets the value indicating whether to allow the editing operation or not.
Declaration
public bool AllowEditing { get; set; }
Property Value
Type | Description |
---|---|
System.Boolean | True or False. |
AllowEditorsContextMenu
Gets or sets the value whether the Editors Context menu is to be Enabled or not.
Declaration
public bool AllowEditorsContextMenu { get; set; }
Property Value
Type | Description |
---|---|
System.Boolean | True or False. |
AllowExcelLikeKeyNavigation
Get or sets the value which indicates whether to allow editing like Excel. Which means, move the SelectionStart where pressed mouse pointer, move it to end when press Down Arrow key and move it where last placed when press Up Arrow key.
Declaration
public bool AllowExcelLikeKeyNavigation { get; set; }
Property Value
Type | Description |
---|---|
System.Boolean | True or False. |
AllowFloatingCell
Gets or sets the value which indicates whether to float the cells or not while displaying the data.
Declaration
public bool AllowFloatingCell { get; set; }
Property Value
Type | Description |
---|---|
System.Boolean | True or False. |
AllowFloatingCellInEdit
/// Gets or sets the value which indicates whether to allow the flood the cells in Edit mode or not.
Declaration
public bool AllowFloatingCellInEdit { get; set; }
Property Value
Type | Description |
---|---|
System.Boolean | True or False. |
AllowGesture
Gets or sets whether the gesture is enabled or not.
Declaration
public bool AllowGesture { get; set; }
Property Value
Type | Description |
---|---|
System.Boolean | Default value is true. If it is false, then it will disable the touch selection, panning, etc. |
AllowHiddenColumnResize
Gets or sets the value indicating whetherto allow hidden column resizing or not.
Declaration
public bool AllowHiddenColumnResize { get; set; }
Property Value
Type | Description |
---|---|
System.Boolean | True or False. |
AllowHiddenRowResize
Gets or sets the value indicating whether to allow hidden row resizing or not.
Declaration
public bool AllowHiddenRowResize { get; set; }
Property Value
Type | Description |
---|---|
System.Boolean | True or False. |
AllowRowResize
Gets or sets the value indicating whether to allow row resizing or not.
Declaration
public bool AllowRowResize { get; set; }
Property Value
Type | Description |
---|---|
System.Boolean | True or False. |
AllowSelection
Gets or sets the value indicating whether to allow the selection or not.
Declaration
public bool AllowSelection { get; set; }
Property Value
Type | Description |
---|---|
System.Boolean | True or False. |
AutoScroller
Gets the auto scroller which provides automatic scrolling of content when the user drags the pressed mouse to an edge of the control.
Declaration
public GridAutoScroller AutoScroller { get; }
Property Value
Type | Description |
---|---|
GridAutoScroller | An instance of GridAutoScroller. |
CellContextMenu
Gets or sets the ContextMenu Items for Grid.
Declaration
public ContextMenuStrip CellContextMenu { get; }
Property Value
Type | Description |
---|---|
System.Windows.Forms.ContextMenuStrip | ContextMenu item of Grid. |
ColumnCount
Gets or sets the number of columncount in grid.
Declaration
public int ColumnCount { get; set; }
Property Value
Type | Description |
---|---|
System.Int32 | Number of columns. |
ColumnResizingController
Gets or sets the value for resizing column controller.
Declaration
public ColumnResizingController ColumnResizingController { get; set; }
Property Value
Type | Description |
---|---|
ColumnResizingController | An instance of ColumnResizingController. |
ColumnWidths
Gets the collection of columnwidths for grid.
Declaration
public LineSizeCollection ColumnWidths { get; }
Property Value
Type | Description |
---|---|
LineSizeCollection | Collection of columnwidths. |
CopyPaste
Gets the instance of GridCopyPaste class which used to perform clipboard operations(Cut, Copy, Paste).
Declaration
public GridCopyPaste CopyPaste { get; }
Property Value
Type | Description |
---|---|
GridCopyPaste | An instance of GridCopyPaste. |
CoveredCells
Gets the coveredcells in the grid.
Declaration
public CoveredCellInfoCollection CoveredCells { get; }
Property Value
Type | Description |
---|---|
CoveredCellInfoCollection | Collection of CoveredCells. |
CreateGridColumn
Gets or sets System.Func<T, TResult> to create instance of GridColumn.
Declaration
public Func<SfCellGrid, GridColumn> CreateGridColumn { get; set; }
Property Value
Type |
---|
System.Func<SfCellGrid, GridColumn> |
CurrentCell
Gets the current cell of the Grid.
Declaration
public GridCurrentCell CurrentCell { get; }
Property Value
Type | Description |
---|---|
GridCurrentCell | An instance of GridCurrentCell. |
DefaultColumnWidth
Gets or sets the default columnwidth for grid.
Declaration
public double DefaultColumnWidth { get; set; }
Property Value
Type | Description |
---|---|
System.Double | Width of the column. |
DefaultRowHeight
Gets or sets the default rowheight for grid.
Declaration
public double DefaultRowHeight { get; set; }
Property Value
Type | Description |
---|---|
System.Double | Height of the row. |
EditorSelectionBehavior
Gets or sets a value indicating whether editor select all the value or move last position.
Declaration
public EditorSelectionBehavior EditorSelectionBehavior { get; set; }
Property Value
Type | Description |
---|---|
EditorSelectionBehavior | One of the enum options of EditBehavior. |
EditTrigger
Gets or Sets a value indicating any of the trigger options will cause cells to enter Edit Mode.
Declaration
public EditTrigger EditTrigger { get; set; }
Property Value
Type | Description |
---|---|
EditTrigger | One of the enum options of EditTrigger. |
FooterColumns
Gets or sets the number of footer columns in grid.
Declaration
public int FooterColumns { get; set; }
Property Value
Type | Description |
---|---|
System.Int32 | Number of footercolumns. |
FooterRows
Gets or sets the number of footer rows in grid.
Declaration
public int FooterRows { get; set; }
Property Value
Type | Description |
---|---|
System.Int32 | Number of footerrows. |
FormulaEngine
Gets the value indicating the instance of FormulaEngine which is used to perform calculations in grid.
Declaration
public FormulaEngine FormulaEngine { get; }
Property Value
Type | Description |
---|---|
FormulaEngine | An instance of FormulaEngine. |
FrozenColumns
Gets or sets the number of frozencolumns in grid.
Declaration
public int FrozenColumns { get; set; }
Property Value
Type | Description |
---|---|
System.Int32 | Number of frozencolumns. |
FrozenRows
Gets or sets the number of frozenrows in grid.
Declaration
public int FrozenRows { get; set; }
Property Value
Type | Description |
---|---|
System.Int32 | Number of frozenrows. |
GridLineColor
Gets or sets the gridline color.
Declaration
public Brush GridLineColor { get; set; }
Property Value
Type | Description |
---|---|
System.Drawing.Brush | Color for the Gridline. |
HeaderColumns
Gets or sets the number of header columns in grid.
Declaration
public int HeaderColumns { get; set; }
Property Value
Type | Description |
---|---|
System.Int32 | Number of header columns. |
HeaderRows
Gets or sets the number of header rows in grid.
Declaration
public int HeaderRows { get; set; }
Property Value
Type | Description |
---|---|
System.Int32 | Number of header rows. |
RowCount
Gets or sets the number of rowcounts in grid.
Declaration
public int RowCount { get; set; }
Property Value
Type | Description |
---|---|
System.Int32 | Number of rows. |
RowHeights
Gets the collection of rowheights for grid.
Declaration
public LineSizeCollection RowHeights { get; }
Property Value
Type | Description |
---|---|
LineSizeCollection | Collection of rowheights. |
RowResizingController
Gets or sets the value for resizing row controller.
Declaration
public RowResizingController RowResizingController { get; set; }
Property Value
Type | Description |
---|---|
RowResizingController | An instance of RowResizingController. |
ScrollColumns
Gets the ScrollAxisBase for columns.
Declaration
public ScrollAxisBase ScrollColumns { get; }
Property Value
Type | Description |
---|---|
ScrollAxisBase | An instance of ScrollAxisBase. |
ScrollRows
Gets the ScrollAxisBase for rows.
Declaration
public ScrollAxisBase ScrollRows { get; }
Property Value
Type | Description |
---|---|
ScrollAxisBase | An instance of ScrollAxisBase. |
SelectedRanges
Gets or sets the collection of selected ranges from grid.
Declaration
public GridRangeInfoList SelectedRanges { get; set; }
Property Value
Type | Description |
---|---|
GridRangeInfoList | A collection of selected ranges. |
SelectionBorderBrush
Gets or sets the selection border brush.
Declaration
public Brush SelectionBorderBrush { get; set; }
Property Value
Type | Description |
---|---|
System.Drawing.Brush | Brush for border. |
SelectionBorderThickness
Gets or sets the thickness of selection border.
Declaration
public double SelectionBorderThickness { get; set; }
Property Value
Type | Description |
---|---|
System.Double | Thickness of the border. |
SelectionBrush
Gets or sets the selected area brush.
Declaration
public Brush SelectionBrush { get; set; }
Property Value
Type | Description |
---|---|
System.Drawing.Brush | Brush for selection. |
SelectionController
Gets or sets the Selection Controller which provides the selection of content when the user drags the pressed mouse to an edge of the control.
Declaration
public SelectionController SelectionController { get; set; }
Property Value
Type | Description |
---|---|
SelectionController | An instance of SelectionController. |
ShowComment
Gets or Sets the value which indicates whether to show the cell comment or not.
Declaration
public bool ShowComment { get; set; }
Property Value
Type | Description |
---|---|
System.Boolean | True or False. |
ShowGridLines
Gets or sets value indicating whether gridlines shown or not.
Declaration
public bool ShowGridLines { get; set; }
Property Value
Type | Description |
---|---|
System.Boolean | True or False. |
ShowTooltip
Gets or sets the value which indicates whether to show the cell tooltip or not.
Declaration
public bool ShowTooltip { get; set; }
Property Value
Type | Description |
---|---|
System.Boolean | True or False. |
Methods
Dispose(Boolean)
Dispose the live resources used by the SfCellGrid class.
Declaration
protected override void Dispose(bool disposing)
Parameters
Type | Name | Description |
---|---|---|
System.Boolean | disposing | Dispose the instance, if it is True |
Overrides
GetCellValue(Int32, Int32)
Used to get the value of the cell.
Declaration
public virtual object GetCellValue(int rowIndex, int colIndex)
Parameters
Type | Name | Description |
---|---|---|
System.Int32 | rowIndex | RowIndex of the cell |
System.Int32 | colIndex | ColumnIndex of the cell |
Returns
Type | Description |
---|---|
System.Object | Returns the cell value |
GetDependentCellValue(Int32, Int32)
Gets the dependent cell value of the specified cell.
Declaration
public virtual string GetDependentCellValue(int rowIndex, int colIndex)
Parameters
Type | Name | Description |
---|---|---|
System.Int32 | rowIndex | Row index of the cell |
System.Int32 | colIndex | Column index of the cell |
Returns
Type | Description |
---|---|
System.String | retuns the value of the specified cell |
GetDisplayText(Int32, Int32)
Used to get the display text of the cell.
Declaration
public virtual string GetDisplayText(int rowIndex, int colIndex)
Parameters
Type | Name | Description |
---|---|---|
System.Int32 | rowIndex | RowIndex of the cell |
System.Int32 | colIndex | ColumnIndex of the cell |
Returns
Type | Description |
---|---|
System.String | Returns the display text |
GetValueRowCol(Int32, Int32)
Returns the formula string if the cell contains a formula, or the value if the cell cantains anything other than a formula.
Declaration
public object GetValueRowCol(int row, int col)
Parameters
Type | Name | Description |
---|---|---|
System.Int32 | row | The row of the cell. |
System.Int32 | col | The column of the cell. |
Returns
Type | Description |
---|---|
System.Object | The formula string or value. |
InitializeCellRendererCollection()
Initializes the GridCellRendererCollection.
Declaration
protected virtual void InitializeCellRendererCollection()
InvalidateCell(GridRangeInfo, Boolean)
Invalidates the mentioned range in the grid.
Declaration
public void InvalidateCell(GridRangeInfo range, bool clearStyles = true)
Parameters
Type | Name | Description |
---|---|---|
GridRangeInfo | range | Specified range. |
System.Boolean | clearStyles | Set this false to avoid resetting the GridStyleInfo of cells in mentioned range |
InvalidateCell(Int32, Int32)
Invaildates the mentioned cell in the gird.
Declaration
public void InvalidateCell(int rowIndex, int colIndex)
Parameters
Type | Name | Description |
---|---|---|
System.Int32 | rowIndex | Index of the row. |
System.Int32 | colIndex | Index of the column |
InvalidateCellBorders(GridRangeInfo)
Invalidates the cell borders in the mentioned range.
Declaration
public void InvalidateCellBorders(GridRangeInfo range)
Parameters
Type | Name | Description |
---|---|---|
GridRangeInfo | range | An instance ofGridRangeInfo. |
InvalidateCells(Boolean)
Invalidate all Cells in a grid.
Declaration
public void InvalidateCells(bool clearStyles = true)
Parameters
Type | Name | Description |
---|---|---|
System.Boolean | clearStyles | Set this false to avoid resetting the GridStyleInfo |
InvalidateSelection()
Invalidates the selection layout alone.
Declaration
public void InvalidateSelection()
InvalidateSelection(GridRangeInfo)
Invalidates the specified range of selection layout.
Declaration
public void InvalidateSelection(GridRangeInfo range)
Parameters
Type | Name | Description |
---|---|---|
GridRangeInfo | range |
InvalidateVisual()
Invalidates measurement state(layout) of grid
Declaration
public void InvalidateVisual()
InvalidateVisual(Boolean)
Invalidates measurement state(layout) of grid
Declaration
public void InvalidateVisual(bool setLayoutDirty)
Parameters
Type | Name | Description |
---|---|---|
System.Boolean | setLayoutDirty | If true, invalidates layout of each row |
InvalidateVisual(Boolean, GridRangeInfo)
Invalidates measurement state(layout) of grid.
Declaration
public void InvalidateVisual(bool setLayoutDirty, GridRangeInfo range)
Parameters
Type | Name | Description |
---|---|---|
System.Boolean | setLayoutDirty | If true, invalidates layout of rows in a mentioned range |
GridRangeInfo | range | Specified range. |
OnCellRequestNavigateEvent(CellRequestNavigateEventArgs)
Helper method to raise Hyperlink Requset Navigate event.
Declaration
protected virtual bool OnCellRequestNavigateEvent(CellRequestNavigateEventArgs e)
Parameters
Type | Name | Description |
---|---|---|
CellRequestNavigateEventArgs | e | An CellRequestNavigateEventArgs that contains the event data. |
Returns
Type | Description |
---|---|
System.Boolean | True or False. |
OnContainerKeyDown(KeyEventArgs)
Occurs when key down on Syncfusion.Windows.Forms.CellGrid.SfCellGrid.VisualContainer.
Declaration
protected virtual bool OnContainerKeyDown(KeyEventArgs e)
Parameters
Type | Name | Description |
---|---|---|
System.Windows.Forms.KeyEventArgs | e | An System.Windows.Input.KeyEventArgs that contains the event data. |
Returns
Type | Description |
---|---|
System.Boolean | True or False. |
OnCreateCopyPaste()
Creates a new instance of GridCopyPaste.
Declaration
protected virtual GridCopyPaste OnCreateCopyPaste()
Returns
Type | Description |
---|---|
GridCopyPaste | An instance of GridCopyPaste. |
OnCreateCurrentCell()
Creates a new instance of GridCurrentCell.
Declaration
protected virtual GridCurrentCell OnCreateCurrentCell()
Returns
Type | Description |
---|---|
GridCurrentCell | An instance of GridCurrentCell. |
OnCreateGridColumn(SfCellGrid)
Creates new instance for GridColumn.
Declaration
protected virtual GridColumn OnCreateGridColumn(SfCellGrid grid)
Parameters
Type | Name | Description |
---|---|---|
SfCellGrid | grid |
Returns
Type | Description |
---|---|
GridColumn | An instance of GridColumn. |
OnCreateVisualContainer()
Initialize new instance for Visual Container
Declaration
protected virtual VisualContainer OnCreateVisualContainer()
Returns
Type |
---|
VisualContainer |
OnCurrentCellEndEdit(CurrentCellEndEditEventArgs)
Helper method to raise Current Cell Begin Edit Event.
Declaration
protected virtual void OnCurrentCellEndEdit(CurrentCellEndEditEventArgs e)
Parameters
Type | Name | Description |
---|---|---|
CurrentCellEndEditEventArgs | e | An System.Windows.Input.KeyEventArgs that contains the event data. |
OnHorizontalScroll(Object, ScrollEventArgs)
Declaration
protected virtual void OnHorizontalScroll(object sender, ScrollEventArgs se)
Parameters
Type | Name | Description |
---|---|---|
System.Object | sender | |
System.Windows.Forms.ScrollEventArgs | se |
OnHScroll(Object, ScrollEventArgs)
Declaration
protected override void OnHScroll(object sender, ScrollEventArgs se)
Parameters
Type | Name | Description |
---|---|---|
System.Object | sender | |
System.Windows.Forms.ScrollEventArgs | se |
Overrides
OnKeyDown(KeyEventArgs)
Declaration
protected override void OnKeyDown(KeyEventArgs e)
Parameters
Type | Name | Description |
---|---|---|
System.Windows.Forms.KeyEventArgs | e |
OnLayout(LayoutEventArgs)
Declaration
protected override void OnLayout(LayoutEventArgs levent)
Parameters
Type | Name | Description |
---|---|---|
System.Windows.Forms.LayoutEventArgs | levent |
OnMouseUp(MouseEventArgs)
Trigger the method when mouse up in visualcontainer.
Declaration
protected virtual void OnMouseUp(MouseEventArgs e)
Parameters
Type | Name | Description |
---|---|---|
System.Windows.Forms.MouseEventArgs | e |
OnPreviewKeyDown(PreviewKeyDownEventArgs)
Declaration
protected override void OnPreviewKeyDown(PreviewKeyDownEventArgs e)
Parameters
Type | Name | Description |
---|---|---|
System.Windows.Forms.PreviewKeyDownEventArgs | e |
OnSizeChanged(EventArgs)
Declaration
protected override void OnSizeChanged(EventArgs e)
Parameters
Type | Name | Description |
---|---|---|
System.EventArgs | e |
Overrides
OnValueChanged(Int32, Int32, String)
Raises the ValueChanged event.
Declaration
public void OnValueChanged(int row, int col, string value)
Parameters
Type | Name | Description |
---|---|---|
System.Int32 | row | The row of the change. |
System.Int32 | col | The column of the change. |
System.String | value | The changed value. |
OnVerticalScroll(Object, ScrollEventArgs)
Declaration
protected virtual void OnVerticalScroll(object sender, ScrollEventArgs se)
Parameters
Type | Name | Description |
---|---|---|
System.Object | sender | |
System.Windows.Forms.ScrollEventArgs | se |
OnVScroll(Object, ScrollEventArgs)
Declaration
protected override void OnVScroll(object sender, ScrollEventArgs se)
Parameters
Type | Name | Description |
---|---|---|
System.Object | sender | |
System.Windows.Forms.ScrollEventArgs | se |
Overrides
PointToCellRowColumnIndex(Point)
Gets the RowColumnIndex of the cell under the mentioned location
Declaration
public RowColumnIndex PointToCellRowColumnIndex(Point p)
Parameters
Type | Name | Description |
---|---|---|
System.Drawing.Point | p | X and Y-Coordinates. |
Returns
Type | Description |
---|---|
RowColumnIndex | An instance of RowColumnIndex. |
PointToCellRowColumnIndexOutsideCells(Point, Boolean)
Gets the RowColumnIndex of the cell under the mentioned location.
Declaration
public RowColumnIndex PointToCellRowColumnIndexOutsideCells(Point p, bool allowOutsideLines)
Parameters
Type | Name | Description |
---|---|---|
System.Drawing.Point | p | X and Y-Coordinates. |
System.Boolean | allowOutsideLines | Set this true if point can be below corner of last line. |
Returns
Type | Description |
---|---|
RowColumnIndex | An instance of RowColumnIndex. |
RecalculateCell(Int32, Int32, Boolean)
Recalculating dependency cells of the precedent cell. When ever the precedent cell is changed, thats dependecncy should be updated. When setting tag as null, that will be recalculate when invalidate the cell.
Declaration
public void RecalculateCell(int row, int col, bool invaladateCell)
Parameters
Type | Name | Description |
---|---|---|
System.Int32 | row | Current Cell's row index. |
System.Int32 | col | Current Cell's column index. |
System.Boolean | invaladateCell | True or False. |
ScrollInView(RowColumnIndex)
Scrolls the mentioned cell into view.
Declaration
public void ScrollInView(RowColumnIndex rowColumnIndex)
Parameters
Type | Name | Description |
---|---|---|
RowColumnIndex | rowColumnIndex | Coordinates of a cell. |
SetColumnWidth(Int32, Int32, Double)
Set the column width
Declaration
public virtual void SetColumnWidth(int startIndex, int endIndex, double width)
Parameters
Type | Name | Description |
---|---|---|
System.Int32 | startIndex | Starting column index |
System.Int32 | endIndex | End column index |
System.Double | width | Width |
SetRowHeight(Int32, Int32, Double)
Set the row height
Declaration
public virtual void SetRowHeight(int startIndex, int endIndex, double height)
Parameters
Type | Name | Description |
---|---|---|
System.Int32 | startIndex | Starting row index |
System.Int32 | endIndex | End row index |
System.Double | height | Height |
SetValueRowCol(Object, Int32, Int32)
Sets the value of a cell.
Declaration
public void SetValueRowCol(object value, int row, int col)
Parameters
Type | Name | Description |
---|---|---|
System.Object | value | The value to be set. |
System.Int32 | row | The row of the cell. |
System.Int32 | col | The column of the cell. |
ShowHidePopup(Boolean)
Used to show/hide the popups shown in the grid
Declaration
public virtual void ShowHidePopup(bool show)
Parameters
Type | Name | Description |
---|---|---|
System.Boolean | show |
UnWireEvents()
Unwire the events
Declaration
protected virtual void UnWireEvents()
UpdateScrollBars()
Update the Scrollbar when perform row or column manipulation(Insert, delete, hide, adjust size, etc.).
Declaration
public override void UpdateScrollBars()
Overrides
WireEvents()
Wire the events
Declaration
protected virtual void WireEvents()
WireParentObject()
Not implemented.
Declaration
public void WireParentObject()
Events
CellClick
Occurs when click on the cell.
Declaration
public event GridCellClickEventHandler CellClick
Event Type
Type |
---|
GridCellClickEventHandler |
CellCommentOpening
Occurs when perform cell comment opening.
Declaration
public event CellCommentOpeningEventHandler CellCommentOpening
Event Type
Type |
---|
CellCommentOpeningEventHandler |
CellContextMenuOpening
Occurs When Context Menu is to be displayed
Declaration
public event CellContextMenuOpeningEventHandler CellContextMenuOpening
Event Type
Type |
---|
CellContextMenuOpeningEventHandler |
CellRequestNavigate
Occurs when the current cell request to navigate the URI.
Declaration
public event CellRequestNavigateEventHandler CellRequestNavigate
Event Type
Type |
---|
CellRequestNavigateEventHandler |
CellTooltipOpening
Occurs when perform cell tooltip opening.
Declaration
public event CellTooltipOpeningEventHandler CellTooltipOpening
Event Type
Type |
---|
CellTooltipOpeningEventHandler |
CurrentCellActivated
Occurs after the current cell is activated
Declaration
public event CurrentCellActivatedEventHandler CurrentCellActivated
Event Type
Type |
---|
CurrentCellActivatedEventHandler |
CurrentCellActivating
Occurs when the current cell going to be activated
Declaration
public event CurrentCellActivatingEventHandler CurrentCellActivating
Event Type
Type |
---|
CurrentCellActivatingEventHandler |
CurrentCellBeginEdit
Occurs when the current cell enters into edit mode
Declaration
public event CurrentCellBeginEditEventHandler CurrentCellBeginEdit
Event Type
Type |
---|
CurrentCellBeginEditEventHandler |
CurrentCellEndEdit
Occurs when the current cell leaves from edit mode
Declaration
public event CurrentCellEndEditEventHandler CurrentCellEndEdit
Event Type
Type |
---|
CurrentCellEndEditEventHandler |
CurrentCellValidated
Occurs after the current cell is validated
Declaration
public event CurrentCellValidatedEventHandler CurrentCellValidated
Event Type
Type |
---|
CurrentCellValidatedEventHandler |
CurrentCellValidating
Occurs when current cell value going to be validated
Declaration
public event CurrentCellValidatingEventHandler CurrentCellValidating
Event Type
Type |
---|
CurrentCellValidatingEventHandler |
CurrentCellValueChanged
Occurs when the current cell value gets changed while cell is in edit mode
Declaration
public event CurrentCellValueChangedEventhandler CurrentCellValueChanged
Event Type
Type |
---|
CurrentCellValueChangedEventhandler |
PropertyChanged
Occurs when property changed
Declaration
public event PropertyChangedEventHandler PropertyChanged
Event Type
Type |
---|
System.ComponentModel.PropertyChangedEventHandler |
ResizingColumns
Occurs when perform resizing columns.
Declaration
public event ResizingColumnsEventHandler ResizingColumns
Event Type
Type |
---|
ResizingColumnsEventHandler |
ResizingRows
Occurs when perform resizing rows.
Declaration
public event ResizingRowsEventHandler ResizingRows
Event Type
Type |
---|
ResizingRowsEventHandler |
SelectionChanged
Occurs after the selection is changed
Declaration
public event SelectionChangedEventHandler SelectionChanged
Event Type
Type |
---|
SelectionChangedEventHandler |
SelectionChanging
Occurs when selection going to be changed
Declaration
public event SelectionChangingEventHandler SelectionChanging
Event Type
Type |
---|
SelectionChangingEventHandler |
ValueChanged
An event raised on the IWorksheet whenever a value changes.
Declaration
public event ValueChangedEventHandler ValueChanged
Event Type
Type |
---|
ValueChangedEventHandler |
Explicit Interface Implementations
IDisposable.Dispose()
Declaration
void IDisposable.Dispose()