IB Sheet 8 Examples

Solid(커스텀행)

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'><div></div></div>


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

CSS

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

JavaScript

var ib = ib||{};
ib = {
//시트 초기화 구문
'init':{
  
  "Def": {
    "Row": {
      "CanFormula": 1,
      "CalcOrder": "titleColor"
    }
  },
  //공통기능 설정 부분
  "Cfg": {
    "SearchMode": 0
  },
  //중앙(메인) 컬럼 설정
  "Cols": [
    {"Header": "선택","Type": "Bool","Name": "chk","Width": "60"},
    {"Header": "스크린수","Type": "Int","Name": "screenNo","Width": "80","Format": "#,###","FormulaRow": "Sum"},
    {"Header": "영화명","Type": "Text","Name": "title","MinWidth": "250","RelWidth": 1, ColorFormula: " screenNo>1000 ? '#FF8888' : '#FFFFFF' "},
    {"Header": "감독","Type": "Text","Name": "director","Width": "120"},
    {"Header": "제작사","Type": "Text","Name": "company","MinWidth": "180","RelWidth": 1},
    {"Header": "개봉일","Type": "Date","Name": "openDate","Width": "120","Format": "yyyy/MM/dd","EditFormat": "yyyy/MM/dd"},
    {"Header": "영화유형","Type": "Enum","Name": "movieType","Width": "100","Enum": "|SF|가족|드라마|액션|범죄|스릴러|판타지|애니메이션|다큐멘터리|기타","EnumKeys": "|AA|BB|CC|DD|EE|FF|GG|HH|II|JJ"},
    {"Header": "국적","Type": "Text","Name": "country","Width": "80"},
    {"Header": "전국매출액","Type": "Int","Name": "amt","Width": "150","Format": "#,###","FormulaRow": "Sum"},
    {"Header": "전국관객수","Type": "Int","Name": "people","Width": "100","Format": "#,###","FormulaRow": "Sum"},
    {"Header": "등급","Type": "Enum","Name": "rate","Width": "80","Enum": "|전체|12세|15세|청불","EnumKeys": "|01|02|03|04|05"}
  ]
},
//시트 이벤트
'event':{
	onRenderFirstFinish: function(evtParam) {
  	evtParam.sheet.loadSearchData(loadData);
  }
},
//시트객체 생성
'create':function () {
    var options = this.init;
    
    options.Events = this.event;
    IBSheet.create({
      id: 'sheet', // 생성할 시트의 id
      el: 'sheetDiv', // 시트를 생성할 Dom 객체 및 id
      options: options // 생성될 시트의 속성
    });
  },
//화면 기능
'sampleBtn':function () {
    if (arguments[0].type === 'radio') { // 솔리드 위치 선택
      sheet.getRowById('solidRow').Space = arguments[1]; // 솔리드행 위치 변경
      sheet.rerender();
    }
  }
}
ib.create();
// 외부 함수
function...