Gets or sets the error message for the cell type. This property is used by the derived classes.
Syntax
Visual Basic (Declaration) | |
---|
Public Overridable Property ErrorMessage As String |
Visual Basic (Usage) | Copy Code |
---|
Dim instance As GeneralCellType
Dim value As String
instance.ErrorMessage = value
value = instance.ErrorMessage |
C# | |
---|
public virtual string ErrorMessage {get; set;} |
Property Value
String containing the message to display for errors
Example
This example creates a spreadsheet with 7 columns and 50 rows. It then creates a GeneralCellType object and uses its ErrorMessage property to provide a message to display if the user types in invalid data. A loop assigns the cells in the first column to be general 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.GeneralCellType genrl=new FarPoint.Web.Spread.GeneralCellType();
genrl.ErrorMessage="You must use numbers!!";
int i;
for(i=0;i<=49;i++)
{
FpSpread1.Sheets[0].Cells[i,0].CellType=genrl;
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 genrl As New FarPoint.Web.Spread.GeneralCellType()
genrl.ErrorMessage="You must use numbers!!"
Dim i As Integer
For i = 0 To 49
FpSpread1.Sheets(0).Cells(i,0).CellType=genrl
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
See Also