NumberFormat Property (CurrencyCellType)

Gets or sets a NumberFormatInfo which is used to format the numeric value, such as for currency.

Syntax

Visual Basic
C#

'Declaration
 
Public Overrides Property NumberFormat As NumberFormatInfo

'Usage
 
Dim instance As CurrencyCellType
Dim value As NumberFormatInfo
 
instance.NumberFormat = value
 
value = instance.NumberFormat

public override NumberFormatInfo NumberFormat {get; set;}

Property Value

NumberFormatInfo object containing the format information for the number

Example

This sets the formatting for the celltype.

FarPoint.Web.Spread.CurrencyCellType c = new FarPoint.Web.Spread.CurrencyCellType(); 
System.Globalization.NumberFormatInfo nfi = new System.Globalization.NumberFormatInfo(); 
nfi.NumberDecimalDigits = 3; 
nfi.NumberDecimalSeparator = ","; 
nfi.CurrencySymbol = "$";
c.NumberFormat = nfi; 
FpSpread1.ActiveSheetView.Cells[0, 0].CellType = c; 
FpSpread1.ActiveSheetView.Cells[0, 0].Value = 234.56;

Visual Basic

Dim c As New FarPoint.Web.Spread.CurrencyCellType
Dim nfi As New System.Globalization.NumberFormatInfo
nfi.NumberDecimalDigits = 3
nfi.NumberDecimalSeparator = ","
nfi.CurrencySymbol = "$"
c.NumberFormat = nfi
FpSpread1.ActiveSheetView.Cells(0, 0).CellType = c
FpSpread1.ActiveSheetView.Cells(0, 0).Value = 234.56

Requirements

Target Platforms: Windows 7, Windows 8, Windows Vista, Windows Server 2000, Windows 2000 Professional, Windows XP Professional, Windows NT 4.0 Workstation, SP6, Windows NT 4.0 Server, SP6

Reference

CurrencyCellType Class
CurrencyCellType Members