FarPoint.Web.Spread Assembly > FarPoint.Web.Spread.Model Namespace > DefaultSheetStyleModel Class : GetDirectInfo Method |
'Declaration Public Overrides Function GetDirectInfo( _ ByVal row As Integer, _ ByVal column As Integer, _ ByVal destInfo As StyleInfo _ ) As StyleInfo
'Usage Dim instance As DefaultSheetStyleModel Dim row As Integer Dim column As Integer Dim destInfo As StyleInfo Dim value As StyleInfo value = instance.GetDirectInfo(row, column, destInfo)
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 |
Spread uses a composite of style settings to paint the spreadsheet. For example, for a cell, the component looks at the style settings for the column and row for the cell, and the cell's own settings.
Use this method to get the direct settings for the specified object. Use the SetDirectInfo methods to set the direct settings for an object.
Direct cell styles override direct row styles, which override direct column styles, which override model default styles.
To return the composite information for an object, use the GetCompositeInfo method.
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.StyleInfo style=new FarPoint.Web.Spread.StyleInfo(); style.BackColor=Color.Yellow; model.SetDirectInfo(0,0,style); ListBox1.Items.Add(model.GetDirectInfo(0,0,style).BackColor.ToString()); }
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.StyleInfo() style.BackColor=Color.Yellow model.SetDirectInfo(0,0,style) ListBox1.Items.Add(model.GetDirectInfo(0,0,style).BackColor.ToString()) End Sub
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