指定したセル範囲の外側と内側の罫線を引く方法はありますか?
対象製品
SPREAD for .NET Windows Forms Edition
詳細
CellRangeクラスにてセル範囲を指定し、SheetViewクラスより提供されているSetOutlineBorderメソッドおよびSetInsideBorderメソッドを呼び出すことで容易に設定することが出来ます。
◎サンプルコード(VB)
◎サンプルコード(C#)
◎サンプルコード(VB)
Imports FarPoint.Win
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim cr As New FarPoint.Win.Spread.Model.CellRange(1, 1, 3, 3)
Dim cbs1 As New ComplexBorderSide(ComplexBorderSideStyle.DashDot)
Dim cbs2 As New ComplexBorderSide(ComplexBorderSideStyle.DoubleLine)
Dim cbs3 As New ComplexBorderSide(ComplexBorderSideStyle.SlantedDashDot)
Dim cbs4 As New ComplexBorderSide(ComplexBorderSideStyle.MediumDashed)
Dim cbs5 As New ComplexBorderSide(ComplexBorderSideStyle.DashDotDot, Color.Red)
Dim cbs6 As New ComplexBorderSide(ComplexBorderSideStyle.DashDotDot, Color.Blue)
Dim cb1 As New ComplexBorder(cbs1, cbs2, cbs3, cbs4)
Dim cb2 As New ComplexBorder(cbs5, cbs6, Nothing, Nothing)
FpSpread1.ActiveSheet.SetOutlineBorder(cr, cb1)
FpSpread1.ActiveSheet.SetInsideBorder(cr, cb2)
End Sub
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim cr As New FarPoint.Win.Spread.Model.CellRange(1, 1, 3, 3)
Dim cbs1 As New ComplexBorderSide(ComplexBorderSideStyle.DashDot)
Dim cbs2 As New ComplexBorderSide(ComplexBorderSideStyle.DoubleLine)
Dim cbs3 As New ComplexBorderSide(ComplexBorderSideStyle.SlantedDashDot)
Dim cbs4 As New ComplexBorderSide(ComplexBorderSideStyle.MediumDashed)
Dim cbs5 As New ComplexBorderSide(ComplexBorderSideStyle.DashDotDot, Color.Red)
Dim cbs6 As New ComplexBorderSide(ComplexBorderSideStyle.DashDotDot, Color.Blue)
Dim cb1 As New ComplexBorder(cbs1, cbs2, cbs3, cbs4)
Dim cb2 As New ComplexBorder(cbs5, cbs6, Nothing, Nothing)
FpSpread1.ActiveSheet.SetOutlineBorder(cr, cb1)
FpSpread1.ActiveSheet.SetInsideBorder(cr, cb2)
End Sub
◎サンプルコード(C#)
using FarPoint.Win;
private void button1_Click(object sender, System.EventArgs e)
{
FarPoint.Win.Spread.Model.CellRange cr = new FarPoint.Win.Spread.Model.CellRange(1, 1, 3, 3);
ComplexBorderSide cbs1 = new ComplexBorderSide(ComplexBorderSideStyle.DashDot);
ComplexBorderSide cbs2 = new ComplexBorderSide(ComplexBorderSideStyle.DoubleLine);
ComplexBorderSide cbs3 = new ComplexBorderSide(ComplexBorderSideStyle.SlantedDashDot);
ComplexBorderSide cbs4 = new ComplexBorderSide(ComplexBorderSideStyle.MediumDashed);
ComplexBorderSide cbs5 = new ComplexBorderSide(ComplexBorderSideStyle.DashDotDot, Color.Red);
ComplexBorderSide cbs6 = new ComplexBorderSide(ComplexBorderSideStyle.DashDotDot, Color.Blue);
ComplexBorder cb1 = new ComplexBorder(cbs1, cbs2, cbs3, cbs4);
ComplexBorder cb2 = new ComplexBorder(cbs5, cbs6, null, null);
fpSpread1.ActiveSheet.SetOutlineBorder(cr, cb1);
fpSpread1.ActiveSheet.SetInsideBorder(cr, cb2);
}
private void button1_Click(object sender, System.EventArgs e)
{
FarPoint.Win.Spread.Model.CellRange cr = new FarPoint.Win.Spread.Model.CellRange(1, 1, 3, 3);
ComplexBorderSide cbs1 = new ComplexBorderSide(ComplexBorderSideStyle.DashDot);
ComplexBorderSide cbs2 = new ComplexBorderSide(ComplexBorderSideStyle.DoubleLine);
ComplexBorderSide cbs3 = new ComplexBorderSide(ComplexBorderSideStyle.SlantedDashDot);
ComplexBorderSide cbs4 = new ComplexBorderSide(ComplexBorderSideStyle.MediumDashed);
ComplexBorderSide cbs5 = new ComplexBorderSide(ComplexBorderSideStyle.DashDotDot, Color.Red);
ComplexBorderSide cbs6 = new ComplexBorderSide(ComplexBorderSideStyle.DashDotDot, Color.Blue);
ComplexBorder cb1 = new ComplexBorder(cbs1, cbs2, cbs3, cbs4);
ComplexBorder cb2 = new ComplexBorder(cbs5, cbs6, null, null);
fpSpread1.ActiveSheet.SetOutlineBorder(cr, cb1);
fpSpread1.ActiveSheet.SetInsideBorder(cr, cb2);
}
関連情報
キーワード
外観
この文書は、以前は次のFAQ IDで公開されていました : 6139