SetStyleInfo Method

Sets the style for a cell, a column, a row, or an entire sheet.

Syntax

Visual Basic
C#

'Declaration
 
Public Overridable Sub SetStyleInfo( _
   ByVal row As Integer, _
   ByVal column As Integer, _
   ByVal info As StyleInfo _
)

'Usage
 
Dim instance As SheetView
Dim row As Integer
Dim column As Integer
Dim info As StyleInfo
 
instance.SetStyleInfo(row, column, info)

public virtual void SetStyleInfo( 
   int row,
   int column,
   StyleInfo info
)

Parameters

row: Row index
column: Column index
info: StyleInfo object

Example

This example illustrates the use of this member by returning the StyleInfo for the specified cell.

FarPoint.Win.Spread.StyleInfo si = new FarPoint.Win.Spread.StyleInfo();
FarPoint.Win.Spread.StyleInfo si2;
si.BackColor = Color.LightBlue;
fpSpread1.ActiveSheet.SetStyleInfo(0, 0, si);
si2 = fpSpread1.ActiveSheet.GetStyleInfo(0, 0);
listBox1.Items.Add(si2.BackColor.ToString());

Visual Basic

Dim si As New FarPoint.Win.Spread.StyleInfo()
Dim si2 As FarPoint.Win.Spread.StyleInfo
si.BackColor = Color.LightBlue
FpSpread1.ActiveSheet.SetStyleInfo(0, 0, si)
si2 = FpSpread1.ActiveSheet.GetStyleInfo(0, 0)
ListBox1.Items.Add(si2.BackColor.ToString())

Requirements

Target Platforms: Windows 2000 Professional (SP4), Windows 2000 Server, Windows 2003 Server (SP1), Windows 2008, Windows XP (SP2), Windows Vista, Windows 7, Windows 8

Reference

SheetView Class
SheetView Members
StyleInfo Class

User-Task Documentation

Creating and Applying a Style for Cells