Spread for ASP.NET 13 Product Documentation
FarPoint.Web.Spread Assembly / FarPoint.Web.Spread Namespace / SpreadCommandEventArgs Class / EditValues Property
Example


In This Topic
    EditValues Property
    In This Topic
    Gets the postback data in an array list of values.
    Syntax
    '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
    Example
    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 = ""
         Next
    End Sub
    See Also