Huge News!Announcing our $40M Series B led by Abstract Ventures.Learn More →
@jspreadsheet/parser
Advanced tools
@jspreadsheet/parser - npm Package Compare versions
Comparing version 2.5.1 to 2.5.2
| /** | ||
| * Jspreadsheet XLSX parser 2.5.1 | ||
| * Jspreadsheet XLSX parser 2.5.2 | ||
| * https://JSS.com/v8/plugins/parser | ||
@@ -37,51 +37,51 @@ * @License: this plugin requires a license | ||
| $jscomp.asyncExecutePromiseGenerator=function(g){function l(t){return g.next(t)}function q(t){return g.throw(t)}return new Promise(function(t,v){function y(A){A.done?t(A.value):Promise.resolve(A.value).then(l,q).then(y,v)}y(g.next())})};$jscomp.asyncExecutePromiseGeneratorFunction=function(g){return $jscomp.asyncExecutePromiseGenerator(g())};$jscomp.asyncExecutePromiseGeneratorProgram=function(g){return $jscomp.asyncExecutePromiseGenerator(new $jscomp.generator.Generator_(new $jscomp.generator.Engine_(g)))}; | ||
| $jscomp.polyfill("Array.prototype.includes",function(g){return g?g:function(l,q){var t=this;t instanceof String&&(t=String(t));var v=t.length;q=q||0;for(0>q&&(q=Math.max(q+v,0));q<v;q++){var y=t[q];if(y===l||Object.is(y,l))return!0}return!1}},"es7","es3");var _$_55df='use strict{00ffffff{00000000{{undefined{,{localhost{.{parser{License required{A valid license is required{This plugin is not included on the scope of this license{text/xml{parsererror{The file has damaged sub-files{string{async{type{xl/workbook.xml{workbook{xl/styles.xml{styles{xl/theme/theme1.xml{theme{xl/sharedStrings.xml{sharedStrings{xl/worksheets/sheet{worksheet{xl/drawings/drawing{drawing{xl/drawings/_rels/drawing{drawingRel{xl/worksheets/_rels/sheet{rel{xl/media{image{base64{xl/comments{comment{sheets{left{100px{name{state{hidden{definedNames{localSheetId{t{rPr{<span style="{xml:space{all: initial;{sz{val{font-size: {px;{rFont{font-family: {;{b{font-weight: bold;{i{font-style: italic;{color{indexed{color: #{tint{rgb{">{</span>{themeElements > clrScheme{windowText{window{lastClr{dk{sheetView[showGridLines="0"]{colors indexedColors{FF000000{FFFFFFFF{FFFF0000{FF00FF00{FF0000FF{FFFFFF00{FFFF00FF{FF00FFFF{FF800000{FF008000{FF000080{FF808000{FF800080{FF008080{FFC0C0C0{FF808080{FF9999FF{FF993366{FFFFFFCC{FFCCFFFF{FF660066{FFFF8080{FF0066CC{FFCCCCFF{FF00CCFF{FFCCFFCC{FFFFFF99{FF99CCFF{FFFF99CC{FFCC99FF{FFFFCC99{FF3366FF{FF33CCCC{FF99CC00{FFFFCC00{FFFF9900{FFFF6600{FF666699{FF969696{FF003366{FF339966{FF003300{FF333300{FF993300{FF333399{FF333333{General{0{0.00{#,##0{#,##0.00{0%{0.00%{0.00E+00{# ?/?{# ??/??{m/d/yy{d-mmm-yy{d-mmm{mmm-yy{h:mm AM/PM{h:mm:ss AM/PM{h:mm{h:mm:ss{m/d/yy h:mm{#,##0 ;(#,##0){#,##0 ;[Red](#,##0){#,##0.00;(#,##0.00){#,##0.00;[Red](#,##0.00){mm:ss{[h]:mm:ss{mmss.0{##0.0E+0{@{solid{1px{2px{3px{dotted{dashed{double{fillId{fills{patternType{background-color: #{fontId{fonts{alignment{horizontal{text-align: {vertical{center{middle{vertical-align: {wrapText{white-space: break-spaces;{textRotation{borderId{borders{top{border-bottom-style{border-right-style{diagonal{style{border-{-style: {-width: {-color: #{applyProtection{protection{locked{numFmtId{applyNumberFormat{numFmts{[numFmtId="{"]{formatCode{\\\\{g{"{text{function{number{numeric{percentage{currency{_xlfn.{_xll.{ig{list{textLength{date{not between{={!={>{<{>={<={between{warning{warn{reject{ {!{:{dropdown{dataValidation[showErrorMessage="1"]{allowBlank{operator{formula1{showDropDown{sqref{yyyy-mm-dd{formula2{errorStyle{errorTitle{error{containsBlanks{notContainsBlanks{cellIs{containsText{notContainsText{beginsWith{endsWith{contains{not contains{begins with{ends with{right{bottom{dxfId{dxfs > dxf:nth-of-type({){patternFill > bgColor{background-color{#{font color{border{conditionalFormatting{cfRule{format{not exist{exist{formula{dimension{ref{row c[r]{r{800px{both{1024px{cols{min{max{width{px{mergeCells{cellXfs{sheetData{ht{1{s{inlineStr{is > t{f{v{array{shared{/_rels{.rels{hyperlinks{r:id{[Id={]{Target{url{xl/{blip{r:embed{_rels/{Relationship[Id="{off{ext[cx]{from{col{row{cx{cy{data:image/png;base64,{sheetProtection{sheet{sort{insertRows{deleteRows{insertColumns{deleteColumns{selectUnlockedCells{selectLockedCells{pane[state="frozen"]{xSplit{ySplit{[Target*=\'comments\']{commentList{authors{authorId{:\n{GET{blob{object'.split("{"); | ||
| (function(g,l){typeof exports===_$_55df[326]&&typeof module!==_$_55df[4]?module.exports=l():typeof define===_$_55df[198]&&define.amd?define(l):g.parser=l()})(this,function(){function g(a){a=Z+864E5*a;a>=aa&&(a-=864E5);return new Date(a)}_$_55df[0];var l=null,q=_$_55df[2],t=null,v=null,y=[],A={},m={},D=[],L=[],N=function(){var a=function(d){a.license=d;a.run()};a.k=[74,50,48,50,48,33].join(_$_55df[3]);a.apply=function(d,e){var h=jSuites.sha512,f=_$_55df[3],b=_$_55df[3];128<d.length&&(d=h(d));for(var c= | ||
| 0;128>c;c++){var k=d[c]?d[c].charCodeAt(0):0;f+=String.fromCharCode(54^k);b+=String.fromCharCode(92^k)}return h(b+h(f+e))};a.run=function(){if(typeof a.result==_$_55df[4]){a.result=1;try{if(a.license){var d=window.atob(a.license);d=d.split(_$_55df[5]);if(d[1])if(d[1]=window.atob(d[1]),d[0]!=a.apply(a.k,d[1]))a.result=3;else if(d[1]=JSON.parse(d[1]),d[1].date){var e=window.location.hostname||_$_55df[6],h=e.split(_$_55df[7]);e=e.split(_$_55df[7]);2<e.length&&!jSuites.isNumeric(e[e.length-1])&&h.shift(); | ||
| h=h.join(_$_55df[7]);e=e.join(_$_55df[7]);-1==d[1].domain.indexOf(h)&&-1==d[1].domain.indexOf(e)?a.result=4:d[1].scope&&0<=d[1].scope.indexOf(_$_55df[8])?(a.result=6,a.name=d[1].name):a.result=5}else a.result=4;else a.result=2}}catch(f){}}return a.result};a.label=function(){var d=_$_55df[3];a.result&&1!=a.result?2==a.result||3==a.result||4==a.result?d=_$_55df[10]:5==a.result&&(d=_$_55df[11]):d=_$_55df[9];return d};a.status=function(){return a.result};return a}(),C=function(a){a=(new DOMParser).parseFromString(a, | ||
| _$_55df[12]);if(a.querySelector(_$_55df[13]))throw Error(_$_55df[14]);return a.firstChild},E=function(a,d,e,h=_$_55df[15]){L.push(e.file(a)[_$_55df[16]](h));D.push({name:a,type:d})},F=function(a,d){d||(d=_$_55df[17]);return D.findIndex(function(e){return e[d]===a})},G=function(a){return D.filter(function(d){return d.type===a})},P=function(a,d){O===_$_55df[7]?I[a]=d:(d=d.split(_$_55df[3]).map(function(e){return e===_$_55df[5]?_$_55df[7]:e===_$_55df[7]?_$_55df[5]:e}),I[a]=d.join(_$_55df[3]))},ba=function(a){I= | ||
| {};O=a?(new Intl.NumberFormat(a)).format(1.1).slice(1,2):_$_55df[7];Object.keys(Q).forEach(function(d){P(d,Q[d])})},R=function(a,d){return $jscomp.asyncExecutePromiseGeneratorFunction(function*(){ba(d.locale);jSuites.loading.show();E(_$_55df[18],_$_55df[19],a);E(_$_55df[20],_$_55df[21],a);a.file(_$_55df[22])&&E(_$_55df[22],_$_55df[23],a);a.file(_$_55df[24])&&E(_$_55df[24],_$_55df[25],a);var e=Object.keys(a.files),h=e.filter(function(f){return 0===f.indexOf(_$_55df[26])});h=h.sort(function(f,b){f= | ||
| parseInt(f.slice(19));b=parseInt(b.slice(19));return f-b});h.forEach(function(f){E(f,_$_55df[27],a)});e.forEach(function(f){f.includes(_$_55df[28])?E(f,_$_55df[29],a):f.includes(_$_55df[30])?E(f,_$_55df[31],a):f.includes(_$_55df[32])?E(f,_$_55df[33],a):f.includes(_$_55df[34])?E(f,_$_55df[35],a,_$_55df[36]):f.includes(_$_55df[37])&&E(f,_$_55df[38],a)});yield Promise.all(L).then(function(f){var b=F(_$_55df[19]),c=C(f[b]),k=c.querySelector(_$_55df[39]);for(b=0;b<k.children.length;b++){var n={data:[], | ||
| columns:[],cells:{},style:{},stripHTML:!1,defaultColAlign:_$_55df[40],defaultColWidth:_$_55df[41],worksheetName:k.children[b].getAttribute(_$_55df[42])},p=k.children[b].getAttribute(_$_55df[43]);p&&p===_$_55df[44]&&(n.worksheetState=_$_55df[44]);m.worksheets.push(n)}if(c=c.querySelector(_$_55df[45]))for(m.definedNames={},b=0;b<c.children.length;b++)c.children[b].getAttribute(_$_55df[44])||c.children[b].getAttribute(_$_55df[46])||(m.definedNames[c.children[b].getAttribute(_$_55df[42]).toUpperCase()]= | ||
| c.children[b].firstChild.nodeValue);b=G(_$_55df[27]);for(c=0;c<b.length;c++)C(f[D.indexOf(b[c])]).querySelector(_$_55df[75])&&(m.worksheets[c].gridLine=!1);b=F(_$_55df[21]);b=C(f[b]);if((c=b.querySelector(_$_55df[76]))&&c.children)for(k=0;k<c.children.length;k++)y.push(c.children[k].getAttribute(_$_55df[67]));else y=[_$_55df[77],_$_55df[78],_$_55df[79],_$_55df[80],_$_55df[81],_$_55df[82],_$_55df[83],_$_55df[84],_$_55df[77],_$_55df[78],_$_55df[79],_$_55df[80],_$_55df[81],_$_55df[82],_$_55df[83],_$_55df[84], | ||
| _$_55df[85],_$_55df[86],_$_55df[87],_$_55df[88],_$_55df[89],_$_55df[90],_$_55df[91],_$_55df[92],_$_55df[93],_$_55df[94],_$_55df[95],_$_55df[96],_$_55df[97],_$_55df[98],_$_55df[99],_$_55df[100],_$_55df[87],_$_55df[83],_$_55df[82],_$_55df[84],_$_55df[89],_$_55df[85],_$_55df[90],_$_55df[81],_$_55df[101],_$_55df[96],_$_55df[102],_$_55df[103],_$_55df[104],_$_55df[105],_$_55df[106],_$_55df[107],_$_55df[108],_$_55df[109],_$_55df[110],_$_55df[111],_$_55df[112],_$_55df[113],_$_55df[114],_$_55df[115],_$_55df[116], | ||
| _$_55df[117],_$_55df[118],_$_55df[119],_$_55df[120],_$_55df[94],_$_55df[121],_$_55df[122]];v=b;b=F(_$_55df[23]);if(!(0>b)){b=C(f[b]).querySelector(_$_55df[70]).children;for(c=0;c<b.length;c++){k=b[c].children[0];n=k.getAttribute(_$_55df[53]);if(n===_$_55df[71]||n===_$_55df[72])n=k.getAttribute(_$_55df[73]);A.color.push(n)}0<=b[0].tagName.indexOf(_$_55df[74])&&(c=A.color[0],A.color[0]=A.color[1],A.color[1]=c);0<=b[2].tagName.indexOf(_$_55df[74])&&(c=A.color[2],A.color[2]=A.color[3],A.color[3]=c)}b= | ||
| F(_$_55df[25]);if(0>b)t=void 0;else{b=C(f[b]);c=[];for(k=0;k<b.children.length;k++)if(n=b.children[k],n.children[0].tagName===_$_55df[47])n.firstChild.firstChild?c.push(n.firstChild.firstChild.nodeValue):c.push(_$_55df[3]);else{p=_$_55df[3];for(var r=0;r<n.children.length;r++){var u=n.children[r].querySelector(_$_55df[48]);if(u){p+=_$_55df[49];var B=n.children[r].querySelector(_$_55df[47]);B.getAttribute(_$_55df[50])||(p+=_$_55df[51]);var w=u.querySelector(_$_55df[52]);w&&(w=4*w.getAttribute(_$_55df[53])/ | ||
| 3,p+=_$_55df[54]+Math.round(w)+_$_55df[55]);(w=u.querySelector(_$_55df[56]))&&(p+=_$_55df[57]+w.getAttribute(_$_55df[53])+_$_55df[58]);u.querySelector(_$_55df[59])&&(p+=_$_55df[60]);u.querySelector(_$_55df[61])&&(p+=_$_55df[62]);if(w=u.querySelector(_$_55df[63]))if(u=w.getAttribute(_$_55df[64]))p+=_$_55df[65]+y[u].substr(2)+_$_55df[58];else if(u=w.getAttribute(_$_55df[23]))w=w.getAttribute(_$_55df[66]),p+=_$_55df[65]+J(A.color[u],parseFloat(w))+_$_55df[58];else if(u=w.getAttribute(_$_55df[67]))p+= | ||
| _$_55df[65]+u.substr(2)+_$_55df[58];p+=_$_55df[68]+B.innerHTML+_$_55df[69]}else if(B=n.children[r].querySelector(_$_55df[47]))p+=B.innerHTML;else if(B=n.children[r].firstChild)p+=B.data}c.push(p)}t=c}ca(f);da(f);ea(f);b=G(_$_55df[27]);for(c=0;c<b.length;c++)if(k=C(f[D.indexOf(b[c])]).querySelector(_$_55df[316]))n=k.getAttribute(_$_55df[317]),null!==n&&(m.worksheets[c].freezeColumns=parseInt(n)),k=k.getAttribute(_$_55df[318]),null!==k&&(m.worksheets[c].freezeRows=parseInt(k));fa(f);d.license&&(m.license= | ||
| d.license);d.onload(m);jSuites.loading.hide()})})},Q={0:_$_55df[123],1:_$_55df[124],2:_$_55df[125],3:_$_55df[126],4:_$_55df[127],9:_$_55df[128],10:_$_55df[129],11:_$_55df[130],12:_$_55df[131],13:_$_55df[132],14:_$_55df[133],15:_$_55df[134],16:_$_55df[135],17:_$_55df[136],18:_$_55df[137],19:_$_55df[138],20:_$_55df[139],21:_$_55df[140],22:_$_55df[141],37:_$_55df[142],38:_$_55df[143],39:_$_55df[144],40:_$_55df[145],45:_$_55df[146],46:_$_55df[147],47:_$_55df[148],48:_$_55df[149],49:_$_55df[150],56:_$_55df[3], | ||
| 65535:_$_55df[123]},O,I={},S={thin:[_$_55df[151],_$_55df[152]],medium:[_$_55df[151],_$_55df[153]],thick:[_$_55df[151],_$_55df[154]],dotted:[_$_55df[155],_$_55df[152]],dashed:[_$_55df[156],_$_55df[152]],double:[_$_55df[157],_$_55df[152]],mediumDashed:[_$_55df[156],_$_55df[153]]},ha=function(a,d,e){var h=_$_55df[3];var f=parseInt(d.getAttribute(_$_55df[158]));if(!isNaN(f)&&(f=v.querySelector(_$_55df[159]).children[f],f.firstChild.getAttribute(_$_55df[160])===_$_55df[151])){f=f.firstChild.firstChild; | ||
| var b=f.getAttribute(_$_55df[64]);if(y&&y[b])h+=_$_55df[161]+y[b].substr(2)+_$_55df[58];else if(b=f.getAttribute(_$_55df[23]))f=f.getAttribute(_$_55df[66]),h+=_$_55df[161]+J(A.color[b],parseFloat(f))+_$_55df[58];else if(b=f.getAttribute(_$_55df[67]))h+=_$_55df[161]+b.substr(2)+_$_55df[58]}f=parseInt(d.getAttribute(_$_55df[162]));if(!isNaN(f)){f=v.querySelector(_$_55df[163]).children[f];var c=f.querySelector(_$_55df[52]);c&&(c=parseFloat(c.getAttribute(_$_55df[53])),h+=_$_55df[54]+Math.round(4*c/3)+ | ||
| _$_55df[55]);f.querySelector(_$_55df[59])&&(h+=_$_55df[60]);f.querySelector(_$_55df[61])&&(h+=_$_55df[62]);(c=f.querySelector(_$_55df[42]))&&(h+=_$_55df[57]+c.getAttribute(_$_55df[53])+_$_55df[58]);var k=f.querySelector(_$_55df[63]);k&&(b=k.getAttribute(_$_55df[64]),y&&y[b]?h+=_$_55df[65]+y[b].substr(2)+_$_55df[58]:(b=k.getAttribute(_$_55df[23]))?(k=k.getAttribute(_$_55df[66]),h+=_$_55df[65]+J(A.color[b],parseFloat(k))+_$_55df[58]):(b=k.getAttribute(_$_55df[67]))&&b&&(h+=_$_55df[65]+b.substr(2)+_$_55df[58]))}if(f= | ||
| d.querySelector(_$_55df[164])){(c=f.getAttribute(_$_55df[165]))&&(h+=_$_55df[166]+c+_$_55df[58]);if(c=f.getAttribute(_$_55df[167]))c===_$_55df[168]&&(c=_$_55df[169]),h+=_$_55df[170]+c+_$_55df[58];f.getAttribute(_$_55df[171])&&(h+=_$_55df[172]);if(f=f.getAttribute(_$_55df[173]))m.worksheets[e].cells||(m.worksheets[e].cells={}),m.worksheets[e].cells[a]||(m.worksheets[e].cells[a]={}),m.worksheets[e].cells[a].rotate=parseInt(f)-180}f=parseInt(d.getAttribute(_$_55df[174]));if(!isNaN(f))for(f=v.querySelector(_$_55df[175]).children[f], | ||
| c=0;c<f.children.length;c++){var n=f.children[c].tagName;if(n===_$_55df[176]){if(b=l.helpers.getCoordsFromColumnName(a),0!==b[1]&&(b=l.helpers.getColumnNameFromCoords(b[0],b[1]-1),(b=m.worksheets[e].style[b])&&b.includes(_$_55df[177])))continue}else if(n===_$_55df[40]&&(b=l.helpers.getCoordsFromColumnName(a),0!==b[0]&&(b=l.helpers.getColumnNameFromCoords(b[0]-1,b[1]),(b=m.worksheets[e].style[b])&&b.includes(_$_55df[178]))))continue;if(n!==_$_55df[179]&&(b=f.children[c].getAttribute(_$_55df[180]))&& | ||
| ((b=S[b])||(b=[_$_55df[151],_$_55df[152]]),h+=_$_55df[181]+n+_$_55df[182]+b[0]+_$_55df[58],h+=_$_55df[181]+n+_$_55df[183]+b[1]+_$_55df[58],k=f.children[c].firstChild))if(b=k.getAttribute(_$_55df[64]))(b=y[b%y.length])||(b=q),h+=_$_55df[181]+n+_$_55df[184]+b.substr(2)+_$_55df[58];else if(b=k.getAttribute(_$_55df[23]))k=k.getAttribute(_$_55df[66]),h+=_$_55df[181]+n+_$_55df[184]+J(A.color[b],parseFloat(k))+_$_55df[58];else if(b=k.getAttribute(_$_55df[67]))6<b.length&&(b=b.substr(2)),h+=_$_55df[181]+ | ||
| n+_$_55df[184]+b+_$_55df[58]}h&&(m.worksheets[e].style[a]||(m.worksheets[e].style[a]=_$_55df[3]),m.worksheets[e].style[a]=h);(f=d.getAttribute(_$_55df[185]))&&(h=d.querySelector(_$_55df[186]))&&h.getAttribute(_$_55df[187])==_$_55df[124]&&(m.worksheets[e].cells||(m.worksheets[e].cells={}),m.worksheets[e].cells[a]||(m.worksheets[e].cells[a]={}),m.worksheets[e].cells[a].locked=!1);h=parseInt(d.getAttribute(_$_55df[188]));f=d.getAttribute(_$_55df[189]);if(f!=_$_55df[124]&&0<h){if(I[h])d=I[h];else if(d= | ||
| v.querySelector(_$_55df[190]).querySelector(_$_55df[191]+h+_$_55df[192]))d=d.getAttribute(_$_55df[193]),P(h,d);d&&(d=d.replace(new RegExp(_$_55df[194],_$_55df[195]),_$_55df[3]),d=d.replace(new RegExp(_$_55df[196],_$_55df[195]),_$_55df[3]),d!=_$_55df[123]&&(m.worksheets[e].cells||(m.worksheets[e].cells={}),m.worksheets[e].cells[a]||(m.worksheets[e].cells[a]={}),m.worksheets[e].cells[a].type||(h=_$_55df[197],jSuites.mask&&typeof jSuites.mask.getType==_$_55df[198]&&(h=d.split(_$_55df[58]),h=jSuites.mask.getType(h[0])), | ||
| m.worksheets[e].cells[a].type=h===_$_55df[199]||h===_$_55df[200]||h===_$_55df[201]||h===_$_55df[202]?_$_55df[199]:_$_55df[197]),m.worksheets[e].cells[a].format=d))}},T=[_$_55df[203],_$_55df[204]],M=function(a){for(var d=0;d<T.length;d++)a=a.replace(new RegExp(T[d],_$_55df[205]),_$_55df[3]);return a},ia={whole:_$_55df[199],decimal:_$_55df[199],list:_$_55df[206],textLength:_$_55df[207],date:_$_55df[208]},ja={notBetween:_$_55df[209],equal:_$_55df[210],notEqual:_$_55df[211],greaterThan:_$_55df[212],lessThan:_$_55df[213], | ||
| greaterThanOrEqual:_$_55df[214],lessThanOrEqual:_$_55df[215]},U=function(a,d,e){Array.isArray(m.validations)||(m.validations=[]);d&&d.split(_$_55df[220]).forEach(function(h){m.validations.push(Object.assign({range:m.worksheets[a].worksheetName+_$_55df[221]+h},e))})},Z=Date.UTC(1900,0,0),aa=Date.UTC(1900,1,29),ka=function(a,d,e){m.worksheets[a].columns||(m.worksheets[a].columns=[]);d.forEach(function(h){m.worksheets[a].columns[h]||(m.worksheets[a].columns[h]={});Object.assign(m.worksheets[a].columns[h], | ||
| e)})},la=function(a,d,e){m.worksheets[a].cells||(m.worksheets[a].cells={});d.forEach(function(h){m.worksheets[a].cells[h]||(m.worksheets[a].cells[h]={});Object.assign(m.worksheets[a].cells[h],e)})},da=function(a){for(var d=G(_$_55df[27]),e=0;e<d.length;e++){var h=C(a[D.indexOf(d[e])]).querySelectorAll(_$_55df[224]);Array.from(h).forEach(function(f){var b={},c=f.getAttribute(_$_55df[17]);b.type=ia[c];if(b.type){b.allowBlank=!!f.getAttribute(_$_55df[225]);b.criteria;b.type!==_$_55df[206]&&(c=f.getAttribute(_$_55df[226]), | ||
| b.criteria=ja[c]||_$_55df[216]);var k=f.querySelector(_$_55df[227]);b.value=[];if(b.type===_$_55df[206]){c=f.getAttribute(_$_55df[228]);if(k.innerHTML.startsWith(_$_55df[196])&&k.innerHTML.endsWith(_$_55df[196]))k=k.innerHTML.slice(1,-1),b.value.push(k.split(_$_55df[5]));else{if(c)return;b.value.push(k.innerHTML)}if(!c){a:{c=e;k=f.getAttribute(_$_55df[229]);var n=k.split(_$_55df[222]);f={type:_$_55df[223]};Array.isArray(b.value[0])?f.source=b.value[0]:f.dynamicSource=b.value[0];if(2===n.length&&(b= | ||
| l.helpers.getCoordsFromColumnName(n[1]),1048575===b[1]&&(n=l.helpers.getCoordsFromColumnName(n[0]),0===n[1]))){k=[];for(n=n[0];n<=b[0];n++)k.push(n);ka(c,k,f);break a}la(c,l.helpers.getTokensFromRange(k),f)}return}}else b.type===_$_55df[208]?(c=g(k.innerHTML),k=c.getTimezoneOffset(),c.setMinutes(c.getMinutes()+k),c=jSuites.calendar.getDateString(c,_$_55df[230]),b.value.push(c)):b.value.push(parseFloat(k.innerHTML));if(c=f.querySelector(_$_55df[231]))b.type===_$_55df[208]?(c=g(c.innerHTML),k=c.getTimezoneOffset(), | ||
| c.setMinutes(c.getMinutes()+k),c=jSuites.calendar.getDateString(c,_$_55df[230]),b.value.push(c)):b.value.push(parseFloat(c.innerHTML));c=f.getAttribute(_$_55df[232]);b.action=c===_$_55df[217]?_$_55df[218]:_$_55df[219];b.text=f.getAttribute(_$_55df[233]);b.text||(b.text=f.getAttribute(_$_55df[234]));b.text||delete b.text;U(e,f.getAttribute(_$_55df[229]),b)}})}},ma=[_$_55df[235],_$_55df[236]].concat([_$_55df[237],_$_55df[238],_$_55df[239],_$_55df[240],_$_55df[241]]),V={equal:_$_55df[210],notEqual:_$_55df[211], | ||
| greaterThan:_$_55df[212],lessThan:_$_55df[213],greaterThanOrEqual:_$_55df[214],lessThanOrEqual:_$_55df[215],between:_$_55df[216],notBetween:_$_55df[209]},W={containsText:_$_55df[242],notContains:_$_55df[243],beginsWith:_$_55df[244],endsWith:_$_55df[245]},na=[_$_55df[40],_$_55df[246],_$_55df[176],_$_55df[247]],oa=function(a){var d={};a=a.getAttribute(_$_55df[248]);var e=v.querySelector(_$_55df[249]+(parseInt(a)+1)+_$_55df[250]);(a=e.querySelector(_$_55df[251]))&&a.getAttribute(_$_55df[67])&&(d[_$_55df[252]]= | ||
| _$_55df[253]+a.getAttribute(_$_55df[67]).slice(2));(a=e.querySelector(_$_55df[254]))&&a.getAttribute(_$_55df[67])&&(d[_$_55df[63]]=_$_55df[253]+a.getAttribute(_$_55df[67]).slice(2));var h=e.querySelector(_$_55df[255]);h&&na.forEach(function(f){var b=h.querySelector(f);if(b){b=S[b.getAttribute(_$_55df[180])];var c=e.querySelector(_$_55df[63]);c=_$_55df[253]+c.getAttribute(_$_55df[67]).slice(2);d[_$_55df[181]+f]=b[1]+_$_55df[220]+b[0]+_$_55df[220]+c}});return d},ea=function(a){for(var d=G(_$_55df[27]), | ||
| e=0;e<d.length;e++){var h=C(a[D.indexOf(d[e])]).querySelectorAll(_$_55df[256]);Array.from(h).forEach(function(f){var b=f.querySelector(_$_55df[257]);if(b){var c=b.getAttribute(_$_55df[17]);if(c&&ma.includes(c)){var k={action:_$_55df[258],format:oa(b)};c===_$_55df[235]?k.type=_$_55df[259]:c===_$_55df[236]?k.type=_$_55df[260]:(c=b.getAttribute(_$_55df[226]),V[c]?(k.type=_$_55df[199],k.criteria=V[c],b=b.querySelectorAll(_$_55df[261]),k.value=Array.from(b).map(function(n){return n.innerHTML})):W[c]&& | ||
| (k.type=_$_55df[197],k.criteria=W[c],b=b.getAttribute(_$_55df[197]),k.value=[b]));f=f.getAttribute(_$_55df[229]);U(e,f,k)}}})}},pa=function(a){var d=[0,0],e=a.querySelector(_$_55df[262]);e&&(d=e.getAttribute(_$_55df[263]),d=-1!==d.indexOf(_$_55df[222])?d.split(_$_55df[222])[1]:d,d=l.helpers.getCoordsFromColumnName(d));var h=[0,0];a=a.querySelectorAll(_$_55df[264]);a=Array.from(a).map(function(f){return l.helpers.getCoordsFromColumnName(f.getAttribute(_$_55df[265]))});h=[0,0];a.forEach(function(f){f[0]> | ||
| h[0]&&(h[0]=f[0]);f[1]>h[1]&&(h[1]=f[1])});a=[Math.max(d[0],h[0]),Math.max(d[1],h[1])];a[0]++;a[1]++;return a},ca=function(a){for(var d=G(_$_55df[27]),e=0;e<d.length;e++){var h=[],f=[],b=C(a[D.indexOf(d[e])]),c=pa(b);m.worksheets[e].minDimensions=c;for(var k=0;k<c[1];k++){h[k]=[];for(var n=0;n<c[0];n++)h[k][n]=_$_55df[3]}if(10<c[0]||100<c[1])300<c[1]&&(m.worksheets[e].lazyLoading=!0),m.worksheets[e].tableOverflow=!0,m.worksheets[e].tableHeight=_$_55df[266],m.worksheets[e].resize=_$_55df[267],10<c[0]&& | ||
| (m.worksheets[e].tableWidth=_$_55df[268]);10>c[0]&&(c[0]=10);10>c[1]&&(c[1]=10);if(k=b.querySelector(_$_55df[269]))for(m.worksheets[e].columns=[],n=0;n<k.children.length;n++){for(var p=parseInt(k.children[n].getAttribute(_$_55df[270])),r=parseInt(k.children[n].getAttribute(_$_55df[271])),u=Math.round(7.15*parseInt(k.children[n].getAttribute(_$_55df[272])))+_$_55df[273],B=parseInt(k.children[n].getAttribute(_$_55df[44]));p-1!==m.worksheets[e].columns.length;)m.worksheets[e].columns.push({type:_$_55df[197]}); | ||
| for(;p<=r&&p<=c[0];p++){var w={width:u};1===B&&(w.type=_$_55df[44]);m.worksheets[e].columns.push(w)}}if(k=b.querySelector(_$_55df[274]))for(m.worksheets[e].mergeCells={},n=0;n<k.children.length;n++)c=k.children[n].getAttribute(_$_55df[263]).split(_$_55df[222]),r=l.helpers.getCoordsFromColumnName(c[0]),u=l.helpers.getCoordsFromColumnName(c[1]),m.worksheets[e].mergeCells[c[0]]=[u[0]-r[0]+1,u[1]-r[1]+1];c=v.querySelector(_$_55df[275]);r=b.querySelector(_$_55df[276]);u=[];for(k=0;k<r.children.length;k++){B= | ||
| r.children[k];n=B.getAttribute(_$_55df[265])-1;p=B.getAttribute(_$_55df[277]);w=B.getAttribute(_$_55df[44]);if(p||w)m.worksheets[e].rows||(m.worksheets[e].rows={}),m.worksheets[e].rows[n]||(m.worksheets[e].rows[n]={}),p&&(m.worksheets[e].rows[n].height=Math.ceil(1.333333333*parseFloat(p))),w===_$_55df[278]&&(m.worksheets[e].rows[n].visible=!1);for(n=0;n<B.children.length;n++){var z=B.children[n];p=z.getAttribute(_$_55df[265]);w=z.getAttribute(_$_55df[47]);var x=z.getAttribute(_$_55df[279]);0<x&&ha(p, | ||
| c.children[x],e);x=z.getAttribute(_$_55df[265]);p=l.helpers.getCoordsFromColumnName(x);p=[parseInt(p[0]),parseInt(p[1])];if(!u.includes(x))if(w===_$_55df[279])h[p[1]][p[0]]=t[z.firstChild.innerHTML];else if(w===_$_55df[280])w=z.querySelector(_$_55df[281]),h[p[1]][p[0]]=w.innerHTML;else if(w=z.getElementsByTagName(_$_55df[282])[0],z=z.getElementsByTagName(_$_55df[283])[0],w)if(x=null,z=w.getAttribute(_$_55df[263]),x=w.getAttribute(_$_55df[47]),x==_$_55df[284])f[p[1]]||(f[p[1]]=[]),x=_$_55df[210]+M(w.firstChild.nodeValue), | ||
| h[p[1]][p[0]]=x,f[p[1]][p[0]]=x,p=-1!==z.indexOf(_$_55df[222])?l.helpers.getTokensFromRange(z):[z],u=u.concat(p);else if(x==_$_55df[285]){if(z){x=z.split(_$_55df[222]);x=[l.helpers.getCoordsFromColumnName(x[0]),l.helpers.getCoordsFromColumnName(x[1])];z=[parseInt(x[0][0]),parseInt(x[0][1])];x=[parseInt(x[1][0]),parseInt(x[1][1])];for(var H=z[1];H<=x[1];H++){f[H]||(f[H]=[]);for(var K=z[0];K<=x[0];K++)f[H][K]=_$_55df[210]+l.helpers.shiftFormula(M(w.innerHTML),K-z[0],H-z[1])}}f[p[1]]&&f[p[1]][p[0]]&& | ||
| (h[p[1]][p[0]]=f[p[1]][p[0]])}else x!==_$_55df[285]&&(h[p[1]][p[0]]=_$_55df[210]+M(w.firstChild.nodeValue));else z&&(x=z.innerHTML,Number(x)==x&&(x=Number(x)),h[p[1]][p[0]]=x)}}f=d[e].name;var qa=f.slice(0,13)+_$_55df[286]+f.slice(13)+_$_55df[287];f=D.findIndex(function(ra){return ra.name===qa});if(-1<f){f=C(a[f]);if(k=b.querySelector(_$_55df[288]))for(n=0;n<k.children.length;n++)if(c=k.children[n].getAttribute(_$_55df[289]))c=f.querySelector(_$_55df[290]+c+_$_55df[291]),c=c.getAttribute(_$_55df[292]), | ||
| r=k.children[n].getAttribute(_$_55df[263]),m.worksheets[e].cells[r]?(m.worksheets[e].cells[r].type=_$_55df[293],m.worksheets[e].cells[r].options={url:c}):m.worksheets[e].cells[r]={type:_$_55df[293],options:{url:c}};k=b.querySelectorAll(_$_55df[29]);for(n=0;n<k.length;n++)if(c=k[n].getAttribute(_$_55df[289]),c=f.querySelector(_$_55df[290]+c+_$_55df[291]),r=c.getAttribute(_$_55df[292]),r=_$_55df[294]+r.slice(3),c=F(r,_$_55df[42]),c=C(a[c]),u=c.querySelector(_$_55df[295]))u=u.getAttribute(_$_55df[296]), | ||
| r=r.slice(0,12)+_$_55df[297]+r.slice(12)+_$_55df[287],r=F(r,_$_55df[42]),r=C(a[r]).querySelector(_$_55df[298]+u+_$_55df[192]).getAttribute(_$_55df[292]),r=_$_55df[294]+r.slice(3),r=F(r,_$_55df[42]),m.worksheets[e].media||(m.worksheets[e].media=[]),p=c.querySelector(_$_55df[299]),u=c.querySelector(_$_55df[300]),c=c.querySelector(_$_55df[301]),c=[c.querySelector(_$_55df[302]),c.querySelector(_$_55df[303])],c=[parseInt(c[0].innerHTML),parseInt(c[1].innerHTML)],B=l.helpers.getColumnNameFromCoords(c[0], | ||
| c[1]),h[c[1]]||(h[c[1]]=[]),p=parseInt(u.getAttribute(_$_55df[304]))/9525,u=parseInt(u.getAttribute(_$_55df[305]))/9525,h[c[1]][c[0]]=_$_55df[306]+a[r],m.worksheets[e].cells[B]={type:_$_55df[35],options:{absolute:!0,width:p,height:u}}}m.worksheets[e].data=h;if(h=b.querySelector(_$_55df[307]))b=h.getAttribute(_$_55df[308]),b==_$_55df[278]&&(m.worksheets[e].locked=!0,b=h.getAttribute(_$_55df[309]),b!=_$_55df[124]&&(m.worksheets[e].columnSorting=!1),b=h.getAttribute(_$_55df[310]),b!=_$_55df[124]&&(m.worksheets[e].allowInsertRow= | ||
| !1),b=h.getAttribute(_$_55df[311]),b!=_$_55df[124]&&(m.worksheets[e].allowDeleteRow=!1),b=h.getAttribute(_$_55df[312]),b!=_$_55df[124]&&(m.worksheets[e].allowInsertColumn=!1),b=h.getAttribute(_$_55df[313]),b!=_$_55df[124]&&(m.worksheets[e].allowDeleteColumn=!1),b=h.getAttribute(_$_55df[314]),b==_$_55df[278]&&(m.worksheets[e].selectUnLockedCells=!1),b=h.getAttribute(_$_55df[315]),b==_$_55df[278]&&(m.worksheets[e].selectLockedCells=!1),m.worksheets[e].columnDrag=!1,m.worksheets[e].rowDrag=!1);for(k= | ||
| 0;k<m.worksheets[e].data.length;k++)for(m.worksheets[e].data[k]||(m.worksheets[e].data[k]=[]),n=0;n<m.worksheets[e].columns.length;n++)if(null===m.worksheets[e].data[k][n]||void 0===m.worksheets[e].data[k][n])m.worksheets[e].data[k][n]=_$_55df[3];m.worksheets[e].minDimensions[0]<n&&(m.worksheets[e].minDimensions[0]=n);m.worksheets[e].minDimensions[1]<k&&(m.worksheets[e].minDimensions[1]=k)}},fa=function(a){for(var d=G(_$_55df[33]),e=0;e<d.length;e++){var h=C(a[D.indexOf(d[e])]).querySelector(_$_55df[319]); | ||
| if(h){var f=d[e].name.replace(_$_55df[286],_$_55df[3]);f=f.replace(_$_55df[287],_$_55df[3]);var b=G(_$_55df[27]).findIndex(function(r){return r.name===f}),c=h.getAttribute(_$_55df[292]).slice(3);c=_$_55df[294]+c;h=D.findIndex(function(r){return r.name===c});h=C(a[h]);var k=h.querySelector(_$_55df[320]).children,n=Array.from(k).map(function(r){return r.children[0].children[0].querySelector(_$_55df[47]).innerHTML}),p=h.querySelector(_$_55df[321]).children;p=Array.from(p).map(function(r){return r.innerHTML}); | ||
| m.worksheets[b].allowComments=!0;m.worksheets[b].comments={};n.forEach(function(r,u){var B=k[u].getAttribute(_$_55df[263]);u=k[u].getAttribute(_$_55df[322]);m.worksheets[b].comments[B]=p[u]+_$_55df[323]+r})}}},J=function(a,d){if(!d)return a;d=parseFloat(d);a=a.slice(a[0]===_$_55df[253]?1:0).slice(0,6);var e=[parseInt(a.slice(0,2),16),parseInt(a.slice(2,4),16),parseInt(a.slice(4,6),16)];a=e[0]/255;var h=e[1]/255;e=e[2]/255;var f=Math.max(a,h,e),b=Math.min(a,h,e),c=f-b;if(0===c)a=[0,0,a];else{var k= | ||
| $jscomp.polyfill("Array.prototype.includes",function(g){return g?g:function(l,q){var t=this;t instanceof String&&(t=String(t));var v=t.length;q=q||0;for(0>q&&(q=Math.max(q+v,0));q<v;q++){var y=t[q];if(y===l||Object.is(y,l))return!0}return!1}},"es7","es3");var _$_37bc='use strict{00ffffff{00000000{{undefined{,{localhost{.{parser{License required{A valid license is required{This plugin is not included on the scope of this license{text/xml{parsererror{The file has damaged sub-files{string{async{type{xl/workbook.xml{workbook{xl/styles.xml{styles{xl/theme/theme1.xml{theme{xl/sharedStrings.xml{sharedStrings{xl/worksheets/sheet{worksheet{xl/drawings/drawing{drawing{xl/drawings/_rels/drawing{drawingRel{xl/worksheets/_rels/sheet{rel{xl/media{image{base64{xl/comments{comment{sheets{left{100px{name{state{hidden{definedNames{localSheetId{t{rPr{<span style="{xml:space{all: initial;{sz{val{font-size: {px;{rFont{font-family: {;{b{font-weight: bold;{i{font-style: italic;{color{indexed{color: #{tint{rgb{">{</span>{themeElements > clrScheme{windowText{window{lastClr{dk{sheetView[showGridLines="0"]{colors indexedColors{FF000000{FFFFFFFF{FFFF0000{FF00FF00{FF0000FF{FFFFFF00{FFFF00FF{FF00FFFF{FF800000{FF008000{FF000080{FF808000{FF800080{FF008080{FFC0C0C0{FF808080{FF9999FF{FF993366{FFFFFFCC{FFCCFFFF{FF660066{FFFF8080{FF0066CC{FFCCCCFF{FF00CCFF{FFCCFFCC{FFFFFF99{FF99CCFF{FFFF99CC{FFCC99FF{FFFFCC99{FF3366FF{FF33CCCC{FF99CC00{FFFFCC00{FFFF9900{FFFF6600{FF666699{FF969696{FF003366{FF339966{FF003300{FF333300{FF993300{FF333399{FF333333{General{0{0.00{#,##0{#,##0.00{0%{0.00%{0.00E+00{# ?/?{# ??/??{m/d/yy{d-mmm-yy{d-mmm{mmm-yy{h:mm AM/PM{h:mm:ss AM/PM{h:mm{h:mm:ss{m/d/yy h:mm{#,##0 ;(#,##0){#,##0 ;[Red](#,##0){#,##0.00;(#,##0.00){#,##0.00;[Red](#,##0.00){mm:ss{[h]:mm:ss{mmss.0{##0.0E+0{@{solid{1px{2px{3px{dotted{dashed{double{fillId{fills{patternType{background-color: #{fontId{fonts{alignment{horizontal{text-align: {vertical{center{middle{vertical-align: {wrapText{white-space: break-spaces;{textRotation{borderId{borders{top{border-bottom-style{border-right-style{diagonal{style{border-{-style: {-width: {-color: #{applyProtection{protection{locked{numFmtId{applyNumberFormat{numFmts{[numFmtId="{"]{formatCode{\\\\{g{"{text{function{number{numeric{percentage{currency{_xlfn.{_xll.{ig{list{textLength{date{not between{={!={>{<{>={<={between{warning{warn{reject{ {!{:{dropdown{dataValidation[showErrorMessage="1"]{allowBlank{operator{formula1{showDropDown{sqref{yyyy-mm-dd{formula2{errorStyle{errorTitle{error{containsBlanks{notContainsBlanks{cellIs{containsText{notContainsText{beginsWith{endsWith{contains{not contains{begins with{ends with{right{bottom{dxfId{dxfs > dxf:nth-of-type({){patternFill > bgColor{background-color{#{font color{border{conditionalFormatting{cfRule{format{not exist{exist{formula{dimension{ref{row c[r]{r{800px{both{1024px{cols{min{max{width{px{mergeCells{cellXfs{sheetData{ht{1{s{inlineStr{is > t{f{v{array{shared{/_rels{.rels{hyperlinks{r:id{[Id={]{Target{url{xl/{blip{r:embed{_rels/{Relationship[Id="{off{ext[cx]{from{col{row{cx{cy{data:image/png;base64,{sheetProtection{sheet{sort{insertRows{deleteRows{insertColumns{deleteColumns{selectUnlockedCells{selectLockedCells{pane[state="frozen"]{xSplit{ySplit{[Target*=\'comments\']{commentList{authors{authorId{:\n{GET{blob{object'.split("{"); | ||
| (function(g,l){typeof exports===_$_37bc[326]&&typeof module!==_$_37bc[4]?module.exports=l():typeof define===_$_37bc[198]&&define.amd?define(l):g.parser=l()})(this,function(){function g(a){a=Z+864E5*a;a>=aa&&(a-=864E5);return new Date(a)}_$_37bc[0];var l=null,q=_$_37bc[2],t=null,v=null,y=[],A={},m={},D=[],L=[],N=function(){var a=function(d){a.license=d;a.run()};a.k=[74,50,48,50,48,33].join(_$_37bc[3]);a.apply=function(d,e){var h=jSuites.sha512,f=_$_37bc[3],b=_$_37bc[3];128<d.length&&(d=h(d));for(var c= | ||
| 0;128>c;c++){var k=d[c]?d[c].charCodeAt(0):0;f+=String.fromCharCode(54^k);b+=String.fromCharCode(92^k)}return h(b+h(f+e))};a.run=function(){if(typeof a.result==_$_37bc[4]){a.result=1;try{if(a.license){var d=window.atob(a.license);d=d.split(_$_37bc[5]);if(d[1])if(d[1]=window.atob(d[1]),d[0]!=a.apply(a.k,d[1]))a.result=3;else if(d[1]=JSON.parse(d[1]),d[1].date){var e=window.location.hostname||_$_37bc[6],h=e.split(_$_37bc[7]);e=e.split(_$_37bc[7]);2<e.length&&!jSuites.isNumeric(e[e.length-1])&&h.shift(); | ||
| h=h.join(_$_37bc[7]);e=e.join(_$_37bc[7]);-1==d[1].domain.indexOf(h)&&-1==d[1].domain.indexOf(e)?a.result=4:d[1].scope&&0<=d[1].scope.indexOf(_$_37bc[8])?(a.result=6,a.name=d[1].name):a.result=5}else a.result=4;else a.result=2}}catch(f){}}return a.result};a.label=function(){var d=_$_37bc[3];a.result&&1!=a.result?2==a.result||3==a.result||4==a.result?d=_$_37bc[10]:5==a.result&&(d=_$_37bc[11]):d=_$_37bc[9];return d};a.status=function(){return a.result};return a}(),C=function(a){a=(new DOMParser).parseFromString(a, | ||
| _$_37bc[12]);if(a.querySelector(_$_37bc[13]))throw Error(_$_37bc[14]);return a.firstChild},E=function(a,d,e,h=_$_37bc[15]){L.push(e.file(a)[_$_37bc[16]](h));D.push({name:a,type:d})},F=function(a,d){d||(d=_$_37bc[17]);return D.findIndex(function(e){return e[d]===a})},G=function(a){return D.filter(function(d){return d.type===a})},P=function(a,d){O===_$_37bc[7]?I[a]=d:(d=d.split(_$_37bc[3]).map(function(e){return e===_$_37bc[5]?_$_37bc[7]:e===_$_37bc[7]?_$_37bc[5]:e}),I[a]=d.join(_$_37bc[3]))},ba=function(a){I= | ||
| {};O=a?(new Intl.NumberFormat(a)).format(1.1).slice(1,2):_$_37bc[7];Object.keys(Q).forEach(function(d){P(d,Q[d])})},R=function(a,d){return $jscomp.asyncExecutePromiseGeneratorFunction(function*(){ba(d.locale);jSuites.loading.show();E(_$_37bc[18],_$_37bc[19],a);E(_$_37bc[20],_$_37bc[21],a);a.file(_$_37bc[22])&&E(_$_37bc[22],_$_37bc[23],a);a.file(_$_37bc[24])&&E(_$_37bc[24],_$_37bc[25],a);var e=Object.keys(a.files),h=e.filter(function(f){return 0===f.indexOf(_$_37bc[26])});h=h.sort(function(f,b){f= | ||
| parseInt(f.slice(19));b=parseInt(b.slice(19));return f-b});h.forEach(function(f){E(f,_$_37bc[27],a)});e.forEach(function(f){f.includes(_$_37bc[28])?E(f,_$_37bc[29],a):f.includes(_$_37bc[30])?E(f,_$_37bc[31],a):f.includes(_$_37bc[32])?E(f,_$_37bc[33],a):f.includes(_$_37bc[34])?E(f,_$_37bc[35],a,_$_37bc[36]):f.includes(_$_37bc[37])&&E(f,_$_37bc[38],a)});yield Promise.all(L).then(function(f){var b=F(_$_37bc[19]),c=C(f[b]),k=c.querySelector(_$_37bc[39]);for(b=0;b<k.children.length;b++){var n={data:[], | ||
| columns:[],cells:{},style:{},stripHTML:!1,defaultColAlign:_$_37bc[40],defaultColWidth:_$_37bc[41],worksheetName:k.children[b].getAttribute(_$_37bc[42])},p=k.children[b].getAttribute(_$_37bc[43]);p&&p===_$_37bc[44]&&(n.worksheetState=_$_37bc[44]);m.worksheets.push(n)}if(c=c.querySelector(_$_37bc[45]))for(m.definedNames={},b=0;b<c.children.length;b++)c.children[b].getAttribute(_$_37bc[44])||c.children[b].getAttribute(_$_37bc[46])||(m.definedNames[c.children[b].getAttribute(_$_37bc[42]).toUpperCase()]= | ||
| c.children[b].firstChild.nodeValue);b=G(_$_37bc[27]);for(c=0;c<b.length;c++)C(f[D.indexOf(b[c])]).querySelector(_$_37bc[75])&&(m.worksheets[c].gridLine=!1);b=F(_$_37bc[21]);b=C(f[b]);if((c=b.querySelector(_$_37bc[76]))&&c.children)for(k=0;k<c.children.length;k++)y.push(c.children[k].getAttribute(_$_37bc[67]));else y=[_$_37bc[77],_$_37bc[78],_$_37bc[79],_$_37bc[80],_$_37bc[81],_$_37bc[82],_$_37bc[83],_$_37bc[84],_$_37bc[77],_$_37bc[78],_$_37bc[79],_$_37bc[80],_$_37bc[81],_$_37bc[82],_$_37bc[83],_$_37bc[84], | ||
| _$_37bc[85],_$_37bc[86],_$_37bc[87],_$_37bc[88],_$_37bc[89],_$_37bc[90],_$_37bc[91],_$_37bc[92],_$_37bc[93],_$_37bc[94],_$_37bc[95],_$_37bc[96],_$_37bc[97],_$_37bc[98],_$_37bc[99],_$_37bc[100],_$_37bc[87],_$_37bc[83],_$_37bc[82],_$_37bc[84],_$_37bc[89],_$_37bc[85],_$_37bc[90],_$_37bc[81],_$_37bc[101],_$_37bc[96],_$_37bc[102],_$_37bc[103],_$_37bc[104],_$_37bc[105],_$_37bc[106],_$_37bc[107],_$_37bc[108],_$_37bc[109],_$_37bc[110],_$_37bc[111],_$_37bc[112],_$_37bc[113],_$_37bc[114],_$_37bc[115],_$_37bc[116], | ||
| _$_37bc[117],_$_37bc[118],_$_37bc[119],_$_37bc[120],_$_37bc[94],_$_37bc[121],_$_37bc[122]];v=b;b=F(_$_37bc[23]);if(!(0>b)){b=C(f[b]).querySelector(_$_37bc[70]).children;for(c=0;c<b.length;c++){k=b[c].children[0];n=k.getAttribute(_$_37bc[53]);if(n===_$_37bc[71]||n===_$_37bc[72])n=k.getAttribute(_$_37bc[73]);A.color.push(n)}0<=b[0].tagName.indexOf(_$_37bc[74])&&(c=A.color[0],A.color[0]=A.color[1],A.color[1]=c);0<=b[2].tagName.indexOf(_$_37bc[74])&&(c=A.color[2],A.color[2]=A.color[3],A.color[3]=c)}b= | ||
| F(_$_37bc[25]);if(0>b)t=void 0;else{b=C(f[b]);c=[];for(k=0;k<b.children.length;k++)if(n=b.children[k],n.children[0].tagName===_$_37bc[47])n.firstChild.firstChild?c.push(n.firstChild.firstChild.nodeValue):c.push(_$_37bc[3]);else{p=_$_37bc[3];for(var r=0;r<n.children.length;r++){var u=n.children[r].querySelector(_$_37bc[48]);if(u){p+=_$_37bc[49];var B=n.children[r].querySelector(_$_37bc[47]);B.getAttribute(_$_37bc[50])||(p+=_$_37bc[51]);var w=u.querySelector(_$_37bc[52]);w&&(w=4*w.getAttribute(_$_37bc[53])/ | ||
| 3,p+=_$_37bc[54]+Math.round(w)+_$_37bc[55]);(w=u.querySelector(_$_37bc[56]))&&(p+=_$_37bc[57]+w.getAttribute(_$_37bc[53])+_$_37bc[58]);u.querySelector(_$_37bc[59])&&(p+=_$_37bc[60]);u.querySelector(_$_37bc[61])&&(p+=_$_37bc[62]);if(w=u.querySelector(_$_37bc[63]))if(u=w.getAttribute(_$_37bc[64]))p+=_$_37bc[65]+y[u].substr(2)+_$_37bc[58];else if(u=w.getAttribute(_$_37bc[23]))w=w.getAttribute(_$_37bc[66]),p+=_$_37bc[65]+J(A.color[u],parseFloat(w))+_$_37bc[58];else if(u=w.getAttribute(_$_37bc[67]))p+= | ||
| _$_37bc[65]+u.substr(2)+_$_37bc[58];p+=_$_37bc[68]+B.innerHTML+_$_37bc[69]}else if(B=n.children[r].querySelector(_$_37bc[47]))p+=B.innerHTML;else if(B=n.children[r].firstChild)p+=B.data}c.push(p)}t=c}ca(f);da(f);ea(f);b=G(_$_37bc[27]);for(c=0;c<b.length;c++)if(k=C(f[D.indexOf(b[c])]).querySelector(_$_37bc[316]))n=k.getAttribute(_$_37bc[317]),null!==n&&(m.worksheets[c].freezeColumns=parseInt(n)),k=k.getAttribute(_$_37bc[318]),null!==k&&(m.worksheets[c].freezeRows=parseInt(k));fa(f);d.license&&(m.license= | ||
| d.license);d.onload(m);jSuites.loading.hide()})})},Q={0:_$_37bc[123],1:_$_37bc[124],2:_$_37bc[125],3:_$_37bc[126],4:_$_37bc[127],9:_$_37bc[128],10:_$_37bc[129],11:_$_37bc[130],12:_$_37bc[131],13:_$_37bc[132],14:_$_37bc[133],15:_$_37bc[134],16:_$_37bc[135],17:_$_37bc[136],18:_$_37bc[137],19:_$_37bc[138],20:_$_37bc[139],21:_$_37bc[140],22:_$_37bc[141],37:_$_37bc[142],38:_$_37bc[143],39:_$_37bc[144],40:_$_37bc[145],45:_$_37bc[146],46:_$_37bc[147],47:_$_37bc[148],48:_$_37bc[149],49:_$_37bc[150],56:_$_37bc[3], | ||
| 65535:_$_37bc[123]},O,I={},S={thin:[_$_37bc[151],_$_37bc[152]],medium:[_$_37bc[151],_$_37bc[153]],thick:[_$_37bc[151],_$_37bc[154]],dotted:[_$_37bc[155],_$_37bc[152]],dashed:[_$_37bc[156],_$_37bc[152]],double:[_$_37bc[157],_$_37bc[152]],mediumDashed:[_$_37bc[156],_$_37bc[153]]},ha=function(a,d,e){var h=_$_37bc[3];var f=parseInt(d.getAttribute(_$_37bc[158]));if(!isNaN(f)&&(f=v.querySelector(_$_37bc[159]).children[f],f.firstChild.getAttribute(_$_37bc[160])===_$_37bc[151])){f=f.firstChild.firstChild; | ||
| var b=f.getAttribute(_$_37bc[64]);if(y&&y[b])h+=_$_37bc[161]+y[b].substr(2)+_$_37bc[58];else if(b=f.getAttribute(_$_37bc[23]))f=f.getAttribute(_$_37bc[66]),h+=_$_37bc[161]+J(A.color[b],parseFloat(f))+_$_37bc[58];else if(b=f.getAttribute(_$_37bc[67]))h+=_$_37bc[161]+b.substr(2)+_$_37bc[58]}f=parseInt(d.getAttribute(_$_37bc[162]));if(!isNaN(f)){f=v.querySelector(_$_37bc[163]).children[f];var c=f.querySelector(_$_37bc[52]);c&&(c=parseFloat(c.getAttribute(_$_37bc[53])),h+=_$_37bc[54]+Math.round(4*c/3)+ | ||
| _$_37bc[55]);f.querySelector(_$_37bc[59])&&(h+=_$_37bc[60]);f.querySelector(_$_37bc[61])&&(h+=_$_37bc[62]);(c=f.querySelector(_$_37bc[42]))&&(h+=_$_37bc[57]+c.getAttribute(_$_37bc[53])+_$_37bc[58]);var k=f.querySelector(_$_37bc[63]);k&&(b=k.getAttribute(_$_37bc[64]),y&&y[b]?h+=_$_37bc[65]+y[b].substr(2)+_$_37bc[58]:(b=k.getAttribute(_$_37bc[23]))?(k=k.getAttribute(_$_37bc[66]),h+=_$_37bc[65]+J(A.color[b],parseFloat(k))+_$_37bc[58]):(b=k.getAttribute(_$_37bc[67]))&&b&&(h+=_$_37bc[65]+b.substr(2)+_$_37bc[58]))}if(f= | ||
| d.querySelector(_$_37bc[164])){(c=f.getAttribute(_$_37bc[165]))&&(h+=_$_37bc[166]+c+_$_37bc[58]);if(c=f.getAttribute(_$_37bc[167]))c===_$_37bc[168]&&(c=_$_37bc[169]),h+=_$_37bc[170]+c+_$_37bc[58];f.getAttribute(_$_37bc[171])&&(h+=_$_37bc[172]);if(f=f.getAttribute(_$_37bc[173]))m.worksheets[e].cells||(m.worksheets[e].cells={}),m.worksheets[e].cells[a]||(m.worksheets[e].cells[a]={}),f=parseInt(f),90<f&&(f=90-f),m.worksheets[e].cells[a].rotate=f}f=parseInt(d.getAttribute(_$_37bc[174]));if(!isNaN(f))for(f= | ||
| v.querySelector(_$_37bc[175]).children[f],c=0;c<f.children.length;c++){var n=f.children[c].tagName;if(n===_$_37bc[176]){if(b=l.helpers.getCoordsFromColumnName(a),0!==b[1]&&(b=l.helpers.getColumnNameFromCoords(b[0],b[1]-1),(b=m.worksheets[e].style[b])&&b.includes(_$_37bc[177])))continue}else if(n===_$_37bc[40]&&(b=l.helpers.getCoordsFromColumnName(a),0!==b[0]&&(b=l.helpers.getColumnNameFromCoords(b[0]-1,b[1]),(b=m.worksheets[e].style[b])&&b.includes(_$_37bc[178]))))continue;if(n!==_$_37bc[179]&&(b= | ||
| f.children[c].getAttribute(_$_37bc[180]))&&((b=S[b])||(b=[_$_37bc[151],_$_37bc[152]]),h+=_$_37bc[181]+n+_$_37bc[182]+b[0]+_$_37bc[58],h+=_$_37bc[181]+n+_$_37bc[183]+b[1]+_$_37bc[58],k=f.children[c].firstChild))if(b=k.getAttribute(_$_37bc[64]))(b=y[b%y.length])||(b=q),h+=_$_37bc[181]+n+_$_37bc[184]+b.substr(2)+_$_37bc[58];else if(b=k.getAttribute(_$_37bc[23]))k=k.getAttribute(_$_37bc[66]),h+=_$_37bc[181]+n+_$_37bc[184]+J(A.color[b],parseFloat(k))+_$_37bc[58];else if(b=k.getAttribute(_$_37bc[67]))6< | ||
| b.length&&(b=b.substr(2)),h+=_$_37bc[181]+n+_$_37bc[184]+b+_$_37bc[58]}h&&(m.worksheets[e].style[a]||(m.worksheets[e].style[a]=_$_37bc[3]),m.worksheets[e].style[a]=h);(f=d.getAttribute(_$_37bc[185]))&&(h=d.querySelector(_$_37bc[186]))&&h.getAttribute(_$_37bc[187])==_$_37bc[124]&&(m.worksheets[e].cells||(m.worksheets[e].cells={}),m.worksheets[e].cells[a]||(m.worksheets[e].cells[a]={}),m.worksheets[e].cells[a].locked=!1);h=parseInt(d.getAttribute(_$_37bc[188]));f=d.getAttribute(_$_37bc[189]);if(f!= | ||
| _$_37bc[124]&&0<h){if(I[h])d=I[h];else if(d=v.querySelector(_$_37bc[190]).querySelector(_$_37bc[191]+h+_$_37bc[192]))d=d.getAttribute(_$_37bc[193]),P(h,d);d&&(d=d.replace(new RegExp(_$_37bc[194],_$_37bc[195]),_$_37bc[3]),d=d.replace(new RegExp(_$_37bc[196],_$_37bc[195]),_$_37bc[3]),d!=_$_37bc[123]&&(m.worksheets[e].cells||(m.worksheets[e].cells={}),m.worksheets[e].cells[a]||(m.worksheets[e].cells[a]={}),m.worksheets[e].cells[a].type||(h=_$_37bc[197],jSuites.mask&&typeof jSuites.mask.getType==_$_37bc[198]&& | ||
| (h=d.split(_$_37bc[58]),h=jSuites.mask.getType(h[0])),m.worksheets[e].cells[a].type=h===_$_37bc[199]||h===_$_37bc[200]||h===_$_37bc[201]||h===_$_37bc[202]?_$_37bc[199]:_$_37bc[197]),m.worksheets[e].cells[a].format=d))}},T=[_$_37bc[203],_$_37bc[204]],M=function(a){for(var d=0;d<T.length;d++)a=a.replace(new RegExp(T[d],_$_37bc[205]),_$_37bc[3]);return a},ia={whole:_$_37bc[199],decimal:_$_37bc[199],list:_$_37bc[206],textLength:_$_37bc[207],date:_$_37bc[208]},ja={notBetween:_$_37bc[209],equal:_$_37bc[210], | ||
| notEqual:_$_37bc[211],greaterThan:_$_37bc[212],lessThan:_$_37bc[213],greaterThanOrEqual:_$_37bc[214],lessThanOrEqual:_$_37bc[215]},U=function(a,d,e){Array.isArray(m.validations)||(m.validations=[]);d&&d.split(_$_37bc[220]).forEach(function(h){m.validations.push(Object.assign({range:m.worksheets[a].worksheetName+_$_37bc[221]+h},e))})},Z=Date.UTC(1900,0,0),aa=Date.UTC(1900,1,29),ka=function(a,d,e){m.worksheets[a].columns||(m.worksheets[a].columns=[]);d.forEach(function(h){m.worksheets[a].columns[h]|| | ||
| (m.worksheets[a].columns[h]={});Object.assign(m.worksheets[a].columns[h],e)})},la=function(a,d,e){m.worksheets[a].cells||(m.worksheets[a].cells={});d.forEach(function(h){m.worksheets[a].cells[h]||(m.worksheets[a].cells[h]={});Object.assign(m.worksheets[a].cells[h],e)})},da=function(a){for(var d=G(_$_37bc[27]),e=0;e<d.length;e++){var h=C(a[D.indexOf(d[e])]).querySelectorAll(_$_37bc[224]);Array.from(h).forEach(function(f){var b={},c=f.getAttribute(_$_37bc[17]);b.type=ia[c];if(b.type){b.allowBlank=!!f.getAttribute(_$_37bc[225]); | ||
| b.criteria;b.type!==_$_37bc[206]&&(c=f.getAttribute(_$_37bc[226]),b.criteria=ja[c]||_$_37bc[216]);var k=f.querySelector(_$_37bc[227]);b.value=[];if(b.type===_$_37bc[206]){c=f.getAttribute(_$_37bc[228]);if(k.innerHTML.startsWith(_$_37bc[196])&&k.innerHTML.endsWith(_$_37bc[196]))k=k.innerHTML.slice(1,-1),b.value.push(k.split(_$_37bc[5]));else{if(c)return;b.value.push(k.innerHTML)}if(!c){a:{c=e;k=f.getAttribute(_$_37bc[229]);var n=k.split(_$_37bc[222]);f={type:_$_37bc[223]};Array.isArray(b.value[0])? | ||
| f.source=b.value[0]:f.dynamicSource=b.value[0];if(2===n.length&&(b=l.helpers.getCoordsFromColumnName(n[1]),1048575===b[1]&&(n=l.helpers.getCoordsFromColumnName(n[0]),0===n[1]))){k=[];for(n=n[0];n<=b[0];n++)k.push(n);ka(c,k,f);break a}la(c,l.helpers.getTokensFromRange(k),f)}return}}else b.type===_$_37bc[208]?(c=g(k.innerHTML),k=c.getTimezoneOffset(),c.setMinutes(c.getMinutes()+k),c=jSuites.calendar.getDateString(c,_$_37bc[230]),b.value.push(c)):b.value.push(parseFloat(k.innerHTML));if(c=f.querySelector(_$_37bc[231]))b.type=== | ||
| _$_37bc[208]?(c=g(c.innerHTML),k=c.getTimezoneOffset(),c.setMinutes(c.getMinutes()+k),c=jSuites.calendar.getDateString(c,_$_37bc[230]),b.value.push(c)):b.value.push(parseFloat(c.innerHTML));c=f.getAttribute(_$_37bc[232]);b.action=c===_$_37bc[217]?_$_37bc[218]:_$_37bc[219];b.text=f.getAttribute(_$_37bc[233]);b.text||(b.text=f.getAttribute(_$_37bc[234]));b.text||delete b.text;U(e,f.getAttribute(_$_37bc[229]),b)}})}},ma=[_$_37bc[235],_$_37bc[236]].concat([_$_37bc[237],_$_37bc[238],_$_37bc[239],_$_37bc[240], | ||
| _$_37bc[241]]),V={equal:_$_37bc[210],notEqual:_$_37bc[211],greaterThan:_$_37bc[212],lessThan:_$_37bc[213],greaterThanOrEqual:_$_37bc[214],lessThanOrEqual:_$_37bc[215],between:_$_37bc[216],notBetween:_$_37bc[209]},W={containsText:_$_37bc[242],notContains:_$_37bc[243],beginsWith:_$_37bc[244],endsWith:_$_37bc[245]},na=[_$_37bc[40],_$_37bc[246],_$_37bc[176],_$_37bc[247]],oa=function(a){var d={};a=a.getAttribute(_$_37bc[248]);var e=v.querySelector(_$_37bc[249]+(parseInt(a)+1)+_$_37bc[250]);(a=e.querySelector(_$_37bc[251]))&& | ||
| a.getAttribute(_$_37bc[67])&&(d[_$_37bc[252]]=_$_37bc[253]+a.getAttribute(_$_37bc[67]).slice(2));(a=e.querySelector(_$_37bc[254]))&&a.getAttribute(_$_37bc[67])&&(d[_$_37bc[63]]=_$_37bc[253]+a.getAttribute(_$_37bc[67]).slice(2));var h=e.querySelector(_$_37bc[255]);h&&na.forEach(function(f){var b=h.querySelector(f);if(b){b=S[b.getAttribute(_$_37bc[180])];var c=e.querySelector(_$_37bc[63]);c=_$_37bc[253]+c.getAttribute(_$_37bc[67]).slice(2);d[_$_37bc[181]+f]=b[1]+_$_37bc[220]+b[0]+_$_37bc[220]+c}}); | ||
| return d},ea=function(a){for(var d=G(_$_37bc[27]),e=0;e<d.length;e++){var h=C(a[D.indexOf(d[e])]).querySelectorAll(_$_37bc[256]);Array.from(h).forEach(function(f){var b=f.querySelector(_$_37bc[257]);if(b){var c=b.getAttribute(_$_37bc[17]);if(c&&ma.includes(c)){var k={action:_$_37bc[258],format:oa(b)};c===_$_37bc[235]?k.type=_$_37bc[259]:c===_$_37bc[236]?k.type=_$_37bc[260]:(c=b.getAttribute(_$_37bc[226]),V[c]?(k.type=_$_37bc[199],k.criteria=V[c],b=b.querySelectorAll(_$_37bc[261]),k.value=Array.from(b).map(function(n){return n.innerHTML})): | ||
| W[c]&&(k.type=_$_37bc[197],k.criteria=W[c],b=b.getAttribute(_$_37bc[197]),k.value=[b]));f=f.getAttribute(_$_37bc[229]);U(e,f,k)}}})}},pa=function(a){var d=[0,0],e=a.querySelector(_$_37bc[262]);e&&(d=e.getAttribute(_$_37bc[263]),d=-1!==d.indexOf(_$_37bc[222])?d.split(_$_37bc[222])[1]:d,d=l.helpers.getCoordsFromColumnName(d));var h=[0,0];a=a.querySelectorAll(_$_37bc[264]);a=Array.from(a).map(function(f){return l.helpers.getCoordsFromColumnName(f.getAttribute(_$_37bc[265]))});h=[0,0];a.forEach(function(f){f[0]> | ||
| h[0]&&(h[0]=f[0]);f[1]>h[1]&&(h[1]=f[1])});a=[Math.max(d[0],h[0]),Math.max(d[1],h[1])];a[0]++;a[1]++;return a},ca=function(a){for(var d=G(_$_37bc[27]),e=0;e<d.length;e++){var h=[],f=[],b=C(a[D.indexOf(d[e])]),c=pa(b);m.worksheets[e].minDimensions=c;for(var k=0;k<c[1];k++){h[k]=[];for(var n=0;n<c[0];n++)h[k][n]=_$_37bc[3]}if(10<c[0]||100<c[1])300<c[1]&&(m.worksheets[e].lazyLoading=!0),m.worksheets[e].tableOverflow=!0,m.worksheets[e].tableHeight=_$_37bc[266],m.worksheets[e].resize=_$_37bc[267],10<c[0]&& | ||
| (m.worksheets[e].tableWidth=_$_37bc[268]);10>c[0]&&(c[0]=10);10>c[1]&&(c[1]=10);if(k=b.querySelector(_$_37bc[269]))for(m.worksheets[e].columns=[],n=0;n<k.children.length;n++){for(var p=parseInt(k.children[n].getAttribute(_$_37bc[270])),r=parseInt(k.children[n].getAttribute(_$_37bc[271])),u=Math.round(7.15*parseInt(k.children[n].getAttribute(_$_37bc[272])))+_$_37bc[273],B=parseInt(k.children[n].getAttribute(_$_37bc[44]));p-1!==m.worksheets[e].columns.length;)m.worksheets[e].columns.push({type:_$_37bc[197]}); | ||
| for(;p<=r&&p<=c[0];p++){var w={width:u};1===B&&(w.type=_$_37bc[44]);m.worksheets[e].columns.push(w)}}if(k=b.querySelector(_$_37bc[274]))for(m.worksheets[e].mergeCells={},n=0;n<k.children.length;n++)c=k.children[n].getAttribute(_$_37bc[263]).split(_$_37bc[222]),r=l.helpers.getCoordsFromColumnName(c[0]),u=l.helpers.getCoordsFromColumnName(c[1]),m.worksheets[e].mergeCells[c[0]]=[u[0]-r[0]+1,u[1]-r[1]+1];c=v.querySelector(_$_37bc[275]);r=b.querySelector(_$_37bc[276]);u=[];for(k=0;k<r.children.length;k++){B= | ||
| r.children[k];n=B.getAttribute(_$_37bc[265])-1;p=B.getAttribute(_$_37bc[277]);w=B.getAttribute(_$_37bc[44]);if(p||w)m.worksheets[e].rows||(m.worksheets[e].rows={}),m.worksheets[e].rows[n]||(m.worksheets[e].rows[n]={}),p&&(m.worksheets[e].rows[n].height=Math.ceil(1.333333333*parseFloat(p))),w===_$_37bc[278]&&(m.worksheets[e].rows[n].visible=!1);for(n=0;n<B.children.length;n++){var z=B.children[n];p=z.getAttribute(_$_37bc[265]);w=z.getAttribute(_$_37bc[47]);var x=z.getAttribute(_$_37bc[279]);0<x&&ha(p, | ||
| c.children[x],e);x=z.getAttribute(_$_37bc[265]);p=l.helpers.getCoordsFromColumnName(x);p=[parseInt(p[0]),parseInt(p[1])];if(!u.includes(x))if(w===_$_37bc[279])h[p[1]][p[0]]=t[z.firstChild.innerHTML];else if(w===_$_37bc[280])w=z.querySelector(_$_37bc[281]),h[p[1]][p[0]]=w.innerHTML;else if(w=z.getElementsByTagName(_$_37bc[282])[0],z=z.getElementsByTagName(_$_37bc[283])[0],w)if(x=null,z=w.getAttribute(_$_37bc[263]),x=w.getAttribute(_$_37bc[47]),x==_$_37bc[284])f[p[1]]||(f[p[1]]=[]),x=_$_37bc[210]+M(w.firstChild.nodeValue), | ||
| h[p[1]][p[0]]=x,f[p[1]][p[0]]=x,p=-1!==z.indexOf(_$_37bc[222])?l.helpers.getTokensFromRange(z):[z],u=u.concat(p);else if(x==_$_37bc[285]){if(z){x=z.split(_$_37bc[222]);x=[l.helpers.getCoordsFromColumnName(x[0]),l.helpers.getCoordsFromColumnName(x[1])];z=[parseInt(x[0][0]),parseInt(x[0][1])];x=[parseInt(x[1][0]),parseInt(x[1][1])];for(var H=z[1];H<=x[1];H++){f[H]||(f[H]=[]);for(var K=z[0];K<=x[0];K++)f[H][K]=_$_37bc[210]+l.helpers.shiftFormula(M(w.innerHTML),K-z[0],H-z[1])}}f[p[1]]&&f[p[1]][p[0]]&& | ||
| (h[p[1]][p[0]]=f[p[1]][p[0]])}else x!==_$_37bc[285]&&(h[p[1]][p[0]]=_$_37bc[210]+M(w.firstChild.nodeValue));else z&&(x=z.innerHTML,Number(x)==x&&(x=Number(x)),h[p[1]][p[0]]=x)}}f=d[e].name;var qa=f.slice(0,13)+_$_37bc[286]+f.slice(13)+_$_37bc[287];f=D.findIndex(function(ra){return ra.name===qa});if(-1<f){f=C(a[f]);if(k=b.querySelector(_$_37bc[288]))for(n=0;n<k.children.length;n++)if(c=k.children[n].getAttribute(_$_37bc[289]))c=f.querySelector(_$_37bc[290]+c+_$_37bc[291]),c=c.getAttribute(_$_37bc[292]), | ||
| r=k.children[n].getAttribute(_$_37bc[263]),m.worksheets[e].cells[r]?(m.worksheets[e].cells[r].type=_$_37bc[293],m.worksheets[e].cells[r].options={url:c}):m.worksheets[e].cells[r]={type:_$_37bc[293],options:{url:c}};k=b.querySelectorAll(_$_37bc[29]);for(n=0;n<k.length;n++)if(c=k[n].getAttribute(_$_37bc[289]),c=f.querySelector(_$_37bc[290]+c+_$_37bc[291]),r=c.getAttribute(_$_37bc[292]),r=_$_37bc[294]+r.slice(3),c=F(r,_$_37bc[42]),c=C(a[c]),u=c.querySelector(_$_37bc[295]))u=u.getAttribute(_$_37bc[296]), | ||
| r=r.slice(0,12)+_$_37bc[297]+r.slice(12)+_$_37bc[287],r=F(r,_$_37bc[42]),r=C(a[r]).querySelector(_$_37bc[298]+u+_$_37bc[192]).getAttribute(_$_37bc[292]),r=_$_37bc[294]+r.slice(3),r=F(r,_$_37bc[42]),m.worksheets[e].media||(m.worksheets[e].media=[]),p=c.querySelector(_$_37bc[299]),u=c.querySelector(_$_37bc[300]),c=c.querySelector(_$_37bc[301]),c=[c.querySelector(_$_37bc[302]),c.querySelector(_$_37bc[303])],c=[parseInt(c[0].innerHTML),parseInt(c[1].innerHTML)],B=l.helpers.getColumnNameFromCoords(c[0], | ||
| c[1]),h[c[1]]||(h[c[1]]=[]),p=parseInt(u.getAttribute(_$_37bc[304]))/9525,u=parseInt(u.getAttribute(_$_37bc[305]))/9525,h[c[1]][c[0]]=_$_37bc[306]+a[r],m.worksheets[e].cells[B]={type:_$_37bc[35],options:{absolute:!0,width:p,height:u}}}m.worksheets[e].data=h;if(h=b.querySelector(_$_37bc[307]))b=h.getAttribute(_$_37bc[308]),b==_$_37bc[278]&&(m.worksheets[e].locked=!0,b=h.getAttribute(_$_37bc[309]),b!=_$_37bc[124]&&(m.worksheets[e].columnSorting=!1),b=h.getAttribute(_$_37bc[310]),b!=_$_37bc[124]&&(m.worksheets[e].allowInsertRow= | ||
| !1),b=h.getAttribute(_$_37bc[311]),b!=_$_37bc[124]&&(m.worksheets[e].allowDeleteRow=!1),b=h.getAttribute(_$_37bc[312]),b!=_$_37bc[124]&&(m.worksheets[e].allowInsertColumn=!1),b=h.getAttribute(_$_37bc[313]),b!=_$_37bc[124]&&(m.worksheets[e].allowDeleteColumn=!1),b=h.getAttribute(_$_37bc[314]),b==_$_37bc[278]&&(m.worksheets[e].selectUnLockedCells=!1),b=h.getAttribute(_$_37bc[315]),b==_$_37bc[278]&&(m.worksheets[e].selectLockedCells=!1),m.worksheets[e].columnDrag=!1,m.worksheets[e].rowDrag=!1);for(k= | ||
| 0;k<m.worksheets[e].data.length;k++)for(m.worksheets[e].data[k]||(m.worksheets[e].data[k]=[]),n=0;n<m.worksheets[e].columns.length;n++)if(null===m.worksheets[e].data[k][n]||void 0===m.worksheets[e].data[k][n])m.worksheets[e].data[k][n]=_$_37bc[3];m.worksheets[e].minDimensions[0]<n&&(m.worksheets[e].minDimensions[0]=n);m.worksheets[e].minDimensions[1]<k&&(m.worksheets[e].minDimensions[1]=k)}},fa=function(a){for(var d=G(_$_37bc[33]),e=0;e<d.length;e++){var h=C(a[D.indexOf(d[e])]).querySelector(_$_37bc[319]); | ||
| if(h){var f=d[e].name.replace(_$_37bc[286],_$_37bc[3]);f=f.replace(_$_37bc[287],_$_37bc[3]);var b=G(_$_37bc[27]).findIndex(function(r){return r.name===f}),c=h.getAttribute(_$_37bc[292]).slice(3);c=_$_37bc[294]+c;h=D.findIndex(function(r){return r.name===c});h=C(a[h]);var k=h.querySelector(_$_37bc[320]).children,n=Array.from(k).map(function(r){return r.children[0].children[0].querySelector(_$_37bc[47]).innerHTML}),p=h.querySelector(_$_37bc[321]).children;p=Array.from(p).map(function(r){return r.innerHTML}); | ||
| m.worksheets[b].allowComments=!0;m.worksheets[b].comments={};n.forEach(function(r,u){var B=k[u].getAttribute(_$_37bc[263]);u=k[u].getAttribute(_$_37bc[322]);m.worksheets[b].comments[B]=p[u]+_$_37bc[323]+r})}}},J=function(a,d){if(!d)return a;d=parseFloat(d);a=a.slice(a[0]===_$_37bc[253]?1:0).slice(0,6);var e=[parseInt(a.slice(0,2),16),parseInt(a.slice(2,4),16),parseInt(a.slice(4,6),16)];a=e[0]/255;var h=e[1]/255;e=e[2]/255;var f=Math.max(a,h,e),b=Math.min(a,h,e),c=f-b;if(0===c)a=[0,0,a];else{var k= | ||
| 0;b=f+b;switch(f){case a:k=((h-e)/c+6)%6;break;case h:k=(e-a)/c+2;break;case e:k=(a-h)/c+4}a=[k/6,c/(1<b?2-b:b),b/2]}a[2]=0>d?a[2]*(1+d):1-(1-a[2])*(1-d);h=a[1];d=a[2];e=2*h*(.5>d?d:1-d);d-=e/2;d=[d,d,d];a=6*a[0];if(0!==h)switch(a|0){case 0:case 6:d[0]+=e;d[1]+=e*a;break;case 1:d[0]+=e*(2-a);d[1]+=e;break;case 2:d[1]+=e;d[2]+=e*(a-2);break;case 3:d[1]+=e*(4-a);d[2]+=e;break;case 4:d[2]+=e;d[0]+=e*(a-4);break;case 5:d[2]+=e*(6-a),d[0]+=e}for(a=0;3!=a;++a)d[a]=Math.round(255*d[a]);a=0;for(h=1;3!=a;++a)h= | ||
| 256*h+(255<d[a]?255:0>d[a]?0:d[a]);return h.toString(16).toUpperCase().slice(1)},X=0,Y=function(a){null===l&&(l=this);v=t=null;y=[];A={color:[]};m={worksheets:[]};D=[];L=[];var d=N.label();if(d){X++;if(5<X)return alert(d),!1;console.log(d)}var e=new JSZip;a.url?jSuites.ajax({url:a.url,method:_$_55df[324],dataType:_$_55df[325],success:function(h){e.loadAsync(h).then(function(f){return $jscomp.asyncExecutePromiseGeneratorFunction(function*(){yield R(f,a)})}).catch(function(f){console.error(f);jSuites.loading.hide(); | ||
| if(typeof a.onerror==_$_55df[198])a.onerror(f)})}}):a.file&&e.loadAsync(a.file).then(function(h){return $jscomp.asyncExecutePromiseGeneratorFunction(function*(){yield R(h,a)})}).catch(function(h){console.error(h);jSuites.loading.hide();if(typeof a.onerror==_$_55df[198])a.onerror(h)})};Y.license=function(a){N(a)};return Y}); | ||
| 256*h+(255<d[a]?255:0>d[a]?0:d[a]);return h.toString(16).toUpperCase().slice(1)},X=0,Y=function(a){null===l&&(l=this);v=t=null;y=[];A={color:[]};m={worksheets:[]};D=[];L=[];var d=N.label();if(d){X++;if(5<X)return alert(d),!1;console.log(d)}var e=new JSZip;a.url?jSuites.ajax({url:a.url,method:_$_37bc[324],dataType:_$_37bc[325],success:function(h){e.loadAsync(h).then(function(f){return $jscomp.asyncExecutePromiseGeneratorFunction(function*(){yield R(f,a)})}).catch(function(f){console.error(f);jSuites.loading.hide(); | ||
| if(typeof a.onerror==_$_37bc[198])a.onerror(f)})}}):a.file&&e.loadAsync(a.file).then(function(h){return $jscomp.asyncExecutePromiseGeneratorFunction(function*(){yield R(h,a)})}).catch(function(h){console.error(h);jSuites.loading.hide();if(typeof a.onerror==_$_37bc[198])a.onerror(h)})};Y.license=function(a){N(a)};return Y}); |
@@ -8,9 +8,9 @@ # JSS Extensions | ||
| The javascript spreadsheet: | ||
| https://jspreasheet.com/ | ||
| LemonadeJS: | ||
| LemonadeJS - Reactive two-way data binding micro library. | ||
| https://lemonadejs.net | ||
| jSuites: | ||
| https://jsuites.net | ||
| jSuites - JS Library collection | ||
| https://jsuites.net | ||
| Jspreadsheet Pro | ||
| https://jspreadsheet.com/ |
@@ -30,7 +30,7 @@ { | ||
| "jszip": "^3.7.1", | ||
| "jsuites": "^4.16.1" | ||
| "jsuites": "^4.16.8" | ||
| }, | ||
| "main": "dist/index.js", | ||
| "types": "dist/index.d.ts", | ||
| "version": "2.5.1", | ||
| "version": "2.5.2", | ||
| "bugs": "https://github.com/jspreadsheet/pro/issues", | ||
@@ -37,0 +37,0 @@ "homepage": "https://github.com/jspreadsheet/pro", |
New alerts
License Policy Violation
LicenseThis package is not allowed per your license policy. Review the package's license to ensure compliance.
Found 1 instance in 1 package
Major refactor
Supply chain riskPackage has recently undergone a major refactor. It may be unstable or indicate significant internal changes. Use caution when updating to versions that include significant changes.
Found 1 instance in 1 package
Fixed alerts
License Policy Violation
LicenseThis package is not allowed per your license policy. Review the package's license to ensure compliance.
Found 1 instance in 1 package
Major refactor
Supply chain riskPackage has recently undergone a major refactor. It may be unstable or indicate significant internal changes. Use caution when updating to versions that include significant changes.
Found 1 instance in 1 package
Improved metrics
- Total package byte prevSize
- increased by0.19%
39747
Worsened metrics
- Lines of code
- decreased by-0.52%
192
Dependency changes
Updatedjsuites@^4.16.8