Spread ASP.NET 6.0 Product Documentation
Unchanged Field
See Also  Example Send Feedback
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 98, Windows NT 4.0, Windows Millennium Edition, Windows 2000, Windows XP Home Edition, Windows XP Professional, Windows Server 2003 family, Windows Vista, Windows Server 2008 family

See Also

© 2002-2012 GrapeCity, Inc. All Rights Reserved.