Spread Windows Forms 7.0 Product Documentation
Creating a Range of Cells
See Also Support Options
Spread Windows Forms 7.0 Product Documentation > Developer's Guide > Understanding the Spreadsheet Objects > Working with Cells > Creating a Range of Cells

Glossary Item Box

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

Define a range of cells and 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.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.";
VB Copy Code
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, simply select the cells that you want to be in the range and once selected, the properties that you choose are set to those cells.

See Also

© 2002-2014 ComponentOne, a division of GrapeCity. All Rights Reserved.