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 appears 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 appears before the value and the currency symbol after with a space, as in -1 $ |
| SignBeforeSymbolAfter | [5] Displays the negative sign appears 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 appears 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, 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 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
See Also
Reference
FarPoint.Win.Spread.CellType NamespaceNegativeFormat Property (CurrencyCellType Class)