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",
	"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:"checkbox", options: {checkedvalue: "ok", uncheckedvalue: "ng"}},					
	                        {title:["이름"], 		key:"name", 	type:"input", maxlength: 4, options: {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: "￦ #,###.##" } }, style: { data: { 'text-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"
			      ],	  	  
	"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