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