Spread for ASP.NET 8.0 Product Documentation
SetStyleInfo Method
Example 


Row index
Column index
StyleInfo object with cell style settings
Sets the style for a cell, a column, a row, or an entire sheet.
Syntax
'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);
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

See Also

Reference

SheetView Class
SheetView Members
GetStyleInfo Method

User-Task Documentation

Styles for Cells

 

 


Copyright © GrapeCity, inc. All rights reserved.