Syntax
| Visual Basic (Declaration) | |
|---|---|
Public Enum NegativeFormat Inherits System.Enum | |
| Visual Basic (Usage) |  Copy Code |
|---|---|
Dim instance As NegativeFormat | |
| C# | |
|---|---|
public enum NegativeFormat : System.Enum | |
Members
| Member | Description |
|---|---|
| NegativeSignAfter | Displays the negative sign after (to the right) of the value, as in 1- |
| NegativeSignAfterWithSpace | Displays the negative sign with space after (to the right) of the value, as in 1 - |
| NegativeSignBefore | Displays the negative sign before (to the left) of the value, as in -1 |
| NegativeSignBeforeWithSpace | Displays the negative sign with space before (to the left) of the value, as in - 1 |
| Parentheses | [0] Displays the value within parentheses, as in (1) |
| UseRegional | [-1] Displays the value according to the Windows regional settings |
Example
This example specifies that the negative sign with a space before the value is displayed in a numeric cell with a negative value.
| C# | Copy Code |
|---|---|
FarPoint.Win.Spread.CellType.NumberCellType numct = new FarPoint.Win.Spread.CellType.NumberCellType();
numct.NegativeFormat = FarPoint.Win.Spread.CellType.NegativeFormat.NegativeSignBeforeWithSpace;
fpSpread1.ActiveSheet.Cells[0, 0].CellType = numct;
fpSpread1.ActiveSheet.Cells[0, 0].Value = -50; | |
| Visual Basic | Copy Code |
|---|---|
Dim numct As New FarPoint.Win.Spread.CellType.NumberCellType() numct.NegativeFormat = FarPoint.Win.Spread.CellType.NegativeFormat.NegativeSignBeforeWithSpace FpSpread1.ActiveSheet.Cells(0, 0).CellType = numct FpSpread1.ActiveSheet.Cells(0, 0).Value = -50 | |
Inheritance Hierarchy
System.Object
System.ValueType
System.Enum
FarPoint.Win.Spread.CellType.NegativeFormat
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