Spread ASP.NET 16
FarPoint.Web.Spread Assembly / FarPoint.Web.Spread Namespace / ButtonCellType Class / ButtonCellType Constructor / ButtonCellType Constructor(String,String)
String of command to perform when the user clicks the button
String with button text
Example


In This Topic
    ButtonCellType Constructor(String,String)
    In This Topic
    Creates a new button cell with the specified command and text.
    Syntax
    'Declaration
     
    Public Function New( _
       ByVal cmd As String, _
       ByVal text As String _
    )
    'Usage
     
    Dim cmd As String
    Dim text As String
     
    Dim instance As New ButtonCellType(cmd, text)
    public ButtonCellType( 
       string cmd,
       string text
    )

    Parameters

    cmd
    String of command to perform when the user clicks the button
    text
    String with button text
    Example
    This example shows the use of this constructor by creating a spreadsheet, setting the first two columns of cells to be button cells and constructing the buttons with a CommandNames of "MyRed" and "MyBlue". (In the ButtonCommand event the CommandNames are queried and the background color of the spreadsheet is changed depending on the CommandName.)
    FarPoint.Web.Spread.ButtonCellType btn=new FarPoint.Web.Spread.ButtonCellType("MyRed","Red");
    FarPoint.Web.Spread.ButtonCellType btn1=new FarPoint.Web.Spread.ButtonCellType("MyBlue","Blue");
    FarPoint.Web.Spread.StyleInfo style=new FarPoint.Web.Spread.StyleInfo();
    FarPoint.Web.Spread.StyleInfo style1=new FarPoint.Web.Spread.StyleInfo();
    FpSpread1.Sheets[0].ColumnCount=7;
    FpSpread1.Sheets[0].RowCount=50;
    style.CellType=btn;
    style1.CellType=btn1;
    FpSpread1.Sheets[0].SetStyleInfo(-1,0,style);
    FpSpread1.Sheets[0].SetStyleInfo(-1,1,style1);
    private void FpSpread1_ButtonCommand(object sender,FarPoint.Web.Spread.SpreadCommandEventArgs e)
    {
    if(e.CommandName=="MyRed")
    {
    FpSpread1.Sheets[0].BackColor=Color.Red;
    }
    else if(e.CommandName=="MyBlue")
    {
    FpSpread1.Sheets[0].BackColor=Color.Blue;
    }
    }
    Dim btn As New FarPoint.Web.Spread.ButtonCellType("MyRed","Red")
    Dim btn1 As New FarPoint.Web.Spread.ButtonCellType("MyBlue","Blue")
    Dim style As New FarPoint.Web.Spread.StyleInfo()
    Dim style1 As New FarPoint.Web.Spread.StyleInfo()
    FpSpread1.Sheets(0).ColumnCount=7
    FpSpread1.Sheets(0).RowCount=50
    style.CellType=btn
    style1.CellType=btn1
    FpSpread1.Sheets(0).SetStyleInfo(-1,0,style)
    FpSpread1.Sheets(0).SetStyleInfo(-1,1,style1)
    Private Sub FpSpread1_ButtonCommand(ByVal sender As Object,ByVal e AsFarPoint.Web.Spread.SpreadCommandEventArgs)Handles FpSpread1.ButtonCommand
    If e.CommandName="MyRed" Then
    FpSpread1.Sheets(0).BackColor=Color.Red
    Else If e.CommandName="MyBlue" Then
    FpSpread1.Sheets(0).BackColor=Color.Blue
    End If
    End Sub
    See Also