Spread for ASP.NET 7.0 Product Documentation
Unchanged Field
See Also  Example Support Options
FarPoint.Web.Spread Assembly > FarPoint.Web.Spread Namespace > FpSpread Class : Unchanged Field


Glossary Item Box

Represents the unchanged property of the cell contents.

Syntax

Visual Basic (Declaration) 
Public Shared Unchanged As Object
Visual Basic (Usage)Copy Code
Dim value As Object
 
value = FpSpread.Unchanged
 
FpSpread.Unchanged = value
C# 
public static object Unchanged

Field Value

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

Remarks

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

Example

C#Copy Code
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 BasicCopy Code
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

Requirements

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

See Also

© 2002-2014 ComponentOne, a division of GrapeCity. All Rights Reserved.