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 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