void spreadsheetControl_CellEndEdit(object sender, DevExpress.XtraSpreadsheet.SpreadsheetCellValidatingEventArgs e)
{
if (e.ColumnIndex == 4 && e.RowIndex == 5)
{
int value;
if (!int.TryParse(e.EditorText, out value) || value < 1 || value > 10)
{
DXMessageBox.Show("Please enter a whole number of years from 1 to 10");
e.Cancel = true;
}
}
}
private void SpreadsheetControl_CellEndEdit(object sender, DevExpress.XtraSpreadsheet.SpreadsheetCellValidatingEventArgs e)
{
if (e.ColumnIndex == 0)
{
if (string.IsNullOrEmpty(e.EditorText))
{
return;
}
float value = float.Parse(e.EditorText);
if (value < 100 || value > 2000)
{
e.Cancel = true;
XtraMessageBox.Show("The entered value must be >=100 and <=2000");
}
}
}
private void spsVessel_CellEndEdit(object sender, DevExpress.XtraSpreadsheet.SpreadsheetCellValidatingEventArgs e)
{
}