const spread = new GC.Spread.Sheets.Workbook(document.getElementById('spreadContainer'));
spread.options.tabStripVisible = false;
const sheet = spread.getActiveSheet();
spread.suspendPaint();
const headers = ['공정명', '작업지시번호', '담당자', '진행 상태', '비고'];
const widths = [130, 130, 90, 100, 180];
headers.forEach((h, c) => {
sheet.setValue(0, c, h);
sheet.setColumnWidth(c, widths[c]);
sheet.getCell(0, c).backColor('#37474F').foreColor('#FFFFFF').font('bold 12px sans-serif').hAlign(GC.Spread.Sheets.HorizontalAlign.center);
});
sheet.setRowHeight(0, 36);
const data = [
['원재료 투입', 'WO-2024-001', '김민준', '완료', ''],
['절단 가공', 'WO-2024-002', '이서연', '진행중', ''],
['용접', 'WO-2024-003', '박지호', '지연', '납기 위험 — 확인 필요'],
];
data.forEach((row, r) => {
row.forEach((val, c) => sheet.setValue(r + 1, c, val));
sheet.setRowHeight(r + 1, 32);
[0,1,2,3,4].forEach(c => sheet.getCell(r+1,c).hAlign(GC.Spread.Sheets.HorizontalAlign.center).vAlign(GC.Spread.Sheets.VerticalAlign.center));
});
// Step 1: 전체 셀 잠금 해제
const defaultStyle = new GC.Spread.Sheets.Style();
defaultStyle.locked = false;
sheet.setDefaultStyle(defaultStyle);
// Step 2: 읽기 전용 영역(헤더 + 공정명·작업지시·담당자) 잠금
sheet.getRange(0, 0, 1, 5).locked(true);
for (let r = 1; r <= 3; r++) {
for (let c = 0; c <= 2; c++) sheet.getCell(r, c).locked(true);
}
// Step 3: 시트 보호 활성화
sheet.options.isProtected = true;
sheet.options.protectionOptions = {
allowSelectLockedCells: true,
allowSelectUnlockedCells: true
};
// 편집 가능 컬럼 시각 표시 (노란 배경)
for (let r = 1; r <= 3; r++) {
sheet.getCell(r, 3).backColor('#FFF9C4');
sheet.getCell(r, 4).backColor('#FFF9C4');
}
spread.resumePaint();