const spread = new GC.Spread.Sheets.Workbook(document.getElementById('spreadContainer'));
const tabColors = ['#1565C0', '#2E7D32', '#AD1457'];
const teamNames = ['A팀', 'B팀', 'C팀'];
teamNames.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.setColumnWidth(0, 120); sheet.setColumnWidth(1, 120);
sheet.setRowHeight(0, 36);
[['목표 달성률', `${70 + idx * 10}%`], ['신규 계약', 12 + idx * 5], ['누적 매출', (idx + 1) * 8000000]].forEach(([label, val], r) => {
sheet.setValue(r + 1, 0, label);
sheet.setValue(r + 1, 1, val);
sheet.getCell(r + 1, 0).backColor(r % 2 === 0 ? '#F5F5F5' : '#FAFAFA');
sheet.getCell(r + 1, 1).backColor(r % 2 === 0 ? '#F5F5F5' : '#FAFAFA');
});
});
// 현재 시트 복사 → 복사된 시트로 자동 이동
document.getElementById('btnCopy')?.addEventListener('click', () => {
const sourceIdx = spread.getActiveSheetIndex();
const source = spread.getSheet(sourceIdx);
const json = source.toJSON(); // toJSON()은 반환값 사용 — 인수로 받지 않음
const copyName = source.name() + '_복사';
const newIdx = spread.getSheetCount();
const newSheet = new GC.Spread.Sheets.Worksheet(copyName);
spread.addSheet(newIdx, newSheet);
newSheet.fromJSON(json);
newSheet.name(copyName); // fromJSON이 원본 이름 복원하므로 재설정
newSheet.options.sheetTabColor = '#FF8F00';
spread.setActiveSheetIndex(newIdx);
spread.repaint();
});
// 왼쪽으로 이동 — removeSheet 후 sheet 객체 무효화로 toJSON 직렬화 후 재삽입
document.getElementById('btnMoveLeft')?.addEventListener('click', () => {
const idx = spread.getActiveSheetIndex();
if (idx > 0) {
const sheet = spread.getSheet(idx);
const name = sheet.name();
const json = sheet.toJSON();
spread.removeSheet(idx);
const newSheet = new GC.Spread.Sheets.Worksheet(name);
spread.addSheet(idx - 1, newSheet);
newSheet.fromJSON(json);
newSheet.name(name);
spread.setActiveSheetIndex(idx - 1);
spread.repaint();
}
});
// 오른쪽으로 이동
document.getElementById('btnMoveRight')?.addEventListener('click', () => {
const idx = spread.getActiveSheetIndex();
if (idx < spread.getSheetCount() - 1) {
const sheet = spread.getSheet(idx);
const name = sheet.name();
const json = sheet.toJSON();
spread.removeSheet(idx);
const newSheet = new GC.Spread.Sheets.Worksheet(name);
spread.addSheet(idx + 1, newSheet);
newSheet.fromJSON(json);
newSheet.name(name);
spread.setActiveSheetIndex(idx + 1);
spread.repaint();
}
});