You can set attributes on the client side. There is an FpCellType attribute and an FpActiveSpread attribute. The FpCellType is an attribute on a table object (cell). FpActiveSpread is an attribute on a document object.
The following client functions are called by Spread when going in and out of edit mode on a table cell. You might find these functions useful when creating custom cells. You can use the FpCellType attribute to get to these functions. The methods are SetValue, GetValue, SetEditorValue, GetEditorValue, SetFocus, and IsValid.
| Function | Description |
|---|---|
| SetValue | Called when setting the value to the renderer of the cell. |
| GetValue | Called when getting the value from the renderer to pass to the editor. |
| SetEditorValue | Called when setting the value from GetValue into the editor. |
| GetEditorValue | Called when getting the value from the editor to pass to the renderer. |
| SetFocus | Called when the editor is getting focus. |
| IsValid | Called when the cell is exiting editmode and is used to determine if the value from GetEditorValue is valid. |
The attribute of the cell type name is appended to the beginning of the function name. For example:
- MyCellType_setValue
- MyCellType_getValue
- MyCellType_getEditorValue
- MyCellType_setEditorValue
- MyCellType_isValid
- MyCellType_setFocus
The FpActiveSpread attribute can be used to query the Spread that is active, which is useful in hierarchial spreadsheets. The Spread ID on the client side may appear as follows:
<% FpSpread1.ClientID %>_r_i… where r is the ParentRowIndex and i is the relation index number to the child sheet. The ellipses mean to repeat _r_i for each level in the hierarchy.
The following example creates a custom cell and uses the FpCellType attribute:
| VB |  Copy Code |
|---|---|
Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load If Not Page.IsPostBack Then Dim customButton As New customButton() customButton.Text = "testing" FpSpread1.Sheets(0).Cells(0, 0).CellType = customButton End If End Class 'add the following after your last end class <Serializable()> Public Class customButton Inherits FarPoint.Web.Spread.ButtonCellType Public Sub New() End Sub Public Overrides Function PaintCell(ByVal id As String, ByVal parent As TableCell, ByVal style As FarPoint.Web.Spread.Appearance, ByVal margin As FarPoint.Web.Spread.Inset, ByVal val As Object, ByVal ul As Boolean) As System.Web.UI.Control parent.Attributes.Add("FpCellType", "ztest") Return MyBase.PaintCell(id, parent, style, margin, val, ul) End Function End Class |
|
add the following to the aspx page
| JavaScript | Copy Code |
|---|---|
<SCRIPT language=javascript> function ztest_getValue(rd){ return ""; } </SCRIPT> |
|