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.

To fill ranges using drag-and-drop or drag-and-fill actions, refer to Using Drag Operations to Fill Cells.

Using Code

1. Define a range of cells using the Cell object.

2. Set properties for the range such as the Note property.

Example

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

FarPoint.Win.Spread.Cell range1;
range1 = fpSpread1.ActiveSheet.Cells[1, 1, 3, 3];
range1.Value = "Value Here";
range1.Note = "This is the note that describes the value.";

Dim range1 As FarPoint.Win.Spread.Cell
range1 = fpSpread1.ActiveSheet.Cells(1, 1, 3, 3)
range1.Value = "Value Here"
range1.Note = "This is the note that describes the value."

Using the Spread Designer

In the Cell, Column, or Row editor and in the Spread Designer, select the cells that you want to be in the range. Properties you set are then applied to those cells.

See Also

Cells

Working with the Active Cell

Managing Data on a Sheet

Displaying Cell Data

Creating a Span of Cells

Allowing Cells to Merge Automatically

Adding a Note to a Cell

Adding a Tag to a Cell

Displaying Text Tips in a Cell

Working with Pattern and Gradient Fill Effects