IB Sheet 8 Examples

소계 기능

HTML

<link rel="stylesheet" href="https://demo.ibleaders.com/ibsheet/v8/samples/customer-sample/assets/css/style.css">
<!-- ibsheet css -->
<link rel="stylesheet" href="https://demo.ibleaders.com/ibsheet/v8/samples/customer-sample/assets/ibsheet/css/default/main.css"/>
<link rel="stylesheet" href="https://demo.ibleaders.com/ibsheet/v8/samples/customer-sample/assets/ibsheet/css/compatible/light/main.css"/>

<!--  ibsheet 필수 js -->
<script src="https://demo.ibleaders.com/ibsheet/v8/samples/customer-sample/assets/ibsheet/ibleaders.js"></script>
<script src="https://demo.ibleaders.com/ibsheet/v8/samples/customer-sample/assets/ibsheet/ibsheet.js"></script>
<script src="https://demo.ibleaders.com/ibsheet/v8/samples/customer-sample/assets/ibsheet/locale/ko.js"></script>

<!--  ibsheet 선택/추가 js -->
<script src="https://demo.ibleaders.com/ibsheet/v8/samples/customer-sample/assets/ibsheet/plugins/ibsheet-common.js"></script>
<script src="https://demo.ibleaders.com/ibsheet/v8/samples/customer-sample/assets/ibsheet/plugins/ibsheet-dialog.js"></script>
<script src="https://demo.ibleaders.com/ibsheet/v8/samples/customer-sample/assets/ibsheet/plugins/ibsheet-excel.js"></script>

<div class='ibsheet-wrap' id='descFunc'>
<button onclick='ib.sampleBtn(this)' class='mgr10'>행추가</button> <button onclick='ib.sampleBtn(this)' class='mgr10'>변경사항저장</button></div>


<div style='height:calc(100% - 108px)'><div id='sheetDiv' style='width:100%;height:100%'></div></div>

JavaScript

var ib = ib||{};
ib = {
//시트 초기화 구문
'init':{
  "Def": {
    "Col": {
      "Spanned": 1
    },
    "Row": {
      "Spanned": 1,
       "CanFormula":1
    }
  },
  //공통기능 설정 부분
  "Cfg": {
    "SearchMode": 0
    
  },
  //틀고정 좌측 컬럼 설정
  "LeftCols": [{
                Header: "NO",
                Type: "Int",
                Name: "SEQ"
            }  ],
  //중앙(메인) 컬럼 설정
  "Cols": [ {
              Header: "상태",
              Name: "status",
              Extend:IB_Preset.STATUS
      		},  //Formula로 설정
     			{   Header: {Value: "삭제"},           
            	Type: "Bool",
            	Name: "CheckData",
            	Width: 100,
            	Align: "Center",
       				Extend:IB_Preset.DelCheck
            }, {
                Header: "데이터1",
                Name: "data1", 
                Type: "Text",
                Align: "center",
                Width: 100,
                FormulaRow: 'Count'
                
            }, {
                Header: "데이터2",
                Name: "data2", 
                Type: "Text",
                Align: "center",
                Width: 100
            }, {
                Header: "데이터3",
                Name: "data3", 
                Type: "Text",
                Align: "center",
                Width: 100
            }, {
                Header: "데이터4",
                Name: "data4", 
                Type: "Text",
                Align: "center",
                Width: 100
            }, {
                Header: "데이터5",
                Name: "data5", 
                Type: "Text",
                Align: "center",
                Width: 100
            }, {
                Header: "데이터6",
                Name: "data6", 
                Type: "Text",
                Align: "center",
                Width: 100
            }
  ]
},
//시트 이벤트
'event':{
  onRenderFirstFinish: function(evtParam) {
  	evtParam.sheet.loadSearchData(loadData);
  }
},
//시트객체 생성
'create':function () {
    var options = this.init;

   ...