Syntax
| Visual Basic (Declaration) | |
|---|---|
Public Overridable Sub SetStyleInfo( _ ByVal row As Integer, _ ByVal column As Integer, _ ByVal info As StyleInfo _ ) | |
| Visual Basic (Usage) |  Copy Code |
|---|---|
Dim instance As SheetView Dim row As Integer Dim column As Integer Dim info As StyleInfo instance.SetStyleInfo(row, column, 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.
| C# | Copy Code |
|---|---|
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 | Copy Code |
|---|---|
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 ClassSheetView Members
GetStyleInfo Method