Visual Basic (Declaration) | |
---|---|
Public Enum NegativeFormat Inherits System.Enum |
Visual Basic (Usage) | Copy Code |
---|---|
Dim instance As NegativeFormat |
C# | |
---|---|
public enum NegativeFormat : System.Enum |
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 |
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 |
System.Object
System.ValueType
System.Enum
FarPoint.Win.Spread.CellType.NegativeFormat
Target Platforms: Windows 2000 Professional (SP4), Windows 2000 Server, Windows 2003 Server (SP1), Windows 2008, Windows XP (SP2), Windows Vista, Windows 7, Windows 8