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.
Return to the cell appearance overview at Customizing the Appearance of a Cell.
Using the Properties Window
- At design time, in the Properties window, select the FpSpread component.
- Select the Sheets property.
- Click the button to display the SheetView Collection Editor.
- Select the sheet.
- Select the button for the Cells object (or Columns or Rows collections).
- Select a block of cells.
- Set properties as needed.
- Click OK to close each editor.
Using Code
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
- Select a block of cells.
- Set properties as needed.
- From the File menu choose Apply and Exit to apply your changes to the component and exit Spread Designer.