Syntax
| Visual Basic (Declaration) | |
|---|---|
Public Property NegativeFormat As PercentNegativeFormat | |
| Visual Basic (Usage) |  Copy Code |
|---|---|
Dim instance As PercentCellType Dim value As PercentNegativeFormat instance.NegativeFormat = value value = instance.NegativeFormat | |
| C# | |
|---|---|
public PercentNegativeFormat NegativeFormat {get; set;} | |
Property Value
PercentNegativeFormat setting that determines the format for negative percent valuesExample
This example creates a percent-formatted numeric cell and sets the various formatting properties.
| C# | Copy Code |
|---|---|
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; | |
| Visual Basic | Copy Code |
|---|---|
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 | |
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