FarPoint.Win.Spread アセンブリ > FarPoint.Win.Spread.CellType 名前空間 > PercentCellType クラス : SpinDecimalIncrement プロパティ |
この増分量は、カーソルが小数点区切り記号の右側にあり、値が1未満に制限されていない場合に適用されます。
FarPoint.Win.Spread.CellType.PercentCellType prctcell = new FarPoint.Win.Spread.CellType.PercentCellType(); prctcell.DecimalPlaces = 3; prctcell.DecimalSeparator = ","; prctcell.FixedPoint = true; prctcell.LeadingZero = FarPoint.Win.Spread.CellType.LeadingZero.UseRegional; prctcell.MaximumValue = 50000.0; prctcell.MinimumValue = -1000.0; prctcell.NegativeFormat = FarPoint.Win.Spread.CellType.PercentNegativeFormat.PercentAfterWithSpace; prctcell.NegativeRed = true; prctcell.PercentSign = "%"; prctcell.PositiveFormat = FarPoint.Win.Spread.CellType.PercentPositiveFormat.PercentAfter; prctcell.Separator = "/"; prctcell.ShowSeparator = true; prctcell.SpinButton = true; prctcell.SpinDecimalIncrement = 10; prctcell.SpinIntegerIncrement = 5; prctcell.SpinWrap = true; fpSpread1.ActiveSheet.Cells[0, 0].CellType = prctcell; fpSpread1.ActiveSheet.Cells[0, 0].Value = -443.0908;
Dim prctcell As New FarPoint.Win.Spread.CellType.PercentCellType() prctcell.DecimalPlaces = 3 prctcell.DecimalSeparator = "," prctcell.FixedPoint = True prctcell.LeadingZero = FarPoint.Win.Spread.CellType.LeadingZero.UseRegional prctcell.MaximumValue = 50000.0 prctcell.MinimumValue = -1000.0 prctcell.NegativeFormat = FarPoint.Win.Spread.CellType.PercentNegativeFormat.PercentAfterWithSpace prctcell.NegativeRed = True prctcell.PercentSign = "%" prctcell.PositiveFormat = FarPoint.Win.Spread.CellType.PercentPositiveFormat.PercentAfter prctcell.Separator = "/" prctcell.ShowSeparator = True prctcell.SpinButton = True prctcell.SpinDecimalIncrement = 10 prctcell.SpinIntegerIncrement = 5 prctcell.SpinWrap = True FpSpread1.ActiveSheet.Cells(0, 0).CellType = prctcell FpSpread1.ActiveSheet.Cells(0, 0).Value = -443.9098