Gets or sets the amount by which the value increments when using the spin buttons and the cursor is in the decimal portion.
Syntax
Visual Basic (Declaration) | |
---|
Public Property SpinDecimalIncrement As Single |
Visual Basic (Usage) | Copy Code |
---|
Dim instance As CurrencyCellType
Dim value As Single
instance.SpinDecimalIncrement = value
value = instance.SpinDecimalIncrement |
C# | |
---|
public float SpinDecimalIncrement {get; set;} |
Property Value
Numeric amount (
single-precision, floating-point number) by which to increment value
Remarks
Example
This example specifies a currency cell and sets spin button properties.
C# | Copy Code |
---|
FarPoint.Win.Spread.CellType.CurrencyCellType crcycell = new FarPoint.Win.Spread.CellType.CurrencyCellType();
crcycell.SpinButton = true;
crcycell.SpinDecimalIncrement = 0.5F;
crcycell.SpinIntegerIncrement = 5;
crcycell.SpinWrap = true;
crcycell.MaximumValue = 500;
crcycell.MinimumValue = -100;
fpSpread1.Sheets[0].Cells[6,2].CellType = crcycell;
fpSpread1.Sheets[0].Cells[6,2].Value = 443.3482; |
Visual Basic | Copy Code |
---|
Dim curr As New FarPoint.Win.Spread.CellType.CurrencyCellType()
curr.SpinButton = True
curr.SpinDecimalIncrement = 0.5
curr.SpinIntegerIncrement = 5
curr.SpinWrap = True
curr.MaximumValue = 500
curr.MinimumValue = -100
FpSpread1.ActiveSheet.Cells(0, 0).CellType = curr
FpSpread1.ActiveSheet.Cells(0, 0).Value = 443.3482 |
Requirements
Target Platforms: Windows 2000 Professional (SP4), Windows 2000 Server, Windows 2003 Server (SP1), Windows 2008, Windows XP (SP2), Windows Vista, Windows 7, Windows 8
See Also