FarPoint.Win.Spread
CurrencyNegativeFormat Enumeration
Example  See Also 
FarPoint.Win.Spread Assembly > FarPoint.Win.Spread.CellType Namespace : CurrencyNegativeFormat Enumeration


Specifies the formatting of the currency symbol and negative sign in currency.

Syntax

Visual Basic (Declaration) 
Public Enum CurrencyNegativeFormat 
   Inherits Enum
Visual Basic (Usage)Copy Code
Dim instance As CurrencyNegativeFormat
C# 
public enum CurrencyNegativeFormat : Enum

Members

MemberDescription
UseRegional [-1] Displays the currency symbol and the negative sign according to the Windows regional settings
ParenthesesSymbolBefore [0] Displays the currency symbol and the value within parentheses, as in ($1)
SignSymbolBefore [1] Displays the negative sign and the currency symbol before the value, as in -$1
SymbolSignBefore [2] Displays the currency symbol and the negative sign before the value, as in $-1
SymbolBeforeSignAfter [3] Displays the currency symbol appears before the value and the negative sign after, as in $1-
ParenthesesSymbolAfter [4] Displays the currency symbol appears after the value and within parentheses, as in (1$)
SignBeforeSymbolAfter [5] Displays the negative sign appears before the value and the currency symbol after, as in -1$
SignSymbolAfter [6] Displays the negative sign and the currency symbol after the value, as in 1-$
SymbolSignAfter [7] Displays the currency symbol and the negative sign after the value, as in 1$-
SignBeforeSpaceSymbolAfter [8] Displays the negative sign appears before the value and the currency symbol after with a space, 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 $-
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
SignSpaceSymbolAfter [13] Displays the negative sign, space, and currency symbol after the value, 1- $
ParenthesesSymbolSpaceBefore [14] Displays the currency symbol and space before the value and within parentheses, as in ($ 1)
ParenthesesSpaceSymbolAfter [15] Displays the currency symbol and a space after the value and within parentheses, as in (1 $)

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 BasicCopy 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

See Also