Editor Property (Column)

Visual Basic
C#

'Declaration
 
Public Property Editor As IEditor

'Usage
 
Dim instance As Column
Dim value As IEditor
 
instance.Editor = value
 
value = instance.Editor

public IEditor Editor {get; set;}

Property Value

IEditor object containing the editor for cells in this column

This example creates a Column object, a CheckBoxEditor object and a CheckBoxRenderer object for the active sheet of a spreadsheet. The CheckBoxEditor is assigned to the Column objects Editor property and the CheckBoxRenderer is assigned to the Column objects Renderer property. The Column object is then assigned to the first column of the spreadsheet, such that all cells in the first column are check boxes. The Editor value of the Column object is returned to a text box.

C#

FarPoint.Web.Spread.Column mycol;
FarPoint.Web.Spread.Editor.CheckBoxEditor edit=new FarPoint.Web.Spread.Editor.CheckBoxEditor();
FarPoint.Web.Spread.Renderer.CheckBoxRenderer rend=new FarPoint.Web.Spread.Renderer.CheckBoxRenderer("img/checked.gif","img/unchecked.gif");
mycol=FpSpread1.ActiveSheetView.Columns[0];
mycol.Editor=edit;
mycol.Renderer=rend;
TextBox1.Text=Convert.ToString(mycol.Editor);

Visual Basic

Dim mycol As FarPoint.Web.Spread.Column
Dim edit As New FarPoint.Web.Spread.Editor.CheckBoxEditor()
Dim rend As New FarPoint.Web.Spread.Renderer.CheckBoxRenderer("img/checked.gif","img/unchecked.gif")
mycol=FpSpread1.ActiveSheetView.Columns(0)
mycol.Editor=edit
mycol.Renderer=rend
TextBox1.Text=Convert.ToString(mycol.Editor)

Target Platforms: Windows 7, Windows 8, Windows 10, Windows Vista, Windows Server 2003, Windows Server 2008, Windows Server 2012, Windows XP Professional

Reference

Column Class
Column Members
IEditor Interface