Spread for ASP.NET 9.0 Product Documentation
EditValues Property
Example 


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
Requirements

Target Platforms: Windows 7, Windows 8, Windows 10, Windows Vista, Windows Server 2003, Windows Server 2008, Windows Server 2012, Windows XP Professional

See Also

Reference

SpreadCommandEventArgs Class
SpreadCommandEventArgs Members

 

 


Copyright © GrapeCity, inc. All rights reserved.