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 10, Windows Vista, Windows Server 2003, Windows Server 2008, Windows Server 2012, Windows XP Professional

Reference

CurrencyCellType Class
CurrencyCellType Members
Overload List
ErrorMessage Property