Creates a new currency cell with the specified message to display.
Syntax
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.
| C# |  Copy Code |
|---|
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 | Copy Code |
|---|
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 98, Windows NT 4.0, Windows Millennium Edition, Windows 2000, Windows XP Home Edition, Windows XP Professional, Windows Server 2003 family, Windows Vista, Windows Server 2008 family
See Also
