MESCIUS SPREAD for Windows Forms 15.0J サンプルコード集
デフォルトスタイルを設定する

SheetViewクラスのDefaultStyleプロパティ(StyleInfo)を利用することで、シート全体のデフォルトスタイルを設定できます。これは、シート上の全てのセルに対して同一スタイルを設定したいような場合に有効な手法です。

【実行例】

デフォルトスタイル

 private void Form1_Load(object sender, System.EventArgs e)
 {

   fpSpread1.ActiveSheet.RowCount = 5;
   fpSpread1.ActiveSheet.ColumnCount = 5;

   //各デフォルトスタイルを設定します
   fpSpread1.ActiveSheet.DefaultStyle.BackColor = Color.LemonChiffon;
   fpSpread1.ActiveSheet.DefaultStyle.ForeColor = Color.Red;
   fpSpread1.ActiveSheet.DefaultStyle.CellType = new FarPoint.Win.Spread.CellType.NumberCellType();
   fpSpread1.ActiveSheet.DefaultStyle.HorizontalAlignment = FarPoint.Win.Spread.CellHorizontalAlignment.Center;
   fpSpread1.ActiveSheet.DefaultStyle.Border = new FarPoint.Win.LineBorder(Color.Green);

   for (int i = 0; i < fpSpread1.ActiveSheet.RowCount; i++)
   {
      for (int j = 0; j < fpSpread1.ActiveSheet.ColumnCount; j++)
      {
         fpSpread1.ActiveSheet.SetValue(i, j, i + j);
      }
   }

 }
 Private Sub Form1_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles MyBase.Load

   FpSpread1.ActiveSheet.RowCount = 5
   FpSpread1.ActiveSheet.ColumnCount = 5

   '各デフォルトスタイルを設定します
   FpSpread1.ActiveSheet.DefaultStyle.BackColor = Color.LemonChiffon
   FpSpread1.ActiveSheet.DefaultStyle.ForeColor = Color.Red
   FpSpread1.ActiveSheet.DefaultStyle.CellType = New FarPoint.Win.Spread.CellType.NumberCellType
   FpSpread1.ActiveSheet.DefaultStyle.HorizontalAlignment = FarPoint.Win.Spread.CellHorizontalAlignment.Center
   FpSpread1.ActiveSheet.DefaultStyle.Border = New FarPoint.Win.LineBorder(Color.Green)

   For i As Integer = 0 To FpSpread1.ActiveSheet.RowCount - 1
      For j As Integer = 0 To FpSpread1.ActiveSheet.ColumnCount - 1
         FpSpread1.ActiveSheet.SetValue(i, j, i + j)
      Next
   Next

 End Sub

 

 


© MESCIUS inc. All rights reserved.