CurrencyNegativeFormat Enumeration

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

Syntax

Visual Basic
C#

'Declaration
 
Public Enum CurrencyNegativeFormat 
   Inherits System.Enum

'Usage
 
Dim instance As CurrencyNegativeFormat

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.

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

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 Server 2012 R2, Windows 2008, Windows XP (SP2), Windows Vista, Windows 7, Windows 8, Windows 8.1, Windows 10

Reference

FarPoint.Win.Spread.CellType Namespace
NegativeFormat Property (CurrencyCellType Class)

User-Task Documentation

Setting a Currency Cell