[C#/WINFORM/SPREAD] 셀 스타일 설정하기

■ 셀 스타일을 설정하는 방법을 보여준다.

▶ 예제 코드 (C#)


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);
    }
}

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);

}