Gets or sets the spanned cells for the sheet corner.
Syntax
| Visual Basic (Declaration) | |
|---|
Public Property SheetCornerSpanModel As ISheetSpanModel |
| Visual Basic (Usage) |  Copy Code |
|---|
Dim instance As SheetView
Dim value As ISheetSpanModel
instance.SheetCornerSpanModel = value
value = instance.SheetCornerSpanModel |
Example
This example sets the models for a sheet corner.
| C# | Copy Code |
|---|
FarPoint.Web.Spread.SheetView sv = new FarPoint.Web.Spread.SheetView;
FarPoint.Web.Spread.StyleInfo info = new FarPoint.Web.Spread.StyleInfo();
info.Border = new FarPoint.Web.Spread.Border(BorderStyle.Dotted, Color.Teal, 2);
sv.SheetCorner.ColumnCount = 3;
sv.SheetCorner.RowCount = 3;
sv.SheetCornerSpanModel.Add(0, 0, 2, 2);
sv.SheetCornerStyleModel.SetDirectInfo(0, 0, info);
sv.SheetCornerRowAxisModel.SetSize(0, 100);
sv.SheetCornerColumnAxisModel.SetSize(0, 100);
FpSpread1.Sheets.Add(sv);
ListBox1.Items.Add(sv.SheetCornerDataModel.ColumnCount.ToString());
ListBox1.Items.Add(sv.SheetCornerDataModel.RowCount.ToString());
ListBox1.Items.Add(sv.SheetCorner.ToString()); |
| Visual Basic | Copy Code |
|---|
Dim sv As New FarPoint.Web.Spread.SheetView
Dim info As New FarPoint.Web.Spread.StyleInfo()
info.Border = New FarPoint.Web.Spread.Border(BorderStyle.Dotted, System.Drawing.Color.Teal, 2)
sv.SheetCorner.ColumnCount = 3
sv.SheetCorner.RowCount = 3
sv.SheetCornerSpanModel.Add(0, 0, 2, 2)
sv.SheetCornerStyleModel.SetDirectInfo(0, 0, info)
sv.SheetCornerRowAxisModel.SetSize(0, 100)
sv.SheetCornerColumnAxisModel.SetSize(0, 100)
FpSpread1.Sheets.Add(sv)
ListBox1.Items.Add(sv.SheetCornerDataModel.ColumnCount.ToString())
ListBox1.Items.Add(sv.SheetCornerDataModel.RowCount.ToString())
ListBox1.Items.Add(sv.SheetCorner.ToString()) |
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
