Spread for ASP.NET 13 Product Documentation
FarPoint.Web.Spread Assembly / FarPoint.Web.Spread Namespace / SheetView Class / GetSelections Method
Example


In This Topic
    GetSelections Method (SheetView)
    In This Topic
    Gets an ordered array of FarPoint.Web.Spread.Model.CellRange objects, from largest to smallest, containing the selected cells on the sheet with minimal overlap between the ranges.
    Syntax
    'Declaration
     
    Public Function GetSelections() As CellRange()
    'Usage
     
    Dim instance As SheetView
    Dim value() As CellRange
     
    value = instance.GetSelections()
    public CellRange[] GetSelections()
    Example
    This example uses the GetSelections method.
    //Select a range first
    protected void Button1_Click(object sender, EventArgs e)
            {
                FarPoint.Web.Spread.Model.CellRange[] cr;
                cr = FpSpread1.ActiveSheetView.GetSelections();
                TextBox1.Text = cr[0].ColumnCount.ToString();
            }
    'Select a range first
     Protected Sub Button1_Click(sender As Object, e As EventArgs) Handles Button1.Click
            Dim cr() As FarPoint.Web.Spread.Model.CellRange
            cr = FpSpread1.ActiveSheetView.GetSelections()
            TextBox1.Text = cr(0).ColumnCount.ToString()
        End Sub
    See Also