FarPoint.Web.Spread Assembly > FarPoint.Web.Spread Namespace > FpSpread Class : Unchanged Field |
private void FpSpread1UpdateCommand(object sender, FarPoint.Web.Spread.SpreadCommandEventArgs e) { int colcnt; int i; string strvalue; 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]; } } }
Private Sub FpSpread1UpdateCommand(ByVal sender As Object, ByVal e As FarPoint.Web.Spread.SpreadCommandEventArgs) Handles FpSpread1.UpdateCommand Dim colcnt As Integer, i As Integer, strvalue As String colcnt = e.EditValues.Count - 1 For i = 0 To colcnt If Not Object.ReferenceEquals(e.EditValues.Item(i), FarPoint.Web.Spread.FpSpread.Unchanged) Then strvalue = e.EditValues.Item(i) End If Next End Sub
This is a static constant object you can use to check if the value of a variable in a cell has been changed.
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