Spread Windows Forms 11.0 Product Documentation
CurrencyPositiveFormat Enumeration
Example Example 


FarPoint.Win.Spread Assembly > FarPoint.Win.Spread.CellType Namespace : CurrencyPositiveFormat Enumeration
Specifies the formatting of the currency symbol and positive sign in a currency cell.
Syntax
'Declaration
 
Public Enum CurrencyPositiveFormat 
   Inherits System.Enum
'Usage
 
Dim instance As CurrencyPositiveFormat
public enum CurrencyPositiveFormat : System.Enum 
Members
MemberDescription
CurrencySymbolAfter[1] Displays the currency symbol after the value
CurrencySymbolAfterWithSpace[3] Displays the currency symbol with a space after the value
CurrencySymbolBefore[0] Displays the currency symbol before the value
CurrencySymbolBeforeWithSpace[2] Displays the currency symbol with a space before the value
UseRegional[-1] Displays the currency symbol according to the Windows regional setting
Example
This example places the currency symbol after the value for positive values.
Dim crrct As New FarPoint.Win.Spread.CellType.CurrencyCellType()
crrct.PositiveFormat = FarPoint.Win.Spread.CellType.CurrencyPositiveFormat.CurrencySymbolAfter
crrct.CurrencySymbol = Chr(163)
fpSpread1.ActiveSheet.Cells(0, 0).CellType = crrct
fpSpread1.ActiveSheet.Cells(0, 0).Value = 435.45
FarPoint.Win.Spread.CellType.CurrencyCellType crrct = new FarPoint.Win.Spread.CellType.CurrencyCellType();
crrct.PositiveFormat = FarPoint.Win.Spread.CellType.CurrencyPositiveFormat.CurrencySymbolAfter;
crrct.CurrencySymbol = "\xA3";
fpSpread1.ActiveSheet.Cells[0, 0].CellType = crrct;
fpSpread1.ActiveSheet.Cells[0, 0].Value = 435.45;
Inheritance Hierarchy

System.Object
   System.ValueType
      System.Enum
         FarPoint.Win.Spread.CellType.CurrencyPositiveFormat

See Also

Reference

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

User-Task Documentation

Setting a Currency Cell