Gets or sets the spanned cells for the column header.
Syntax
| Visual Basic (Declaration) | |
|---|
Public Property ColumnHeaderSpanModel As ISheetSpanModel |
| Visual Basic (Usage) |  Copy Code |
|---|
Dim instance As SheetView
Dim value As ISheetSpanModel
instance.ColumnHeaderSpanModel = value
value = instance.ColumnHeaderSpanModel |
Property Value
ISheetSpanModel object containing the spanned cells
Remarks
Example
This example sets the sheet to have three rows of column headers, adds a span to the rows and sets the size of the first row 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.ColumnHeader.RowCount = 3;
sv.ColumnHeaderSpanModel.Add(0, 0, 2, 2);
sv.ColumnHeaderStyleModel.SetDirectInfo(0, 0, info);
sv.ColumnHeaderRowAxisModel.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.ColumnHeader.RowCount = 3
sv.ColumnHeaderSpanModel.Add(0, 0, 2, 2)
sv.ColumnHeaderStyleModel.SetDirectInfo(0, 0, info)
sv.ColumnHeaderRowAxisModel.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
