JavaScript
const spread = new GC.Spread.Sheets.Workbook(document.getElementById('spreadContainer'));
const sheet = spread.getActiveSheet();
spread.options.tabStripVisible = false;
// 헤더
['항목', '목표', '입력값', '달성 여부'].forEach((h, c) => {
sheet.setValue(0, c, h);
sheet.getCell(0, c).backColor('#37474F').foreColor('#fff').font('bold 12px sans-serif').locked(true);
});
const kpiItems = [
['매출액(억원)', 100],
['고객 수(명)', 500],
['신규 계약(건)', 20],
['만족도(점)', 4.5],
];
kpiItems.forEach(([item, target], i) => {
const r = i + 1;
sheet.setValue(r, 0, item);
sheet.setValue(r, 1, target);
sheet.setValue(r, 2, '');
sheet.setValue(r, 3, '-');
sheet.getCell(r, 0).backColor('#ECEFF1').locked(true);
sheet.getCell(r, 1).backColor('#E3F2FD').locked(true);
sheet.getCell(r, 2).backColor('#FFF9C4').locked(false); // 입력 가능 셀
sheet.getCell(r, 3).backColor('#F5F5F5').locked(true);
});
sheet.setColumnWidth(0, 130);
[1, 2, 3].forEach(c => sheet.setColumnWidth(c, 100));
for (let r = 0; r <= kpiItems.length; r++) sheet.setRowHeight(r, 36);
// 시트 보호 (잠금 해제 셀만 편집 가능)
sheet.options.isProtected = true;
sheet.options.protectionOptions = {
allowSelectLockedCells: true,
allowSelectUnlockedCells: true
};
// ✅ 보호 상태에서 올바른 이벤트 감지 패턴
spread.bind(GC.Spread.Sheets.Events.CellChanged, (event, args) => {
// value 변경만 처리 — style·formula 변경은 무시
if (args.propertyName !== 'value') return;
const r = args.row;
const c = args.col;
if (r < 1 || c !== 2) return; // 입력값 열(C)만 처리
const inputVal = parseFloat(sheet.getValue(r, 2));
const target = parseFloat(sheet.getValue(r, 1));
const achieved = !isNaN(inputVal) && inputVal >= target;
// 핸들러 내 setValue: suspendEvent로 재귀 CellChanged 방지
spread.suspendEvent();
sheet.setValue(r, 3, achieved ? '✅ 달성' : '❌ 미달성');
sheet.getCell(r, 3)
.backColor(achieved ? '#E8F5E9' : '#FFEBEE')
.foreColor(achieved ? '#2E7D32' : '#C62828');
spread.resumeEvent();
const logBox = document.getElementById('logBox');
if (logBox) {
const item = sheet.getValue(r, 0);
logBox.innerHTML =
`[${new Date().toLocaleTimeString()}] ${item}: ${inputVal} (목표 ${target}) → ${achieved ? '달성' : '미달성'}<br>` +
logBox.innerHTML;
}
});