https://reporting.polybox.app/_next/static/chunks/084914e6.19d4f8f0d009dedd.js

1o++)n.rows[e].element.insertBefore(t.records[e][s].element,n.rows[e].element.children[o+1]),s++}if(n.options.footers)for(let e=0;e<n.options.footers.length;e++)n.options.footers[e]=(0,o.Hh)(n.options.footers[e],l,t.footers[e])}for(let e=l;e<n.cols.length;e++)n.cols[e].x=e;for(let e=0;e<n.records.length;e++)for(let t=l;t<n.records[e].length;t++)n.records[e][t].x=t;if(n.options.nestedHeaders&&n.options.nestedHeaders.length>0&&n.options.nestedHeaders[0]&&n.options.nestedHeaders[0][0])for(let l=0;l<n.options.nestedHeaders.length;l++){let o;o=1==e?parseInt(n.options.nestedHeaders[l][n.options.nestedHeaders[l].length-1].colspan)-t.numOfColumns:parseInt(n.options.nestedHeaders[l][n.options.nestedHeaders[l].length-1].colspan)+t.numOfColumns,n.options.nestedHeaders[l][n.options.nestedHeaders[l].length-1].colspan=o,n.thead.children[l].children[n.thead.children[l].children.length-1].setAttribute("colspan",o)}s.o8.call(n)},u=function(){let e,t=this,n=!!t.parent.ignoreEvents,o=!!t.ignoreHistory;t.parent.ignoreEvents=!0,t.ignoreHistory=!0;let s=[];if(t.historyIndex>=0){if("insertRow"==(e=t.history[t.historyIndex--]).action)d.call(t,1,e);else if("deleteRow"==e.action)d.call(t,0,e);else if("insertColumn"==e.action)p.call(t,1,e);else if("deleteColumn"==e.action)p.call(t,0,e);else if("moveRow"==e.action)t.moveRow(e.newValue,e.oldValue);else if("moveColumn"==e.action)t.moveColumn(e.newValue,e.oldValue);else if("setMerge"==e.action)t.removeMerge(e.column,e.data);else if("setStyle"==e.action)t.setStyle(e.oldValue,null,null,1);else if("setWidth"==e.action)t.setWidth(e.column,e.oldValue);else if("setHeight"==e.action)t.setHeight(e.row,e.oldValue);else if("setHeader"==e.action)t.setHeader(e.column,e.oldValue);else if("setComments"==e.action)t.setComments(e.oldValue);else if("orderBy"==e.action){let n=[];for(let t=0;t<e.rows.length;t++)n[e.rows[t]]=t;i.Th.call(t,e.column,+!e.order),i.iY.call(t,n)}else if("setValue"==e.action){for(let n=0;n<e.records.length;n++)s.push({x:e.records[n].x,y:e.records[n].y,value:e.records[n].oldValue}),e.oldStyle&&t.resetStyle(e.oldStyle);t.setValue(s),e.selection&&t.updateSelectionFromCoords(e.selection[0],e.selection[1],e.selection[2],e.selection[3])}}t.parent.ignoreEvents=n,t.ignoreHistory=o,l.A.call(t,"onundo",t,e)},h=function(){let e,t=this,n=!!t.parent.ignoreEvents,o=!!t.ignoreHistory;if(t.parent.ignoreEvents=!0,t.ignoreHistory=!0,t.historyIndex<t.history.length-1){if("insertRow"==(e=t.history[++t.historyIndex]).action)d.call(t,0,e);else if("deleteRow"==e.action)d.call(t,1,e);else if("insertColumn"==e.action)p.call(t,0,e);else if("deleteColumn"==e.action)p.call(t,1,e);else if("moveRow"==e.action)t.moveRow(e.oldValue,e.newValue);else if("moveColumn"==e.action)t.moveColumn(e.oldValue,e.newValue);else if("setMerge"==e.action)r.FU.call(t,e.column,e.colspan,e.rowspan,1);else if("setStyle"==e.action)t.setStyle(e.newValue,null,null,1);else if("setWidth"==e.action)t.setWidth(e.column,e.newValue);else if("setHeight"==e.action)t.setHeight(e.row,e.newValue);else if("setHeader"==e.action)t.setHeader(e.column,e.newValue);else if("setComments"==e.action)t.setComments(e.newValue);else if("orderBy"==e.action)i.Th.call(t,e.column,e.order),i.iY.call(t,e.rows);else if("setValue"==e.action){t.setValue(e.records);for(let n=0;n<e.records.length;n++)e.oldStyle&&t.resetStyle(e.newStyle);e.selection&&t.updateSelectionFromCoords(e.selection[0],e.selection[1],e.selection[2],e.selection[3])}}t.parent.ignoreEvents=n,t.ignoreHistory=o,l.A.call(t,"onredo",t,e)}},530:function(__unused_webpack_module,__nested_webpack_exports__,__nested_webpack_require_15476__){__nested_webpack_require_15476__.d(__nested_webpack_exports__,{$O:function(){return getWorksheetActive},$x:function(){return parseValue},C6:function(){return showIndex},Em:function(){return executeFormula},P9:function(){return createCell},Rs:function(){return updateScroll},TI:function(){return hideIndex},Xr:function(){return getCellFromCoords},Y5:function(){return fullscreen},am:function(){return updateTable},dw:function(){return isFormula},eN:function(){return getWorksheetInstance},hG:function(){return updateResult},ju:function(){return createNestedHeader},k9:function(){return updateCell},o8:function(){return updateTableReferences},p9:function(){return getLabel},rS:function(){return getMask},tT:function(){return getCell},xF:function(){return updateFormulaChain},yB:function(){return updateFormula}});var _dispatch_js__WEBPACK_IMPORTED_MODULE_3__=__nested_webpack_require_15476__(805),_selection_js__WEBPACK_IMPORTED_MODULE_1__=__nested_webpack_require_15476__(657),_helpers_js__WEBPACK_IMPORTED_MODULE_4__=__nested_webpack_require_15476__(978),_meta_js__WEBPACK_IMPORTED_MODULE_5__=__nested_webpack_require_15476__(654),_freeze_js__WEBPACK_IMPORTED_MODULE_6__=__nested_webpack_require_15476__(296),_pagination_js__WEBPACK_IMPORTED_MODULE_7__=__nested_webpack_require_15476__(167),_footer_js__WEBPACK_IMPORTED_MODULE_0__=__nested_webpack_require_15476__(160),_internalHelpers_js__WEBPACK_IMPORTED_MODULE_2__=__nested_webpack_require_15476__(689);let updateTable=function(){let e=this;if(e.options.minSpareRows>0){let t=0;for(let n=e.rows.length-1;n>=0;n--){let l=!1;for(let t=0;t<e.headers.length;t++)e.options.data[n][t]&&(l=!0);if(l)break;t++}e.options.minSpareRows-t>0&&e.insertRow(e.options.minSpareRows-t)}if(e.options.minSpareCols>0){let t=0;for(let n=e.headers.length-1;n>=0;n--){let l=!1;for(let t=0;t<e.rows.length;t++)e.options.data[t][n]&&(l=!0);if(l)break;t++}e.options.minSpareCols-t>0&&e.insertColumn(e.options.minSpareCols-t)}e.options.footers&&_footer_js__WEBPACK_IMPORTED_MODULE_0__.e.call(e),setTimeout(function(){_selection_js__WEBPACK_IMPORTED_MODULE_1__.Aq.call(e)},0)},parseNumber=function(e,t){let n=t&&this.options.columns[t].decimal?this.options.columns[t].decimal

1setValue(o,this.checked)},1!=l.options.columns[e].readOnly&&0!=l.options.editable||s.setAttribute("disabled","disabled"),o.appendChild(s),l.options.data[t][e]=s.checked}else if(l.options.columns&&l.options.columns[e]&&"calendar"==l.options.columns[e].type){let t=null;if(!validDate(n)){let o=jSuites.calendar.extractDateFromString(n,l.options.columns[e].options&&l.options.columns[e].options.format||"YYYY-MM-DD");o&&(t=o)}o.textContent=jSuites.calendar.getDateString(t||n,l.options.columns[e].options&&l.options.columns[e].options.format)}else if(l.options.columns&&l.options.columns[e]&&"dropdown"==l.options.columns[e].type)o.classList.add("jss_dropdown"),o.textContent=getDropDownValue.call(l,e,n);else if(l.options.columns&&l.options.columns[e]&&"color"==l.options.columns[e].type)if("square"==l.options.columns[e].render){let e=document.createElement("div");e.className="color",e.style.backgroundColor=n,o.appendChild(e)}else o.style.color=n,o.textContent=n;else if(l.options.columns&&l.options.columns[e]&&"image"==l.options.columns[e].type){if(n&&"data:image"==n.substr(0,10)){let e=document.createElement("img");e.src=n,o.appendChild(e)}}else l.options.columns&&l.options.columns[e]&&"html"==l.options.columns[e].type||!0===l.parent.config.parseHTML?o.innerHTML=stripScript(parseValue.call(this,e,t,n,o)):o.textContent=parseValue.call(this,e,t,n,o);l.options.columns&&l.options.columns[e]&&1==l.options.columns[e].readOnly&&(o.className="readonly");let s=l.options.columns&&l.options.columns[e]&&l.options.columns[e].align||l.options.defaultColAlign||"center";return o.style.textAlign=s,l.options.columns&&l.options.columns[e]&&0==l.options.columns[e].wordWrap||!(1==l.options.wordWrap||l.options.columns&&l.options.columns[e]&&1==l.options.columns[e].wordWrap||o.innerHTML.length>200)||(o.style.whiteSpace="pre-wrap"),e>0&&1==this.options.textOverflow&&(n||o.innerHTML?l.records[t][e-1].element.style.overflow="hidden":e==l.options.columns.length-1&&(o.style.overflow="hidden")),_dispatch_js__WEBPACK_IMPORTED_MODULE_3__.A.call(l,"oncreatecell",l,o,e,t,n),o},updateCell=function(e,t,n,l){let o,s=this;if(1!=s.records[t][e].element.classList.contains("readonly")||l){if("="==(""+n).substr(0,1)&&1==s.options.secureFormulas){let e=secureFormula(n);e!=n&&(n=e)}let l=_dispatch_js__WEBPACK_IMPORTED_MODULE_3__.A.call(s,"onbeforechange",s,s.records[t][e].element,e,t,n);if(null!=l&&(n=l),s.options.columns&&s.options.columns[e]&&"object"==typeof s.options.columns[e].type&&"function"==typeof s.options.columns[e].type.updateCell){let l=s.options.columns[e].type.updateCell(s.records[t][e].element,n,parseInt(e),parseInt(t),s,s.options.columns[e]);void 0!==l&&(n=l)}o={x:e,y:t,col:e,row:t,value:n,oldValue:s.options.data[t][e]};let r=s.options.columns&&s.options.columns[e]&&"object"==typeof s.options.columns[e].type?s.options.columns[e].type:null;if(r)s.options.data[t][e]=n,"function"==typeof r.setValue&&r.setValue(s.records[t][e].element,n);else if(s.options.columns&&s.options.columns[e]&&("checkbox"==s.options.columns[e].type||"radio"==s.options.columns[e].type)){if("radio"==s.options.columns[e].type)for(let t=0;t<s.options.data.length;t++)s.options.data[t][e]=!1;s.records[t][e].element.children[0].checked=1==n||1==n||"true"==n||"TRUE"==n,s.options.data[t][e]=s.records[t][e].element.children[0].checked}else if(s.options.columns&&s.options.columns[e]&&"dropdown"==s.options.columns[e].type)s.options.data[t][e]=n,s.records[t][e].element.textContent=getDropDownValue.call(s,e,n);else if(s.options.columns&&s.options.columns[e]&&"calendar"==s.options.columns[e].type){let l=null;if(!validDate(n)){let t=jSuites.calendar.extractDateFromString(n,s.options.columns[e].options&&s.options.columns[e].options.format||"YYYY-MM-DD");t&&(l=t)}s.options.data[t][e]=n,s.records[t][e].element.textContent=jSuites.calendar.getDateString(l||n,s.options.columns[e].options&&s.options.columns[e].options.format)}else if(s.options.columns&&s.options.columns[e]&&"color"==s.options.columns[e].type)if(s.options.data[t][e]=n,"square"==s.options.columns[e].render){let l=document.createElement("div");l.className="color",l.style.backgroundColor=n,s.records[t][e].element.textContent="",s.records[t][e].element.appendChild(l)}else s.records[t][e].element.style.color=n,s.records[t][e].element.textContent=n;else if(s.options.columns&&s.options.columns[e]&&"image"==s.options.columns[e].type){if(n=""+n,s.options.data[t][e]=n,s.records[t][e].element.innerHTML="",n&&"data:image"==n.substr(0,10)){let l=document.createElement("img");l.src=n,s.records[t][e].element.appendChild(l)}}else s.options.data[t][e]=n,s.options.columns&&s.options.columns[e]&&"html"==s.options.columns[e].type?s.records[t][e].element.innerHTML=stripScript(parseValue.call(s,e,t,n)):!0===s.parent.config.parseHTML?s.records[t][e].element.innerHTML=stripScript(parseValue.call(s,e,t,n,s.records[t][e].element)):s.records[t][e].element.textContent=parseValue.call(s,e,t,n,s.records[t][e].element),s.options.columns&&s.options.columns[e]&&0==s.options.columns[e].wordWrap||!(1==s.options.wordWrap||s.options.columns&&s.options.columns[e]&&1==s.options.columns[e].wordWrap||s.records[t][e].element.innerHTML.length>200)?s.records[t][e].element.style.whiteSpace="":s.records[t][e].element.style.whiteSpace="pre-wrap";e>0&&(s.records[t][e-1].element.style.overflow=n?"hidden":""),s.options.columns&&s.options.columns[e]&&"function"==typeof s.options.columns[e].render&&s.options.columns[e].render(s.records[t]&&s.records[t][e]?s.records[t][e].element:null,n,parseInt(e),parseInt(t),s,s.options.columns[e]),_dispatch_js__WEBPACK_IMPORTED_MODULE_3__.A.call(s,"onchange",s,s.records[t]&&s.records[t][e]?s.records[t][e].element:null,e,t,n,o.oldValue)}else o={x:e,y:t,col:e,row:t};return o},isFormula=function(e){let t=(""+e)[0];return"="==t||"#"==t},getMask=function(e){if(e.format||e.mask||e.locale){let t={};return e.mask?t.mask=e.mask:e.format?t.mask=e.format:(t.locale=e.locale,t.options=e.options),e.decimal&&(t.options||(t.options={}),t.options={decimal:e.decimal}),t}return null},secureFormula=function(e){let t="",n=0;for(let l=0;l<e.length;l++)'"'==e[l]&&(n=+(0==n)),t+=1==n?e[l]:e[l].toUpperCase();return t},chainLoopProtection=[],updateFormulaChain=function(e,t,n){let l=this,o=(0,_internalHelpers_js__WEBPACK_IMPORTED_MODULE_2__.t3)([e,t]);if(l.formula[o]&&l.formula[o].length>0)if(chainLoopProtection[o])l.records[t][e].element.innerHTML="#ERROR",l.formula[o]="";else{chainLoopProtection[o]=!0;for(let e=0;e<l.formula[o].length;e++){let t=(0,_internalHelpers_js__WEBPACK_IMPORTED_MODULE_2__.vu)(l.formula[o][e],!0),s=""+l.options.data[t[1]][t[0]];"="==s.substr(0,1)?n.push(updateCell.call(l,t[0],t[1],s,!0)):Object.keys(l.formula)[e]=null,updateFormulaChain.call(l,t[0],t[1],n)}}chainLoopProtection=[]},updateFormula=function(e,t){let n=/[A-Z]/,l=/[0-9]/,o="",s=null,r=null,i="";for(let a=0;a<e.length;a++)n.exec(e[a])?(s=1,r=0,i+=e[a]):l.exec(e[a])?(r=+!!s,i+=e[a]):(s&&r&&(i=t[i]?t[i]:i),o+=i,o+=e[a],s=0,r=0,i="");return i&&(s&&r&&(i=t[i]?t[i]:i),o+=i),o},updateFormulas=function(e){let t=this;for(let n=0;n<t.options.data.length;n++)for(let l=0;l<t.options.data[0].length;l++){let o=""+t.options.data[n][l];if("="==o.substr(0,1)){let s=updateFormula(o,e);s!=o&&(t.options.data[n][l]=s)}}let n=[],l=Object.keys(t.formula);for(let o=0;o<l.length;o++){let s=l[o],r=t.formula[s];e[s]&&(s=e[s]),n[s]=[];for(let t=0;t<r.length;t++){let l=r[t];e[l]&&(l=e[l]),n[s].push(l)}}t.formula=n},updateTableReferences=function(){let e=this;if(e.skipUpdateTableReferences)return;for(let t=0;t<e.headers.length;t++)e.headers[t].getAttribute("data-x")!=t&&(e.headers[t].setAttribute("data-x",t),e.headers[t].getAttribute("title")||(e.headers[t].innerHTML=(0,_helpers_js__WEBPACK_IMPORTED_MODULE_4__.getColumnName)(t)));for(let t=0;t<e.rows.length;t++)e.rows[t]&&e.rows[t].element.getAttribute("data-y")!=t&&(e.rows[t].element.setAttribute("data-y",t),e.rows[t].element.children[0].setAttribute("data-y",t),e.rows[t].element.children[0].innerHTML=t+1);let t=[],n=[],l=function(n,l,o,s){if(n!=o&&e.records[s][o].element.setAttribute("data-x",o),l!=s&&e.records[s][o].element.setAttribute("data-y",s),n!=o||l!=s){let e=(0,_internalHelpers_js__WEBPACK_IMPORTED_MODULE_2__.t3)([n,l]),r=(0,_internalHelpers_js__WEBPACK_IMPORTED_MODULE_2__.t3)([o,s]);t[e]=r}};for(let t=0;t<e.records.length;t++)for(let o=0;o<e.records[0].length;o++)if(e.records[t][o]){let s=e.records[t][o].element.getAttribute("data-x"),r=e.records[t][o].element.getAttribute("data-y");if(e.records[t][o].element.getAttribute("data-merged")){let e=(0,_internalHelpers_js__WEBPACK_IMPORTED_MODULE_2__.t3)([s,r]),l=(0,_internalHelpers_js__WEBPACK_IMPORTED_MODULE_2__.t3)([o,t]);if(null==n[e])if(e==l)n[e]=!1;else{let i=parseInt(o-s),a=parseInt(t-r);n[e]=[l,i,a]}}else l(s,r,o,t)}let o=Object.keys(n);if(o.length){for(let t=0;t<o.length;t++)if(n[o[t]]){let s=(0,_internalHelpers_js__WEBPACK_IMPORTED_MODULE_2__.vu)(o[t],!0),r=s[0],i=s[1];l(r,i,r+n[o[t]][1],i+n[o[t]][2]);let a=o[t],c=n[o[t]][0];for(let l=0;l<e.options.mergeCells[a][2].length;l++)r=parseInt(e.options.mergeCells[a][2][l].getAttribute("data-x")),i=parseInt(e.options.mergeCells[a][2][l].getAttribute("data-y")),e.options.mergeCells[a][2][l].setAttribute("data-x",r+n[o[t]][1]),e.options.mergeCells[a][2][l].setAttribute("data-y",i+n[o[t]][2]);e.options.mergeCells[c]=e.options.mergeCells[a],delete e.options.mergeCells[a]}}updateFormulas.call(e,t),_meta_js__WEBPACK_IMPORTED_MODULE_5__.hs.call(e,t),_selection_js__WEBPACK_IMPORTED_MODULE_1__.G9.call(e),updateTable.call(e)},updateScroll=function(e){let t,n,l=this,o=l.content.getBoundingClientRect(),s=o.left,r=o.top,i=o.width,a=o.height,c=l.records[l.selectedCell[3]][l.selectedCell[2]].element.getBoundingClientRect(),d=c.left,p=c.top,u=c.width,h=c.height;0==e||1==e?(t=d-s+l.content.scrollLeft,n=p-r+l.content.scrollTop-2):(t=d-s+l.content.scrollLeft+u,n=p-r+l.content.scrollTop+h),n>l.content.scrollTop+30&&n<l.content.scrollTop+a||(n<l.content.scrollTop+30?l.content.scrollTop=n-h:l.content.scrollTop=n-(a-2));let f=_freeze_js__WEBPACK_IMPORTED_MODULE_6__.w.call(l);t>l.content.scrollLeft+f&&t<l.content.scrollLeft+i||(t<l.content.scrollLeft+30?(l.content.scrollLeft=t,l.content.scrollLeft<50&&(l.content.scrollLeft=0)):t<l.content.scrollLeft+f?l.content.scrollLeft=t-f-1:l.content.scrollLeft=t-(i-20))},updateResult=function(){let e=this,t=0,n=0;for(t=1==e.options.lazyLoading?100:e.options.pagination>0?e.options.pagination:e.results?e.results.length:e.rows.length;e.tbody.firstChild;)e.tbody.removeChild(e.tbody.firstChild);for(let l=0;l<e.rows.length;l++)!e.results||e.results.indexOf(l)>-1?(n<t&&(e.tbody.appendChild(e.rows[l].element),n++),e.rows[l].element.style.display=""):e.rows[l].element.style.display="none";return e.options.pagination>0&&_pagination_js__WEBPACK_IMPORTED_MODULE_7__.IV.call(e),_selection_js__WEBPACK_IMPORTED_MODULE_1__.Aq.call(e),t},getCell=function(e,t){if("string"==typeof e){let n=(0,_internalHelpers_js__WEBPACK_IMPORTED_MODULE_2__.vu)(e,!0);e=n[0],t=n[1]}return this.records[t][e].element},getCellFromCoords=function(e,t){return this.records[t][e].element},getLabel=function(e,t){if("string"==typeof e){let n=(0,_internalHelpers_js__WEBPACK_IMPORTED_MODULE_2__.vu)(e,!0);e=n[0],t=n[1]}return this.records[t][e].element.innerHTML},fullscreen=function(e){let t=this;null==e&&(e=!t.config.fullscreen),t.config.fullscreen!=e&&(t.config.fullscreen=e,1==e?t.element.classList.add("fullscreen"):t.element.classList.remove("fullscreen"))},showIndex=function(){this.table.classList.remove("jss_hidden_index")},hideIndex=function(){this.table.classList.add("jss_hidden_index")},createNestedHeader=function(e){let t=this,n=document.createElement("tr");n.classList.add("jss_nested");let l=document.createElement("td");l.classList.add("jss_selectall"),n.appendChild(l),e.element=n;let o=0;for(let l=0;l<e.length;l++){e[l].colspan||(e[l].colspan=1),e[l].title||(e[l].title=""),e[l].id||(e[l].id="");let s=e[l].colspan,r=[];for(let e=0;e<s;e++)t.options.columns[o]&&"hidden"==t.options.columns[o].type&&s++,r.push(o),o++;let i=document.createElement("td");i.setAttribute("data-column",r.join(",")),i.setAttribute("colspan",e[l].colspan),i.setAttribute("align",e[l].align||"center"),i.setAttribute("id",e[l].id),i.textContent=e[l].title,n.appendChild(i)}return n},getWorksheetActive=function(){let e=this.parent?this.parent:this;return e.element.tabs?e.element.tabs.getActive():0},getWorksheetInstance=function(e){let t=void 0!==e?e:getWorksheetActive.call(this);return this.worksheets[t]}},689:function(e,t,n){n.d(t,{Hh:function(){return o},t3:function(){return r},vu:function(){return s}});var l=n(978);let o=function(e,t,n){if(t<=e.length)return e.slice(0,t).concat(n).concat(e.slice(t));let l=e.slice(0,e.length);for(;t>l.length;)l.push(void 0);return l.concat(n)},s=function(e,t){let n=/^[a-zA-Z]+/.exec(e);if(n){let l=0;for(let e=0;e<n[0].length;e++)l+=parseInt(n[0].charCodeAt(e)-64)*Math.pow(26,n[0].length-1-e);--l<0&&(l=0);let o=parseInt(/[0-9]+$/.exec(e));o>0&&o--,e=1==t?[l,o]:l+"-"+o}return e},r=function(e){return Array.isArray(e)||(e=e.split("-")),(0,l.getColumnName)(parseInt(e[0]))+(parseInt(e[1])+1)}},497:function(e,t,n){n.d(t,{AG:function(){return o},G_:function(){return s},p6:function(){return r},wu:function(){return l}});let l=function(e){let t,n=this;t=(1==n.options.search||1==n.options.filters)&&n.results?n.results:n.rows;let l=100;null!=e&&-1!=e||(e=Math.ceil(t.length/l)-1);let o=e*l,s=e*l+l;s>t.length&&(s=t.length),(o=s-100)<0&&(o=0);for(let e=o;e<s;e++)(1==n.options.search||1==n.options.filters)&&n.results?n.tbody.appendChild(n.rows[t[e]].element):n.tbody.appendChild(n.rows[e].element),n.tbody.children.length>l&&n.tbody.removeChild(n.tbody.firstChild)},o=function(){let e=this;if(e.selectedCell){let t=parseInt(e.tbody.firstChild.getAttribute("data-y"))/100,n=parseInt(e.selectedCell[3]/100),l=parseInt(e.rows.length/100);if(t!=n&&n<=l&&!Array.prototype.indexOf.call(e.tbody.children,e.rows[e.selectedCell[3]].element))return e.loadPage(n),!0}return!1},s=function(){let e,t=this;e=(1==t.options.search||1==t.options.filters)&&t.results?t.results:t.rows;let n=0;if(e.length>100){let l=parseInt(t.tbody.firstChild.getAttribute("data-y"));if((1==t.options.search||1==t.options.filters)&&t.results&&(l=e.indexOf(l)),l>0)for(let o=0;o<30;o++)(l-=1)>-1&&((1==t.options.search||1==t.options.filters)&&t.results?t.tbody.insertBefore(t.rows[e[l]].element,t.tbody.firstChild):t.tbody.insertBefore(t.rows[l].element,t.tbody.firstChild),t.tbody.children.length>100&&(t.tbody.removeChild(t.tbody.lastChild),n=1))}return n},r=function(){let e,t=this;e=(1==t.options.search||1==t.options.filters)&&t.results?t.results:t.rows;let n=0;if(e.length>100){let l=parseInt(t.tbody.lastChild.getAttribute("data-y"));if((1==t.options.search||1==t.options.filters)&&t.results&&(l=e.indexOf(l)),l<t.rows.length-1)for(let o=0;o<=30;o++)l<e.length&&((1==t.options.search||1==t.options.filters)&&t.results?t.tbody.appendChild(t.rows[e[l]].element):t.tbody.appendChild(t.rows[l].element),t.tbody.children.length>100&&(t.tbody.removeChild(t.tbody.firstChild),n=1)),l+=1}return n}},910:function(e,t,n){n.d(t,{D0:function(){return c},FU:function(){return p},Lt:function(){return a},VP:function(){return h},Zp:function(){return u},fd:function(){return d}});var l=n(689),o=n(530),s=n(911),r=n(805),i=n(657);let a=function(e,t){let n=this,o=[];if(n.options.mergeCells){let s=Object.keys(n.options.mergeCells);for(let r=0;r<s.length;r++){let i=(0,l.vu)(s[r],!0),a=n.options.mergeCells[s[r]][0],c=i[0],d=i[0]+(a>1?a-1:0);null==t?c<=e&&d>=e&&o.push(s[r]):t?c<e&&d>=e&&o.push(s[r]):c<=e&&d>e&&o.push(s[r])}}return o},c=function(e,t){let n=this,o=[];if(n.options.mergeCells){let s=Object.keys(n.options.mergeCells);for(let r=0;r<s.length;r++){let i=(0,l.vu)(s[r],!0),a=n.options.mergeCells[s[r]][1],c=i[1],d=i[1]+(a>1?a-1:0);null==t?c<=e&&d>=e&&o.push(s[r]):t?c<e&&d>=e&&o.push(s[r]):c<=e&&d>e&&o.push(s[r])}}return o},d=function(e){let t=this,n={};if(e)n=t.options.mergeCells&&t.options.mergeCells[e]?[t.options.mergeCells[e][0],t.options.mergeCells[e][1]]:null;else if(t.options.mergeCells){t.options.mergeCells;let e=Object.keys(t.options.mergeCells);for(let l=0;l<e.length;l++)n[e[l]]=[t.options.mergeCells[e[l]][0],t.options.mergeCells[e[l]][1]]}return n},p=function(e,t,n,a){let c=this,d=!1;if(e){if("string"!=typeof e)return null}else{if(!c.highlighted.length)return alert(jSuites.translate("No cells selected")),null;{let o=parseInt(c.highlighted[0].getAttribute("data-x")),s=parseInt(c.highlighted[0].getAttribute("data-y")),r=parseInt(c.highlighted[c.highlighted.length-1].getAttribute("data-x")),i=parseInt(c.highlighted[c.highlighted.length-1].getAttribute("data-y"));e=(0,l.t3)([o,s]),t=r-o+1,n=i-s+1}}let p=(0,l.vu)(e,!0);if(c.options.mergeCells&&c.options.mergeCells[e])c.records[p[1]][p[0]].element.getAttribute("data-merged")&&(d="Cell already merged");else if((!t||t<2)&&(!n||n<2))d="Invalid merged properties";else for(let e=p[1];e<p[1]+n;e++)for(let n=p[0];n<p[0]+t;n++)(0,l.t3)([n,e]),c.records[e][n].element.getAttribute("data-merged")&&(d="There is a conflict with another merged cell");if(d)alert(jSuites.translate(d));else{t>1?c.records[p[1]][p[0]].element.setAttribute("colspan",t):t=1,n>1?c.records[p[1]][p[0]].element.setAttribute("rowspan",n):n=1,c.options.mergeCells||(c.options.mergeCells={}),c.options.mergeCells[e]=[t,n,[]],c.records[p[1]][p[0]].element.setAttribute("data-merged","true"),c.records[p[1]][p[0]].element.style.overflow="hidden";let l=[];for(let s=p[1];s<p[1]+n;s++)for(let n=p[0];n<p[0]+t;n++)p[0]==n&&p[1]==s||(l.push(c.options.data[s][n]),o.k9.call(c,n,s,"",!0),c.options.mergeCells[e][2].push(c.records[s][n].element),c.records[s][n].element.style.display="none",c.records[s][n].element=c.records[p[1]][p[0]].element);i.c6.call(c,c.records[p[1]][p[0]].element),a||(s.Dh.call(c,{action:"setMerge",column:e,colspan:t,rowspan:n,data:l}),r.A.call(c,"onmerge",c,{[e]:[t,n]}))}},u=function(e,t,n){let s=this;if(s.options.mergeCells&&s.options.mergeCells[e]){let r=(0,l.vu)(e,!0);s.records[r[1]][r[0]].element.removeAttribute("colspan"),s.records[r[1]][r[0]].element.removeAttribute("rowspan"),s.records[r[1]][r[0]].element.removeAttribute("data-merged");let a=s.options.mergeCells[e],c,d,p=0;for(c=0;c<a[1];c++)for(d=0;d<a[0];d++)(c>0||d>0)&&(s.records[r[1]+c][r[0]+d].element=a[2][p],s.records[r[1]+c][r[0]+d].element.style.display="",t&&t[p]&&o.k9.call(s,r[0]+d,r[1]+c,t[p]),p++);i.c6.call(s,s.records[r[1]][r[0]].element,s.records[r[1]+c-1][r[0]+d-1].element),n||delete s.options.mergeCells[e]}},h=function(e){let t=this;if(t.options.mergeCells){t.options.mergeCells;let n=Object.keys(t.options.mergeCells);for(let l=0;l<n.length;l++)u.call(t,n[l],null,e)}}},654:function(e,t,n){n.d(t,{IQ:function(){return o},hs:function(){return s},iZ:function(){return r}});var l=n(805);let o=function(e,t){let n=this;return e?t?n.options.meta&&n.options.meta[e]&&n.options.meta[e][t]?n.options.meta[e][t]:null:n.options.meta&&n.options.meta[e]?n.options.meta[e]:null:n.options.meta},s=function(e){let t=this;if(t.options.meta){let n={},l=Object.keys(t.options.meta);for(let o=0;o<l.length;

1ords)(t[0],t[1]);if(e.records[t[1]][t[0]].element.getAttribute("data-merged"))e.removeMerge(n);else{let l=t[2]-t[0]+1,o=t[3]-t[1]+1;1===l&&1===o||e.setMerge(n,l,o)}}},updateState:function(e,t,l){s(l,n())}}),e.push({type:"select",options:["border_all","border_outer","border_inner","border_horizontal","border_vertical","border_left","border_top","border_right","border_bottom","border_clear"],columns:5,render:function(e){return'<i class="material-icons">'+e+"</i>"},right:!0,onchange:function(e,t,o,s){let r=n();if(r.selectedCell){let e=[Math.min(r.selectedCell[0],r.selectedCell[2]),Math.min(r.selectedCell[1],r.selectedCell[3]),Math.max(r.selectedCell[0],r.selectedCell[2]),Math.max(r.selectedCell[1],r.selectedCell[3])],n=s;if(e){let o=t.thickness||1,s=t.color||"black",i=t.style||"solid";"double"===i&&(o+=2);let a={},c=e[0],d=e[1],p=e[2],u=e[3],h=function(e,t,l){let r=["","","",""];r[0]=("border_top"===n||"border_outer"===n)&&l===d||("border_inner"===n||"border_horizontal"===n)&&l>d||"border_all"===n?"border-top: "+o+"px "+i+" "+s:"border-top: ",r[1]="border_all"!==n&&"border_right"!==n&&"border_outer"!==n||t!==p?"border-right: ":"border-right: "+o+"px "+i+" "+s,r[2]="border_all"!==n&&"border_bottom"!==n&&"border_outer"!==n||l!==u?"border-bottom: ":"border-bottom: "+o+"px "+i+" "+s,r[3]=("border_left"===n||"border_outer"===n)&&t===c||("border_inner"===n||"border_vertical"===n)&&t>c||"border_all"===n?"border-left: "+o+"px "+i+" "+s:"border-left: ",a[e]=r.join(";")};for(let t=e[1];t<=e[3];t++)for(let n=e[0];n<=e[2];n++)h((0,l.getCellNameFromCoords)(n,t),n,t),r.records[t][n].element.getAttribute("data-merged")&&h((0,l.getCellNameFromCoords)(e[0],e[1]),n,t);Object.keys(a)&&r.setStyle(a)}}},onload:function(e,t){let n=document.createElement("div"),l=document.createElement("div");n.appendChild(l);let o=jSuites.color(l,{closeOnChange:!1,onchange:function(e,n){e.parentNode.children[1].style.color=n,t.color=n}}),s=document.createElement("i");s.classList.add("material-icons"),s.innerHTML="color_lens",s.onclick=function(){o.open()},n.appendChild(s),e.children[1].appendChild(n),l=document.createElement("div"),jSuites.picker(l,{type:"select",data:[1,2,3,4,5],render:function(e){return'<div style="height: '+e+'px; width: 30px; background-color: black;"></div>'},onchange:function(e,n,l,o){t.thickness=o},width:"50px"}),e.children[1].appendChild(l);let r=document.createElement("div");jSuites.picker(r,{type:"select",data:["solid","dotted","dashed","double"],render:function(e){return"double"===e?'<div style="width: 30px; border-top: 3px '+e+' black;"></div>':'<div style="width: 30px; border-top: 2px '+e+' black;"></div>'},onchange:function(e,n,l,o){t.style=o},width:"50px"}),e.children[1].appendChild(r),(l=document.createElement("div")).style.flex="1",e.children[1].appendChild(l)},updateState:function(e,t,l){s(l,n())}}),e.push({type:"divisor"}),e.push({content:"fullscreen",tooltip:"Toggle Fullscreen",onclick:function(e,n,l){"fullscreen"===l.children[0].textContent?(t.fullscreen(!0),l.children[0].textContent="fullscreen_exit"):(t.fullscreen(!1),l.children[0].textContent="fullscreen")},updateState:function(e,t,n,l){!0===l.parent.config.fullscreen?n.children[0].textContent="fullscreen_exit":n.children[0].textContent="fullscreen"}}),e},i=function(e){let t=this,n=e.items;for(let e=0;e<n.length;e++)n[e].tooltip&&(n[e].title=n[e].tooltip,delete n[e].tooltip),"select"==n[e].type?n[e].options?(n[e].data=n[e].options,delete n[e].options):(n[e].data=n[e].v,delete n[e].v,n[e].k&&!n[e].onchange&&(n[e].onchange=function(l,s,r){let i=o.eN.call(t),a=i.getSelected(!0);i.setStyle(Object.fromEntries(a.map(function(t){return[t,n[e].k+": "+r]})))})):"color"==n[e].type&&(n[e].type="i",n[e].onclick=function(l,s,r){r.color||(jSuites.color(r,{onchange:function(l,s){let r=o.eN.call(t),i=r.getSelected(!0);r.setStyle(Object.fromEntries(i.map(function(t){return[t,n[e].k+": "+s]})))},onopen:function(e){e.color.select("")}}),r.color.open())})},a=function(e){let t=this,n=document.createElement("div");return n.classList.add("jss_toolbar"),i.call(t,e),"object"==typeof t.plugins&&Object.entries(t.plugins).forEach(function([,t]){if("function"==typeof t.toolbar){let n=t.toolbar(e);n&&(e=n)}}),jSuites.toolbar(n,e),n},c=function(e){e.parent.toolbar&&e.parent.toolbar.toolbar.update(e)},d=function(){let e=this;if(e.config.toolbar&&!e.toolbar){let t;Array.isArray(e.config.toolbar)?t={items:e.config.toolbar}:"object"==typeof e.config.toolbar?t=e.config.toolbar:(t={items:r.call(e)},"function"==typeof e.config.toolbar&&(t=e.config.toolbar(t))),e.toolbar=e.element.insertBefore(a.call(e,t),e.element.children[1])}},p=function(){let e=this;e.toolbar&&(e.toolbar.parentNode.removeChild(e.toolbar),delete e.toolbar)}}},__webpack_module_cache__={};function __nested_webpack_require_64087__(e){var t=__webpack_module_cache__[e];if(void 0!==t)return t.exports;var n=__webpack_module_cache__[e]={exports:{}};return __webpack_modules__[e](n,n.exports,__nested_webpack_require_64087__),n.exports}__nested_webpack_require_64087__.d=function(e,t){for(var n in t)__nested_webpack_require_64087__.o(t,n)&&!__nested_webpack_require_64087__.o(e,n)&&Object.defineProperty(e,n,{enumerable:!0,get:t[n]})},__nested_webpack_require_64087__.o=function(e,t){return Object.prototype.hasOwnProperty.call(e,t)},__nested_webpack_require_64087__.r=function(e){"undefined"!=typeof Symbol&&Symbol.toStringTag&&Object.defineProperty(e,Symbol.toStringTag,{value:"Module"}),Object.defineProperty(e,"__esModule",{value:!0})};var __nested_webpack_exports__={};__nested_webpack_require_64087__.d(__nested_webpack_exports__,{default:function(){return src}});let lib={jspreadsheet:{}};var libraryBase=lib,dispatch=__nested_webpack_require_64087__(805),internal=__nested_webpack_require_64087__(530),utils_history=__nested_webpack_require_64087__(911);let openEditor=function(e,t,n){let l=this,o=e.getAttribute("data-y"),s=e.getAttribute("data-x");dispatch.A.call(l,"oneditionstart",l,e,parseInt(s),parseInt(o)),s>0&&(l.records[o][s-1].element.style.overflow="hidden");let r=function(t){let n=e.getBoundingClientRect(),l=document.createElement(t);return l.style.width=n.width+"px",l.style.height=n.height-2+"px",l.style.minHeight=n.height-2+"px",e.classList.add("editor"),e.innerHTML="",e.appendChild(l),l};if(1==e.classList.contains("readonly"));else if(l.edition=[l.records[o][s].element,l.records[o][s].element.innerHTML,s,o],l.options.columns&&l.options.columns[s]&&"object"==typeof l.options.columns[s].type)l.options.columns[s].type.openEditor(e,l.options.data[o][s],parseInt(s),parseInt(o),l,l.options.columns[s],n),dispatch.A.call(l,"oncreateeditor",l,e,parseInt(s),parseInt(o),null,l.options.columns[s]);else if(l.options.columns&&l.options.columns[s]&&"hidden"==l.options.columns[s].type);else if(l.options.columns&&l.options.columns[s]&&("checkbox"==l.options.columns[s].type||"radio"==l.options.columns[s].type)){let t=!e.children[0].checked;l.setValue(e,t),l.edition=null}else if(l.options.columns&&l.options.columns[s]&&"dropdown"==l.options.columns[s].type){let t,n=l.options.data[o][s];l.options.columns[s].multiple&&!Array.isArray(n)&&(n=n.split(";"));let i=[];if(t="function"==typeof l.options.columns[s].filter?l.options.columns[s].filter(l.element,e,s,o,l.options.columns[s].source):l.options.columns[s].source)for(let e=0;e<t.length;e++)i.push(t[e]);let a=r("div");dispatch.A.call(l,"oncreateeditor",l,e,parseInt(s),parseInt(o),null,l.options.columns[s]);let c={data:i,multiple:!!l.options.columns[s].multiple,autocomplete:!!l.options.columns[s].autocomplete,opened:!0,value:n,width:"100%",height:a.style.minHeight,position:1==l.options.tableOverflow||1==l.parent.config.fullscreen,onclose:function(){closeEditor.call(l,e,!0)}};l.options.columns[s].options&&l.options.columns[s].options.type&&(c.type=l.options.columns[s].options.type),jSuites.dropdown(a,c)}else if(l.options.columns&&l.options.columns[s]&&("calendar"==l.options.columns[s].type||"color"==l.options.columns[s].type)){let t=l.options.data[o][s],n=r("input");dispatch.A.call(l,"oncreateeditor",l,e,parseInt(s),parseInt(o),null,l.options.columns[s]),n.value=t;let i=l.options.columns[s].options?{...l.options.columns[s].options}:{};if(1!=l.options.tableOverflow&&1!=l.parent.config.fullscreen||(i.position=!0),i.value=l.options.data[o][s],i.opened=!0,i.onclose

1if(0==e?(n=parseInt(o.selectedCell[0]),l=parseInt(o.selectedCell[1])):(n=parseInt(o.selectedCell[2]),l=parseInt(o.selectedCell[3])),0==t){for(let e=0;e<l;e++)if("none"!=o.records[e][n].element.style.display&&"none"!=o.rows[e].element.style.display){l=e;break}}else l=upGet.call(o,n,l);0==e?(o.selectedCell[0]=n,o.selectedCell[1]=l):(o.selectedCell[2]=n,o.selectedCell[3]=l)},up=function(e,t){let n=this;if(e?n.selectedCell[3]>0&&upVisible.call(n,1,+!t):(n.selectedCell[1]>0&&upVisible.call(n,0,+!t),n.selectedCell[2]=n.selectedCell[0],n.selectedCell[3]=n.selectedCell[1]),n.updateSelectionFromCoords(n.selectedCell[0],n.selectedCell[1],n.selectedCell[2],n.selectedCell[3]),1==n.options.lazyLoading)if(0==n.selectedCell[1]||0==n.selectedCell[3])lazyLoading.wu.call(n,0),n.updateSelectionFromCoords(n.selectedCell[0],n.selectedCell[1],n.selectedCell[2],n.selectedCell[3]);else if(lazyLoading.AG.call(n))n.updateSelectionFromCoords(n.selectedCell[0],n.selectedCell[1],n.selectedCell[2],n.selectedCell[3]);else{let e=parseInt(n.tbody.firstChild.getAttribute("data-y"));n.selectedCell[1]-e<30&&(lazyLoading.G_.call(n),n.updateSelectionFromCoords(n.selectedCell[0],n.selectedCell[1],n.selectedCell[2],n.selectedCell[3]))}else if(n.options.pagination>0){let e=n.whichPage(n.selectedCell[3]);e!=n.pageNumber&&n.page(e)}internal.Rs.call(n,1)},rightGet=function(e,t){let n=this;e=parseInt(e),t=parseInt(t);for(let l=e+1;l<n.headers.length;l++)if("none"!=n.records[t][l].element.style.display){if(n.records[t][l].element.getAttribute("data-merged")&&n.records[t][l].element==n.records[t][e].element)continue;e=l;break}return e},rightVisible=function(e,t){let n,l,o=this;if(0==e?(n=parseInt(o.selectedCell[0]),l=parseInt(o.selectedCell[1])):(n=parseInt(o.selectedCell[2]),l=parseInt(o.selectedCell[3])),0==t){for(let e=o.headers.length-1;e>n;e--)if("none"!=o.records[l][e].element.style.display){n=e;break}}else n=rightGet.call(o,n,l);0==e?(o.selectedCell[0]=n,o.selectedCell[1]=l):(o.selectedCell[2]=n,o.selectedCell[3]=l)},right=function(e,t){let n=this;e?n.selectedCell[2]<n.headers.length-1&&rightVisible.call(n,1,+!t):(n.selectedCell[0]<n.headers.length-1&&rightVisible.call(n,0,+!t),n.selectedCell[2]=n.selectedCell[0],n.selectedCell[3]=n.selectedCell[1]),n.updateSelectionFromCoords(n.selectedCell[0],n.selectedCell[1],n.selectedCell[2],n.selectedCell[3]),internal.Rs.call(n,2)},downGet=function(e,t){let n=this;e=parseInt(e);for(let l=(t=parseInt(t))+1;l<n.rows.length;l++)if("none"!=n.records[l][e].element.style.display&&"none"!=n.rows[l].element.style.display){if(n.records[l][e].element.getAttribute("data-merged")&&n.records[l][e].element==n.records[t][e].element)continue;t=l;break}return t},downVisible=function(e,t){let n,l,o=this;if(0==e?(n=parseInt(o.selectedCell[0]),l=parseInt(o.selectedCell[1])):(n=parseInt(o.selectedCell[2]),l=parseInt(o.selectedCell[3])),0==t){for(let e=o.rows.length-1;e>l;e--)if("none"!=o.records[e][n].element.style.display&&"none"!=o.rows[e].element.style.display){l=e;break}}else l=downGet.call(o,n,l);0==e?(o.selectedCell[0]=n,o.selectedCell[1]=l):(o.selectedCell[2]=n,o.selectedCell[3]=l)},down=function(e,t){let n=this;if(e?n.selectedCell[3]<n.records.length-1&&downVisible.call(n,1,+!t):(n.selectedCell[1]<n.records.length-1&&downVisible.call(n,0,+!t),n.selectedCell[2]=n.selectedCell[0],n.selectedCell[3]=n.selectedCell[1]),n.updateSelectionFromCoords(n.selectedCell[0],n.selectedCell[1],n.selectedCell[2],n.selectedCell[3]),1==n.options.lazyLoading)n.selectedCell[1]==n.records.length-1||n.selectedCell[3]==n.records.length-1?(lazyLoading.wu.call(n,-1),n.updateSelectionFromCoords(n.selectedCell[0],n.selectedCell[1],n.selectedCell[2],n.selectedCell[3])):lazyLoading.AG.call(n)?n.updateSelectionFromCoords(n.selectedCell[0],n.selectedCell[1],n.selectedCell[2],n.selectedCell[3]):parseInt(n.tbody.lastChild.getAttribute("data-y"))-n.selectedCell[3]<30&&(lazyLoading.p6.call(n),n.updateSelectionFromCoords(n.selectedCell[0],n.selectedCell[1],n.selectedCell[2],n.selectedCell[3]));else if(n.options.pagination>0){let e=n.whichPage(n.selectedCell[3]);e!=n.pageNumber&&n.page(e)}internal.Rs.call(n,3)},leftGet=function(e,t){let n=this;e=parseInt(e),t=parseInt(t);for(let l=e-1;l>=0;l--)if("none"!=n.records[t][l].element.style.display){if(n.records[t][l].element.getAttribute("data-merged")&&n.records[t][l].element==n.records[t][e].element)continue;e=l;break}return e},leftVisible=function(e,t){let n,l,o=this;

1if(n[++r]){if(u>=l.rows.length-1){if(0==l.options.allowInsertRow)break;l.insertRow()}u=downGet.call(l,e,u)}}selection.AH.call(l,e,t,p,u),utils_history.Dh.call(l,{action:"setValue",records:i,selection:l.selectedCell,newStyle:a,oldStyle:c}),internal.am.call(l);let j=[];for(let l=0;l<n.length;l++)for(let o=0;o<n[l].length;o++)j.push({x:o+e,y:l+t,value:n[l][o]});dispatch.A.call(l,"onpaste",l,j);let w=i.map(function(e){return{x:e.x,y:e.y,value:e.value,oldValue:e.oldValue}});dispatch.A.call(l,"onafterchanges",l,w)}(0,selection.kA)()};var filter=__nested_webpack_require_64087__(829),footer=__nested_webpack_require_64087__(160);let getNumberOfColumns=function(){let e=this,t=e.options.columns&&e.options.columns.length||0;if(e.options.data&&void 0!==e.options.data[0]){let n=Object.keys(e.options.data[0]);n.length>t&&(t=n.length)}return e.options.minDimensions&&e.options.minDimensions[0]>t&&(t=e.options.minDimensions[0]),t},createCellHeader=function(e){let t=this,n=t.options.columns&&t.options.columns[e]&&t.options.columns[e].width||t.options.defaultColWidth||100,l=t.options.columns&&t.options.columns[e]&&t.options.columns[e].align||t.options.defaultColAlign||"center";t.headers[e]=document.createElement("td"),t.headers[e].textContent=t.options.columns&&t.options.columns[e]&&t.options.columns[e].title||(0,helpers.getColumnName)(e),t.headers[e].setAttribute("data-x",e),t.headers[e].style.textAlign=l,t.options.columns&&t.options.columns[e]&&t.options.columns[e].title&&t.headers[e].setAttribute("title",t.headers[e].innerText),t.options.columns&&t.options.columns[e]&&t.options.columns[e].id&&t.headers[e].setAttribute("id",t.options.columns[e].id);let o=document.createElement("col");o.setAttribute("width",n),t.cols[e]={colElement:o,x:e},t.options.columns&&t.options.columns[e]&&"hidden"==t.options.columns[e].type&&(t.headers[e].style.display="none",o.style.display="none")},insertColumn=function(e,t,n,l){let o=this;if(0!=o.options.allowInsertColumn){let s,r=[];Array.isArray(e)?(s=1,e&&(r=e)):s="number"==typeof e?e:1,n=!!n;let i=Math.max(o.options.columns.length,...o.options.data.map(function(e){return e.length}))-1;(null==t||t>=parseInt(i)||t<0)&&(t=i),l||(l=[]);for(let e=0;e<s;e++)l[e]||(l[e]={});let a=[];if(Array.isArray(e)){let s=[];for(let t=0;t<o.options.data.length;t++)s.push(t<e.length?e[t]:"");let r={column:t+ +!n,options:Object.assign({},l[0]),data:s};a.push(r)}else for(let o=0;o<e;o++){let e={column:t+o+ +!n,options:Object.assign({},l[o])};a.push(e)}if(!1===dispatch.A.call(o,"onbeforeinsertcolumn",o,a))return!1;if(o.options.mergeCells&&Object.keys(o.options.mergeCells).length>0&&merges.Lt.call(o,t,n).length){if(!confirm(jSuites.translate("This action will destroy any existing merged cells. Are you sure?")))return!1;o.destroyMerge()}let c=n?t:t+1;o.options.columns=(0,internalHelpers.Hh)(o.options.columns,c,l);let d=o.headers.splice(c),p=o.cols.splice(c),u=[],h=[],f=[],m=[],g=[];for(let e=c;e<s+c;e++)createCellHeader.call(o,e),o.headerContainer.insertBefore(o.headers[e],o.headerContainer.children[e+1]),o.colgroupContainer.insertBefore(o.cols[e].colElement,o.colgroupContainer.children[e+1]),u.push(o.headers[e]),h.push(o.cols[e]);if(o.options.footers)for(let e=0;e<o.options.footers.length;e++){g[e]=[];for(let t=0;t<s;t++)g[e].push("");o.options.footers[e].splice(c,0,g[e])}for(let e=0;e<o.options.data.length;e++){let t=o.options.data[e].splice(c),n=o.records[e].splice(c);m[e]=[],f[e]=[];for(let t=c;t<s+c;t++){let n=r[e]?r[e]:"";o.options.data[e][t]=n;let l=internal.P9.call(o,t,e,o.options.data[e][t]);o.records[e][t]={element:l,y:e},o.rows[e]&&o.rows[e].element.insertBefore(l,o.rows[e].element.children[t+1]),o.options.columns&&o.options.columns[t]&&"function"==typeof o.options.columns[t].render&&o.options.columns[t].render(l,n,parseInt(t),parseInt(e),o,o.options.columns[t]),m[e].push(n),f[e].push({element:l,x:t,y:e})}Array.prototype.push.apply(o.options.data[e],t),Array.prototype.push.apply(o.records[e],n)}Array.prototype.push.apply(o.headers,d),Array.prototype.push.apply(o.cols,p);for(let e=c;e<o.cols.length;e++)o.cols[e].x=e;for(let e=0;e<o.records.length;e++)for(let t=0;t<o.records[e].length;t++)o.records[e][t].x=t;if(o.options.nestedHeaders&&o.options.nestedHeaders.length>0&&o.options.nestedHeaders[0]&&o.options.nestedHeaders[0][0])for(let e=0;e<o.options.nestedHeaders.length;e++){let t=parseInt(o.options.nestedHeaders[e][o.options.nestedHeaders[e].length-1].colspan)+s;o.options.nestedHeaders[e][o.options.nestedHeaders[e].length-1].colspan=t,o.thead.children[e].children[o.thead.children[e].children.length-1].setAttribute("colspan",t);let n=o.thead.children[e].children[o.thead.children[e].children.length-1].getAttribute("data-column");n=n.split(",");for(let e=c;e<s+c;e++)n.push(e);o.thead.children[e].children[o.thead.children[e].children.length-1].setAttribute("data-column",n)}utils_history.Dh.call(o,{action:"insertColumn",columnNumber:t,numOfColumns:s,insertBefore:n,columns:l,headers:u,cols:h,records:f,footers:g,data:m}),internal.o8.call(o),dispatch.A.call(o,"oninsertcolumn",o,a)}},moveColumn=function(e,t){let n=this;if(n.options.mergeCells&&Object.keys(n.options.mergeCells).length>0){let l;if(l=+(e>t),merges.Lt.call(n,e).length||merges.Lt.call(n,t,l).length){if(!confirm(jSuites.translate("This action will destroy any existing merged cells. Are you sure?")))return!1;n.destroyMerge()}}if((e=parseInt(e))>(t=parseInt(t))){n.headerContainer.insertBefore(n.headers[e],n.headers[t]),n.colgroupContainer.insertBefore(n.cols[e].colElement,n.cols[t].colElement);for(let l=0;l<n.rows.length;l++)n.rows[l].element.insertBefore(n.records[l][e].element,n.records[l][t].element)}else{n.headerContainer.insertBefore(n.headers[e],n.headers[t].nextSibling),n.colgroupContainer.insertBefore(n.cols[e].colElement,n.cols[t].colElement.nextSibling);for(let l=0;l<n.rows.length;l++)n.rows[l].element.insertBefore(n.records[l][e].element,n.records[l][t].element.nextSibling)}n.options.columns.splice(t,0,n.options.columns.splice(e,1)[0]),n.headers.splice(t,0,n.headers.splice(e,1)[0]),n.cols.splice(t,0,n.cols.splice(e,1)[0]);let l=Math.min(e,t),o=Math.max(e,t);for(let l=0;l<n.rows.length;l++)n.options.data[l].splice(t,0,n.options.data[l].splice(e,1)[0]),n.records[l].splice(t,0,n.records[l].splice(e,1)[0]);for(let e=l;e<=o;e++)n.cols[e].x=e;for(let e=0;e<n.records.length;e++)for(let t=l;t<=o;t++)n.records[e][t].x=t;if(n.options.footers)for(let l=0;l<n.options.footers.length;l++)n.options.footers[l].splice(t,0,n.options.footers[l].splice(e,1)[0]);utils_history.Dh.call(n,{action:"moveColumn",oldValue:e,newValue:t}),internal.o8.call(n),dispatch.A.call(n,"onmovecolumn",n,e,t,1)},deleteColumn=function(e,t){let n=this;if(0!=n.options.allowDeleteColumn)if(n.headers.length>1){if(null==e){let l=n.getSelectedColumns(!0);l.length?(e=parseInt(l[0]),t=parseInt(l.length)):(e=n.headers.length-1,t=1)}let l=n.options.data[0].length-1;(null==e||e>l||e<0)&&(e=l),t||(t=1),t>n.options.data[0].length-e&&(t=n.options.data[0].length-e);let o=[];for(let n=0;n<t;n++)o.push(n+e);if(!1===dispatch.A.call(n,"onbeforedeletecolumn",n,o))return!1;if(parseInt(e)>-1){let l=!1;if(n.options.mergeCells&&Object.keys(n.options.mergeCells).length>0)for(let o=e;o<e+t;o++)merges.Lt.call(n,o,null).length&&(l=!0);if(l){if(!confirm(jSuites.translate("This action will destroy any existing merged cells. Are you sure?")))return!1;n.destroyMerge()}let s=n.options.columns?n.options.columns.splice(e,t):void 0;for(let l=e;l<e+t;l++)n.cols[l].colElement.className="",n.headers[l].className="",n.cols[l].colElement.parentNode.removeChild(n.cols[l].colElement),n.headers[l].parentNode.removeChild(n.headers[l]);let r=n.headers.splice(e,t),i=n.cols.splice(e,t),a=[],c=[],d=[];for(let l=0;l<n.options.data.length;l++)for(let o=e;o<e+t;o++)n.records[l][o].element.className="",n.records[l][o].element.parentNode.removeChild(n.records[l][o].element);for(let l=0;l<n.options.data.length;l++)c[l]=n.options.data[l].splice(e,t),a[l]=n.records[l].splice(e,t);for(let t=e;t<n.cols.length;t++)n.cols[t].x=t;for(let t=0;t<n.records.length;t++)for(let l=e;l<n.records[t].length;l++)n.records[t][l].x=l;if(n.options.footers)for(let l=0;l<n.options.footers.length;l++)d[l]=n.options.footers[l].splice(e,t);if(selection.at.call(n,0,e,e+t-1),n.options.nestedHeaders&&n.options.nestedHeaders.length>0&&n.options.nestedHeaders[0]&&n.options.nestedHeaders[0][0])for(let e=0;e<n.options.nestedHeaders.length;e++){let l=parseInt(n.options.nestedHeaders[e][n.options.nestedHeaders[e].length-1].colspan)-t;n.options.nestedHeaders[e][n.options.nestedHeaders[e].length-1].colspan=l,n.thead.children[e].children[n.thead.children[e].children.length-1].setAttribute("colspan",l)}utils_history.Dh.call(n,{action:"deleteColumn",columnNumber:e,numOfColumns:t,insertBefore:1,columns:s,headers:r,cols:i,records:a,footers:d,data:c}),internal.o8.call(n),dispatch.A.call(n,"ondeletecolumn",n,o)}}else console.error("Jspreadsheet: It is not possible to delete the last column")},getWidth=function(e){let t,n=this;if(void 0===e){t=[];for(let e=0;e<n.headers.length;e++)t.push(n.options.columns&&n.options.columns[e]&&n.options.columns[e].width||n.options.defaultColWidth||100)}else t=parseInt(n.cols[e].colElement.getAttribute("width"));return t},setWidth=function(e,t,n){let l=this;if(t){if(Array.isArray(e)){n||(n=[]);for(let o=0;o<e.length;o++){n[o]||(n[o]=parseInt(l.cols[e[o]].colElement.getAttribute("width")));let s=Array.isArray(t)&&t[o]?t[o]:t;l.cols[e[o]].colElement.setAttribute("width",s),l.options.columns||(l.options.columns=[]),l.options.columns[e[o]]||(l.options.columns[e[o]]={}),l.options.columns[e[o]].width=s}}else n||(n=parseInt(l.cols[e].colElement.getAttribute("width"))),l.cols[e].colElement.setAttribute("width",t),l.options.columns||(l.options.columns=[]),l.options.columns[e]||(l.options.columns[e]={}),l.options.columns[e].width=t;utils_history.Dh.call(l,{action:"setWidth",column:e,oldValue:n,newValue:t}),dispatch.A.call(l,"onresizecolumn",l,e,t,n),selection.Aq.call(l)}},showColumn=function(e){let t=this;Array.isArray(e)||(e=[e]);for(let n=0;n<e.length;n++){let l=e[n];t.headers[l].style.display="",t.cols[l].colElement.style.display="",t.filter&&t.filter.children.length>l+1&&(t.filter.children[l+1].style.display="");for(let e=0;e<t.options.data.length;e++)t.records[e][l].element.style.display=""}t.options.footers&&footer.e.call(t),t.resetSelection()},hideColumn=function(e){let t=this;Array.isArray(e)||(e=[e]);for(let n=0;n<e.length;n++){let l=e[n];t.headers[l].style.display="none",t.cols[l].colElement.style.display="none",t.filter&&t.filter.children.length>l+1&&(t.filter.children[l+1].style.display="none");for(let e=0;e<t.options.data.length;e++)t.records[e][l].element.style.display="none"}t.options.footers&&footer.e.call(t),t.resetSelection()},getColumnData=function(e,t){let n=this,l=[];for(let o=0;o<n.options.data.length;o++)t?l.push(n.records[o][e].element.innerHTML):l.push(n.options.data[o][e]);return l},setColumnData=function(e,t,n){let l=this;for(let o=0;o<l.rows.length;o++){let s=(0,internalHelpers.t3)([e,o]);null!=t[o]&&l.setValue(s,t[o],n)}},createRow=function(e,t){let n=this;n.records[e]||(n.records[e]=[]),t||(t=n.options.data[e]);let l={element:document.createElement("tr"),y:e};n.rows[e]=l,l.element.setAttribute("data-y",e);let o=null;n.options.defaultRowHeight&&(l.element.style.height=n.options.defaultRowHeight+"px"),n.options.rows&&n.options.rows[e]&&(n.options.rows[e].height&&(l.element.style.height=n.options.rows[e].height),n.options.rows[e].title&&(o=n.options.rows[e].title)),o||(o=parseInt(e+1));let s=document.createElement("td");s.innerHTML=o,s.setAttribute("data-y",e),s.className="jss_row",l.element.appendChild(s);let r=getNumberOfColumns.call(n);for(let o=0;o<r;o++)n.records[e][o]={element:internal.P9.call(this,o,e,t[o]),x:o,y:e},l.element.appendChild(n.records[e][o].element),n.options.columns&&n.options.columns[o]&&"function"==typeof n.options.columns[o].render&&n.options.columns[o].render(n.records[e][o].element,t[o],parseInt(o),parseInt(e),n,n.options.columns[o]);return l},insertRow=function(e,t,n){let l=this;if(0!=l.options.allowInsertRow){let o,s=[];Array.isArray(e)?(o=1,e&&(s=e)):o=void 0!==e?e:1,n=!!n;let r=l.options.data.length-1;(null==t||t>=parseInt(r)||t<0)&&(t=r);let i=[];for(let e=0;e<o;e++){let o=[];for(let e=0;e<l.options.columns.length;e++)o[e]=s[e]?s[e]:"";i.push({row:e+t+ +!n,data:o})}if(!1===dispatch.A.call(l,"onbeforeinsertrow",l,i))return!1;if(l.options.mergeCells&&Object.keys(l.options.mergeCells).length>0&&merges.D0.call(l,t,n).length){if(!confirm(jSuites.translate("This action will destroy any existing merged cells. Are you sure?")))return!1;l.destroyMerge()}if(1==l.options.search){if(l.results&&l.results.length!=l.rows.length){if(!confirm(jSuites.translate("This action will clear your search results. Are you sure?")))return!1;l.resetSearch()}l.results=null}let a=n?t:t+1,c=l.records.splice(a),d=l.options.data.splice(a),p=l.rows.splice(a),u=[],h=[],f=[];for(let e=a;e<o+a;e++){l.options.data[e]=[];for(let t=0;t<l.options.columns.length;t++)l.options.data[e][t]=s[t]?s[t]:"";let n=createRow.call(l,e,l.options.data[e]);p[0]?Array.prototype.indexOf.call(l.tbody.children,p[0].element)>=0&&l.tbody.insertBefore(n.element,p[0].element):Array.prototype.indexOf.call(l.tbody.children,l.rows[t].element)>=0&&l.tbody.appendChild(n.element),u.push([...l.records[e]]),h.push([...l.options.data[e]]),f.push(n)}Array.prototype.push.apply(l.records,c),Array.prototype.push.apply(l.options.data,d),Array.prototype.push.apply(l.rows,p);for(let e=a;e<l.rows.length;e++)l.rows[e].y=e;for(let e=a;e<l.records.length;e++)for(let t=0;t<l.records[e].length;t++)l.records[e][t].y=e;l.options.pagination>0&&l.page(l.pageNumber),utils_history.Dh.call(l,{action:"insertRow",rowNumber:t,numOfRows:o,insertBefore:n,rowRecords:u,rowData:h,rowNode:f}),internal.o8.call(l),dispatch.A.call(l,"oninsertrow",l,i)}},moveRow=function(e,t,n){let l=this;if(l.options.mergeCells&&Object.keys(l.options.mergeCells).length>0){let n;if(n=+(e>t),merges.D0.call(l,e).length||merges.D0.call(l,t,n).length){if(!confirm(jSuites.translate("This action will destroy any existing merged cells. Are you sure?")))return!1;l.destroyMerge()}}if(1==l.options.search){if(l.results&&l.results.length!=l.rows.length){if(!confirm(jSuites.translate("This action will clear your search results. Are you sure?")))return!1;l.resetSearch()}l.results=null}n||(Array.prototype.indexOf.call(l.tbody.children,l.rows[t].element)>=0?e>t?l.tbody.insertBefore(l.rows[e].element,l.rows[t].element):l.tbody.insertBefore(l.rows[e].element,l.rows[t].element.nextSibling):l.tbody.removeChild(l.rows[e].element)),l.rows.splice(t,0,l.rows.splice(e,1)[0]),l.records.splice(t,0,l.records.splice(e,1)[0]),l.options.data.splice(t,0,l.options.data.splice(e,1)[0]);let o=Math.min(e,t),s=Math.max(e,t);for(let e=o;e<=s;e++)l.rows[e].y=e;for(let e=o;e<=s;e++)for(let t=0;t<l.records[e].length;t++)l.records[e][t].y=e;l.options.pagination>0&&l.tbody.children.length!=l.options.pagination&&l.page(l.pageNumber),utils_history.Dh.call(l,{action:"moveRow",oldValue:e,newValue:t}),internal.o8.call(l),dispatch.A.call(l,"onmoverow",l,parseInt(e),parseInt(t),1)},deleteRow=function(e,t){let n=this;if(0!=n.options.allowDeleteRow)if(1==n.options.allowDeletingAllRows||n.options.data.length>1){if(null==e){let l=selection.R5.call(n);0===l.length?(e=n.options.data.length-1,t=1):(e=l[0],t=l.length)}let l=n.options.data.length-1;(null==e||e>l||e<0)&&(e=l),t||(t=1),e+t>=n.options.data.length&&(t=n.options.data.length-e);let o=[];for(let n=0;n<t;n++)o.push(n+e);if(!1===dispatch.A.call(n,"onbeforedeleterow",n,o))return!1;if(parseInt(e)>-1){let s=!1;if(n.options.mergeCells&&Object.keys(n.options.mergeCells).length>0)for(let l=e;l<e+t;l++)merges.D0.call(n,l,!1).length&&(s=!0);if(s){if(!confirm(jSuites.translate("This action will destroy any existing merged cells. Are you sure?")))return!1;n.destroyMerge()}if(1==n.options.search){if(n.results&&n.results.length!=n.rows.length){if(!confirm(jSuites.translate("This action will clear your search results. Are you sure?")))return!1;n.resetSearch()}n.results=null}1!=n.options.allowDeletingAllRows&&l+1===t&&(t--,console.error("Jspreadsheet: It is not possible to delete the last row"));for(let l=e;l<e+t;l++)Array.prototype.indexOf.call(n.tbody.children,n.rows[l].element)>=0&&(n.rows[l].element.className="",n.rows[l].element.parentNode.removeChild(n.rows[l].element));let r=n.records.splice(e,t),i=n.options.data.splice(e,t),a=n.rows.splice(e,t);for(let t=e;t<n.rows.length;t++)n.rows[t].y=t;for(let t=e;t<n.records.length;t++)for(let e=0;e<n.records[t].length;e++)n.records[t][e].y=t;n.options.pagination>0&&n.tbody.children.length!=n.options.pagination&&n.page(n.pageNumber),selection.at.call(n,1,e,e+t-1),utils_history.Dh.call(n,{action:"deleteRow",rowNumber:e,numOfRows:t,insertBefore:1,rowRecords:r,rowData:i,rowNode:a}),internal.o8.call(n),dispatch.A.call(n,"ondeleterow",n,o)}}else console.error("Jspreadsheet: It is not possible to delete the last row")},getHeight=function(e){let t,n=this;if(void 0===e){t=[];for(let e=0;e<n.rows.length;e++){let l=n.rows[e].element.style.height;l&&(t[e]=l)}}else"object"==typeof e&&(e=$(e).getAttribute("data-y")),t=n.rows[e].element.style.height;return t},setHeight=function(e,t,n){let l=this;t>0&&(n||(n=l.rows[e].element.getAttribute("height"))||(n=l.rows[e].element.getBoundingClientRect().height),t=parseInt(t),l.rows[e].element.style.height=t+"px",l.options.rows||(l.options.rows=[]),l.options.rows[e]||(l.options.rows[e]={}),l.options.rows[e].height=t,utils_history.Dh.call(l,{action:"setHeight",row:e,oldValue:n,newValue:t}),dispatch.A.call(l,"onresizerow",l,e,t,n),selection.Aq.call(l))},showRow=function(e){let t=this;Array.isArray(e)||(e=[e]),e.forEach(function(e){t.rows[e].element.style.display=""})},hideRow=function(e){let t=this;Array.isArray(e)||(e=[e]),e.forEach(function(e){t.rows[e].element.style.display="none"})},getRowData=function(e,t){return t?this.records[e].map(function(e){return e.element.innerHTML}):this.options.data[e]},setRowData=function(e,t,n){let l=this;for(let o=0;o<l.headers.length;o++){let s=(0,internalHelpers.t3)([o,e]);null!=t[o]&&l.setValue(s,t[o],n)}};var version={version:"5.0.0",host:"https://bossanova.uk/jspreadsheet",license:"MIT",print:function(){return[["Jspreadsheet CE",this.version,this.host,this.license].join("\r\n")]}};let getElement=function(e){let t=0,n=0;return function e(l){l.className&&(l.classList.contains("jss_container")&&(n=l),l.classList.contains("jss_spreadsheet")&&(n=l.querySelector(":scope > .jtabs-content > .jtabs-selected"))),"THEAD"==l.tagName?t=1:"TBODY"==l.tagName&&(t=2),l.parentNode&&(n||e(l.parentNode))}(e),[n,t]},mouseUpControls=function(e){if(libraryBase.jspreadsheet.current)if(libraryBase.jspreadsheet.current.resizing){if(libraryBase.jspreadsheet.current.resizing.column){let e=parseInt(libraryBase.jspreadsheet.current.cols[libraryBase.jspreadsheet.current.resizing.column].colElement.getAttribute("width")),t=libraryBase.jspreadsheet.current.getSelectedColumns();if(t.length>1){let n=[];for(let e=0;e<t.length;e++)n.push(parseInt(libraryBase.jspreadsheet.current.cols[t[e]].colElement.getAttribute("width")));n[t.indexOf(parseInt(libraryBase.jspreadsheet.current.resizing.column))]=libraryBase.jspreadsheet.current.resizing.width,setWidth.call(libraryBase.jspreadsheet.current,t,e,n)}else setWidth.call(libraryBase.jspreadsheet.current,parseInt(libraryBase.jspreadsheet.current.resizing.column),e,libraryBase.jspreadsheet.current.resizing.width);libraryBase.jspreadsheet.current.headers[libraryBase.jspreadsheet.current.resizing.column].classList.remove("resizing");for(let e=0;e<libraryBase.jspreadsheet.current.records.length;e++)libraryBase.jspreadsheet.current.records[e][libraryBase.jspreadsheet.current.resizing.column]&&libraryBase.jspreadsheet.current.records[e][libraryBase.jspreadsheet.current.resizing.column].element.classList.remove("resizing")}else{libraryBase.jspreadsheet.current.rows[libraryBase.jspreadsheet.current.resizing.row].element.children[0].classList.remove("resizing");let e=libraryBase.jspreadsheet.current.rows[libraryBase.jspreadsheet.current.resizing.row].element.getAttribute("height");setHeight.call(libraryBase.jspreadsheet.current,libraryBase.jspreadsheet.current.resizing.row,e,libraryBase.jspreadsheet.current.resizing.height),libraryBase.jspreadsheet.current.resizing.element.classList.remove("resizing")}libraryBase.jspreadsheet.current.resizing=null}else if(libraryBase.jspreadsheet.current.dragging){if(libraryBase.jspreadsheet.current.dragging){if(libraryBase.jspreadsheet.current.dragging.column){let t=e.target.getAttribute("data-x");libraryBase.jspreadsheet.current.headers[libraryBase.jspreadsheet.current.dragging.column].classList.remove("dragging");for(let e=0;e<libraryBase.jspreadsheet.current.rows.length;e++)libraryBase.jspreadsheet.current.records[e][libraryBase.jspreadsheet.current.dragging.column]&&libraryBase.jspreadsheet.current.records[e][libraryBase.jspreadsheet.current.dragging.column].element.classList.remove("dragging");for(let e=0;e<libraryBase.jspreadsheet.current.headers.length;e++)libraryBase.jspreadsheet.current.headers[e].classList.remove("dragging-left"),libraryBase.jspreadsheet.current.headers[e].classList.remove("dragging-right");t&&libraryBase.jspreadsheet.current.dragging.column!=libraryBase.jspreadsheet.current.dragging.destination&&libraryBase.jspreadsheet.current.moveColumn(libraryBase.jspreadsheet.current.dragging.column,libraryBase.jspreadsheet.current.dragging.destination)}else{let e;libraryBase.jspreadsheet.current.dragging.element.nextSibling?(e=parseInt(libraryBase.jspreadsheet.current.dragging.element.nextSibling.getAttribute("data-y")),libraryBase.jspreadsheet.current.dragging.row<e&&(e-=1)):e=parseInt(libraryBase.jspreadsheet.current.dragging.element.previousSibling.getAttribute("data-y")),libraryBase.jspreadsheet.current.dragging.row!=libraryBase.jspreadsheet.current.dragging.destination&&moveRow.call(libraryBase.jspreadsheet.current,libraryBase.jspreadsheet.current.dragging.row,e,!0),libraryBase.jspreadsheet.current.dragging.element.classList.remove("dragging")}libraryBase.jspreadsheet.current.dragging=null}}else libraryBase.jspreadsheet.current.selectedCorner&&(libraryBase.jspreadsheet.current.selectedCorner=!1,libraryBase.jspreadsheet.current.selection.length>0&&(selection.kF.call(libraryBase.jspreadsheet.current,libraryBase.jspreadsheet.current.selection[0],libraryBase.jspreadsheet.current.selection[libraryBase.jspreadsheet.current.selection.length-1]),selection.gG.call(libraryBase.jspreadsheet.current)));libraryBase.jspreadsheet.timeControl&&(clearTimeout(libraryBase.jspreadsheet.timeControl),libraryBase.jspreadsheet.timeControl=null),libraryBase.jspreadsheet.isMouseAction=!1},mouseDownControls=function(e){let t;t=(e=e||window.event).buttons?e.buttons:e.button?e.button:e.which;let n=getElement(e.target);if(n[0]?libraryBase.jspreadsheet.current!=n[0].jssWorksheet&&(libraryBase.jspreadsheet.current&&(libraryBase.jspreadsheet.current.edition&&closeEditor.call(libraryBase.jspreadsheet.current,libraryBase.jspreadsheet.current.edition[0],!0),libraryBase.jspreadsheet.current.resetSelection()),libraryBase.jspreadsheet.current=n[0].jssWorksheet):libraryBase.jspreadsheet.current&&(libraryBase.jspreadsheet.current.edition&&closeEditor.call(libraryBase.jspreadsheet.current,libraryBase.jspreadsheet.current.edition[0],!0),e.target.classList.contains("jss_object")||(selection.gE.call(libraryBase.jspreadsheet.current,!0),libraryBase.jspreadsheet.current=null)),libraryBase.jspreadsheet.current&&1==t){if(e.target.classList.contains("jss_selectall"))libraryBase.jspreadsheet.current&&selection.Ub.call(libraryBase.jspreadsheet.current);else if(e.target.classList.contains("jss_corner"))0!=libraryBase.jspreadsheet.current.options.editable&&(libraryBase.jspreadsheet.current.selectedCorner=!0);else{if(1==n[1]){let t=e.target.getAttribute("data-x");if(t){let n=e.target.getBoundingClientRect();if(0!=libraryBase.jspreadsheet.current.options.columnResize&&n.width-e.offsetX<6){libraryBase.jspreadsheet.current.resizing={mousePosition:e.pageX,column:t,width:n.width},libraryBase.jspreadsheet.current.headers[t].classList.add("resizing");for(let e=0;e<libraryBase.jspreadsheet.current.records.length;e++)libraryBase.jspreadsheet.current.records[e][t]&&libraryBase.jspreadsheet.current.records[e][t].element.classList.add("resizing")}else if(0!=libraryBase.jspreadsheet.current.options.columnDrag&&n.height-e.offsetY<6)if(merges.Lt.call(libraryBase.jspreadsheet.current,t).length)console.error("Jspreadsheet: This column is part of a merged cell.");else{libraryBase.jspreadsheet.current.resetSelection(),libraryBase.jspreadsheet.current.dragging={element:e.target,column:t,destination:t},libraryBase.jspreadsheet.current.headers[t].classList.add("dragging");for(let e=0;e<libraryBase.jspreadsheet.current.records.length;e++)libraryBase.jspreadsheet.current.records[e][t]&&libraryBase.jspreadsheet.current.records[e][t].element.classList.add("dragging")}else{let n,l;libraryBase.jspreadsheet.current.selectedHeader&&(e.shiftKey||e.ctrlKey)?n=libraryBase.jspreadsheet.current.selectedHeader:(libraryBase.jspreadsheet.current.selectedHeader==t&&0!=libraryBase.jspreadsheet.current.options.allowRenameColumn&&(libraryBase.jspreadsheet.timeControl=setTimeout(function(){libraryBase.jspreadsheet.current.setHeader(t)},800)),libraryBase.jspreadsheet.current.selectedHeader=t,n=t),l=t,selection.AH.call(libraryBase.jspreadsheet.current,n,0,l,libraryBase.jspreadsheet.current.options.data.length-1,e)}}else if(e.target.parentNode.classList.contains("jss_nested")){let t,n;if(e.target.getAttribute("data-column")){let l=e.target.getAttribute("data-column").split(",");t=parseInt(l[0]),n=parseInt(l[l.length-1])}else t=0,n=libraryBase.jspreadsheet.current.options.columns.length-1;selection.AH.call(libraryBase.jspreadsheet.current,t,0,n,libraryBase.jspreadsheet.current.options.data.length-1,e)}}else libraryBase.jspreadsheet.current.selectedHeader=!1;if(2==n[1]){let t=parseInt(e.target.getAttribute("data-y"));if(e.target.classList.contains("jss_row")){let n=e.target.getBoundingClientRect();if(0!=libraryBase.jspreadsheet.current.options.rowResize&&n.height-e.offsetY<6)libraryBase.jspreadsheet.current.resizing={element:e.target.parentNode,mousePosition:e.pageY,row:t,height:n.height},e.target.parentNode.classList.add("resizing");else if(0!=libraryBase.jspreadsheet.current.options.rowDrag&&n.width-e.offsetX<6)merges.D0.call(libraryBase.jspreadsheet.current,t).length?console.error("Jspreadsheet: This row is part of a merged cell"):1==libraryBase.jspreadsheet.current.options.search&&libraryBase.jspreadsheet.current.results?console.error("Jspreadsheet: Please clear your search before perform this action"):(libraryBase.jspreadsheet.current.resetSelection(),libraryBase.jspreadsheet.current.dragging={element:e.target.parentNode,row:t,destination:t},e.target.parentNode.classList.add("dragging"));else{let n,l;null!=libraryBase.jspreadsheet.current.selectedRow&&(e.shiftKey||e.ctrlKey)?n=libraryBase.jspreadsheet.current.selectedRow:(libraryBase.jspreadsheet.current.selectedRow=t,n=t),l=t,selection.AH.call(libraryBase.jspreadsheet.current,null,n,null,l,e)}}else if(e.target.classList.contains("jclose")&&e.target.clientWidth-e.offsetX<50&&e.offsetY<50)closeEditor.call(libraryBase.jspreadsheet.current,libraryBase.jspreadsheet.current.edition[0],!0);else{let t=function(e){let n=e.getAttribute("data-x"),l=e.getAttribute("data-y");return n&&l?[n,l]:e.parentNode?t(e.parentNode):void 0},n=t(e.target);if(n){let t=n[0],l=n[1];libraryBase.jspreadsheet.current.edition&&(libraryBase.jspreadsheet.current.edition[2]==t&&libraryBase.jspreadsheet.current.edition[3]==l||closeEditor.call(libraryBase.jspreadsheet.current,libraryBase.jspreadsheet.current.edition[0],!0)),libraryBase.jspreadsheet.current.edition||(e.shiftKey?selection.AH.call(libraryBase.jspreadsheet.current,libraryBase.jspreadsheet.current.selectedCell[0],libraryBase.jspreadsheet.current.selectedCell[1],t,l,e):selection.AH.call(libraryBase.jspreadsheet.current,t,l,void 0,void 0,e)),libraryBase.jspreadsheet.current.selectedHeader=null,libraryBase.jspreadsheet.current.selectedRow=null}}}else libraryBase.jspreadsheet.current.selectedRow=!1;e.target.classList.contains("jss_page")&&("<"==e.target.textContent?libraryBase.jspreadsheet.current.page(0):">"==e.target.textContent?libraryBase.jspreadsheet.current.page(e.target.getAttribute("title")-1):libraryBase.jspreadsheet.current.page(e.target.textContent-1))}libraryBase.jspreadsheet.current.edition?libraryBase.jspreadsheet.isMouseAction=!1:libraryBase.jspreadsheet.isMouseAction=!0}else libraryBase.jspreadsheet.isMouseAction=!1},mouseMoveControls=function(e){if(((e=e||window.event).buttons?e.buttons:e.button?e.button:e.which)||(libraryBase.jspreadsheet.isMouseAction=!1),libraryBase.jspreadsheet.current)if(1==libraryBase.jspreadsheet.isMouseAction){if(libraryBase.jspreadsheet.current.resizing)if(libraryBase.jspreadsheet.current.resizing.column){let t=e.pageX-libraryBase.jspreadsheet.current.resizing.mousePosition;if(libraryBase.jspreadsheet.current.resizing.width+t>0){let e=libraryBase.jspreadsheet.current.resizing.width+t;libraryBase.jspreadsheet.current.cols[libraryBase.jspreadsheet.current.resizing.column].colElement.setAttribute("width",e),selection.Aq.call(libraryBase.jspreadsheet.current)}}else{let t=e.pageY-libraryBase.jspreadsheet.current.resizing.mousePosition;if(libraryBase.jspreadsheet.current.resizing.height+t>0){let e=libraryBase.jspreadsheet.current.resizing.height+t;libraryBase.jspreadsheet.current.rows[libraryBase.jspreadsheet.current.resizing.row].element.setAttribute("height",e),selection.Aq.call(libraryBase.jspreadsheet.current)}}else if(libraryBase.jspreadsheet.current.dragging)if(libraryBase.jspreadsheet.current.dragging.column){let t=e.target.getAttribute("data-x");if(t)if(merges.Lt.call(libraryBase.jspreadsheet.current,t).length)console.error("Jspreadsheet: This column is part of a merged cell.");else{for(let e=0;e<libraryBase.jspreadsheet.current.headers.length;e++)libraryBase.jspreadsheet.current.headers[e].classList.remove("dragging-left"),libraryBase.jspreadsheet.current.headers[e].classList.remove("dragging-right");libraryBase.jspreadsheet.current.dragging.column==t?libraryBase.jspreadsheet.current.dragging.destination=parseInt(t):e.target.clientWidth/2>e.offsetX?(libraryBase.jspreadsheet.current.dragging.column<t?libraryBase.jspreadsheet.current.dragging.destination=parseInt(t)-1:libraryBase.jspreadsheet.current.dragging.destination=parseInt(t),libraryBase.jspreadsheet.current.headers[t].classList.add("dragging-left")):(libraryBase.jspreadsheet.current.dragging.column<t?libraryBase.jspreadsheet.current.dragging.destination=parseInt(t):libraryBase.jspreadsheet.current.dragging.destination=parseInt(t)+1,libraryBase.jspreadsheet.current.headers[t].classList.add("dragging-right"))}}else{let t=e.target.getAttribute("data-y");if(t)if(merges.D0.call(libraryBase.jspreadsheet.current,t).length)console.error("Jspreadsheet: This row is part of a merged cell.");else{let t=e.target.clientHeight/2>e.offsetY?e.target.parentNode.nextSibling:e.target.parentNode;libraryBase.jspreadsheet.current.dragging.element!=t&&(e.target.parentNode.parentNode.insertBefore(libraryBase.jspreadsheet.current.dragging.element,t),libraryBase.jspreadsheet.current.dragging.destination=Array.prototype.indexOf.call(libraryBase.jspreadsheet.current.dragging.element.parentNode.children,libraryBase.jspreadsheet.current.dragging.element))}}}else{let t=e.target.getAttribute("data-x"),n=e.target.getAttribute("data-y"),l=e.target.getBoundingClientRect();libraryBase.jspreadsheet.current.cursor&&(libraryBase.jspreadsheet.current.cursor.style.cursor="",libraryBase.jspreadsheet.current.cursor=null),e.target.parentNode.parentNode&&e.target.parentNode.parentNode.className&&(e.target.parentNode.parentNode.classList.contains("resizable")&&(e.target&&t&&!n&&l.width-(e.clientX-l.left)<6?(libraryBase.jspreadsheet.current.cursor=e.target,libraryBase.jspreadsheet.current.cursor.style.cursor="col-resize"):e.target&&!t&&n&&l.height-(e.clientY-l.top)<6&&(libraryBase.jspreadsheet.current.cursor=e.target,libraryBase.jspreadsheet.current.cursor.style.cursor="row-resize")),e.target.parentNode.parentNode.classList.contains("draggable")&&(e.target&&!t&&n&&l.width-(e.clientX-l.left)<6||e.target&&t&&!n&&l.height-(e.clientY-l.top)<6)&&(libraryBase.jspreadsheet.current.cursor=e.target,libraryBase.jspreadsheet.current.cursor.style.cursor="move"))}},updateCopySelection=function(e,t){let n=this;selection.gG.call(n);let l=n.selectedContainer[0],o=n.selectedContainer[1],s=n.selectedContainer[2],r=n.selectedContainer[3];if(null!=e&&null!=t){let i,a,c,d;e-s>0?(i=parseInt(s)+1,a=parseInt(e)):(i=parseInt(e),a=parseInt(l)-1),t-r>0?(c=parseInt(r)+1,d=parseInt(t)):(c=parseInt(t),d=parseInt(o)-1),a-i<=d-c?(i=parseInt(l),a=parseInt(s)):(c=parseInt(o),d=parseInt(r));for(let e=c;e<=d;e++)for(let t=i;t<=a;t++)n.records[e][t]&&"none"!=n.rows[e].element.style.display&&"none"!=n.records[e][t].element.style.display&&(n.records[e][t].element.classList.add("selection"),n.records[c][t].element.classList.add("selection-top"),n.records[d][t].element.classList.add("selection-bottom"),n.records[e][i].element.classList.add("selection-left"),n.records[e][a].element.classList.add("selection-right"),n.selection.push(n.records[e][t].element))}},mouseOverControls=function(e){if(((e=e||window.event).buttons?e.buttons:e.button?e.button:e.which)||(libraryBase.jspreadsheet.isMouseAction=!1),libraryBase.jspreadsheet.current&&1==libraryBase.jspreadsheet.isMouseAction){let t=getElement(e.target);if(t[0]){if(libraryBase.jspreadsheet.current!=t[0].jssWorksheet&&libraryBase.jspreadsheet.current)return!1;let n=e.target.getAttribute("data-x"),l=e.target.getAttribute("data-y");if(libraryBase.jspreadsheet.current.resizing||libraryBase.jspreadsheet.current.dragging);else{if(1==t[1]&&libraryBase.jspreadsheet.current.selectedHeader){n=e.target.getAttribute("data-x");let t=libraryBase.jspreadsheet.current.selectedHeader,l=n;selection.AH.call(libraryBase.jspreadsheet.current,t,0,l,libraryBase.jspreadsheet.current.options.data.length-1,e)}if(2==t[1])if(e.target.classList.contains("jss_row")){if(null!=libraryBase.jspreadsheet.current.selectedRow){let t=libraryBase.jspreadsheet.current.selectedRow,n=l;selection.AH.call(libraryBase.jspreadsheet.current,0,t,libraryBase.jspreadsheet.current.options.data[0].length-1,n,e)}}else libraryBase.jspreadsheet.current.edition||n&&l&&(libraryBase.jspreadsheet.current.selectedCorner?updateCopySelection.call(libraryBase.jspreadsheet.current,n,l):libraryBase.jspreadsheet.current.selectedCell&&selection.AH.call(libraryBase.jspreadsheet.current,libraryBase.jspreadsheet.current.selectedCell[0],libraryBase.jspreadsheet.current.selectedCell[1],n,l,e))}}}libraryBase.jspreadsheet.timeControl&&(clearTimeout(libraryBase.jspreadsheet.timeControl),libraryBase.jspreadsheet.timeControl=null)},doubleClickControls=function(e){if(libraryBase.jspreadsheet.current)if(e.target.classList.contains("jss_corner")){if(libraryBase.jspreadsheet.current.highlighted.length>0){let e=libraryBase.jspreadsheet.current.highlighted[0].element.getAttribute("data-x"),t=parseInt(libraryBase.jspreadsheet.current.highlighted[libraryBase.jspreadsheet.current.highlighted.length-1].element.getAttribute("data-y"))+1,n=libraryBase.jspreadsheet.current.highlighted[libraryBase.jspreadsheet.current.highlighted.length-1].element.getAttribute("data-x"),l=libraryBase.jspreadsheet.current.records.length-1;selection.kF.call(libraryBase.jspreadsheet.current,libraryBase.jspreadsheet.current.records[t][e].element,libraryBase.jspreadsheet.current.records[l][n].element)}}else if(e.target.classList.contains("jss_column_filter")){let t=e.target.getAttribute("data-x");filter.N$.call(libraryBase.jspreadsheet.current,t)}else{let t=getElement(e.target);if(1==t[1]&&0!=libraryBase.jspreadsheet.current.options.columnSorting){let t=e.target.getAttribute("data-x");t&&libraryBase.jspreadsheet.current.orderBy(parseInt(t))}if(2==t[1]&&0!=libraryBase.jspreadsheet.current.options.editable&&!libraryBase.jspreadsheet.current.edition){let t=function(e){if(e.parentNode){let n=e.getAttribute("data-x"),l=e.getAttribute("data-y");return n&&l?e:t(e.parentNode)}},n=t(e.target);n&&n.classList.contains("highlight")&&openEditor.call(libraryBase.jspreadsheet.current,n,void 0,e)}}},pasteControls=function(e){libraryBase.jspreadsheet.current&&libraryBase.jspreadsheet.current.selectedCell&&(libraryBase.jspreadsheet.current.edition||0!=libraryBase.jspreadsheet.current.options.editable&&(e&&e.clipboardData?(paste.call(libraryBase.jspreadsheet.current,libraryBase.jspreadsheet.current.selectedCell[0],libraryBase.jspreadsheet.current.selectedCell[1],e.clipboardData.getData("text")),e.preventDefault()):window.clipboardData&&paste.call(libraryBase.jspreadsheet.current,libraryBase.jspreadsheet.current.selectedCell[0],libraryBase.jspreadsheet.current.selectedCell[1],window.clipboardData.getData("text"))))},getRole=function(e){if(e.classList.contains("jss_selectall"))return"select-all";if(e.classList.contains("jss_corner"))return"fill-handle";let t=e;for(;!t.classList.contains("jss_spreadsheet");){if(t.classList.contains("jss_row"))return"row";if(t.classList.contains("jss_nested"))return"nested";if(t.classList.contains("jtabs-headers"))return"tabs";if(t.classList.contains("jtoolbar"))return"toolbar";if(t.classList.contains("jss_pagination"))return"pagination";if("TBODY"===t.tagName)return"cell";if("TFOOT"===t.tagName)return 0===getElementIndex(e)?"grid":"footer";if("THEAD"===t.tagName)return"header";t=t.parentElement}return"applications"},defaultContextMenu=function(e,t,n,l){let o=[];if("header"===l&&(0!=e.options.allowInsertColumn&&o.push({title:jSuites.translate("Insert a new column before"),onclick:function(){e.insertColumn(1,parseInt(t),1)}}),0!=e.options.allowInsertColumn&&o.push({title:jSuites.translate("Insert a new column after"),onclick:function(){e.insertColumn(1,parseInt(t),0)}}),0!=e.options.allowDeleteColumn&&o.push({title:jSuites.translate("Delete selected columns"),onclick:function(){e.deleteColumn(e.getSelectedColumns().length?void 0:parseInt(t))}}),0!=e.options.allowRenameColumn&&o.push({title:jSuites.translate("Rename this column"),onclick:function(){let n=e.getHeader(t),l=prompt(jSuites.translate("Column name"),n);e.setHeader(t,l)}}),0!=e.options.columnSorting&&(o.push({type:"line"}),o.push({title:jSuites.translate("Order ascending"),onclick:function(){e.orderBy(t,0)}}),o.push({title:jSuites.translate("Order descending"),onclick:function(){e.orderBy(t,1)}}))),"row"!==l&&"cell"!==l||(0!=e.options.allowInsertRow&&(o.push({title:jSuites.translate("Insert a new row before"),onclick:function(){e.insertRow(1,parseInt(n),1)}}),o.push({title:jSuites.translate("Insert a new row after"),onclick:function(){e.insertRow(1,parseInt(n))}})),0!=e.options.allowDeleteRow&&o.push({title:jSuites.translate("Delete selected rows"),onclick:function(){e.deleteRow(e.getSelectedRows().length?void 0:parseInt(n))}})),"cell"===l&&0!=e.options.allowComments){o.push({type:"line"});let l=e.records[n][t].element.getAttribute("title")||"";o.push({title:jSuites.translate(l?"Edit comments":"Add comments"),onclick:function(){let o=prompt(jSuites.translate("C

1Base.jspreadsheet.current.edition){let t=e.target.getAttribute("data-x"),n=e.target.getAttribute("data-y");t&&n&&(selection.AH.call(libraryBase.jspreadsheet.current,t,n,void 0,void 0,e),libraryBase.jspreadsheet.timeControl=setTimeout(function(){"color"==libraryBase.jspreadsheet.current.options.columns[t].type?libraryBase.jspreadsheet.tmpElement=null:libraryBase.jspreadsheet.tmpElement=e.target,openEditor.call(libraryBase.jspreadsheet.current,e.target,!1,e)},500))}},touchEndControls=function(e){libraryBase.jspreadsheet.timeControl&&(clearTimeout(libraryBase.jspreadsheet.timeControl),libraryBase.jspreadsheet.timeControl=null,libraryBase.jspreadsheet.tmpElement&&"INPUT"==libraryBase.jspreadsheet.tmpElement.children[0].tagName&&libraryBase.jspreadsheet.tmpElement.children[0].focus(),libraryBase.jspreadsheet.tmpElement=null)},cutControls=function(e){libraryBase.jspreadsheet.current&&(libraryBase.jspreadsheet.current.edition||(copy.call(libraryBase.jspreadsheet.current,!0,void 0,void 0,void 0,void 0,!0),0!=libraryBase.jspreadsheet.current.options.editable&&libraryBase.jspreadsheet.current.setValue(libraryBase.jspreadsheet.current.highlighted.map(function(e){return e.element}),"")))},copyControls=function(e){libraryBase.jspreadsheet.current&&copyControls.enabled&&(libraryBase.jspreadsheet.current.edition||copy.call(libraryBase.jspreadsheet.current,!0))},isMac=function(){return navigator.platform.toUpperCase().indexOf("MAC")>=0},isCtrl=function(e){return isMac()?e.metaKey:e.ctrlKey},keyDownControls=function(e){if(libraryBase.jspreadsheet.current){if(libraryBase.jspreadsheet.current.edition)if(27==e.which)libraryBase.jspreadsheet.current.edition&&closeEditor.call(libraryBase.jspreadsheet.current,libraryBase.jspreadsheet.current.edition[0],!1),e.preventDefault();else if(13==e.which)if(libraryBase.jspreadsheet.current.options.columns&&libraryBase.jspreadsheet.current.options.columns[libraryBase.jspreadsheet.current.edition[2]]&&"calendar"==libraryBase.jspreadsheet.current.options.columns[libraryBase.jspreadsheet.current.edition[2]].type)closeEditor.call(libraryBase.jspreadsheet.current,libraryBase.jspreadsheet.current.edition[0],!0);else if(libraryBase.jspreadsheet.current.options.columns&&libraryBase.jspreadsheet.current.options.columns[libraryBase.jspreadsheet.current.edition[2]]&&"dropdown"==libraryBase.jspreadsheet.current.options.columns[libraryBase.jspreadsheet.current.edition[2]].type);else if((1==libraryBase.jspreadsheet.current.options.wordWrap||libraryBase.jspreadsheet.current.options.columns&&libraryBase.jspreadsheet.current.options.columns[libraryBase.jspreadsheet.current.edition[2]]&&1==libraryBase.jspreadsheet.current.options.columns[libraryBase.jspreadsheet.current.edition[2]].wordWrap||libraryBase.jspreadsheet.current.options.data[libraryBase.jspreadsheet.current.edition[3]][libraryBase.jspreadsheet.current.edition[2]]&&libraryBase.jspreadsheet.current.options.data[libraryBase.jspreadsheet.current.edition[3]][libraryBase.jspreadsheet.current.edition[2]].length>200)&&e.altKey){let e=libraryBase.jspreadsheet.current.edition[0].children[0],t=libraryBase.jspreadsheet.current.edition[0].children[0].value,n=e.selectionStart;e.value=t=t.slice(0,n)+"\n"+t.slice(n),e.focus(),e.selectionStart=n+1,e.selectionEnd=n+1}else libraryBase.jspreadsheet.current.edition[0].children[0].blur();else 9==e.which&&(libraryBase.jspreadsheet.current.options.columns&&libraryBase.jspreadsheet.current.options.columns[libraryBase.jspreadsheet.current.edition[2]]&&["calendar","html"].includes(libraryBase.jspreadsheet.current.options.columns[libraryBase.jspreadsheet.current.edition[2]].type)?closeEditor.call(libraryBase.jspreadsheet.current,libraryBase.jspreadsheet.current.edition[0],!0):libraryBase.jspreadsheet.current.edition[0].children[0].blur());if(!libraryBase.jspreadsheet.current.edition&&libraryBase.jspreadsheet.current.selectedCell){if(37==e.which)left.call(libraryBase.jspreadsheet.current,e.shiftKey,e.ctrlKey),e.preventDefault();else if(39==e.which)right.call(libraryBase.jspreadsheet.current,e.shiftKey,e.ctrlKey),e.preventDefault();else if(38==e.which)up.call(libraryBase.jspreadsheet.current,e.shiftKey,e.ctrlKey),e.preventDefault();else if(40==e.which)down.call(libraryBase.jspreadsheet.current,e.shiftKey,e.ctrlKey),e.preventDefault();else if(36==e.which)first.call(libraryBase.jspreadsheet.current,e.shiftKey,e.ctrlKey),e.preventDefault();else if(35==e.which)last.call(libraryBase.jspreadsheet.current,e.shiftKey,e.ctrlKey),e.preventDefault();else if(46==e.which||8==e.which)0!=libraryBase.jspreadsheet.current.options.editable&&(null!=libraryBase.jspreadsheet.current.selectedRow?0!=libraryBase.jspreadsheet.current.options.allowDeleteRow&&confirm(jSuites.translate("Are you sure to delete the selected rows?"))&&libraryBase.jspreadsheet.current.deleteRow():libraryBase.jspreadsheet.current.selectedHeader?0!=libraryBase.jspreadsheet.current.options.allowDeleteColumn&&confirm(jSuites.translate("Are you sure to delete the selected columns?"))&&libraryBase.jspreadsheet.current.deleteColumn():libraryBase.jspreadsheet.current.setValue(libraryBase.jspreadsheet.current.highlighted.map(function(e){return e.element}),""));else if(13==e.which)e.shiftKey?up.call(libraryBase.jspreadsheet.current):(0!=libraryBase.jspreadsheet.current.options.allowInsertRow&&0!=libraryBase.jspreadsheet.current.options.allowManualInsertRow&&libraryBase.jspreadsheet.current.selectedCell[1]==libraryBase.jspreadsheet.current.options.data.length-1&&libraryBase.jspreadsheet.current.insertRow(),down.call(libraryBase.jspreadsheet.current)),e.preventDefault();

1e++)n[e]=l.options.data[t][l.options.columns[e].name];e.push(n)}l.options.data=e}let o=0,s=0,r=l.options.columns&&l.options.columns.length||0,i=l.options.data.length,a=l.options.minDimensions[0],c=l.options.minDimensions[1],d=a>r?a:r,p=c>i?c:i;for(o=0;o<p;o++)for(s=0;s<d;s++)null==l.options.data[o]&&(l.options.data[o]=[]),null==l.options.data[o][s]&&(l.options.data[o][s]="");for(l.rows=[],l.results=null,l.records=[],l.history=[],l.historyIndex=-1,l.tbody.innerHTML="",1==l.options.lazyLoading?(t=0,n=l.options.data.length<100?l.options.data.length:100,l.options.pagination&&(l.options.pagination=!1,console.error("Jspreadsheet: Pagination will be disable due the lazyLoading"))):l.options.pagination?(l.pageNumber||(l.pageNumber=0),l.options.pagination,t=l.options.pagination*l.pageNumber,n=l.options.pagination*l.pageNumber+l.options.pagination,l.options.data.length<n&&(n=l.options.data.length)):(t=0,n=l.options.data.length),o=0;o<l.options.data.length;o++){let e=createRow.call(l,o,l.options.data[o]);o>=t&&o<n&&l.tbody.appendChild(e.element)}if(1==l.options.lazyLoading||l.options.pagination&&pagination.IV.call(l),l.options.mergeCells){let e=Object.keys(l.options.mergeCells);for(let t=0;t<e.length;t++){let n=l.options.mergeCells[e[t]];merges.FU.call(l,e[t],n[0],n[1],1)}}internal.am.call(l)},getValue=function(e,t){let n,l,o=this;if("string"!=typeof e)return null;n=(e=(0,internalHelpers.vu)(e,!0))[0],l=e[1];let s=null;return null!=n&&null!=l&&(o.records[l]&&o.records[l][n]&&t?s=o.records[l][n].element.innerHTML:o.options.data[l]&&"undefined"!=o.options.data[l][n]&&(s=o.options.data[l][n])),s},getValueFromCoords=function(e,t,n){let l=this,o=null;return null!=e&&null!=t&&(l.records[t]&&l.records[t][e]&&n?o=l.records[t][e].element.innerHTML:l.options.data[t]&&"undefined"!=l.options.data[t][e]&&(o=l.options.data[t][e])),o},setValue=function(e,t,n){let l=this,o=[];if("string"==typeof e){let s=(0,internalHelpers.vu)(e,!0),r=s[0],i=s[1];o.push(internal.k9.call(l,r,i,t,n)),internal.xF.call(l,r,i,o)}else{let s=null,r=null;if(e&&e.getAttribute&&(s=e.getAttribute("data-x"),r=e.getAttribute("data-y")),null!=s&&null!=r)o.push(internal.k9.call(l,s,r,t,n)),internal.xF.call(l,s,r,o);else{let s=Object.keys(e);if(s.length>0)for(let r=0;r<s.length;r++){let s,i;if("string"==typeof e[r]){let t=(0,internalHelpers.vu)(e[r],!0);s=t[0],i=t[1]}else null!=e[r].x&&null!=e[r].y?(s=e[r].x,i=e[r].y,null!=e[r].value&&(t=e[r].value)):(s=e[r].getAttribute("data-x"),i=e[r].getAttribute("data-y"));null!=s&&null!=i&&(o.push(internal.k9.call(l,s,i,t,n)),internal.xF.call(l,s,i,o))}}}utils_history.Dh.call(l,{action:"setValue",records:o,selection:l.selectedCell}),internal.am.call(l);let s=o.map(function(e){return{x:e.x,y:e.y,value:e.value,oldValue:e.oldValue}});dispatch.A.call(l,"onafterchanges",l,s)},setValueFromCoords=function(e,t,n,l){let o=this,s=[];s.push(internal.k9.call(o,e,t,n,l)),internal.xF.call(o,e,t,s),utils_history.Dh.call(o,{action:"setValue",records:s,selection:o.selectedCell}),internal.am.call(o);let r=s.map(function(e){return{x:e.x,y:e.y,value:e.value,oldValue:e.oldValue}});dispatch.A.call(o,"onafterchanges",o,r)},getData=function(e,t,n,l){let o=this,s=[],r=0,i=0,a=Math.max(...o.options.data.map(function(e){return e.length})),c=o.options.data.length;for(let n=0;n<c;n++){r=0;for(let l=0;l<a;l++)e&&!o.records[n][l].element.classList.contains("highlight")||(s[i]||(s[i]=[]),s[i][r]=t?o.records[n][l].element.innerHTML:o.options.data[n][l],r++);r>0&&i++}return n?s.map(function(e){return e.join(n)}).join("\r\n")+"\r\n":l?s.map(function(e){let t={};return e.forEach(function(e,n){t[n]=e}),t}):s},getDataFromRange=function(e,t){let n=this,l=(0,helpers.getCoordsFromRange)(e),o=[];for(let e=l[1];e<=l[3];e++){o.push([]);for(let s=l[0];s<=l[2];s++)t?o[o.length-1].push(n.records[e][s].element.innerHTML):o[o.length-1].push(n.options.data[e][s])}return o},search=function(e){let t=this;if(t.options.filters&&filter.dr.call(t),t.resetSelection(),t.pageNumber=0,t.results=[],e){t.searchInput.value!==e&&(t.searchInput.value=e);let n=function(e,n,l){for(let o=0;o<e.length;o++)if((""+e[o]).toLowerCase().search(n)>=0||(""+t.records[l][o].element.innerHTML).toLowerCase().search(n)>=0)return!0;return!1},l=function(e){-1==t.results.indexOf(e)&&t.results.push(e)},o=e.replace(/[-[\]{}()*+?.,\\^$|#\s]/g,"\\$&");o=RegExp(o,"i"),t.options.data.forEach(function(e,s){if(n(e,o,s)){let e=merges.D0.call(t,s);if(e.length)for(let n=0;n<e.length;n++){let o=(0,internalHelpers.vu)(e[n],!0);for(let s=0;s<t.options.mergeCells[e[n]][1];s++)l(o[1]+s)}else l(s)}})}else t.results=null;internal.hG.call(t)},resetSearch=function(){let e=this;e.searchInput.value="",e.search(""),e.results=null},getHeader=function(e){return this.headers[e].textContent},getHeaders=function(e){let t=this,n=[];for(let e=0;e<t.headers.length;e++)n.push(t.getHeader(e));return e?n:n.join(t.options.csvDelimiter)},setHeader=function(e,t){let n=this;if(n.headers[e]){let l=n.headers[e].textContent,o=n.options.columns&&n.options.columns[e]&&n.options.columns[e].title||"";t||(t=(0,helpers.getColumnName)(e)),n.headers[e].textContent=t,n.headers[e].setAttribute("title",t),n.options.columns||(n.options.columns=[]),n.options.columns[e]||(n.options.columns[e]={}),n.options.columns[e].title=t,utils_history.Dh.call(n,{action:"setHeader",column:e,oldValue:l,newValue:t}),dispatch.A.call(n,"onchangeheader",n,parseInt(e),t,o)}},getStyle=function(e,t){let n=this;if(e)return e=(0,internalHelpers.vu)(e,!0),t?n.records[e[1]][e[0]].element.style[t]:n.records[e[1]][e[0]].element.getAttribute("style");{let e={},l=n.options.data[0].length,o=n.options.data.length;for(let s=0;s<o;s++)for(let o=0;o<l;o++){let l=t?n.records[s][o].element.style[t]:n.records[s][o].element.getAttribute("style");l&&(e[(0,internalHelpers.t3)([o,s])]=l)}return e}},setStyle=function(e,t,n,l,o){let s=this,r={},i={},a=function(e,t,n){let o=(0,internalHelpers.vu)(e,!0);if(s.records[o[1]]&&s.records[o[1]][o[0]]&&(0==s.records[o[1]][o[0]].element.classList.contains("readonly")||l)){let a=s.records[o[1]][o[0]].element.style[t];a!=n||l?s.records[o[1]][o[0]].element.style[t]=n:(n="",s.records[o[1]][o[0]].element.style[t]=""),i[e]||(i[e]=[]),r[e]||(r[e]=[]),i[e].push([t+":"+a]),r[e].push([t+":"+n])}};if(t&&n)"string"==typeof e&&a(e,t,n);else{let t=Object.keys(e);for(let n=0;n<t.length;n++){let l=e[t[n]];"string"==typeof l&&(l=l.split(";"));for(let e=0;e<l.length;e++)"string"==typeof l[e]&&(l[e]=l[e].split(":")),l[e][0].trim()&&a(t[n],l[e][0].trim(),l[e][1])}}let c=Object.keys(i);for(let e=0;e<c.length;e++)i[c[e]]=i[c[e]].join(";");c=Object.keys(r);for(let e=0;e<c.length;e++)r[c[e]]=r[c[e]].join(";");o||utils_history.Dh.call(s,{action:"setStyle",oldValue:i,newValue:r}),dispatch.A.call(s,"onchangestyle",s,r)},resetStyle=function(e,t){let n=this,l=Object.keys(e);for(let e=0;e<l.length;e++){let t=(0,internalHelpers.vu)(l[e],!0);n.records[t[1]]&&n.records[t[1]][t[0]]&&n.records[t[1]][t[0]].element.setAttribute("style","")}n.setStyle(e,null,null,null,t)},download=function(e,t){let n=this;if(0==n.parent.config.allowExport)console.error("Export not allowed");else{let l="",o=new Blob(["\uFEFF"+(l+=copy.call(n,!1,n.options.csvDelimiter,!0,e,!0,void 0,t))],{type:"text/csv;charset=utf-8;"});if(window.navigator&&window.navigator.msSaveOrOpenBlob)window.navigator.msSaveOrOpenBlob(o,(n.options.csvFileName||n.options.worksheetName)+".csv");else{let e=document.createElement("a");e.setAttribute("target","_top"),e.href=URL.createObjectURL(o),e.setAttribute("download",(n.options.csvFileName||n.options.worksheetName)+".csv"),document.body.appendChild(e),e.click(),e.parentNode.removeChild(e)}}},getComments=function(e){let t=this;if(e)return"string"!=typeof e?getComments.call(t):(e=(0,internalHelpers.vu)(e,!0),t.records[e[1]][e[0]].element.getAttribute("title")||"");{let e={};for(let n=0;n<t.options.data.length;n++)for(let l=0;l<t.options.columns.length;l++){let o=t.records[n][l].element.getAttribute("title");o&&(e[(0,internalHelpers.t3)([l,n])]=o)}return e}},setComments=function(e,t){let n,l=this,o={};Object.entries(n="string"==typeof e?{[e]:t}:e).forEach(function([e,t]){let n=(0,helpers.getCoordsFromCellName)(e);o[e]=l.records[n[1]][n[0]].element.getAttribute("title"),l.records[n[1]][n[0]].element.setAttribute("title",t||""),t?(l.records[n[1]][n[0]].element.classList.add("jss_comments"),l.options.comments||(l.options.comments={}),l.options.comments[e]=t):(l.records[n[1]][n[0]].element.classList.remove("jss_comments"),l.options.comments&&l.options.comments[e]&&delete l.options.comments[e])}),utils_history.Dh.call(l,{action:"setComments",newValue:n,oldValue:o}),dispatch.A.call(l,"oncomments",l,n,o)};var orderBy=__nested_webpack_require_64087__(94);let getWorksheetConfig=function(){return this.options},getSpreadsheetConfig=function(){return this.config},setConfig=function(e,t){let n,l=this,o=Object.keys(e);l.parent?n=l.parent:(t=!0,n=l),o.forEach(function(o){t?(n.config[o]=e[o],"toolbar"===o&&(!0===e[o]?n.showToolbar():!1===e[o]&&n.hideToolbar())):l.options[o]=e[o]})};var meta=__nested_webpack_require_64087__(654);let setReadOnly=function(e,t){let n,l=this;if("string"==typeof e){let t=(0,helpers.getCoordsFromCellName)(e);n=l.records[t[1]][t[0]]}else{let t=parseInt(e.getAttribute("data-x")),o=parseInt(e.getAttribute("data-y"));n=l.records[o][t]}t?n.element.classList.add("readonly"):n.element.classList.remove("readonly")},isReadOnly=function(e,t){if("string"==typeof e&&void 0===t){let n=(0,helpers.getCoordsFromCellName)(e);[e,t]=n}return this.records[t][e].element.classList.contains("readonly")},setWorksheetFunctions=function(e){for(let t=0;t<worksheetPublicMethodsLength;t++){let[n,l]=worksheetPublicMethods[t];e[n]=l.bind(e)}},createTable=function(){let e=this;setWorksheetFunctions(e),e.table=document.createElement("table"),e.thead=document.createElement("thead"),e.tbody=document.createElement("tbody"),e.headers=[],e.cols=[],e.content=document.createElement("div"),e.content.classList.add("jss_content"),e.content.onscroll=function(t){scrollControls.call(e,t)},e.content.onwheel=function(t){wheelControls.call(e,t)};let t=document.createElement("div"),n=document.createElement("label");n.innerHTML=jSuites.translate("Search")+": ",t.appendChild(n),e.searchInput=document.createElement("input"),e.searchInput.classList.add("jss_search"),n.appendChild(e.searchInput),e.searchInput.onfocus=function(){e.resetSelection()};let l=document.createElement("div");if(e.options.pagination>0&&e.options.paginationOptions&&e.options.paginationOptions.length>0){e.paginationDropdown=document.createElement("select"),e.paginationDropdown.classList.add("jss_pagination_dropdown"),e.paginationDropdown.onchange=function(){e.options.pagination=parseInt(this.value),e.page(0)};for(let t=0;t<e.options.paginationOptions.length;t++){let n=document.createElement("option");n.value=e.options.paginationOptions[t],n.innerHTML=e.options.paginationOptions[t],e.paginationDropdown.appendChild(n)}e.paginationDropdown.value=e.options.pagination,l.appendChild(document.createTextNode(jSuites.translate("Show "))),l.appendChild(e.paginationDropdown),l.appendChild(document.createTextNode(jSuites.translate("entries")))}let o=document.createElement("div");o.classList.add("jss_filter"),o.appendChild(l),o.appendChild(t),e.colgroupContainer=document.createElement("colgroup");let s=document.createElement("col");if(s.setAttribute("width","50"),e.colgroupContainer.appendChild(s),e.options.nestedHeaders&&e.options.nestedHeaders.length>0&&e.options.nestedHeaders[0]&&e.options.nestedHeaders[0][0])for(let t=0;t<e.options.nestedHeaders.length;t++)e.thead.appendChild(internal.ju.call(e,e.options.nestedHeaders[t]));e.headerContainer=document.createElement("tr"),(s=document.createElement("td")).classList.add("jss_selectall"),e.headerContainer.appendChild(s);let r=getNumberOfColumns.call(e);for(let t=0;t<r;t++)createCellHeader.call(e,t),e.headerContainer.appendChild(e.headers[t]),e.colgroupContainer.appendChild(e.cols[t].colElement);if(e.thead.appendChild(e.headerContainer),1==e.options.filters){e.filter=document.createElement("tr");let t=document.createElement("td");e.filter.appendChild(t);for(let t=0;t<e.options.columns.length;t++){let n=document.createElement("td");n.innerHTML="&nbsp;",n.setAttribute("data-x",t),n.className="jss_column_filter","hidden"==e.options.columns[t].type&&(n.style.display="none"),e.filter.appendChild(n)}e.thead.appendChild(e.filter)}e.table=document.createElement("table"),e.table.classList.add("jss_worksheet"),e.table.setAttribute("cellpadding","0"),e.table.setAttribute("cellspacing","0"),e.table.setAttribute("unselectable","yes"),e.table.appendChild(e.colgroupContainer),e.table.appendChild(e.thead),e.table.appendChild(e.tbody),e.options.textOverflow||e.table.classList.add("jss_overflow"),e.corner=document.createElement("div"),e.corner.className="jss_corner",e.corner.setAttribute("unselectable","on"),e.corner.setAttribute("onselectstart","return false"),0==e.options.selectionCopy&&(e.corner.style.display="none"),e.textarea=document.createElement("textarea"),e.textarea.className="jss_textarea",e.textarea.id="jss_textarea",e.textarea.tabIndex="-1",e.textarea.ariaHidden="true";let i=document.createElement("a");i.setAttribute("href","https://bossanova.uk/jspreadsheet/"),e.ads=document.createElement("div"),e.ads.className="jss_about";let a=document.createElement("span");a.innerHTML="Jspreadsheet CE",i.appendChild(a),e.ads.appendChild(i),document.createElement("div").classList.add("jss_table"),e.pagination=document.createElement("div"),e.pagination.classList.add("jss_pagination");let c=document.createElement("div"),d=document.createElement("div");if(e.pagination.appendChild(c),e.pagination.appendChild(d),e.options.pagination||(e.pagination.style.display="none"),1==e.options.search&&e.element.appendChild(o),e.content.appendChild(e.table),e.content.appendChild(e.corner),e.content.appendChild(e.textarea),e.element.appendChild(e.content),e.element.appendChild(e.pagination),e.element.appendChild(e.ads),e.element.classList.add("jss_container"),e.element.jssWorksheet=e,e.element.jspreadsheet=e,1==e.options.tableOverflow&&(e.options.tableHeight&&(e.content.style["overflow-y"]="auto",e.content.style["box-shadow"]="rgb(221 221 221) 2px 2px 5px 0.1px",e.content.style.maxHeight="string"==typeof e.o

1idth],["setWidth",function(e,t){return setWidth.call(this,e,t)}],["insertRow",insertRow],["moveRow",function(e,t){return moveRow.call(this,e,t)}],["deleteRow",deleteRow],["hideRow",hideRow],["showRow",showRow],["getRowData",getRowData],["setRowData",setRowData],["getHeight",getHeight],["setHeight",function(e,t){return setHeight.call(this,e,t)}],["getMerge",merges.fd],["setMerge",function(e,t,n){return merges.FU.call(this,e,t,n)}],["destroyMerge",function(){return merges.VP.call(this)}],["removeMerge",function(e,t){return merges.Zp.call(this,e,t)}],["search",search],["resetSearch",resetSearch],["getHeader",getHeader],["getHeaders",getHeaders],["setHeader",setHeader],["getStyle",getStyle],["setStyle",function(e,t,n,l){return setStyle.call(this,e,t,n,l)}],["resetStyle",resetStyle],["insertColumn",insertColumn],["moveColumn",moveColumn],["deleteColumn",deleteColumn],["getColumnData",getColumnData],["setColumnData",setColumnData],["whichPage",pagination.ho],["page",pagination.MY],["download",download],["getComments",getComments],["setComments",setComments],["orderBy",orderBy.My],["undo",utils_history.tN],["redo",utils_history.ZS],["getCell",internal.tT],["getCellFromCoords",internal.Xr],["getLabel",internal.p9],["getConfig",getWorksheetConfig],["setConfig",setConfig],["getMeta",function(e){return meta.IQ.call(this,e)}],["setMeta",meta.iZ],["showColumn",showColumn],["hideColumn",hideColumn],["showIndex",internal.C6],["hideIndex",internal.TI],["getWorksheetActive",internal.$O],["openEditor",openEditor],["closeEditor",closeEditor],["createWorksheet",createWorksheet],["openWorksheet",openWorksheet],["deleteWorksheet",deleteWorksheet],["copy",function(e){e?cutControls():copy.call(this,!0)}],["paste",paste],["executeFormula",internal.Em],["getDataFromRange",getDataFromRange],["quantiyOfPages",pagination.$f],["getRange",selection.eO],["isSelected",selection.sp],["setReadOnly",setReadOnly],["isReadOnly",isReadOnly],["getHighlighted",selection.kV],["dispatch",dispatch.A],["down",down],["first",first],["last",last],["left",left],["right",right],["up",up],["openFilter",filter.N$],["resetFilters",filter.dr]],worksheetPublicMethodsLength=wor