作成日: 2017/02/16 最終更新日: 2017/02/16
文書種別
使用方法
詳細
複合罫線(ComplexBorder)を使用すると、セル内の斜めの辺に罫線を表示することができます。
◎サンプルコード(VB)
◎サンプルコード(C#)
◎サンプルコード(VB)
Private Sub Form1_Load(sender As Object, e As EventArgs) Handles MyBase.Load
' 斜め罫線(左上から右下)の設定
Dim diagonalborder1 As New FarPoint.Win.ComplexBorderSide(Color.Blue, 2, System.Drawing.Drawing2D.DashStyle.Solid)
FpSpread1.ActiveSheet.Cells(4, 4).Border = New FarPoint.Win.ComplexBorder(Nothing, Nothing, Nothing, Nothing, diagonalborder1, False, True)
' 斜め罫線(左下から右上)の設定
Dim diagonalborder2 As New FarPoint.Win.ComplexBorderSide(Color.Green, 2, System.Drawing.Drawing2D.DashStyle.Dash)
FpSpread1.ActiveSheet.Cells(4, 5).Border = New FarPoint.Win.ComplexBorder(Nothing, Nothing, Nothing, Nothing, diagonalborder2, True, False)
' 斜め罫線(両対角線)の設定
Dim diagonalborder3 As New FarPoint.Win.ComplexBorderSide(Color.Gray, 2, System.Drawing.Drawing2D.DashStyle.Dot)
FpSpread1.ActiveSheet.Cells(4, 6).Border = New FarPoint.Win.ComplexBorder(Nothing, Nothing, Nothing, Nothing, diagonalborder3, True, True)
End Sub
' 斜め罫線(左上から右下)の設定
Dim diagonalborder1 As New FarPoint.Win.ComplexBorderSide(Color.Blue, 2, System.Drawing.Drawing2D.DashStyle.Solid)
FpSpread1.ActiveSheet.Cells(4, 4).Border = New FarPoint.Win.ComplexBorder(Nothing, Nothing, Nothing, Nothing, diagonalborder1, False, True)
' 斜め罫線(左下から右上)の設定
Dim diagonalborder2 As New FarPoint.Win.ComplexBorderSide(Color.Green, 2, System.Drawing.Drawing2D.DashStyle.Dash)
FpSpread1.ActiveSheet.Cells(4, 5).Border = New FarPoint.Win.ComplexBorder(Nothing, Nothing, Nothing, Nothing, diagonalborder2, True, False)
' 斜め罫線(両対角線)の設定
Dim diagonalborder3 As New FarPoint.Win.ComplexBorderSide(Color.Gray, 2, System.Drawing.Drawing2D.DashStyle.Dot)
FpSpread1.ActiveSheet.Cells(4, 6).Border = New FarPoint.Win.ComplexBorder(Nothing, Nothing, Nothing, Nothing, diagonalborder3, True, True)
End Sub
◎サンプルコード(C#)
private void Form1_Load(object sender, EventArgs e)
{
// 斜め罫線(左上から右下)の設定
FarPoint.Win.ComplexBorderSide diagonalborder1 = new FarPoint.Win.ComplexBorderSide(Color.Blue, 2, System.Drawing.Drawing2D.DashStyle.Solid);
fpSpread1.ActiveSheet.Cells[4, 4].Border = new FarPoint.Win.ComplexBorder(null, null, null, null, diagonalborder1, false, true);
// 斜め罫線(左下から右上)の設定
FarPoint.Win.ComplexBorderSide diagonalborder2 = new FarPoint.Win.ComplexBorderSide(Color.Green, 2, System.Drawing.Drawing2D.DashStyle.Dash);
fpSpread1.ActiveSheet.Cells[4, 5].Border = new FarPoint.Win.ComplexBorder(null, null, null, null, diagonalborder2, true, false);
// 斜め罫線(両対角線)の設定
FarPoint.Win.ComplexBorderSide diagonalborder3 = new FarPoint.Win.ComplexBorderSide(Color.Gray, 2, System.Drawing.Drawing2D.DashStyle.Dot);
fpSpread1.ActiveSheet.Cells[4, 6].Border = new FarPoint.Win.ComplexBorder(null, null, null, null, diagonalborder3, true, true);
}
{
// 斜め罫線(左上から右下)の設定
FarPoint.Win.ComplexBorderSide diagonalborder1 = new FarPoint.Win.ComplexBorderSide(Color.Blue, 2, System.Drawing.Drawing2D.DashStyle.Solid);
fpSpread1.ActiveSheet.Cells[4, 4].Border = new FarPoint.Win.ComplexBorder(null, null, null, null, diagonalborder1, false, true);
// 斜め罫線(左下から右上)の設定
FarPoint.Win.ComplexBorderSide diagonalborder2 = new FarPoint.Win.ComplexBorderSide(Color.Green, 2, System.Drawing.Drawing2D.DashStyle.Dash);
fpSpread1.ActiveSheet.Cells[4, 5].Border = new FarPoint.Win.ComplexBorder(null, null, null, null, diagonalborder2, true, false);
// 斜め罫線(両対角線)の設定
FarPoint.Win.ComplexBorderSide diagonalborder3 = new FarPoint.Win.ComplexBorderSide(Color.Gray, 2, System.Drawing.Drawing2D.DashStyle.Dot);
fpSpread1.ActiveSheet.Cells[4, 6].Border = new FarPoint.Win.ComplexBorder(null, null, null, null, diagonalborder3, true, true);
}
旧文書番号
39979