const spread = new GC.Spread.Sheets.Workbook(document.getElementById('spreadContainer'));
const label = document.getElementById('statusLabel');
const tabColors = ['#E53935', '#43A047', '#1E88E5'];
const sheetNames = ['확정', '검토중', '내부용'];
spread.suspendPaint();
sheetNames.forEach((name, idx) => {
const sheet = idx === 0 ? spread.getActiveSheet() : new GC.Spread.Sheets.Worksheet(name);
if (idx > 0) spread.addSheet(idx, sheet);
sheet.name(name);
sheet.options.sheetTabColor = tabColors[idx];
sheet.setValue(0, 0, `[${name}] 시트`);
sheet.getCell(0, 0).backColor(tabColors[idx]).foreColor('#fff').font('bold 14px sans-serif');
sheet.setRowHeight(0, 36); sheet.setColumnWidth(0, 250);
const note = idx === 2 ? '⚠️ 이 시트는 내부 전용입니다' : '탭 색상이 적용된 시트입니다';
sheet.setValue(1, 0, note);
sheet.setValue(2, 0, '탭 색상·가시성·보호를 버튼으로 제어해보세요.');
});
spread.resumePaint();
const updateStatus = () => {
const sheet = spread.getActiveSheet();
const prot = sheet.options.isProtected ? '🔒 보호됨' : '✏️ 편집가능';
if (label) label.textContent = `[${sheet.name()}] ${prot}`;
};
updateStatus();
spread.bind(GC.Spread.Sheets.Events.ActiveSheetChanged, updateStatus);
// 탭 색상 순환 — options.sheetTabColor + suspendPaint/resumePaint로 탭 스트립 갱신
const colorPalette = ['#E53935', '#43A047', '#1E88E5', '#7B1FA2', '#FF8F00', '#00838F'];
let colorIdx = 0;
document.getElementById('btnColor')?.addEventListener('click', () => {
colorIdx = (colorIdx + 1) % colorPalette.length;
spread.suspendPaint();
spread.getActiveSheet().options.sheetTabColor = colorPalette[colorIdx];
spread.resumePaint();
});
// 내부용 시트 숨김/표시 토글
let hiddenState = false;
document.getElementById('btnHide')?.addEventListener('click', () => {
const innerSheet = spread.getSheetFromName('내부용');
if (!innerSheet) return;
hiddenState = !hiddenState;
innerSheet.visible(!hiddenState);
spread.setActiveSheetIndex(0);
updateStatus();
});
// 보호 토글
document.getElementById('btnProtect')?.addEventListener('click', () => {
const sheet = spread.getActiveSheet();
sheet.options.isProtected = !sheet.options.isProtected;
updateStatus();
});