첨부 실행 코드는 나눔고딕코딩 폰트를 사용합니다.
유용한 소스 코드가 있으면 icodebroker@naver.com으로 보내주시면 감사합니다.
블로그 자료는 자유롭게 사용하세요.

■ 셀 색상 설정하기

----------------------------------------------------------------------------------------------------

 

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;

----------------------------------------------------------------------------------------------------

Posted by 사용자 icodebroker
TAG

댓글을 달아 주세요