try{if(apex.spreadsheet==null||typeof (apex.spreadsheet)!="object"){apex.spreadsheet=new Object()}function ws_Spreadsheet(D){this.Spreadsheet=$x(D);this.numberRows=false;this.numberCells=false;this.currentRow=false;this.classArray=false;this.currentCell=false;this.currentForm=false;this.currentCol=false;this.currentColType=false;this.Reset=A;this.CellInit=B;this.SpreadInit=C;this.control=function(G,E){var F=new apex.ajax.ondemand(G,function(){var H=p.readyState;if(H==1||H==2||H==3){}else{if(H==4){gReturn=p.responseText;$s("apexir_CONTROL_PANEL_DROP",gReturn);$x_Show("apexir_CONTROL_PANEL_DROP");if(E=="SHARING"){window.g_Shuttlep_v01=new dhtml_ShuttleObject("apexir_OTHERS_MAY_VIEW_LEFT","apexir_OTHERS_MAY_VIEW_RIGHT");window.g_Shuttlep_v02=dhtml_ShuttleObject("apexir_OTHERS_MAY_EDIT_LEFT","apexir_OTHERS_MAY_EDIT_RIGHT")}}else{return false}}});F.ajax.addParam("x01",E);F._get()};this.actions=function(E){var F=new apex.ajax.ondemand("websheet",function(){var G=p.readyState;if(G==1||G==2||G==3){}else{if(G==4){websheet_return(p)}else{return false}}});websheets_action(F,E)};this.cells={};this.cells.edit=function(F,E){gReport.controls.value=that.currentCell.innerHTML;that.currentCell.innerHTML="";gReport.controls.lov=true;E.onclick="";gReport.controls.lov_dom=E;gReport.controls.col_lov(F)};return ;function C(){var G=this.Spreadsheet.rows;this.numberRows=G.length;if(!!this.numberRows[0]){this.numberCells=G[0].cells.length;var F=[];var I=[];var E=G[0].getElementsByTagName("DIV");for(var H=0;H<E.length;H++){if(!isNaN(parseInt(E[H].id.substring(1)))){F[F.length]=E[H].parentNode;I[I.length]=E[H].id;E[H].parentNode.style.width=E[H].parentNode.offsetWidth}}}}function B(G){that=this;this.Reset();this.currentRow=G.parentNode.parentNode;this.currentCell=G;this.classArray=G.className.split(" ");this.currentCol=this.classArray[0];this.currentColType=this.classArray[1];if(this.currentColType=="textarea"&&!isNaN(this.currentCol.substring(1))){var E=G.innerHTML;G.innerHTML="";G.onclick="";G.style.padding="0";var F=$dom_AddTag(G,"TEXTAREA");F.style.background="#fff";F.style.position="absolute";F.style.height=G.parentNode.offsetHeight;F.focus();if(G.offsetWidth<250){F.style.width="250px"}else{F.style.width=G.offsetWidth}F.style.zIndex="999";this.currentForm=F;this.currentValue=E;F.value=E;F.onkeydown=function(H){cellkey(H,this)};F.onblur=function(H){cellsave(H,this)};F.focus()}else{if(this.currentColType=="text"&&!isNaN(this.currentCol.substring(1))){$x_Style(G.parentNode,"visibility","hidden");var E=G.innerHTML;G.innerHTML="";G.onclick="";var F=$dom_AddInput(G,"TEXT","","",E);F.style.position="relative";F.focus();F.style.zIndex="999";F.parentNode.style.padding="0";F.style.width="100%";this.currentForm=F;this.currentValue=E;F.value=E;F.onkeydown=function(H){cellkey(H,this)};F.onblur=function(H){cellsave(H,this)};F.focus();$x_Style(G.parentNode,"visibility","visible")}else{if(this.currentColType=="selectlist"&&!isNaN(this.currentCol.substring(1))){that.currentValue=G.innerHTML;that.cells.edit(that.currentCol,G)}else{this.Reset()}}}}function A(){var E=this.currentValue;if(this.currentCell){this.currentCell.innerHTML=E;this.currentCell.style.padding="";this.currentCell.onclick=function(){initCell(this)}}this.currentRow=false;this.currentCell=false;this.currentForm=false;this.currentCol=false}}function initCell(A){gReport.websheet.CellInit(A)}function cellkey(B,C){var A;if(window.event){A=window.event.keyCode}else{if(B){A=B.which}else{return false}}if(B.ctrlKey){switch(A){case 9:runTab(C);break;case 13:runTab(C);null;break;case 37:runTab(C);null;break;case 38:runTab(C);null;break;case 39:runTab(C);null;break;case 40:runTab(C);null;break;case 17:runTab(C);null;break;default:null}}}function runTab(A){if(A.parentNode.cellIndex<gReport.websheet.numberCells-1){gReport.websheet.CellInit(A.parentNode.nextSibling)}else{if(A.parentNode.cellIndex==gReport.websheet.numberCells-1){if(gReport.websheet.currentRow.rowIndex==gReport.websheet.Spreadsheet.rows.length-1){gReport.websheet.CellInit(gReport.websheet.Spreadsheet.rows[1].cells[1])}else{gReport.websheet.CellInit(gReport.websheet.Spreadsheet.rows[gReport.websheet.currentRow.rowIndex+1].cells[1])}}}}function cellsave(B,C){if(gReport.websheet.currentValue!=C.value){gReport.websheet.currentValue=$v(C);var A=new apex.ajax.ondemand("ws_SaveCell",function(){var D=p.readyState;if(D==1||D==2||D==3){}else{if(D==4){ajax_Loading(p.readyState);gReport.websheet.Reset()}else{return false}}});A.ajax.add("AJAX_WS_COLUMN",gReport.websheet.currentCol);A.ajax.add("TEMPORARY_ITEM",C.value);A.ajax.add("CURRENT_WORKSHEET_ROW",gReport.websheet.currentRow.id.substring(3));A._get()}else{gReport.websheet.Reset()}return }function addOption(B,D,C){var A=document.createElement("OPTION");A.text=D;A.value=C;B.options.add(A);return A}function ws_GetSelectItem(pThis,pVal){this.dGet=dGet;var get=new htmldb_Get(null,$x("pFlowId").value,"APPLICATION_PROCESS=ws_GetSelectItem",0);this.dGet();return ;function dGet(){get.add("CURRENT_WORKSHEET_ROW",gReport.websheet.currentRow.id.substring(3));get.add("AJAX_WS_COLUMN",gReport.websheet.currentCol);get.GetAsync(dShow)}function dShow(){if(p.readyState==1){ajax_Loading(p.readyState)}else{if(p.readyState==2){}else{if(p.readyState==3){}else{if(p.readyState==4){ajax_Loading(p.readyState);var myObject=eval("("+p.responseText+")");for(var i=0;i<myObject.row.length;i++){var lOpt=addOption(pThis,myObject.row[i].R,myObject.row[i].R);if(myObject.row[i].R==pVal){lOpt.selected=true}}}}}}}}}catch(e){}function websheets_action(B,A){(!!A)?B.ajax.addParam("p_widget_action",A):null;switch(A){case"properties":B.ajax.addParam("x01",$v("apexir_NAME"));B.ajax.addParam("x02",$v("apexir_DESCRIPTION"));break;case"column_add":B.ajax.addParam("x01",$v("apxir_COLUMN_NAME"));B.ajax.addParam("x02",$v("apexir_COLUMN_TYPE"));B.ajax.addParam("x03",$v("apexir_DISPLAY_AS"));B.ajax.addParam("x04",$v("apexir_LOV"));B.ajax.addParam("x05",$v("apexir_REQUIRED"));B.ajax.addParam("x06",$v("apexir_DEFAULT_TYPE"));B.ajax.addParam("x07",$v("apexir_DEFAULT_TEXT"));B.ajax.addParam("x08",$v("apexir_LOV_NAME"));B.ajax.addParam("x09",$v("apexir_LOV_ENTRIES"));break;case"column_remove":B.ajax.addParam("x01",$v("P2_COLUMN"));break;case"column_properties":B.ajax.addParam("x01",$v("apexir_COLUMN"));B.ajax.addParam("x02",$v("apexir_GROUP_ID"));B.ajax.addParam("x03",$v("apexir_DISPLAY_AS"));B.ajax.addParam("x04",$v("apexir_COLUMN_LABEL"));B.ajax.addParam("x05",$v("apexir_FORMAT_MASK"));B.ajax.addParam("x06",$v("apexir_REQUIRED"));B.ajax.addParam("x07",$v("apexir_HEADING_ALIGNMENT"));B.ajax.addParam("x08",$v("apexir_COLUMN_ALIGNMENT"));B.ajax.addParam("x09",$v("apexir_DEFAULT_TYPE"));B.ajax.addParam("x10",$v("apexir_DEFAULT_TEXT"));break;case"lov":B.ajax.addParam("x01",$v("apexir_LOV_ID"));B.ajax.addParam("x02",$v("apexir_LOV_NAME"));B.ajax.addParam("x03",$v("apexir_LOV_ENTRIES"));break;case"column_groups":B.ajax.addParam("x01",$v("apexir_GROUP_ID"));B.ajax.addParam("x02",$v("apexir_DISPLAY_SEQUENCE"));B.ajax.addParam("x03",$v("apexir_NAME"));B.ajax.addParam("x04",$v("apexir_DESCRIPTION"));break;case"set_column_value":B.ajax.addParam("x01",$v("apexir_COLUMN"));B.ajax.addParam("x02",$v("apexir_NEW_COLUMN_VALUE"));B.ajax.addParam("x03",$v("apexir_ROWS"));break;case"replace_column_value":B.ajax.addParam("x01",$v("apexir_ROWS"));B.ajax.addParam("x02",$v("apexir_COLUMS"));B.ajax.addParam("x03",$v("apexir_REPLACE"));B.ajax.addParam("x04",$v("apexir_REPLACE_WITH"));break;case"fill_column_value":B.ajax.addParam("x01",$v("apexir_COLUMN"));B.ajax.addParam("x02",$v("apexir_FILL_WITH"));break;case"delete_rows":B.ajax.addParam("x01",$v("apexir_ROWS"));break;case"set_geocode":B.ajax.addParam("x01",$v("apexir_SHUTTLE_RIGHT"));break;case"reset_geocode":false;break;case"copy":B.ajax.addParam("x01",$v("apexir_NEW_WORKSHEET_NAME"));break;case"export":B.ajax.addParam("x01",$v("apexir_EXPORT_FORMAT"));break;case"delete":B.ajax.addParam("x01",$v("apexir_ACTION"));break;default:false;break}B._get()}function websheet_return(A){if(A.responseText=="true"){gReport.pull()}else{$s("apexir_DIALOG_MESSAGE",A.responseText);$x_Show("apexir_DIALOG_MESSAGE")}}function pull_lov(D){var B=$x(D).value;var C=$x(D).options[$x(D).selectedIndex].text;if(B!=""){var A=new apex.ajax.ondemand("GET_LOV",function(){var E=p.readyState;if(E==1||E==2||E==3){}else{if(E==4){gReturn=p.responseText;$s("apexir_LOV_NAME",C);$s("apexir_LOV_ENTRIES",gReturn.substring(0,gReturn.length-1))}else{return false}}});A.ajax.addParam("x01",B);A._get()}else{$s("apexir_LOV_NAME","");$s("apexir_LOV_ENTRIES","")}}function pull_column_data(B){var A=new apex.ajax.ondemand("show_dialog",function(){var C=p.readyState;if(C==1||C==2||C==3){}else{if(C==4){gReturn=p.responseText;$s("apexir_CONTROL_PANEL_DROP",gReturn);$x_Show("apexir_CONTROL_PANEL_DROP")}else{return false}}});A.ajax.addParam("x01","COLUMN_PROPERTIES2");A.ajax.addParam("x02",$v(B));A._get()}function pull_column_group(B){var A=new apex.ajax.ondemand("show_dialog",function(){var C=p.readyState;if(C==1||C==2||C==3){}else{if(C==4){gReturn=p.responseText;$s("apexir_CONTROL_PANEL_DROP",gReturn);$x_Show("apexir_CONTROL_PANEL_DROP")}else{return false}}});A.ajax.addParam("x01","GROUP2");A.ajax.addParam("x02",$v(B));A._get()};