Unchanged Field

Represents the unchanged property of the cell contents.

Syntax

Visual Basic
C#

'Declaration
 
Public Shared Unchanged As Object

'Usage
 
Dim value As Object
 
value = FpSpread.Unchanged
 
FpSpread.Unchanged = value

public static object Unchanged

Field Value

Static constant object you check to see if the value has changed

Example

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];
        }
    }
}

Visual Basic

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

Remarks

This is a static constant object you can use to check if the value of a variable in a cell has been changed.

Requirements

Target Platforms: Windows 7, Windows 8, Windows 10, Windows Vista, Windows Server 2003, Windows Server 2008, Windows Server 2012, Windows XP Professional

Reference

FpSpread Class
FpSpread Members