Spread ASP.NET 14
Spread for ASP.NET 14 Product Documentation / Developer's Guide / Customizing the Appearance / Customizing the Appearance of a Cell / Creating a Range of Cells
In This Topic
    Creating a Range of Cells
    In This Topic

    You can create a range of cells to allow you to define properties and behaviors for those cells. A range may be any set of cells.

    Using the Properties Window

    1. At design time, in the Properties window, select the FpSpread component.
    2. Select the Sheets property.
    3. Click the button to display the SheetView Collection Editor.
    4. Select the sheet.
    5. Select the button for the Cells object (or Columns or Rows collections).
    6. Select a block of cells.
    7. Set properties as needed.
    8. Click OK to close each editor.

    Using Code

    1. Specify the range of cells.
    2. Set the Note property for the Cell object for that range.

    Example

    This example code sets the Note property for a range of Cell objects.

    C#
    Copy Code
    FarPoint.Web.Spread.Cell range1;
    range1 = fpSpread1.ActiveSheetView.Cells[0, 0, 2, 2];
    range1.Value = "Value Here";
    range1.Note = "This is the note that describes the value.";
    
    VB
    Copy Code
    Dim range1 As FarPoint.Web.Spread.Cell
    range1 = fpSpread1.ActiveSheetView.Cells(0, 0, 2, 2)
    range1.Value = "Value Here"
    range1.Note = "This is the note that describes the value."
    

    Using the Spread Designer

    1. Select a block of cells.
    2. Set properties as needed.
    3. From the File menu choose Apply and Exit to apply your changes to the component and exit Spread Designer.