protected void FpSpread2_UpdateCommand(object sender, FarPoint.Web.Spread.SpreadCommandEventArgs e)
{
int colcnt;
int i;
string strvalue;
int r = (int)e.CommandArgument;
colcnt = e.EditValues.Count - 1;
for (i = 0; i <= colcnt; i++)
{
if(!object.ReferenceEquals(e.EditValues[i], FarPoint.Web.Spread.FpSpread.Unchanged))
{
strvalue = e.EditValues[i].ToString();
FpSpread1.Sheets[0].Cells[r, i].Value = strvalue;
}
}
}
Protected Sub FpSpread2_UpdateCommand(ByVal sender As Object, ByVal e As FarPoint.Web.Spread.SpreadCommandEventArgs)
Dim colcnt As Integer
Dim i As Integer
Dim strvalue As String
Dim r As Integer = CInt(e.CommandArgument)
colcnt = e.EditValues.Count - 1
For i = 0 To colcnt
If Not Object.ReferenceEquals(e.EditValues(i), FarPoint.Web.Spread.FpSpread.Unchanged) Then
strvalue = e.EditValues(i).ToString()
FpSpread1.Sheets(0).Cells(r, i).Value = strvalue
End If
strvalue = ""
Next
End Sub