FarPoint.Win.Spread Assembly > FarPoint.Win.Spread.CellType Namespace : CurrencyNegativeFormat Enumeration |
'Declaration Public Enum CurrencyNegativeFormat Inherits System.Enum
'Usage Dim instance As CurrencyNegativeFormat
public enum CurrencyNegativeFormat : System.Enum
Member | Description |
---|---|
ParenthesesSpaceSymbolAfter | [15] Displays the currency symbol and a space after the value and within parentheses, as in (1 $) |
ParenthesesSymbolAfter | [4] Displays the currency symbol after the value and within parentheses, as in (1$) |
ParenthesesSymbolBefore | [0] Displays the currency symbol and the value within parentheses, as in ($1) |
ParenthesesSymbolSpaceBefore | [14] Displays the currency symbol and space before the value and within parentheses, as in ($ 1) |
SignBeforeSpaceSymbolAfter | [8] Displays the negative sign before the value and a space with the currency symbol after the value, as in -1 $ |
SignBeforeSymbolAfter | [5] Displays the negative sign before the value and the currency symbol after, as in -1$ |
SignSpaceSymbolAfter | [13] Displays the negative sign, space, and currency symbol after the value, 1- $ |
SignSymbolAfter | [6] Displays the negative sign and the currency symbol after the value, as in 1-$ |
SignSymbolBefore | [1] Displays the negative sign and the currency symbol before the value, as in -$1 |
SignSymbolSpaceBefore | [9] Displays the negative sign and the currency symbol with a space before the value, as in -$ 1 |
SpaceSymbolSignAfter | [10] Displays the currency symbol and the negative sign with a space after the value, as in 1 $- |
SymbolBeforeSignAfter | [3] Displays the currency symbol before the value and the negative sign after, as in $1- |
SymbolSignAfter | [7] Displays the currency symbol and the negative sign after the value, as in 1$- |
SymbolSignBefore | [2] Displays the currency symbol and the negative sign before the value, as in $-1 |
SymbolSpaceBeforeSignAfter | [11] Displays the currency symbol with a space before the value and the negative sign after the value, as in $ 1- |
SymbolSpaceSignBefore | [12] Displays the currency symbol, space, and negative sign before the value, as in $ -1 |
UseRegional | [-1] Displays the currency symbol and the negative sign according to the Windows regional settings |
FarPoint.Win.Spread.CellType.CurrencyCellType crrct = new FarPoint.Win.Spread.CellType.CurrencyCellType(); crrct.NegativeFormat = FarPoint.Win.Spread.CellType.CurrencyNegativeFormat.ParenthesesSymbolSpaceBefore; crrct.CurrencySymbol = "\xA3"; crrct.NegativeRed = true; fpSpread1.ActiveSheet.Cells[0, 0].CellType = crrct; fpSpread1.ActiveSheet.Cells[0, 0].Value = -435.0;
Dim crrct As New FarPoint.Win.Spread.CellType.CurrencyCellType() crrct.NegativeFormat = FarPoint.Win.Spread.CellType.CurrencyNegativeFormat.ParenthesesSymbolSpaceBefore crrct.CurrencySymbol = Chr(163) crrct.NegativeRed = True FpSpread1.ActiveSheet.Cells(0, 0).CellType = crrct FpSpread1.ActiveSheet.Cells(0, 0).Value = -435.0
System.Object
System.ValueType
System.Enum
FarPoint.Win.Spread.CellType.CurrencyNegativeFormat
Target Platforms: Windows 2000 Professional (SP4), Windows 2000 Server, Windows 2003 Server (SP1), Windows 2008, Windows XP (SP2), Windows Vista, Windows 7, Windows 8
FarPoint.Win.Spread.CellType Namespace
NegativeFormat Property (CurrencyCellType Class)