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.SheetViewsv=FpSpread1.ActiveSheetView;
FarPoint.Web.Spread.StyleInfoinfo=NewFarPoint.Web.Spread.StyleInfo();
info.Border=NewFarPoint.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 |
|---|
DimsvAsFarPoint.Web.Spread.SheetView
DiminfoAsNewFarPoint.Web.Spread.StyleInfo()
info.Border=NewFarPoint.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 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
See Also
