Style Property (CellRange)

Gets or sets the style used to display every cell in the range.

Syntax

Visual Basic
C#
C++/CLI

'Declaration
 
Public Property Style As CellStyle

'Usage
 
Dim instance As CellRange
Dim value As CellStyle
 
instance.Style = value
 
value = instance.Style

public CellStyle Style {get; set;}

public:
property CellStyle^ Style {
   CellStyle^ get();
   void set (    CellStyle^ value);
}

Remarks

Getting or setting the range style ensures that every cell in the range has the same style. If the range does not contain any cells with custom styles, this property returns null.

Example

The code below creates a CellRange structure and uses it to apply a custom style to the entire range.

// create a style
CellStyle cs = _flex.Styles.Add("red");
cs.BackColor = Color.Red;
            
// create a cell range and assign it a style
CellRange rg = _flex.GetCellRange(1, 1, 5, 5);
rg.Style = cs;

Requirements

Target Platforms: Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2

Reference

CellRange Structure
CellRange Members