FarPoint.Win.Spread Assembly > FarPoint.Win.Spread Namespace > TableBorder Class > TableBorder Constructor : TableBorder Constructor(ComplexBorderSide,ComplexBorderSide,ComplexBorderSide,ComplexBorderSide,ComplexBorderSide,ComplexBorderSide) |
'Declaration Public Function New( _ ByVal left As ComplexBorderSide, _ ByVal top As ComplexBorderSide, _ ByVal right As ComplexBorderSide, _ ByVal bottom As ComplexBorderSide, _ ByVal vertical As ComplexBorderSide, _ ByVal horizontal As ComplexBorderSide _ )
'Usage Dim left As ComplexBorderSide Dim top As ComplexBorderSide Dim right As ComplexBorderSide Dim bottom As ComplexBorderSide Dim vertical As ComplexBorderSide Dim horizontal As ComplexBorderSide Dim instance As New TableBorder(left, top, right, bottom, vertical, horizontal)
public TableBorder( ComplexBorderSide left, ComplexBorderSide top, ComplexBorderSide right, ComplexBorderSide bottom, ComplexBorderSide vertical, ComplexBorderSide horizontal )
FarPoint.Win.ComplexBorderSide bside = new FarPoint.Win.ComplexBorderSide(Color.Yellow); FarPoint.Win.ComplexBorderSide bside1 = new FarPoint.Win.ComplexBorderSide(Color.Green); FarPoint.Win.ComplexBorderSide bside2 = new FarPoint.Win.ComplexBorderSide(Color.Red); FarPoint.Win.ComplexBorderSide bside3 = new FarPoint.Win.ComplexBorderSide(Color.Blue); FarPoint.Win.ComplexBorderSide bside4 = new FarPoint.Win.ComplexBorderSide(Color.Orange); FarPoint.Win.ComplexBorderSide bside5 = new FarPoint.Win.ComplexBorderSide(Color.Brown); FarPoint.Win.Spread.TableBorder tborder = new FarPoint.Win.Spread.TableBorder(bside, bside1, bside2, bside3, bside4, bside5); FarPoint.Win.Spread.TableElementStyle testyle = new FarPoint.Win.Spread.TableElementStyle(tborder, Color.White, Color.Black, FarPoint.Win.Spread.RegularBoldItalicFontStyle.Bold); FarPoint.Win.Spread.TableStyle tstyle = fpSpread1.CreateTableStyle("Style1", FarPoint.Win.Spread.TableStyle.TableStyleLight2); tstyle.FirstColumn = testyle; fpSpread1.Sheets[0].Cells[1, 1].Text = "Last Name"; fpSpread1.Sheets[0].Cells[1, 2].Text = "Value"; fpSpread1.Sheets[0].Cells[2, 1].Text = "Smith"; fpSpread1.Sheets[0].Cells[2, 2].Value = 50; fpSpread1.Sheets[0].Cells[3, 1].Text = "Vil"; fpSpread1.Sheets[0].Cells[3, 2].Value = 10; fpSpread1.Sheets[0].Cells[4, 1].Text = "Press"; fpSpread1.Sheets[0].Cells[4, 2].Value = 78; fpSpread1.TableStyleCollection.Add(tstyle); FarPoint.Win.Spread.TableView table = fpSpread1.Sheets[0].AddTable("table", 1, 1, 5, 2, "Style1"); table.FirstColumn = true;
Dim bside As New FarPoint.Win.ComplexBorderSide(Color.Yellow) Dim bside1 As New FarPoint.Win.ComplexBorderSide(Color.Green) Dim bside2 As New FarPoint.Win.ComplexBorderSide(Color.Red) Dim bside3 As New FarPoint.Win.ComplexBorderSide(Color.Blue) Dim bside4 As New FarPoint.Win.ComplexBorderSide(Color.Orange) Dim bside5 As New FarPoint.Win.ComplexBorderSide(Color.Brown) Dim tborder As New FarPoint.Win.Spread.TableBorder(bside, bside1, bside2, bside3, bside4, bside5) Dim testyle As New FarPoint.Win.Spread.TableElementStyle(tborder, Color.White, Color.Black, FarPoint.Win.Spread.RegularBoldItalicFontStyle.Bold) Dim tstyle As FarPoint.Win.Spread.TableStyle tstyle = FpSpread1.CreateTableStyle("Style1", FarPoint.Win.Spread.TableStyle.TableStyleLight2) tstyle.FirstColumn = testyle FpSpread1.Sheets(0).Cells(1, 1).Text = "Last Name" FpSpread1.Sheets(0).Cells(1, 2).Text = "Value" FpSpread1.Sheets(0).Cells(2, 1).Text = "Smith" FpSpread1.Sheets(0).Cells(2, 2).Value = 50 FpSpread1.Sheets(0).Cells(3, 1).Text = "Vil" FpSpread1.Sheets(0).Cells(3, 2).Value = 10 FpSpread1.Sheets(0).Cells(4, 1).Text = "Press" FpSpread1.Sheets(0).Cells(4, 2).Value = 78 FpSpread1.TableStyleCollection.Add(tstyle) Dim table As FarPoint.Win.Spread.TableView = FpSpread1.Sheets(0).AddTable("table", 1, 1, 5, 2, "Style1") table.FirstColumn = True
Target Platforms: Windows 2000 Professional (SP4), Windows 2000 Server, Windows 2003 Server (SP1), Windows Server 2012 R2, Windows 2008, Windows XP (SP2), Windows Vista, Windows 7, Windows 8, Windows 8.1, Windows 10