PowerTools SPREAD for Windows Forms 8.0J
ResetBorder メソッド (AlternatingRow)


この行のセル罫線をリセットし、デフォルト行からセル罫線を継承します。
構文
'Declaration
 
Public Sub ResetBorder() 
'使用法
 
Dim instance As AlternatingRow
 
instance.ResetBorder()
public void ResetBorder()
次のサンプルコードでは、このメソッド(およびその他のリセットメソッド)を使用して、交互行プロパティをリセットしています。
fpSpread1.ActiveSheet.AlternatingRows[0].BackColor = Color.LightBlue;
fpSpread1.ActiveSheet.AlternatingRows[0].Border = new FarPoint.Win.LineBorder(Color.DarkBlue);
fpSpread1.ActiveSheet.AlternatingRows[0].CellType = new FarPoint.Win.Spread.CellType.GeneralCellType();
fpSpread1.ActiveSheet.AlternatingRows[0].Font = new Font("Comic Sans MS", 10);
fpSpread1.ActiveSheet.AlternatingRows[0].ForeColor = Color.Red;
fpSpread1.ActiveSheet.AlternatingRows[0].HorizontalAlignment = FarPoint.Win.Spread.CellHorizontalAlignment.Right;
fpSpread1.ActiveSheet.AlternatingRows[0].Locked = false;
fpSpread1.ActiveSheet.AlternatingRows[0].VerticalAlignment = FarPoint.Win.Spread.CellVerticalAlignment.Topn

private void button1Click(object sender, System.EventArgs e)
{
     DialogResult dlg = new DialogResult();
     dlg = MessageBox.Show("Reset the AlternatingRow??", "Reset", MessageBoxButtons.OKCancel);
     if (dlg == DialogResult.OK)
     {
          fpSpread1.ActiveSheet.AlternatingRows[0].ResetBackColor();
          fpSpread1.ActiveSheet.AlternatingRows[0].ResetBorder();
          fpSpread1.ActiveSheet.AlternatingRows[0].ResetCellType();
          fpSpread1.ActiveSheet.AlternatingRows[0].ResetFont();
          fpSpread1.ActiveSheet.AlternatingRows[0].ResetForeColor();
          fpSpread1.ActiveSheet.AlternatingRows[0].ResetHorizontalAlignment();
          fpSpread1.ActiveSheet.AlternatingRows[0].ResetLocked();
          fpSpread1.ActiveSheet.AlternatingRows[0].ResetVerticalAlignment();
     }
}
FpSpread1.ActiveSheet.AlternatingRows(0).BackColor = Color.LightBlue
FpSpread1.ActiveSheet.AlternatingRows(0).Border = New FarPoint.Win.LineBorder(Color.DarkBlue)
FpSpread1.ActiveSheet.AlternatingRows(0).CellType = New FarPoint.Win.Spread.CellType.GeneralCellType
FpSpread1.ActiveSheet.AlternatingRows(0).Font = New Font("Comic Sans MS", 10)
FpSpread1.ActiveSheet.AlternatingRows(0).ForeColor = Color.Red
FpSpread1.ActiveSheet.AlternatingRows(0).HorizontalAlignment = FarPoint.Win.Spread.CellHorizontalAlignment.Right
FpSpread1.ActiveSheet.AlternatingRows(0).Locked = False
FpSpread1.ActiveSheet.AlternatingRows(0).VerticalAlignment = FarPoint.Win.Spread.CellVerticalAlignment.Top

Private Sub Button1Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
     Dim dlg As New DialogResult
     dlg = MessageBox.Show("Reset the AlternatingRow??", "Reset", MessageBoxButtons.OKCancel)
     If dlg = DialogResult.OK Then
          FpSpread1.ActiveSheet.AlternatingRows(0).ResetBackColor()
          FpSpread1.ActiveSheet.AlternatingRows(0).ResetBorder()
          FpSpread1.ActiveSheet.AlternatingRows(0).ResetCellType()
          FpSpread1.ActiveSheet.AlternatingRows(0).ResetFont()
          FpSpread1.ActiveSheet.AlternatingRows(0).ResetForeColor()
          FpSpread1.ActiveSheet.AlternatingRows(0).ResetHorizontalAlignment()
          FpSpread1.ActiveSheet.AlternatingRows(0).ResetLocked()
          FpSpread1.ActiveSheet.AlternatingRows(0).ResetVerticalAlignment()
     End If
End Sub
参照

AlternatingRow クラス
AlternatingRow メンバ

 

 


© 2004-2015, GrapeCity inc. All rights reserved.