在UpdateCommand可以通过 e.EditValues 拿到新值,旧值直接在Spread中取就可以:
- protected void FpSpread1_UpdateCommand(object sender, FarPoint.Web.Spread.SpreadCommandEventArgs e)
- {
- int row = (int)e.CommandArgument;
- for (int i = 0; i < e.EditValues.Count; i++)
- {
- object oldvalue = FpSpread1.ActiveSheetView.Cells[row, i].Value;
- object newvalue = e.EditValues[i];
- }
- }
复制代码 |