const designer = new GC.Spread.Sheets.Designer.Designer(document.getElementById('spreadContainer'));
const spread = designer.getWorkbook();
const sheet = spread.getActiveSheet();
// 샘플 판매 보고서 데이터
const headers = ['제품', '1분기', '2분기', '3분기', '4분기', '합계'];
headers.forEach((h, c) => {
sheet.setValue(0, c, h);
sheet.getCell(0, c).backColor('#1565C0').foreColor('#fff').font('bold 12px sans-serif');
sheet.setColumnWidth(c, c === 0 ? 110 : 78);
});
const data = [
['스프레드시트 엔진', 1200, 1450, 1380, 1620],
['차트 컴포넌트', 980, 1100, 1250, 1400],
['피벗 플러그인', 650, 720, 800, 950],
['Designer 모듈', 420, 580, 670, 820],
];
data.forEach((row, r) => {
row.forEach((val, c) => sheet.setValue(r + 1, c, val));
sheet.setFormula(r + 1, 5, `=SUM(B${r + 2}:E${r + 2})`);
if (r % 2 === 0) for (let c = 0; c < 6; c++) sheet.getCell(r + 1, c).backColor('#F5F5F5');
});
sheet.setRowHeight(0, 36);