CurrencyCellType Constructor(String)

Creates a new currency cell with the specified message to display.

Syntax

Visual Basic
C#

'Declaration
 
Public Function New( _
   ByVal errorMessage As String _
)

'Usage
 
Dim errorMessage As String
 
Dim instance As New CurrencyCellType(errorMessage)

public CurrencyCellType( 
   string errorMessage
)

Parameters

errorMessage: Message (as a string) to display if the input value is not valid

Example

This example creates a spreadsheet with 7 columns and 50 rows. It then creates a CurrencyCell object with a message to display if the user enters invalid data. A loop assigns the cells in the first column to be currency cells and places values in them.

FpSpread1.Sheets[0].ColumnCount = 7;
FpSpread1.Sheets[0].PageSize = 50;
FpSpread1.Sheets[0].RowCount = 50;
FarPoint.Web.Spread.CurrencyCellType curr = new FarPoint.Web.Spread.CurrencyCellType("You must use numbers!!");
int i;
for (i = 0; i <=49; i++)
{
  FpSpread1.Sheets[0].Cells[i, 0].CellType = curr;
  FpSpread1.Sheets[0].Cells[i, 0].Value = 100 + i;
}

Visual Basic

FpSpread1.Sheets(0).ColumnCount = 7
FpSpread1.Sheets(0).PageSize = 50
FpSpread1.Sheets(0).RowCount = 50
Dim curr As New FarPoint.Web.Spread.CurrencyCellType("You must use numbers!!")
Dim i As Integer
For i = 0 To 49
   FpSpread1.Sheets(0).Cells(i, 0).CellType = curr
   FpSpread1.Sheets(0).Cells(i, 0).Value = 100 + i
Next i

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
Overload List
ErrorMessage Property