Spread Windows Forms 10.0 Product Documentation
CurrencyPositiveFormat Enumeration
Example Example 


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

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

See Also

Reference

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

User-Task Documentation

Setting a Currency Cell

 

 


Copyright © GrapeCity, inc. All rights reserved.