Syntax
| Visual Basic (Declaration) | |
|---|---|
Public Overridable Sub SetDirectName( _ ByVal row As Integer, _ ByVal column As Integer, _ ByVal styleName As String _ ) | |
| Visual Basic (Usage) |  Copy Code |
|---|---|
Dim instance As DefaultSheetStyleModel Dim row As Integer Dim column As Integer Dim styleName As String instance.SetDirectName(row, column, styleName) | |
Parameters
- row
- Model row index of the cell, or -1 to specify a column or model default
- column
- Model column index of the cell, or -1 to specify a row or model default
- styleName
- Name of the style to set
Exceptions
| Exception | Description |
|---|---|
| System.IndexOutOfRangeException | Specified row index is not valid; must be between -1 and the total number of rows |
| System.IndexOutOfRangeException | Specified column index is not valid; must be between -1 and the total number of columns |
Remarks
Direct cell styles override direct row styles, which override direct column styles, which override model default styles. Direct row styles use -1 for the column, direct column styles use -1 for the row, and model default styles use -1 for both the row and column.
Example
This example creates a new NamedStyle object. The background color of the NamedStyle is set to yellow and the Name is set to "Yellow Cell". The value from the GetDirectName method is returned to a list box.
| C# | Copy Code |
|---|---|
privatevoidPage_Load(objectsender,System.EventArgse)
{
if(this.IsPostBack)return;
FarPoint.Web.Spread.Model.DefaultSheetStyleModelmodel=(FarPoint.Web.Spread.Model.DefaultSheetStyleModel)FpSpread1.Sheets[0].StyleModel;
FarPoint.Web.Spread.NamedStylestyle=newFarPoint.Web.Spread.NamedStyle();
style.Name="YellowCell";
style.BackColor=Color.Yellow;
FpSpread1.NamedStyles.Add(style);
model.SetDirectName(0,0,"YellowCell");
ListBox1.Items.Add(model.GetDirectName(0,0));
} | |
| Visual Basic | Copy Code |
|---|---|
PrivateSubPage_Load(ByValsenderAsSystem.Object,ByValeAsSystem.EventArgs)HandlesMyBase.Load If(IsPostBack)ThenReturn DimmodelAsFarPoint.Web.Spread.Model.DefaultSheetStyleModel=FpSpread1.Sheets(0).StyleModel DimstyleAsNewFarPoint.Web.Spread.NamedStyle() style.Name="YellowCell" style.BackColor=Color.Yellow FpSpread1.NamedStyles.Add(style) model.SetDirectName(0,0,"YellowCell") ListBox1.Items.Add(model.GetDirectName(0,0)) EndSub | |
Requirements
Target Platforms: Windows 98, Windows NT 4.0, Windows Millennium Edition, Windows 2000, Windows XP Home Edition, Windows XP Professional, Windows Server 2003 family, Windows Vista, Windows Server 2008 family