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 (to the right) after the value, as in 1- |
| NegativeSignAfterWithSpace | Displays the negative sign with a space (to the right) after the value, as in 1 - |
| NegativeSignBefore | Displays the negative sign (to the left) before the value, as in -1 |
| NegativeSignBeforeWithSpace | Displays the negative sign with a space (to the left) before 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 2000 Professional (SP4), Windows 2000 Server, Windows 2003 Server (SP1), Windows 2008, Windows XP (SP2), Windows Vista, Windows 7, Windows 8