JavaScript
const spread = new GC.Spread.Sheets.Workbook(document.getElementById('spreadContainer'));
const sheet = spread.getActiveSheet();
spread.options.tabStripVisible = false;
sheet.setValue(0, 0, '프로젝트'); sheet.setValue(0, 1, '진척률 (클릭하여 조정)'); sheet.setValue(0, 2, '상태');
[0, 1, 2].forEach(c => {
sheet.getCell(0, c).backColor('#00695C').foreColor('#fff').font('bold 13px sans-serif').hAlign(1);
});
sheet.setColumnWidth(0, 150); sheet.setColumnWidth(1, 200); sheet.setColumnWidth(2, 80);
sheet.setRowHeight(0, 36);
// 슬라이더 드롭다운 스타일
const sliderStyle = new GC.Spread.Sheets.Style();
sliderStyle.cellButtons = [{
imageType: GC.Spread.Sheets.ButtonImageType.dropdown,
command: 'openSlider',
useButtonStyle: true,
}];
sliderStyle.dropDowns = [{
type: GC.Spread.Sheets.DropDownType.slider,
option: {
min: 0, max: 100, step: 5,
marks: [0, 25, 50, 75, 100],
direction: GC.Spread.Sheets.LayoutDirection.horizontal,
tooltipVisible: true,
width: 300,
}
}];
sliderStyle.formatter = '0"%"';
const projects = [
['ERPv2 화면 개발', 72], ['모바일 앱 마이그레이션', 45],
['데이터 마트 구축', 88], ['결재 모듈 리팩토링', 20],
];
projects.forEach(([name, pct], r) => {
sheet.setValue(r + 1, 0, name);
sheet.setValue(r + 1, 1, pct);
sheet.setStyle(r + 1, 1, sliderStyle);
const status = pct >= 80 ? '완료임박' : pct >= 50 ? '진행중' : '초기';
sheet.setValue(r + 1, 2, status);
const color = pct >= 80 ? '#E8F5E9' : pct >= 50 ? '#FFF8E1' : '#FFF3E0';
sheet.getCell(r + 1, 1).backColor(color);
sheet.setRowHeight(r + 1, 36);
});