Spread for ASP.NET 11 Product Documentation
GetEditor Method (SheetView)
Example 


FarPoint.Web.Spread Assembly > FarPoint.Web.Spread Namespace > SheetView Class : GetEditor Method
Row index of the cell
Column index of the cell
Gets the editor used to edit a cell at the specified row and column.
Syntax
'Declaration
 
Public Overridable Function GetEditor( _
   ByVal row As Integer, _
   ByVal column As Integer _
) As IEditor
'Usage
 
Dim instance As SheetView
Dim row As Integer
Dim column As Integer
Dim value As IEditor
 
value = instance.GetEditor(row, column)
public virtual IEditor GetEditor( 
   int row,
   int column
)

Parameters

row
Row index of the cell
column
Column index of the cell

Return Value

IEditor object containing the editor for cells in this sheet
Example
This example creates a SheetView object and assigns it to the active sheet. An Editor, Renderer, and Formatter are added and assigned to the first cell in the sheet. The SheetView object queries these Interfaces and returns the values to a list box.
FarPoint.Web.Spread.SheetView sv=null;
FarPoint.Web.Spread.Cell mycell;
FarPoint.Web.Spread.Editor.IEditor ed;
FarPoint.Web.Spread.Renderer.IRenderer rend;
FarPoint.Web.Spread.Renderer.IFormatter fmt;
sv=FpSpread1.ActiveSheetView;
FpSpread1.Sheets[0].ColumnCount=7;
FpSpread1.Sheets[0].RowCount=10;
ed=new FarPoint.Web.Spread.GeneralCellType();
rend=new FarPoint.Web.Spread.CurrencyCellType();
fmt=new FarPoint.Web.Spread.DoubleCellType();
mycell=FpSpread1.Cells[0,0];
mycell.Editor=ed;
mycell.Renderer=rend;
mycell.Formatter=fmt;
ListBox1.Items.Add(Convert.ToString(sv.GetEditor(0,0)));
ListBox1.Items.Add(Convert.ToString(sv.GetRenderer(0,0)));
ListBox1.Items.Add(Convert.ToString(sv.GetFormatter(0,0)));
Dim sv As FarPoint.Web.Spread.SheetView
Dim mycell As FarPoint.Web.Spread.Cell
Dim ed As FarPoint.Web.Spread.Editor.IEditor
Dim rend As FarPoint.Web.Spread.Renderer.IRenderer
Dim fmt As FarPoint.Web.Spread.Renderer.IFormatter
sv=FpSpread1.ActiveSheetView
FpSpread1.Sheets(0).ColumnCount=7
FpSpread1.Sheets(0).RowCount=10
ed=New FarPoint.Web.Spread.GeneralCellType()
rend=New FarPoint.Web.Spread.CurrencyCellType()
fmt=New FarPoint.Web.Spread.DoubleCellType()
mycell=FpSpread1.Cells(0,0)
mycell.Editor=ed
mycell.Renderer=rend
mycell.Formatter=fmt
ListBox1.Items.Add(Convert.ToString(sv.GetEditor(0,0)))
ListBox1.Items.Add(Convert.ToString(sv.GetRenderer(0,0)))
ListBox1.Items.Add(Convert.ToString(sv.GetFormatter(0,0)))
See Also

Reference

SheetView Class
SheetView Members
BaseEditor Class