SetDirectName Method (DefaultSheetStyleModel)

In This Topic

Sets the name of the direct style for the specified cell, column, row, or model default to the specified style name.

Syntax

Visual Basic
C#

'Declaration
 
Public Overridable Sub SetDirectName( _
   ByVal row As Integer, _
   ByVal column As Integer, _
   ByVal styleName As String _
)

'Usage
 
Dim instance As DefaultSheetStyleModel
Dim row As Integer
Dim column As Integer
Dim styleName As String
 
instance.SetDirectName(row, column, styleName)

public virtual void SetDirectName( 
   int row,
   int column,
   string 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#
Visual Basic

private void Page_Load(object sender,System.EventArgs e)
{
if(this.IsPostBack)return;

FarPoint.Web.Spread.Model.DefaultSheetStyleModel model=(FarPoint.Web.Spread.Model.DefaultSheetStyleModel)FpSpread1.Sheets[0].StyleModel;
FarPoint.Web.Spread.NamedStyle style=new FarPoint.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));
}

Private Sub Page_Load(ByVal sender As System.Object,ByVal e As System.EventArgs)Handles MyBase.Load
If(IsPostBack)Then Return

Dim model As FarPoint.Web.Spread.Model.DefaultSheetStyleModel=FpSpread1.Sheets(0).StyleModel
Dim style As New FarPoint.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))
End Sub

Reference

DefaultSheetStyleModel Class
DefaultSheetStyleModel Members
GetDirectAltRowName Method
GetDirectName Method
SetDirectAltRowName Method
NamedStyles Property