这里想到了一个解决办法,通过CellValidateInfoNeeded事件判断验证错误,然后在Change事件中,将单元格清空
- bool CellValueisValid = true;
- private void FpSpread1_CellValidateInfoNeeded(object sender, CellValidateInfoNeededEventArgs e)
- {
- if (!e.IsValid)
- {
-
- CellValueisValid = false;
- }
- }
- private void FpSpread1_Change(object sender, ChangeEventArgs e)
- {
- fpSpread1.ActiveSheet.ActiveCell.ResetText();
- CellValueisValid = true;
- }
复制代码 |