QCELL

Classes

QCell

Methods

(static) create(properties) → {void}

Since:

• QCELL v1.0.0

Example

QCELL.create({
	"parentid"            : "QCellArea",
	"id"                  : "QCell1",
	"data"                : {"input": cell_data},
	"rowheader"           : "sequence",
	"rowheaderstitle"     : ["qcell1"...],
	"selectmode"          : "cell",
	"highlightrepeat"     : 2,
	"frozencols"          : 2,
	"frozenrows"          : 3,
	"frozenbottomrows"    : 2,
	"rowheight"           : {header: 40, data: 40},
	"oneclickedit"        : false,
	"onloadurl"           : "URL",
	"merge"               : {"data":"row"},
	"delkeymode"          : "none",	
	"useexcelstylepanel"  : false,
	"bottompanel"         : true,
	"bottompanelstyle"    : "excel",
	"copypastemode"       : "focus",
	"additionaldataindex" : ["test1","test2"],	
	"events"              : click : function (event){ var objQCell = event.data.target; },
	"bottompanelcallback" : function (row, col, data) { return '재고수량 합계 :' + qcell1.getColSum(4)+'개'+' 데이터 개수 : ' + qcell1.getRows('data')+'개'},
	"bottompanelheight"   : 30,
	"columns"             : [ 
	                          {title:["순번"], 		key:"seq", remove : true},
	                          {title:["분류"], 		key:"selectmenu", type:"selectmenu", options:{input: select_method, itemcount: 9, direction:"down"}},							  
	                          {title:["선택"], 		key:"checkbox", options: {checkedvalue: "ok", uncheckedvalue: "ng"}},					
	                          {title:["이름"], 		key:"name", 	type:"input",  options: {maxlength: 4, mergecol: true}}, 
	                          {title:["나이"], 		key:"age", 	type:"input", options: {format: {type: "string", rule: "@ 세"}}},
	                          {title:["입력문구"], 		key:"placeholder", 	 type: "input",  options: { inputclass:"align-center", placeholder:'- 없이 입력하세요'}},
	                          {title:["연락처"], 		key:"phone", 	type:"input", options: {mask: {alias: "999-9999-9999"}}},
	                          {title:["주민세"], 		key:"resident", options: { format: { type: "number", rule: "#,###" , useinvaliddata : true }}},
	                          {title:["품목가격"], 		key:"price1", 	type:"input", datytype:"number"},							
	                          {title:["가격"]		key:"price2",   type: "input", width: "150px", key: "price", , options: { mask: { alias: 'currency', prefix:'￦ ', 
							  	digits:2 }, format: { type: "number", rule: "￦ #,###.##" } }, styleclassname: { "data": "align-right" }, sort: true },							
	                          {title:["주소"], 		key:"address", 	type:"textarea", filter : true, topmove : true},
	                          {title:["입사일"], 		key:"regdate", 	type:"datepicker ", options: {locale:"kr", local : "kr", changeyear :true, direction:"down"}}
			      ],
	"rowheaders"          : [
				"radio",
				"sequence",
				"checkbox",
				"state"
			      ],
	"statetype"           : "later",	
	"pagination"          : {pageunit: 10, unitlist: [10, 20, 30]},
	"contextmenu"         : {
		base: {
			id: 'base-contextmenu',
			contents:
			[
				{icon: './add.png', label: 'a', action: function(){QCell1.addRow();}},
				{icon: './del.png', label: 'b', action: function(){QCell1.removeRow();}},
				{label: 'c', items: [{label: 'c-1'}, {label: 'c-2'}]},
				{label: 'd', items: [{label: 'd-1', items: [{label: 'd-1-1'}, {label: 'd-1-2'}]}, {label: 'd-2', items: [{label: 'd-2-1'}, {label: 'd-2-2'},]}]}
			]
		}
	}
});

Parameters:

Returns:

Type

void

(static) hasInstance(id) → {Boolean}

Example

QCELL.hasInstance("sheet1");

Parameters:

Returns:

Type

Boolean

(static) getInstance(id) → {Object}

Example

var sheet1 = QCELL.getInstance("sheet1");

Parameters:

Returns:

Type

Object

(static) getInstanceIDs() → {Array}

Example

var arrSheetIDs = QCELL.getInstanceIDs();

Returns:

Type

Array

(static) deleteInstance(id) → {Boolean}

Example

QCELL.deleteInstance("sheet1");

Parameters:

Returns:

Type

Boolean

(static) deleteAllInstances() → {Boolean}

Example

QCELL.deleteAllInstances();

Returns:

Type

Boolean