Spread ASP.NET 6.0 Product Documentation
EditValues Property
See Also  Example Send Feedback
FarPoint.Web.Spread Assembly > FarPoint.Web.Spread Namespace > SpreadCommandEventArgs Class : EditValues Property


Glossary Item Box

Gets the postback data in an array list of values.

Syntax

Visual Basic (Declaration) 
Public ReadOnly Property EditValues As ArrayList
Visual Basic (Usage)Copy Code
Dim instance As SpreadCommandEventArgs
Dim value As ArrayList
 
value = instance.EditValues
C# 
public ArrayList EditValues {get;}

Property Value

ArrayList containing the postback data

Example

This example loops through the cells in a second Spread component and puts the values in the first Spread component.
C#Copy Code
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;
        }
     }
}
Visual BasicCopy Code
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

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.