Format Method (ComboBoxCellType)

When deriving a cell type based on this type, override this to change what gets passed back and formatted as a string into the cell on the sheet from the object in the data model.

Syntax

Visual Basic
C#

'Declaration
 
Public Overrides Function Format( _
   ByVal o As Object _
) As String

'Usage
 
Dim instance As ComboBoxCellType
Dim o As Object
Dim value As String
 
value = instance.Format(o)

public override string Format( 
   object o
)

Parameters

o: Object in the data model from which to get formatting information

Return Value

Formatted string to put in the cell on the sheet

Example

The following example subclasses the ComboBoxCellType class and creates a combo box cell in the first cell of the spreadsheet. To view the combox, double-click in the first cell.

Visual Basic

Imports FarPoint.Web.Spread
Partial Class SampleCode_Sample1VB
  Inherits System.Web.UI.Page

  Private Sub Page_Load(ByVal sender As System.Object,ByVal e As System.EventArgs)Handles MyBase.Load
    Dim cb As New myCombo()
    FpSpread1.ActiveSheetView.Cells(0, 0).CellType = cb
  End Sub

End Class

<Serializable()>
Public Class myCombo
  Inherits FarPoint.Web.Spread.ComboBoxCellType

  Sub New()
    MyBase.New(New String() {"One", "Two", "Three"}, New String() {"1", "2", "3"})
  End Sub

  Public Overrides Function Format(ByVal o As Object) As String
    Return MyBase.Format(o)
  End Function

  Public Overrides Function GetEditorControl(ByVal id As String, ByVal tc As TableCell, ByVal style As FarPoint.Web.Spread.Appearance, ByVal margin As FarPoint.Web.Spread.Inset, ByVal v As Object, ByVal ul As Boolean) As System.Web.UI.Control
    Return MyBase.GetEditorControl(id, tc, style, margin, v, ul)
  End Function

  Public Overrides Function PaintCell(ByVal id As String, ByVal tc As TableCell, ByVal style As FarPoint.Web.Spread.Appearance, ByVal margin As FarPoint.Web.Spread.Inset, ByVal v As Object, ByVal ul As Boolean) As System.Web.UI.Control
    Return MyBase.PaintCell(id, tc, style, margin, v, ul)
  End Function

  Public Overrides Function Parse(ByVal s As String) As Object
    Return MyBase.Parse(s)
  End Function

  Public Overrides ReadOnly Property EditorClientScriptUrl() As String
    Get
      Return "listboxeditor.htc"
    End Get
  End Property

End Class

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using FarPoint.Web.Spread;
using System.Drawing;
using System.Collections;

public partial class Sample3 : System.Web.UI.Page
{
  private void Page_Load(object sender, System.EventArgs e)
  {
    myCombo cb = new myCombo(new string[] { "One", "Two", "Three" });
    FpSpread1.ActiveSheetView.Cells[0, 0].CellType = cb;
  }
 
}

[Serializable()]
class myCombo:FarPoint.Web.Spread.ComboBoxCellType
{
  ArrayList items=new ArrayList();
  ArrayList values=new ArrayList();

public myCombo(string[]items):base(items)
{
for(int i=0;i<items.Length;i++)
{
this.items.Add(items[i]);
}
}

public override string Format(object o)
{
return base.Format(o);
}

public override Control GetEditorControl(string id,TableCell tc,FarPoint.Web.Spread.Appearance style,FarPoint.Web.Spread.Inset margin,object v,bool ul)
{
return base.GetEditorControl(id,tc,style,margin,v,ul);
}

public override Control PaintCell(string id,TableCell tc,FarPoint.Web.Spread.Appearance style,FarPoint.Web.Spread.Inset margin,object v,bool ul)
{
return base.PaintCell(id,tc,style,margin,v,ul);
}

public override object Parse(string s)
{
return base.Parse(s);
}

public override string EditorClientScriptUrl{get{return"listboxeditor.htc";}}
}

Requirements

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

Reference

ComboBoxCellType Class
ComboBoxCellType Members