Column Header의 Label 변경
this.fpSpread1_Sheet1.ColumnHeader.Cells.Get(0, 1).Value = "상태";
this.fpSpread1_Sheet1.ColumnHeader.Cells.Get(0, 2).Value = "기관코드";
this.fpSpread1_Sheet1.ColumnHeader.Cells.Get(0, 3).Value = "기관명";
Column의 폭(width) 설정
this.fpSpread1_Sheet1.Columns.Get(0).Width = 48F;
Column의 값을 사용자가 수정하지 못하도록 설정
this.fpSpread1_Sheet1.Columns.Get(1).Locked = true;
특정 Column에 속한 Cell Value의 정렬
this.fpSpread1_Sheet1.Columns.Get(6).VerticalAlignment = FarPoint.Win.Spread.CellVerticalAlignment.Center;
this.fpSpread1_Sheet1.Columns.Get(7).HorizontalAlignment = FarPoint.Win.Spread.CellHorizontalAlignment.Left;
Column Hidden 처리
this.fpSpread1_Sheet1.Columns.Get(9).Visible = false;
Row Header Hidden 처리
_fpUserList.RowHeader.Visible = false;
Column의 Size 변경 불가
_ActiveSheet.ColumnHeader.Columns.Default.Resizable = false;Column Header를 눌렀을때 Sorting
_fpHoldOrgList.Columns.Get(SP_HOLD_ORG_LIST_HOLD_ORG_ID, SP_HOLD_ORG_LIST_FOLDER).AllowAutoSort = true;CheckBox 사용
FarPoint.Win.Spread.CellType.CheckBoxCellType checkBoxCellType6 = new FarPoint.Win.Spread.CellType.CheckBoxCellType();
this.fpSpread1_Sheet1.Columns.Get(8).CellType = checkBoxCellType6;
댓글 없음:
댓글 쓰기