Spread for ASP.NET 7.0 Product Documentation
EditValues Property
See Also  Example Support Options
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 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

See Also

© 2002-2014 ComponentOne, a division of GrapeCity. All Rights Reserved.