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 with cell style settings

Remarks

Use this method to specify the cell style for a cell, a column, a row, or the entire sheet. Set the column and row parameters as follows to set the style:

To set the style for a . . .	col setting	row setting
Cell	Column index	Row index
Column	Column index	-1
Row	-1	Row index
Sheet	-1	-1

Use the GetStyleInfo method to return the style for a cell.

Example

This example illustrates the use of this member by setting the style for the specified cell.

FarPoint.Web.Spread.SheetView sv;
FarPoint.Web.Spread.StyleInfo si = new FarPoint.Web.Spread.StyleInfo();
si.Border = New FarPoint.Web.Spread.Border(BorderStyle.Dotted, Color.Red);
sv = FpSpread1.ActiveSheetView;
sv.SetStyleInfo(0, 0, si);

Visual Basic

Dim sv As FarPoint.Web.Spread.SheetView
Dim si As New FarPoint.Web.Spread.StyleInfo
si.Border = New FarPoint.Web.Spread.Border(BorderStyle.Dotted, Color.Red)
sv = FpSpread1.ActiveSheetView
sv.SetStyleInfo(0, 0, si)

Requirements

Target Platforms: Windows 7, Windows 8, Windows Vista, Windows Server 2000, Windows 2000 Professional, Windows XP Professional, Windows NT 4.0 Workstation, SP6, Windows NT 4.0 Server, SP6

Reference

SheetView Class
SheetView Members
GetStyleInfo Method

User-Task Documentation

Styles for Cells