Spread ASP.NET 15
FarPoint.Web.Spread Assembly / FarPoint.Web.Spread Namespace / SpreadCommandEventArgs Class / EditValues Property

In This Topic
    EditValues Property
    In This Topic
    Gets the postback data in an array list of values.
    Public ReadOnly Property EditValues As ArrayList
    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.
    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;
    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 = ""
    End Sub
    See Also