Syntax
| Visual Basic (Declaration) | |
|---|---|
Public Enum CurrencyNegativeFormat Inherits System.Enum | |
| Visual Basic (Usage) |  Copy Code |
|---|---|
Dim instance As CurrencyNegativeFormat | |
| C# | |
|---|---|
public enum CurrencyNegativeFormat : System.Enum | |
Members
| 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 |
Example
This example displays the currency symbol and space before the value and within parentheses for negative values.
| C# | Copy Code |
|---|---|
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; | |
| Visual Basic | Copy Code |
|---|---|
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 | |
Inheritance Hierarchy
System.Object
System.ValueType
System.Enum
FarPoint.Win.Spread.CellType.CurrencyNegativeFormat
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
See Also
Reference
FarPoint.Win.Spread.CellType NamespaceNegativeFormat Property (CurrencyCellType Class)