Spread Windows Forms 11.0 Product Documentation
SpinDecimalIncrement Property (NumberCellType)
Example 


FarPoint.Win.Spread Assembly > FarPoint.Win.Spread.CellType Namespace > NumberCellType Class : SpinDecimalIncrement Property
Gets or sets the amount by which the value increments when using the spin buttons and the cursor is in the decimal portion.
Syntax
'Declaration
 
Public Property SpinDecimalIncrement As Single
'Usage
 
Dim instance As NumberCellType
Dim value As Single
 
instance.SpinDecimalIncrement = value
 
value = instance.SpinDecimalIncrement
public float SpinDecimalIncrement {get; set;}

Property Value

Single-precision, floating-point number representing the increment for the decimal
Remarks

This increment applies when the cursor is to the right of the decimal separator but the value is not limited to numbers less than 1.

Example
This example sets several properties of a numeric format cell including the increment for the spin buttons.
FarPoint.Win.Spread.CellType.NumberCellType num = new FarPoint.Win.Spread.CellType.NumberCellType();
num.DecimalPlaces = 3;
num.DecimalSeparator = ",";
num.FixedPoint = true;
num.LeadingZero = FarPoint.Win.Spread.CellType.LeadingZero.UseRegional;
num.MaximumValue = 50000.0;
num.MinimumValue = -1000.0;
num.NegativeFormat = FarPoint.Win.Spread.CellType.NegativeFormat.Parentheses;
num.NegativeRed = true;
num.Separator = "/";
num.ShowSeparator = true;
num.SpinButton = true;
num.SpinDecimalIncrement = 10;
num.SpinIntegerIncrement = 5;
num.SpinWrap = true;
fpSpread1.ActiveSheet.Cells[0, 0].CellType = num;
fpSpread1.ActiveSheet.Cells[0, 0].Value = -443.0908;
Dim num As New FarPoint.Win.Spread.CellType.NumberCellType()
num.DecimalPlaces = 3
num.DecimalSeparator = ","
num.FixedPoint = True
num.LeadingZero = FarPoint.Win.Spread.CellType.LeadingZero.UseRegional
num.MaximumValue = 50000.0
num.MinimumValue = -1000.0
num.NegativeFormat = FarPoint.Win.Spread.CellType.NegativeFormat.Parentheses
num.NegativeRed = True
num.Separator = "/"
num.ShowSeparator = True
num.SpinButton = True
num.SpinDecimalIncrement = 10
num.SpinIntegerIncrement = 5
num.SpinWrap = True
FpSpread1.ActiveSheet.Cells(0, 0).CellType = num
FpSpread1.ActiveSheet.Cells(0, 0).Value = 443.9098
See Also

Reference

NumberCellType Class
NumberCellType Members

User-Task Documentation

Displaying Spin Buttons