Syntax
| Visual Basic (Declaration) | |
|---|---|
Public Enum PercentNegativeFormat Inherits System.Enum | |
| Visual Basic (Usage) |  Copy Code |
|---|---|
Dim instance As PercentNegativeFormat | |
| C# | |
|---|---|
public enum PercentNegativeFormat : System.Enum | |
Members
| Member | Description |
|---|---|
| PercentAfter | [1] Displays the negative percent value with the percent symbol following the number |
| PercentAfterWithSpace | [0] Displays the negative percent value with a space and the percent symbol following the number |
| PercentBefore | [2] Displays the negative percent value with the percent symbol before the number |
| UseRegional | [-1] Displays the negative percent value in the format set by the Windows regional settings |
Example
This example specifies the format for negative percent values and places the percent sign with a space after the value.
| C# | Copy Code |
|---|---|
FarPoint.Win.Spread.CellType.PercentCellType prct = new FarPoint.Win.Spread.CellType.PercentCellType();
prct.NegativeFormat = FarPoint.Win.Spread.CellType.PercentNegativeFormat.PercentAfterWithSpace;
fpSpread1.ActiveSheet.Cells[0, 0].CellType = prct;
fpSpread1.ActiveSheet.Cells[0, 0].Value = -0.34; | |
| Visual Basic | Copy Code |
|---|---|
Dim prct As New FarPoint.Win.Spread.CellType.PercentCellType() prct.NegativeFormat = FarPoint.Win.Spread.CellType.PercentNegativeFormat.PercentAfterWithSpace FpSpread1.ActiveSheet.Cells(0, 0).CellType = prct FpSpread1.ActiveSheet.Cells(0, 0).Value =- 0.34 | |
Inheritance Hierarchy
System.Object
System.ValueType
System.Enum
FarPoint.Win.Spread.CellType.PercentNegativeFormat
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