const spread = new GC.Spread.Sheets.Workbook(document.getElementById('spreadContainer'));
const sheet = spread.getActiveSheet();
spread.options.tabStripVisible = false;
spread.options.scrollByPixel = true;
const ROWS = 10000;
const headers = ['순번', '거래일', '거래처', '품목', '수량', '단가(원)', '금액(원)', '비고'];
const colWidths = [55, 90, 100, 100, 60, 90, 100, 80];
sheet.setRowCount(ROWS + 1); // 헤더 1행 + 데이터 10,000행
headers.forEach((h, c) => {
sheet.setValue(0, c, h);
sheet.getCell(0, c).backColor('#37474F').foreColor('#fff').font('bold 12px sans-serif');
sheet.setColumnWidth(c, colWidths[c]);
});
sheet.setRowHeight(0, 32);
const items = ['모니터', 'SSD', '마우스', '키보드', 'RAM', '쿨러', '파워'];
const orgs = ['(주)테크솔', '한국IT', '미래시스템', '알파소프트', '글로벌넷'];
const t0 = performance.now();
spread.suspendPaint();
for (let r = 0; r < ROWS; r++) {
const qty = Math.floor(Math.random() * 50) + 1;
const price = (Math.floor(Math.random() * 200) + 10) * 1000;
sheet.setValue(r + 1, 0, r + 1);
sheet.setValue(r + 1, 1, `2024-${String(Math.floor(r / 834) + 1).padStart(2, '0')}-${String((r % 28) + 1).padStart(2, '0')}`);
sheet.setValue(r + 1, 2, orgs[r % 5]);
sheet.setValue(r + 1, 3, items[r % 7]);
sheet.setValue(r + 1, 4, qty);
sheet.setValue(r + 1, 5, price);
sheet.setValue(r + 1, 6, qty * price);
sheet.setValue(r + 1, 7, r % 15 === 0 ? '우선처리' : '');
if (r % 2 === 0) {
for (let c = 0; c < 8; c++) sheet.getCell(r + 1, c).backColor('#FAFAFA');
}
}
spread.resumePaint();
const elapsed = (performance.now() - t0).toFixed(0);
const status = document.getElementById('statusBar');
if (status) status.textContent = `✅ ${ROWS.toLocaleString()}행 렌더링 완료 (${elapsed}ms) — 스크롤하여 가상화 성능 확인`;