IBSheet8 Manual Sample

author(s): IBSheet

HTML

<!-- ibsheet css -->
<link rel="stylesheet" href="https://www.ibsheet.com/v8/assets/lib/ibsheet/css/default/main.css"/><!--  ibsheet 필수 js -->
<script src="https://www.ibsheet.com/v8/assets/lib/iblicense.js"></script>
<script src="https://www.ibsheet.com/v8/assets/lib/ibsheet/ibsheet.js"></script>
<script src="https://www.ibsheet.com/v8/assets/lib/ibsheet/locale/ko.js"></script>

<!--  ibsheet 선택/추가 js -->
<script src="https://www.ibsheet.com/v8/assets/lib/ibsheet/plugins/ibsheet-common.js"></script>
<script src="https://www.ibsheet.com/v8/assets/lib/ibsheet/plugins/ibsheet-dialog.js"></script>
<script src="https://www.ibsheet.com/v8/assets/lib/ibsheet/plugins/ibsheet-excel.js"></script>
<script src="https://www.ibsheet.com/v8/assets/lib/ibsheet/plugins/jszip.min.js"></script>

<input type="button" value="모두접기" onclick="ib.sampleBtn(this)"> 
<input type="button" value="모두펼침" onclick="ib.sampleBtn(this)"> 
<select id="level">
    <option value="1">1</option>
    <option value="2">2</option>
    <option value="3" selected>3</option>
    <option value="4">4</option>
    <option value="5">5</option>
    <option value="6">6</option>
</select>
<input type="button" value="레벨까지 보기" onclick="ib.sampleBtn(this)"> 
<input type="button" value="노드연결선 감추기" onclick="ib.sampleBtn(this)"> 
<br>

<div style='height:500px'><div id='sheetDiv' style='width:100%;height:100%'></div></div>

CSS

a{text-decoration:none;color:#4444FF;}

JavaScript

var ib = ib||{};
ib = {
//시트 초기화 구문
'init':{
  //공통기능 설정 부분
  "Cfg": {
    "SearchMode": 2,
    "MessageWidth": 300,
    "CanSort": 0,
    MainCol: "Cls"
  },
  "Def": {
    "Row": {
      "CanFormula": true
    }
  },
  //틀고정 좌측 컬럼 설정
  "LeftCols": [
    {"Type": "Int","Width": 50,"Align": "Center","Name": "SEQ"}
  ],
  //중앙(메인) 컬럼 설정
  "Cols": [
    {"Header": "생산자물가지수","Type": "Text","Name": "Cls","MinWidth": "200","Align": "Left","RelWidth": 1,"CanEdit": 1},
    {"Header": "2012년 8월","Type": "Float","Name": "Y201208","Width": "100","Align": "Right","Format": "#,##0.00","FormulaRow": "Sum","CanEdit": 1},
    {"Header": "2012년 9월","Type": "Float","Name": "Y201209","Width": "100","Align": "Right","Format": "#,##0.00","FormulaRow": "Sum","CanEdit": 1},
    {"Header": "2012년 10월","Type": "Float","Name": "Y201210","Width": "100","Align": "Right","Format": "#,##0.00","FormulaRow": "Sum","CanEdit": 1},
    {"Header": "2012년 11월","Type": "Float","Name": "Y201211","Width": "100","Align": "Right","Format": "#,##0.00","FormulaRow": "Sum","CanEdit": 1},
    {"Header": "2012년 12월","Type": "Float","Name": "Y201212","Width": "100","Align": "Right","Format": "#,##0.00","FormulaRow": "Sum","CanEdit": 1},
    {"Header": "2013년 1월","Type": "Float","Name": "Y201301","Width": "100","Align": "Right","Format": "#,##0.00","FormulaRow": "Sum","CanEdit": 1},
    {"Header": "2013년 2월","Type": "Float","Name": "Y201302","Width": "100","Align": "Right","Format": "#,##0.00","FormulaRow": "Sum","CanEdit": 1},
    {"Header": "2013년 3월","Type": "Float","Name": "Y201303","Width": "100","Align": "Right","Format": "#,##0.00","FormulaRow": "Sum","CanEdit": 1},
    {"Header": "2013년 4월","Type": "Float","Name": "Y201304","Width": "100","Align": "Right","Format": "#,##0.00","FormulaRow": "Sum","CanEdit": 1},
    {"Header": "2013년 5월","Type": "Float","Name": "Y201305","Width": "100","Align": "Right","Format": "#,##0.00","FormulaRow": "Sum","CanEdit": 1},
    {"Header": "2013년 6월","Type":...