EditValues Property

Visual Basic
C#

'Declaration
 
Public ReadOnly Property EditValues As ArrayList

'Usage
 
Dim instance As SpreadCommandEventArgs
Dim value As ArrayList
 
value = instance.EditValues

public ArrayList EditValues {get;}

Property Value

ArrayList containing the postback data

This example loops through the cells in a second Spread component and puts the values in the first Spread component.

C#

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 Basic

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

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

Reference

SpreadCommandEventArgs Class
SpreadCommandEventArgs Members