IB Sheet 8 Examples

Enum형 컬럼

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><span>주소 컬럼에 표시되는 아이템 개수 설정  </span><input type='number' id='showLineInput' max='15' min='1' class='mgr10' value='10' style='width:60px;'><button type='button' class='mgr10' onclick='ib.sampleBtn(this)'>변경</button></div></div>


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

JavaScript

var ib = ib||{};
ib = {
//시트 초기화 구문
'init':{
  "Def": {
    "Header": {},
    "Col": {
      "Spanned": 1,
      "SuggestType": "Search,Empty,Start,IgnoreSpace"
    },
    "Spacer": {
      "CanFocus": 0,
      "Width": 5
    },
    "Row": {
      "CanFormula": true,
      "CalcOrder": "sTeamSuggest,sPosEnum,sPosEnumKeys,sTeamColor,sPosColor"
    }
  },
  //공통기능 설정 부분
  "Cfg": {
    "SearchMode": 0,
    "MaxPages": 3,
    "SuppressMessage": 3
  },
  //틀고정 좌측 컬럼 설정
  "LeftCols": [
    {"Type": "Int","Width": 50,"Align": "Center","Name": "SEQ"}
  ],
  //중앙(메인) 컬럼 설정
  "Cols": [
    {"Header": {"Value": "임원","Align": "Center","Icon": "Check","HeaderCheck": 1},"Type": "Bool","Name": "Chk"},
    {"Header": "부서명","Type": "Text","Name": "sDept","Width": "130","Align": "Center","CanEdit": 1,"RawSort": 1,"Suggest": "|CEO|SI사업부|인사부|솔루션사업부|영업팀|기술연구소|경영지원팀"},
    {"Header": "팀명","Type": "Text","Name": "sTeam","Width": "110","Align": "Center","CanEdit": 1,"RawSort": 1,"ColorFormula": changeColorFormula,"SuggestFormula": suggestFormula},
    {"Header": "직급","Type": "Enum","Name": "sPos","Width": "95","Align": "Center","ColorFormula": changeColorFormula,"CanEdit": 1,"RawSort": 1,"Enum": "|대표이사|이사|상무|소장|차장|부장|과장|대리|사원","EnumKeys": "|01A|02A|03A|04A|04B|05B|06B|07B|08B|09B","EnumFormula": enumFormula,"EnumKeysFormula": enumKeysFormula},
    {"Header": "성명","Type": "Text","Name": "sName","MinWidth": "100","Align": "Center","CanEdit": 1,"RawSort": 1},
    {"Header": "성별","Type": "Enum","Name": "sSex","Width": "70","Align": "Center","CanEdit": 1,"RawSort": 1,"Enum": "|남자|여자","EnumKeys": "|男|女"},
    {"Header": "연령대","Type": "Text","Name": "sAge2","Width": "70","Align": "Center","CanEdit": 1,"RawSort": 1,"Suggest": "|10대|20대|30대|40대|50대|60대 이상"},
    {"Header": "거주지","Type": "Text","Name": "sAddr1","Width": "80","Align": "Center","CanEdit": 1,"RawSort": 1,"Suggest": "|서울|경기|강원"},
    {"Header": "나이","Type": "Int","Name": "sAge","Width": "65","Align": "Right","CanEdit": 1,"RawSort":...