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 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2