Spread Windows Forms 6.0 Product Documentation
CurrencyPositiveFormat Enumeration
Example  See Also  Support Options
FarPoint.Win.Spread Assembly > FarPoint.Win.Spread.CellType Namespace : CurrencyPositiveFormat Enumeration


Glossary Item Box

Specifies the formatting of the currency symbol and positive sign in a currency cell.

Syntax

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

Members

MemberDescription
CurrencySymbolAfter[1] Displays the currency symbol appears after the value
CurrencySymbolAfterWithSpace[3] Display the currency symbol appears with a space after the value
CurrencySymbolBefore[0] Displays the currency symbol appears before the value
CurrencySymbolBeforeWithSpace[2] Displays the currency symbol appears 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.
Visual BasicCopy Code
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
C#Copy Code
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 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

© 2002-2012 ComponentOne, a division of GrapeCity. All Rights Reserved.