JavaScript
const spread = new GC.Spread.Sheets.Workbook(document.getElementById('spreadContainer'));
const sheet = spread.getActiveSheet();
spread.options.tabStripVisible = false;
// 헤더
const headers = ['항목', '처리 버튼', '완료 여부', '담당자'];
headers.forEach((h, c) => {
sheet.setValue(0, c, h);
sheet.getCell(0, c).backColor('#1565C0').foreColor('#fff').font('bold 13px sans-serif').hAlign(1);
sheet.setColumnWidth(c, c === 0 ? 120 : c === 1 ? 110 : 90);
});
sheet.setRowHeight(0, 36);
const items = ['계약서 검토', '견적 승인', '납품 확인', '청구서 발송'];
items.forEach((item, r) => {
sheet.setValue(r + 1, 0, item);
// ButtonCellType
const btn = new GC.Spread.Sheets.CellTypes.Button();
btn.text('처리');
btn.buttonBackColor('#1976D2');
btn.marginLeft(8); btn.marginRight(8);
sheet.setCellType(r + 1, 1, btn);
// CheckBoxCellType
const chk = new GC.Spread.Sheets.CellTypes.CheckBox();
chk.textTrue('완료'); chk.textFalse('대기');
sheet.setCellType(r + 1, 2, chk);
sheet.setValue(r + 1, 2, r < 2);
sheet.setValue(r + 1, 3, ['김민준', '이서연', '박지호', '최유진'][r]);
sheet.setRowHeight(r + 1, 34);
});
// ButtonClicked 이벤트 — Button, CheckBox 공통
spread.bind(GC.Spread.Sheets.Events.ButtonClicked, function(e, args) {
const { row, col } = args;
const cellType = sheet.getCellType(row, col);
const log = document.getElementById('eventLog');
if (cellType instanceof GC.Spread.Sheets.CellTypes.Button) {
log.textContent = `[버튼 클릭] ${sheet.getValue(row, 0)} 처리 시작 — 행 ${row}`;
sheet.getCell(row, 0).backColor('#E3F2FD');
} else if (cellType instanceof GC.Spread.Sheets.CellTypes.CheckBox) {
const val = sheet.getValue(row, col);
log.textContent = `[체크박스] ${sheet.getValue(row, 0)}: ${val ? '✅ 완료' : '⬜ 대기'}`;
}
});