Gets the editor used to edit a cell at the specified row and column.
Syntax
| Visual Basic (Usage) |  Copy Code |
|---|
Dim instance As SheetView
Dim row As Integer
Dim column As Integer
Dim value As IEditor
value = instance.GetEditor(row, 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.
| C# | Copy Code |
|---|
FarPoint.Web.Spread.SheetViewsv=null;
FarPoint.Web.Spread.Cellmycell;
FarPoint.Web.Spread.Editor.IEditored;
FarPoint.Web.Spread.Renderer.IRendererrend;
FarPoint.Web.Spread.Renderer.IFormatterfmt;
sv=FpSpread1.ActiveSheetView;
FpSpread1.Sheets[0].ColumnCount=7;
FpSpread1.Sheets[0].RowCount=10;
ed=NewFarPoint.Web.Spread.GeneralCellType();
rend=NewFarPoint.Web.Spread.CurrencyCellType();
fmt=NewFarPoint.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))); |
| Visual Basic | Copy Code |
|---|
DimsvAsFarPoint.Web.Spread.SheetView
DimmycellAsFarPoint.Web.Spread.Cell
DimedAsFarPoint.Web.Spread.Editor.IEditor
DimrendAsFarPoint.Web.Spread.Renderer.IRenderer
DimfmtAsFarPoint.Web.Spread.Renderer.IFormatter
sv=FpSpread1.ActiveSheetView
FpSpread1.Sheets(0).ColumnCount=7
FpSpread1.Sheets(0).RowCount=10
ed=NewFarPoint.Web.Spread.GeneralCellType()
rend=NewFarPoint.Web.Spread.CurrencyCellType()
fmt=NewFarPoint.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))) |
Requirements
Target Platforms: Windows 98, Windows NT 4.0, Windows Millennium Edition, Windows 2000, Windows XP Home Edition, Windows XP Professional, Windows Server 2003 family, Windows Vista, Windows Server 2008 family
See Also
