Creating a Range of Cells

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.

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.";

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.