Gets or sets the spanned cells for the row header.
Syntax
| Visual Basic (Declaration) | |
|---|
Public Property RowHeaderSpanModel As ISheetSpanModel |
| Visual Basic (Usage) |  Copy Code |
|---|
Dim instance As SheetView
Dim value As ISheetSpanModel
instance.RowHeaderSpanModel = value
value = instance.RowHeaderSpanModel |
Property Value
ISheetSpanModel object containing the spanned cells
Remarks
Example
This example assignes a SheetView object to the active sheet, adds three columns to the row headers, adds a span and sets the size of the first column of headers. A border is also placed around the spanned headers.
| C# | Copy Code |
|---|
FarPoint.Web.Spread.SheetView sv=FpSpread1.ActiveSheetView;
FarPoint.Web.Spread.StyleInfo info=new FarPoint.Web.Spread.StyleInfo();
info.Border=new FarPoint.Web.Spread.Border(BorderStyle.Dotted,Color.Teal,2);
sv.PageSize=10;
sv.RowCount=10;
sv.RowHeader.ColumnCount=3;
sv.RowHeaderSpanModel.Add(0,0,2,2);
sv.RowHeaderStyleModel.SetDirectInfo(0,0,info);
sv.RowHeaderColumnAxisModel.SetSize(0,50); |
| Visual Basic | Copy Code |
|---|
Dim sv As FarPoint.Web.Spread.SheetView
Dim info As New FarPoint.Web.Spread.StyleInfo()
info.Border=New FarPoint.Web.Spread.Border(BorderStyle.Dotted,Color.Teal,2)
sv=FpSpread1.ActiveSheetView
sv.PageSize=10
sv.RowCount=10
sv.RowHeader.ColumnCount=3
sv.RowHeaderSpanModel.Add(0,0,2,2)
sv.RowHeaderStyleModel.SetDirectInfo(0,0,info)
sv.RowHeaderColumnAxisModel.SetSize(0,50) |
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
