■ 셀 색상을 설정하는 방법을 보여준다.
▶ 예제 코드 (C#)
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 |
fpSpread1.ActiveSheet.Cells[0, 1].Value = "This is default."; fpSpread1.ActiveSheet.Cells[1, 1].Value = "This is custom."; fpSpread1.ActiveSheet.Cells[2, 1].Value = "This is locked."; fpSpread1.ActiveSheet.Cells[3, 1].Value = "This is selected."; fpSpread1.ActiveSheet.Cells[1, 1].BackColor = Color.LimeGreen; fpSpread1.ActiveSheet.Cells[1, 1].ForeColor = Color.Yellow; fpSpread1.ActiveSheet.Cells[2, 1].Locked = true; fpSpread1.ActiveSheet.Protect = true; fpSpread1.ActiveSheet.LockBackColor = Color.Brown; fpSpread1.ActiveSheet.LockForeColor = Color.Orange; fpSpread1.ActiveSheet.SelectionStyle = FarPoint.Win.Spread.SelectionStyles.SelectionColors; fpSpread1.ActiveSheet.SelectionPolicy = FarPoint.Win.Spread.Model.SelectionPolicy.Range; fpSpread1.ActiveSheet.SelectionUnit = FarPoint.Win.Spread.Model.SelectionUnit.Cell; fpSpread1.ActiveSheet.SelectionBackColor = Color.Pink; fpSpread1.ActiveSheet.SelectionForeColor = Color.Red; |