Spread Windows Forms 13.0 Product Documentation
FarPoint.Win.Spread Assembly / FarPoint.Win.Spread Namespace / SheetView Class / Columns Property
Example


In This Topic
    Columns Property (SheetView)
    In This Topic
    Gets a Columns object for the columns in the data area of the sheet.
    Syntax
    'Declaration
 
Public ReadOnly Property Columns As Columns
    'Usage
 
Dim instance As SheetView
Dim value As Columns
 
value = instance.Columns
    public Columns Columns {get;}

    Property Value

    Columns object containing the collection of columns
    Remarks
    This property returns the columns in the sheet, but not the columns in the row header.
    Example
    This example sets a border around several cells in the columns and rows. 
    fpSpread1.ActiveSheet.Columns[0, 1].Border = new FarPoint.Win.BevelBorder(FarPoint.Win.BevelBorderType.Lowered, Color.LightBlue,
Color.Blue, 1);
fpSpread1.ActiveSheet.Rows[0, 3].Border = new FarPoint.Win.BevelBorder(FarPoint.Win.BevelBorderType.Lowered, Color.LightBlue,
Color.Blue, 1);
    FpSpread1.ActiveSheet.Columns(0, 1).Border = New FarPoint.Win.BevelBorder(FarPoint.Win.BevelBorderType.Lowered, Color.LightBlue,
Color.Blue, 1)
FpSpread1.ActiveSheet.Rows(0, 3).Border = New FarPoint.Win.BevelBorder(FarPoint.Win.BevelBorderType.Lowered, Color.LightBlue,
Color.Blue, 1)
    See Also

    Reference

    SheetView Class
    SheetView Members
    Columns Class

    User-Task Documentation

    Customizing the Appearance of Rows or Columns
    Customizing Row or Column Interaction

     

     

    Copyright © 2003-2020 GrapeCity, Inc. All rights reserved.

    Product Support Forum | Print this page