NumericUpDownCellType Constructor

Visual Basic
C#

'Declaration
 
Public Function New()

'Usage
 
Dim instance As New NumericUpDownCellType()

public NumericUpDownCellType()

This example creates a numeric up-down cell type.

C#

FarPoint.Web.Spread.Extender.NumericUpDownCellType n = new FarPoint.Web.Spread.Extender.NumericUpDownCellType();
n.Step = 1;
n.Width = 130;
n.ShowEditor = true;
n.ServiceUpPath = "WebService.asmx";
n.ServiceUpMethod = "Increment";
n.ServiceDownPath = "WebService.asmx";
n.ServiceDownMethod = "Decrement";
FpSpread1.ActiveSheetView.Cells[0, 0].CellType = n;
FpSpread1.ActiveSheetView.Cells[0, 0].Value = 1;

[WebMethod()]
    public double Increment(double current) {
        current = (current + 0.25);
        if ((current > 10)) {
            current = 10;
        }
        return current;
    }
    
    [WebMethod()]
    public double Decrement(double current) {
        current = (current - 0.25);
        if ((current < 0.25)) {
            current = 0.25;
        }
        return current;
    }

Visual Basic

Dim n As New FarPoint.Web.Spread.Extender.NumericUpDownCellType
n.Step = 1
n.Width = 130
n.ShowEditor = True
n.ServiceUpPath = "WebService.asmx"
n.ServiceUpMethod = "Increment"
n.ServiceDownPath = "WebService.asmx"
n.ServiceDownMethod = "Decrement"
FpSpread1.ActiveSheetView.Cells(0, 0).CellType = n
FpSpread1.ActiveSheetView.Cells(0, 0).Value = 1

<WebMethod()>
Public Function Increment(ByVal current As Double) As Double
  current = current + 0.25
    If current > 10 Then
    current = 10
    End If
  Return current
 End Function
 <WebMethod()>
 Public Function Decrement(ByVal current As Double) As Double
  current = current - 0.25
    If current < 0.25 Then
    current = 0.25
    End If
  Return current
End Function

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

Reference

NumericUpDownCellType Class
NumericUpDownCellType Members