Cells Property (FpSpread)

Gets the cells in the client area of the active sheet in the Spread component.

Syntax

Visual Basic
C#

'Declaration
 
Public ReadOnly Property Cells As Cells

'Usage
 
Dim instance As FpSpread
Dim value As Cells
 
value = instance.Cells

public Cells Cells {get;}

Property Value

Cells object that contains the cells in the data area of the currently selected sheet

Remarks

This property is available at run time only.

Use the Cells, Columns, Rows, and Sheets properties to work with individual cells, columns, rows, or sheets by specifying indices, then setting properties for the specified object.

Example

This example creates a spreadsheet with three sheets, sets the second sheet to be the active sheet, changes the BackColor of the AlternatingRows, and makes the cells in the first column button cells.

FpSpread1.Sheets.Count=3;
FpSpread1.ActiveSheetViewIndex=1;
FpSpread1.ActiveSheetView.AlternatingRows[0].BackColor=Color.Yellow;
FpSpread1.ActiveSheetView.AlternatingRows[1].BackColor=Color.YellowGreen;
FpSpread1.ActiveSheetView.Cells[0,0].CellType=newFarPoint.Web.Spread.ButtonCellType();
FpSpread1.ActiveSheetView.Cells[1,0].CellType=newFarPoint.Web.Spread.ButtonCellType();
FpSpread1.ActiveSheetView.Cells[2,0].CellType=newFarPoint.Web.Spread.ButtonCellType();

Visual Basic

FpSpread1.Sheets.Count=3
FpSpread1.ActiveSheetViewIndex=1
FpSpread1.ActiveSheetView.AlternatingRows(0).BackColor=Color.Yellow
FpSpread1.ActiveSheetView.AlternatingRows(1).BackColor=Color.YellowGreen
FpSpread1.ActiveSheetView.Cells(0,0).CellType=NewFarPoint.Web.Spread.ButtonCellType()
FpSpread1.ActiveSheetView.Cells(1,0).CellType=NewFarPoint.Web.Spread.ButtonCellType()
FpSpread1.ActiveSheetView.Cells(2,0).CellType=NewFarPoint.Web.Spread.ButtonCellType()

Requirements

Target Platforms: Windows 7, Windows 8, Windows 10, Windows Vista, Windows Server 2003, Windows Server 2008, Windows Server 2012, Windows XP Professional

Reference

FpSpread Class
FpSpread Members
Cells Class

User-Task Documentation

Customizing the Colors of a Cell