Spread ASP.NET 14
FarPoint.Web.Spread Assembly / FarPoint.Web.Spread Namespace / SheetView Class / GetEditor Method
Row index of the cell
Column index of the cell
Example


In This Topic
    GetEditor Method (SheetView)
    In This Topic
    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