@jspreadsheet/parser
Advanced tools
Comparing version 2.7.1 to 2.7.2
/** | ||
* Jspreadsheet XLSX parser 2.7.1 | ||
* Jspreadsheet XLSX parser 2.7.2 | ||
* https://JSS.com/v8/plugins/parser | ||
@@ -19,3 +19,3 @@ * @License: this plugin requires a license | ||
$jscomp.polyfillUnisolated=function(g,k,q,r){q=$jscomp.global;g=g.split(".");for(r=0;r<g.length-1;r++){var t=g[r];if(!(t in q))return;q=q[t]}g=g[g.length-1];r=q[g];k=k(r);k!=r&&null!=k&&$jscomp.defineProperty(q,g,{configurable:!0,writable:!0,value:k})}; | ||
$jscomp.polyfillIsolated=function(g,k,q,r){var t=g.split(".");g=1===t.length;r=t[0];r=!g&&r in $jscomp.polyfills?$jscomp.polyfills:$jscomp.global;for(var y=0;y<t.length-1;y++){var A=t[y];if(!(A in r))return;r=r[A]}t=t[t.length-1];q=$jscomp.IS_SYMBOL_NATIVE&&"es6"===q?r[t]:null;k=k(q);null!=k&&(g?$jscomp.defineProperty($jscomp.polyfills,t,{configurable:!0,writable:!0,value:k}):k!==q&&(void 0===$jscomp.propertyToPolyfillSymbol[t]&&(q=1E9*Math.random()>>>0,$jscomp.propertyToPolyfillSymbol[t]=$jscomp.IS_SYMBOL_NATIVE? | ||
$jscomp.polyfillIsolated=function(g,k,q,r){var t=g.split(".");g=1===t.length;r=t[0];r=!g&&r in $jscomp.polyfills?$jscomp.polyfills:$jscomp.global;for(var w=0;w<t.length-1;w++){var A=t[w];if(!(A in r))return;r=r[A]}t=t[t.length-1];q=$jscomp.IS_SYMBOL_NATIVE&&"es6"===q?r[t]:null;k=k(q);null!=k&&(g?$jscomp.defineProperty($jscomp.polyfills,t,{configurable:!0,writable:!0,value:k}):k!==q&&(void 0===$jscomp.propertyToPolyfillSymbol[t]&&(q=1E9*Math.random()>>>0,$jscomp.propertyToPolyfillSymbol[t]=$jscomp.IS_SYMBOL_NATIVE? | ||
$jscomp.global.Symbol(t):$jscomp.POLYFILL_PREFIX+q+"$"+t),$jscomp.defineProperty(r,$jscomp.propertyToPolyfillSymbol[t],{configurable:!0,writable:!0,value:k})))};$jscomp.underscoreProtoCanBeSet=function(){var g={a:!0},k={};try{return k.__proto__=g,k.a}catch(q){}return!1}; | ||
@@ -34,55 +34,55 @@ $jscomp.setPrototypeOf=$jscomp.TRUST_ES6_POLYFILLS&&"function"==typeof Object.setPrototypeOf?Object.setPrototypeOf:$jscomp.underscoreProtoCanBeSet()?function(g,k){g.__proto__=k;if(g.__proto__!==k)throw new TypeError(g+" is not extensible");return g}:null;$jscomp.arrayIteratorImpl=function(g){var k=0;return function(){return k<g.length?{done:!1,value:g[k++]}:{done:!0}}};$jscomp.arrayIterator=function(g){return{next:$jscomp.arrayIteratorImpl(g)}}; | ||
$jscomp.generator.Engine_.prototype.throw_=function(g){this.context_.start_();if(this.context_.yieldAllIterator_)return this.yieldAllStep_(this.context_.yieldAllIterator_["throw"],g,this.context_.next_);this.context_.throw_(g);return this.nextStep_()}; | ||
$jscomp.generator.Engine_.prototype.yieldAllStep_=function(g,k,q){try{var r=g.call(this.context_.yieldAllIterator_,k);$jscomp.generator.ensureIteratorResultIsObject_(r);if(!r.done)return this.context_.stop_(),r;var t=r.value}catch(y){return this.context_.yieldAllIterator_=null,this.context_.throw_(y),this.nextStep_()}this.context_.yieldAllIterator_=null;q.call(this.context_,t);return this.nextStep_()}; | ||
$jscomp.generator.Engine_.prototype.yieldAllStep_=function(g,k,q){try{var r=g.call(this.context_.yieldAllIterator_,k);$jscomp.generator.ensureIteratorResultIsObject_(r);if(!r.done)return this.context_.stop_(),r;var t=r.value}catch(w){return this.context_.yieldAllIterator_=null,this.context_.throw_(w),this.nextStep_()}this.context_.yieldAllIterator_=null;q.call(this.context_,t);return this.nextStep_()}; | ||
$jscomp.generator.Engine_.prototype.nextStep_=function(){for(;this.context_.nextAddress;)try{var g=this.program_(this.context_);if(g)return this.context_.stop_(),{value:g.value,done:!1}}catch(k){this.context_.yieldResult=void 0,this.context_.throw_(k)}this.context_.stop_();if(this.context_.abruptCompletion_){g=this.context_.abruptCompletion_;this.context_.abruptCompletion_=null;if(g.isException)throw g.exception;return{value:g.return,done:!0}}return{value:void 0,done:!0}}; | ||
$jscomp.generator.Generator_=function(g){this.next=function(k){return g.next_(k)};this.throw=function(k){return g.throw_(k)};this.return=function(k){return g.return_(k)};this[Symbol.iterator]=function(){return this}};$jscomp.generator.createGenerator=function(g,k){k=new $jscomp.generator.Generator_(new $jscomp.generator.Engine_(k));$jscomp.setPrototypeOf&&g.prototype&&$jscomp.setPrototypeOf(k,g.prototype);return k}; | ||
$jscomp.asyncExecutePromiseGenerator=function(g){function k(r){return g.next(r)}function q(r){return g.throw(r)}return new Promise(function(r,t){function y(A){A.done?r(A.value):Promise.resolve(A.value).then(k,q).then(y,t)}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(k,q){var r=this;r instanceof String&&(r=String(r));var t=r.length;q=q||0;for(0>q&&(q=Math.max(q+t,0));q<t;q++){var y=r[q];if(y===k||Object.is(y,k))return!0}return!1}},"es7","es3");var _$_b078='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{worksheet{xl/workbook.xml{workbook{xl/styles.xml{styles{xl/theme/theme1.xml{theme{xl/sharedStrings.xml{sharedStrings{xl/worksheets/sheet{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{veryHidden{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{empty{notEmpty{formula{dimension{ref{row[r]{r{row c[r]{A{800px{both{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/{drawings{blip{r:embed{_rels/{Relationship[Id="{media{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,k){typeof exports===_$_b078[330]&&typeof module!==_$_b078[4]?module.exports=k():typeof define===_$_b078[199]&&define.amd?define(k):g.parser=k()})(this,function(){function g(a){a=Z+864E5*a;a>=aa&&(a-=864E5);return new Date(a)}_$_b078[0];var k=null,q=_$_b078[2],r=null,t=null,y=[],A={},m={},E=[],L=[],N=function(){var a=function(b){a.license=b;a.run()};a.k=[74,50,48,50,48,33].join(_$_b078[3]);a.apply=function(b,f){var e=jSuites.sha512,d=_$_b078[3],c=_$_b078[3];128<b.length&&(b=e(b));for(var h= | ||
0;128>h;h++){var l=b[h]?b[h].charCodeAt(0):0;d+=String.fromCharCode(54^l);c+=String.fromCharCode(92^l)}return e(c+e(d+f))};a.run=function(){if(typeof a.result==_$_b078[4]){a.result=1;try{if(a.license){var b=window.atob(a.license);b=b.split(_$_b078[5]);if(b[1])if(b[1]=window.atob(b[1]),b[0]!=a.apply(a.k,b[1]))a.result=3;else if(b[1]=JSON.parse(b[1]),b[1].date){var f=window.location.hostname||_$_b078[6],e=f.split(_$_b078[7]);f=f.split(_$_b078[7]);2<f.length&&!jSuites.isNumeric(f[f.length-1])&&e.shift(); | ||
e=e.join(_$_b078[7]);f=f.join(_$_b078[7]);-1==b[1].domain.indexOf(e)&&-1==b[1].domain.indexOf(f)?a.result=4:b[1].scope&&0<=b[1].scope.indexOf(_$_b078[8])?(a.result=6,a.name=b[1].name):a.result=5}else a.result=4;else a.result=2}}catch(d){}}return a.result};a.label=function(){var b=_$_b078[3];a.result&&1!=a.result?2==a.result||3==a.result||4==a.result?b=_$_b078[10]:5==a.result&&(b=_$_b078[11]):b=_$_b078[9];return b};a.status=function(){return a.result};return a}(),C=function(a){a=(new DOMParser).parseFromString(a, | ||
_$_b078[12]);a.querySelector(_$_b078[13])&&console.log(_$_b078[14]);return a.firstChild},D=function(a,b,f,e=_$_b078[15]){L.push(f.file(a)[_$_b078[16]](e));E.push({name:a,type:b})},F=function(a,b){b||(b=_$_b078[17]);return E.findIndex(function(f){return f[b]===a})},I=function(a){return E.filter(function(b){return b.type===a})},P=function(a,b){O===_$_b078[7]?H[a]=b:(b=b.split(_$_b078[3]).map(function(f){return f===_$_b078[5]?_$_b078[7]:f===_$_b078[7]?_$_b078[5]:f}),H[a]=b.join(_$_b078[3]))},ba=function(a){H= | ||
{};O=a?(new Intl.NumberFormat(a)).format(1.1).slice(1,2):_$_b078[7];Object.keys(Q).forEach(function(b){P(b,Q[b])})},R=function(a,b){return $jscomp.asyncExecutePromiseGeneratorFunction(function*(){ba(b.locale);jSuites.loading.show();D(_$_b078[19],_$_b078[20],a);D(_$_b078[21],_$_b078[22],a);a.file(_$_b078[23])&&D(_$_b078[23],_$_b078[24],a);a.file(_$_b078[25])&&D(_$_b078[25],_$_b078[26],a);var f=Object.keys(a.files),e=f.filter(function(d){return 0===d.indexOf(_$_b078[27])});e=e.sort(function(d,c){d= | ||
parseInt(d.slice(19));c=parseInt(c.slice(19));return d-c});e.forEach(function(d){D(d,_$_b078[18],a)});f.forEach(function(d){d.includes(_$_b078[28])?D(d,_$_b078[29],a):d.includes(_$_b078[30])?D(d,_$_b078[31],a):d.includes(_$_b078[32])?D(d,_$_b078[33],a):d.includes(_$_b078[34])?D(d,_$_b078[35],a,_$_b078[36]):d.includes(_$_b078[37])&&D(d,_$_b078[38],a)});yield Promise.all(L).then(function(d){var c=F(_$_b078[20]),h=C(d[c]),l=h.querySelector(_$_b078[39]);for(c=0;c<l.children.length;c++){var n={data:[], | ||
columns:[],cells:{},style:{},stripHTML:!1,defaultColAlign:_$_b078[40],defaultColWidth:_$_b078[41],worksheetName:l.children[c].getAttribute(_$_b078[42])},p=l.children[c].getAttribute(_$_b078[43]);!p||p!==_$_b078[44]&&p!==_$_b078[45]||(n.worksheetState=_$_b078[44]);m.worksheets.push(n)}if(h=h.querySelector(_$_b078[46]))for(m.definedNames={},c=0;c<h.children.length;c++)h.children[c].getAttribute(_$_b078[44])||h.children[c].getAttribute(_$_b078[47])||(m.definedNames[h.children[c].getAttribute(_$_b078[42]).toUpperCase()]= | ||
h.children[c].firstChild.nodeValue);c=F(_$_b078[22]);c=C(d[c]);if((h=c.querySelector(_$_b078[77]))&&h.children)for(l=0;l<h.children.length;l++)y.push(h.children[l].getAttribute(_$_b078[68]));else y=[_$_b078[78],_$_b078[79],_$_b078[80],_$_b078[81],_$_b078[82],_$_b078[83],_$_b078[84],_$_b078[85],_$_b078[78],_$_b078[79],_$_b078[80],_$_b078[81],_$_b078[82],_$_b078[83],_$_b078[84],_$_b078[85],_$_b078[86],_$_b078[87],_$_b078[88],_$_b078[89],_$_b078[90],_$_b078[91],_$_b078[92],_$_b078[93],_$_b078[94],_$_b078[95], | ||
_$_b078[96],_$_b078[97],_$_b078[98],_$_b078[99],_$_b078[100],_$_b078[101],_$_b078[88],_$_b078[84],_$_b078[83],_$_b078[85],_$_b078[90],_$_b078[86],_$_b078[91],_$_b078[82],_$_b078[102],_$_b078[97],_$_b078[103],_$_b078[104],_$_b078[105],_$_b078[106],_$_b078[107],_$_b078[108],_$_b078[109],_$_b078[110],_$_b078[111],_$_b078[112],_$_b078[113],_$_b078[114],_$_b078[115],_$_b078[116],_$_b078[117],_$_b078[118],_$_b078[119],_$_b078[120],_$_b078[121],_$_b078[95],_$_b078[122],_$_b078[123]];t=c;c=F(_$_b078[24]); | ||
if(!(0>c)){c=C(d[c]).querySelector(_$_b078[71]).children;for(h=0;h<c.length;h++){l=c[h].children[0];n=l.getAttribute(_$_b078[54]);if(n===_$_b078[72]||n===_$_b078[73])n=l.getAttribute(_$_b078[74]);A.color.push(n)}0<=c[0].tagName.indexOf(_$_b078[75])&&(h=A.color[0],A.color[0]=A.color[1],A.color[1]=h);0<=c[2].tagName.indexOf(_$_b078[75])&&(h=A.color[2],A.color[2]=A.color[3],A.color[3]=h)}c=F(_$_b078[26]);if(0>c)r=void 0;else{c=C(d[c]);h=[];for(l=0;l<c.children.length;l++)if(n=c.children[l],n.children[0].tagName=== | ||
_$_b078[48])n.firstChild.firstChild?h.push(n.firstChild.firstChild.nodeValue):h.push(_$_b078[3]);else{p=_$_b078[3];for(var u=0;u<n.children.length;u++){var x=n.children[u].querySelector(_$_b078[49]);if(x){p+=_$_b078[50];var B=n.children[u].querySelector(_$_b078[48]);B.getAttribute(_$_b078[51])||(p+=_$_b078[52]);var v=x.querySelector(_$_b078[53]);v&&(v=4*v.getAttribute(_$_b078[54])/3,p+=_$_b078[55]+Math.round(v)+_$_b078[56]);(v=x.querySelector(_$_b078[57]))&&(p+=_$_b078[58]+v.getAttribute(_$_b078[54])+ | ||
_$_b078[59]);x.querySelector(_$_b078[60])&&(p+=_$_b078[61]);x.querySelector(_$_b078[62])&&(p+=_$_b078[63]);if(v=x.querySelector(_$_b078[64]))if(x=v.getAttribute(_$_b078[65]))p+=_$_b078[66]+y[x].substr(2)+_$_b078[59];else if(x=v.getAttribute(_$_b078[24]))v=v.getAttribute(_$_b078[67]),p+=_$_b078[66]+J(A.color[x],parseFloat(v))+_$_b078[59];else if(x=v.getAttribute(_$_b078[68]))p+=_$_b078[66]+x.substr(2)+_$_b078[59];p+=_$_b078[69]+B.innerHTML+_$_b078[70]}else if(B=n.children[u].querySelector(_$_b078[48]))p+= | ||
B.innerHTML;else if(B=n.children[u].firstChild)p+=B.data}h.push(p)}r=h}c=I(_$_b078[18]);for(h=0;h<c.length;h++)if(n=C(d[E.indexOf(c[h])]),l=h,n.querySelector(_$_b078[76])&&(m.worksheets[l].gridLine=!1),ca(n,h,d),da(n,h),ea(n,h),l=h,n=n.querySelector(_$_b078[320]))p=n.getAttribute(_$_b078[321]),null!==p&&(m.worksheets[l].freezeColumns=parseInt(p)),n=n.getAttribute(_$_b078[322]),null!==n&&(m.worksheets[l].freezeRows=parseInt(n));fa(d);b.license&&(m.license=b.license);b.onload(m);jSuites.loading.hide()})})}, | ||
Q={0:_$_b078[124],1:_$_b078[125],2:_$_b078[126],3:_$_b078[127],4:_$_b078[128],9:_$_b078[129],10:_$_b078[130],11:_$_b078[131],12:_$_b078[132],13:_$_b078[133],14:_$_b078[134],15:_$_b078[135],16:_$_b078[136],17:_$_b078[137],18:_$_b078[138],19:_$_b078[139],20:_$_b078[140],21:_$_b078[141],22:_$_b078[142],37:_$_b078[143],38:_$_b078[144],39:_$_b078[145],40:_$_b078[146],45:_$_b078[147],46:_$_b078[148],47:_$_b078[149],48:_$_b078[150],49:_$_b078[151],56:_$_b078[3],65535:_$_b078[124]},O,H={},S={thin:[_$_b078[152], | ||
_$_b078[153]],medium:[_$_b078[152],_$_b078[154]],thick:[_$_b078[152],_$_b078[155]],dotted:[_$_b078[156],_$_b078[153]],dashed:[_$_b078[157],_$_b078[153]],double:[_$_b078[158],_$_b078[153]],mediumDashed:[_$_b078[157],_$_b078[154]]},ha=function(a,b,f){var e=_$_b078[3];var d=parseInt(b.getAttribute(_$_b078[159]));if(!isNaN(d)&&(d=t.querySelector(_$_b078[160]).children[d],d.firstChild.getAttribute(_$_b078[161])===_$_b078[152])){d=d.firstChild.firstChild;var c=d.getAttribute(_$_b078[65]);if(y&&y[c])e+= | ||
_$_b078[162]+y[c].substr(2)+_$_b078[59];else if(c=d.getAttribute(_$_b078[24]))d=d.getAttribute(_$_b078[67]),e+=_$_b078[162]+J(A.color[c],parseFloat(d))+_$_b078[59];else if(c=d.getAttribute(_$_b078[68]))e+=_$_b078[162]+c.substr(2)+_$_b078[59]}d=parseInt(b.getAttribute(_$_b078[163]));if(!isNaN(d)){d=t.querySelector(_$_b078[164]).children[d];var h=d.querySelector(_$_b078[53]);h&&(h=parseFloat(h.getAttribute(_$_b078[54])),e+=_$_b078[55]+Math.round(4*h/3)+_$_b078[56]);d.querySelector(_$_b078[60])&&(e+= | ||
_$_b078[61]);d.querySelector(_$_b078[62])&&(e+=_$_b078[63]);(h=d.querySelector(_$_b078[42]))&&(e+=_$_b078[58]+h.getAttribute(_$_b078[54])+_$_b078[59]);var l=d.querySelector(_$_b078[64]);l&&(c=l.getAttribute(_$_b078[65]),y&&y[c]?e+=_$_b078[66]+y[c].substr(2)+_$_b078[59]:(c=l.getAttribute(_$_b078[24]))?(l=l.getAttribute(_$_b078[67]),e+=_$_b078[66]+J(A.color[c],parseFloat(l))+_$_b078[59]):(c=l.getAttribute(_$_b078[68]))&&c&&(e+=_$_b078[66]+c.substr(2)+_$_b078[59]))}if(d=b.querySelector(_$_b078[165])){(h= | ||
d.getAttribute(_$_b078[166]))&&(e+=_$_b078[167]+h+_$_b078[59]);if(h=d.getAttribute(_$_b078[168]))h===_$_b078[169]&&(h=_$_b078[170]),e+=_$_b078[171]+h+_$_b078[59];d.getAttribute(_$_b078[172])&&(e+=_$_b078[173]);if(d=d.getAttribute(_$_b078[174]))m.worksheets[f].cells||(m.worksheets[f].cells={}),m.worksheets[f].cells[a]||(m.worksheets[f].cells[a]={}),d=parseInt(d),90<d&&(d=90-d),m.worksheets[f].cells[a].rotate=d}d=parseInt(b.getAttribute(_$_b078[175]));if(!isNaN(d))for(d=t.querySelector(_$_b078[176]).children[d], | ||
h=0;h<d.children.length;h++){var n=d.children[h].tagName;if(n===_$_b078[177]){if(c=k.helpers.getCoordsFromColumnName(a),0!==c[1]&&(c=k.helpers.getColumnNameFromCoords(c[0],c[1]-1),(c=m.worksheets[f].style[c])&&c.includes(_$_b078[178])))continue}else if(n===_$_b078[40]&&(c=k.helpers.getCoordsFromColumnName(a),0!==c[0]&&(c=k.helpers.getColumnNameFromCoords(c[0]-1,c[1]),(c=m.worksheets[f].style[c])&&c.includes(_$_b078[179]))))continue;if(n!==_$_b078[180]&&(c=d.children[h].getAttribute(_$_b078[181]))&& | ||
((c=S[c])||(c=[_$_b078[152],_$_b078[153]]),e+=_$_b078[182]+n+_$_b078[183]+c[0]+_$_b078[59],e+=_$_b078[182]+n+_$_b078[184]+c[1]+_$_b078[59],l=d.children[h].firstChild))if(c=l.getAttribute(_$_b078[65]))(c=y[c%y.length])||(c=q),e+=_$_b078[182]+n+_$_b078[185]+c.substr(2)+_$_b078[59];else if(c=l.getAttribute(_$_b078[24]))l=l.getAttribute(_$_b078[67]),e+=_$_b078[182]+n+_$_b078[185]+J(A.color[c],parseFloat(l))+_$_b078[59];else if(c=l.getAttribute(_$_b078[68]))6<c.length&&(c=c.substr(2)),e+=_$_b078[182]+ | ||
n+_$_b078[185]+c+_$_b078[59]}e&&(m.worksheets[f].style[a]||(m.worksheets[f].style[a]=_$_b078[3]),m.worksheets[f].style[a]=e);(d=b.getAttribute(_$_b078[186]))&&(e=b.querySelector(_$_b078[187]))&&e.getAttribute(_$_b078[188])==_$_b078[125]&&(m.worksheets[f].cells||(m.worksheets[f].cells={}),m.worksheets[f].cells[a]||(m.worksheets[f].cells[a]={}),m.worksheets[f].cells[a].locked=!1);e=parseInt(b.getAttribute(_$_b078[189]));d=b.getAttribute(_$_b078[190]);if(d!=_$_b078[125]&&0<e){if(H[e])b=H[e];else if(b= | ||
t.querySelector(_$_b078[191]).querySelector(_$_b078[192]+e+_$_b078[193]))b=b.getAttribute(_$_b078[194]),P(e,b);b&&(b=b.replace(new RegExp(_$_b078[195],_$_b078[196]),_$_b078[3]),b=b.replace(new RegExp(_$_b078[197],_$_b078[196]),_$_b078[3]),b!=_$_b078[124]&&(m.worksheets[f].cells||(m.worksheets[f].cells={}),m.worksheets[f].cells[a]||(m.worksheets[f].cells[a]={}),m.worksheets[f].cells[a].type||(e=_$_b078[198],jSuites.mask&&typeof jSuites.mask.getType==_$_b078[199]&&(e=b.split(_$_b078[59]),e=jSuites.mask.getType(e[0])), | ||
m.worksheets[f].cells[a].type=e===_$_b078[200]||e===_$_b078[201]||e===_$_b078[202]||e===_$_b078[203]?_$_b078[200]:_$_b078[198]),m.worksheets[f].cells[a].format=b))}},T=[_$_b078[204],_$_b078[205]],M=function(a){for(var b=0;b<T.length;b++)a=a.replace(new RegExp(T[b],_$_b078[206]),_$_b078[3]);return a},ia={whole:_$_b078[200],decimal:_$_b078[200],list:_$_b078[207],textLength:_$_b078[208],date:_$_b078[209]},ja={notBetween:_$_b078[210],equal:_$_b078[211],notEqual:_$_b078[212],greaterThan:_$_b078[213],lessThan:_$_b078[214], | ||
greaterThanOrEqual:_$_b078[215],lessThanOrEqual:_$_b078[216]},U=function(a,b,f){Array.isArray(m.validations)||(m.validations=[]);b&&b.split(_$_b078[221]).forEach(function(e){m.validations.push(Object.assign({range:m.worksheets[a].worksheetName+_$_b078[222]+e},f))})},Z=Date.UTC(1900,0,0),aa=Date.UTC(1900,1,29),ka=function(a,b,f){m.worksheets[a].columns||(m.worksheets[a].columns=[]);b.forEach(function(e){m.worksheets[a].columns[e]||(m.worksheets[a].columns[e]={});Object.assign(m.worksheets[a].columns[e], | ||
f)})},la=function(a,b,f){m.worksheets[a].cells||(m.worksheets[a].cells={});b.forEach(function(e){m.worksheets[a].cells[e]||(m.worksheets[a].cells[e]={});Object.assign(m.worksheets[a].cells[e],f)})},da=function(a,b){a=a.querySelectorAll(_$_b078[225]);Array.from(a).forEach(function(f){var e={},d=f.getAttribute(_$_b078[17]);e.type=ia[d];if(e.type){e.allowBlank=!!f.getAttribute(_$_b078[226]);e.criteria;e.type!==_$_b078[207]&&(d=f.getAttribute(_$_b078[227]),e.criteria=ja[d]||_$_b078[217]);var c=f.querySelector(_$_b078[228]); | ||
e.value=[];if(e.type===_$_b078[207]){d=f.getAttribute(_$_b078[229]);if(c.innerHTML.startsWith(_$_b078[197])&&c.innerHTML.endsWith(_$_b078[197]))c=c.innerHTML.slice(1,-1),e.value.push(c.split(_$_b078[5]));else{if(d)return;e.value.push(c.innerHTML)}if(!d){a:{d=f.getAttribute(_$_b078[230]);c=d.split(_$_b078[223]);f={type:_$_b078[224]};Array.isArray(e.value[0])?f.source=e.value[0]:f.dynamicSource=e.value[0];if(2===c.length&&(e=k.helpers.getCoordsFromColumnName(c[1]),1048575===e[1]&&(c=k.helpers.getCoordsFromColumnName(c[0]), | ||
0===c[1]))){d=[];for(c=c[0];c<=e[0];c++)d.push(c);ka(b,d,f);break a}la(b,k.helpers.getTokensFromRange(d),f)}return}}else e.type===_$_b078[209]?(d=g(c.innerHTML),c=d.getTimezoneOffset(),d.setMinutes(d.getMinutes()+c),d=jSuites.calendar.getDateString(d,_$_b078[231]),e.value.push(d)):e.value.push(parseFloat(c.innerHTML));if(d=f.querySelector(_$_b078[232]))e.type===_$_b078[209]?(d=g(d.innerHTML),c=d.getTimezoneOffset(),d.setMinutes(d.getMinutes()+c),d=jSuites.calendar.getDateString(d,_$_b078[231]),e.value.push(d)): | ||
e.value.push(parseFloat(d.innerHTML));d=f.getAttribute(_$_b078[233]);e.action=d===_$_b078[218]?_$_b078[219]:_$_b078[220];e.text=f.getAttribute(_$_b078[234]);e.text||(e.text=f.getAttribute(_$_b078[235]));e.text||delete e.text;U(b,f.getAttribute(_$_b078[230]),e)}})},ma=[_$_b078[236],_$_b078[237]].concat([_$_b078[238],_$_b078[239],_$_b078[240],_$_b078[241],_$_b078[242]]),V={equal:_$_b078[211],notEqual:_$_b078[212],greaterThan:_$_b078[213],lessThan:_$_b078[214],greaterThanOrEqual:_$_b078[215],lessThanOrEqual:_$_b078[216], | ||
between:_$_b078[217],notBetween:_$_b078[210]},W={containsText:_$_b078[243],notContains:_$_b078[244],beginsWith:_$_b078[245],endsWith:_$_b078[246]},na=[_$_b078[40],_$_b078[247],_$_b078[177],_$_b078[248]],oa=function(a){var b={};a=a.getAttribute(_$_b078[249]);var f=t.querySelector(_$_b078[250]+(parseInt(a)+1)+_$_b078[251]);(a=f.querySelector(_$_b078[252]))&&a.getAttribute(_$_b078[68])&&(b[_$_b078[253]]=_$_b078[254]+a.getAttribute(_$_b078[68]).slice(2));(a=f.querySelector(_$_b078[255]))&&a.getAttribute(_$_b078[68])&& | ||
(b[_$_b078[64]]=_$_b078[254]+a.getAttribute(_$_b078[68]).slice(2));var e=f.querySelector(_$_b078[256]);e&&na.forEach(function(d){var c=e.querySelector(d);if(c){c=S[c.getAttribute(_$_b078[181])];var h=f.querySelector(_$_b078[64]);h=_$_b078[254]+h.getAttribute(_$_b078[68]).slice(2);b[_$_b078[182]+d]=c[1]+_$_b078[221]+c[0]+_$_b078[221]+h}});return b},ea=function(a,b){a=a.querySelectorAll(_$_b078[257]);Array.from(a).forEach(function(f){var e=f.querySelector(_$_b078[258]);if(e){var d=e.getAttribute(_$_b078[17]); | ||
if(d&&ma.includes(d)){var c={action:_$_b078[259],format:oa(e)};d===_$_b078[236]?c.type=_$_b078[260]:d===_$_b078[237]?c.type=_$_b078[261]:(d=e.getAttribute(_$_b078[227]),V[d]?(c.type=_$_b078[200],c.criteria=V[d],e=e.querySelectorAll(_$_b078[262]),c.value=Array.from(e).map(function(h){return h.innerHTML})):W[d]&&(c.type=_$_b078[198],c.criteria=W[d],e=e.getAttribute(_$_b078[198]),c.value=[e]));f=f.getAttribute(_$_b078[230]);U(b,f,c)}}})},pa=function(a){var b=[0,0],f=a.querySelector(_$_b078[263]);f&& | ||
(b=f.getAttribute(_$_b078[264]),b=-1!==b.indexOf(_$_b078[223])?b.split(_$_b078[223])[1]:b,b=k.helpers.getCoordsFromColumnName(b));f=a.querySelectorAll(_$_b078[265]);var e=1;Array.from(f).forEach(function(c){c=parseInt(c.getAttribute(_$_b078[266]));c>e&&(e=c)});e--;a=a.querySelectorAll(_$_b078[267]);var d=_$_b078[268];Array.from(a).forEach(function(c){c=c.getAttribute(_$_b078[266]);c=/^\D+/.exec(c);c[0].length>=d.length&&c[0]>d&&(d=c[0])});a=[k.helpers.getCoordsFromColumnName(d)[0],e];a=[Math.max(b[0], | ||
a[0]),Math.max(b[1],a[1])];a[0]++;a[1]++;return a},ca=function(a,b,f){var e=I(_$_b078[18]),d=[],c=[],h=pa(a);m.worksheets[b].minDimensions=h;for(var l=0;l<h[1];l++){d[l]=[];for(var n=0;n<h[0];n++)d[l][n]=_$_b078[3]}if(10<h[0]||100<h[1])300<h[1]&&(m.worksheets[b].lazyLoading=!0),m.worksheets[b].tableOverflow=!0,m.worksheets[b].tableHeight=_$_b078[269],m.worksheets[b].tableWidth=_$_b078[269],m.worksheets[b].resize=_$_b078[270];5>h[0]&&(h[0]=5);5>h[1]&&(h[1]=5);if(l=a.querySelector(_$_b078[271]))for(m.worksheets[b].columns= | ||
[],n=0;n<l.children.length;n++){for(var p=parseInt(l.children[n].getAttribute(_$_b078[272])),u=parseInt(l.children[n].getAttribute(_$_b078[273])),x=Math.round(7.15*parseInt(l.children[n].getAttribute(_$_b078[274])))+_$_b078[275],B=parseInt(l.children[n].getAttribute(_$_b078[44]));p-1!==m.worksheets[b].columns.length;)m.worksheets[b].columns.push({type:_$_b078[198]});for(;p<=u&&p<=h[0];p++){var v={width:x};1===B&&(v.type=_$_b078[44]);m.worksheets[b].columns.push(v)}}if(l=a.querySelector(_$_b078[276]))for(m.worksheets[b].mergeCells= | ||
{},n=0;n<l.children.length;n++)h=l.children[n].getAttribute(_$_b078[264]).split(_$_b078[223]),u=k.helpers.getCoordsFromColumnName(h[0]),x=k.helpers.getCoordsFromColumnName(h[1]),m.worksheets[b].mergeCells[h[0]]=[x[0]-u[0]+1,x[1]-u[1]+1];h=t.querySelector(_$_b078[277]);u=a.querySelector(_$_b078[278]);x=[];for(l=0;l<u.children.length;l++){B=u.children[l];n=B.getAttribute(_$_b078[266])-1;p=B.getAttribute(_$_b078[279]);v=B.getAttribute(_$_b078[44]);if(p||v)m.worksheets[b].rows||(m.worksheets[b].rows= | ||
{}),m.worksheets[b].rows[n]||(m.worksheets[b].rows[n]={}),p&&(m.worksheets[b].rows[n].height=Math.ceil(1.333333333*parseFloat(p))),v===_$_b078[280]&&(m.worksheets[b].rows[n].visible=!1);for(n=0;n<B.children.length;n++){var z=B.children[n];v=z.getAttribute(_$_b078[266]);var w=z.getAttribute(_$_b078[48]);p=z.getAttribute(_$_b078[281]);0<p&&ha(v,h.children[p],b);p=k.helpers.getCoordsFromColumnName(v);p=[parseInt(p[0]),parseInt(p[1])];if(!x.includes(v))if(w===_$_b078[281])d[p[1]][p[0]]=r[z.firstChild.innerHTML]; | ||
else if(w===_$_b078[282])v=z.querySelector(_$_b078[283]),d[p[1]][p[0]]=v.innerHTML;else if(v=z.getElementsByTagName(_$_b078[284])[0],z=z.getElementsByTagName(_$_b078[285])[0],v)if(w=null,z=v.getAttribute(_$_b078[264]),w=v.getAttribute(_$_b078[48]),w==_$_b078[286])c[p[1]]||(c[p[1]]=[]),w=_$_b078[211]+M(v.firstChild.nodeValue),d[p[1]][p[0]]=w,c[p[1]][p[0]]=w,p=-1!==z.indexOf(_$_b078[223])?k.helpers.getTokensFromRange(z):[z],x=x.concat(p);else if(w==_$_b078[287]){if(z){w=z.split(_$_b078[223]);w=[k.helpers.getCoordsFromColumnName(w[0]), | ||
k.helpers.getCoordsFromColumnName(w[1])];z=[parseInt(w[0][0]),parseInt(w[0][1])];w=[parseInt(w[1][0]),parseInt(w[1][1])];Number.isNaN(w[0])&&(w[0]=z[0]);Number.isNaN(w[1])&&(w[1]=z[1]);for(var G=z[1];G<=w[1];G++){c[G]||(c[G]=[]);for(var K=z[0];K<=w[0];K++)c[G][K]=_$_b078[211]+k.helpers.shiftFormula(M(v.textContent),K-z[0],G-z[1])}}c[p[1]]&&c[p[1]][p[0]]&&(d[p[1]][p[0]]=c[p[1]][p[0]])}else d[p[1]][p[0]]=_$_b078[211]+M(v.firstChild.nodeValue);else z&&(w=z.innerHTML,Number(w)==w&&(w=Number(w)),d[p[1]][p[0]]= | ||
w)}}e=e[b].name;var qa=e.slice(0,13)+_$_b078[288]+e.slice(13)+_$_b078[289];e=E.findIndex(function(ra){return ra.name===qa});if(-1<e){e=C(f[e]);if(c=a.querySelector(_$_b078[290]))for(n=0;n<c.children.length;n++)if(l=c.children[n].getAttribute(_$_b078[291]))l=e.querySelector(_$_b078[292]+l+_$_b078[293]),l=l.getAttribute(_$_b078[294]),h=c.children[n].getAttribute(_$_b078[264]),m.worksheets[b].cells[h]?(m.worksheets[b].cells[h].type=_$_b078[295],m.worksheets[b].cells[h].options={url:l}):m.worksheets[b].cells[h]= | ||
{type:_$_b078[295],options:{url:l}};c=a.querySelectorAll(_$_b078[29]);for(n=0;n<c.length;n++)if(l=c[n].getAttribute(_$_b078[291]),l=e.querySelector(_$_b078[292]+l+_$_b078[293]),h=l.getAttribute(_$_b078[294]),h=_$_b078[296]+h.slice(h.lastIndexOf(_$_b078[297])),l=F(h,_$_b078[42]),l=C(f[l]),u=l.querySelector(_$_b078[298]))u=u.getAttribute(_$_b078[299]),h=h.slice(0,12)+_$_b078[300]+h.slice(12)+_$_b078[289],h=F(h,_$_b078[42]),h=C(f[h]).querySelector(_$_b078[301]+u+_$_b078[193]).getAttribute(_$_b078[294]), | ||
h=_$_b078[296]+h.slice(h.lastIndexOf(_$_b078[302])),h=F(h,_$_b078[42]),m.worksheets[b].media||(m.worksheets[b].media=[]),p=l.querySelector(_$_b078[303]),u=l.querySelector(_$_b078[304]),l=l.querySelector(_$_b078[305]),l=[l.querySelector(_$_b078[306]),l.querySelector(_$_b078[307])],l=[parseInt(l[0].innerHTML),parseInt(l[1].innerHTML)],x=k.helpers.getColumnNameFromCoords(l[0],l[1]),d[l[1]]||(d[l[1]]=[]),B=parseInt(u.getAttribute(_$_b078[308]))/9525,u=parseInt(u.getAttribute(_$_b078[309]))/9525,d[l[1]][l[0]]= | ||
_$_b078[310]+f[h],m.worksheets[b].cells[x]={type:_$_b078[35],options:{absolute:!0,width:B,height:u}}}m.worksheets[b].data=d;if(a=a.querySelector(_$_b078[311]))f=a.getAttribute(_$_b078[312]),f==_$_b078[280]&&(m.worksheets[b].locked=!0,f=a.getAttribute(_$_b078[313]),f!=_$_b078[125]&&(m.worksheets[b].columnSorting=!1),f=a.getAttribute(_$_b078[314]),f!=_$_b078[125]&&(m.worksheets[b].allowInsertRow=!1),f=a.getAttribute(_$_b078[315]),f!=_$_b078[125]&&(m.worksheets[b].allowDeleteRow=!1),f=a.getAttribute(_$_b078[316]), | ||
f!=_$_b078[125]&&(m.worksheets[b].allowInsertColumn=!1),f=a.getAttribute(_$_b078[317]),f!=_$_b078[125]&&(m.worksheets[b].allowDeleteColumn=!1),f=a.getAttribute(_$_b078[318]),f==_$_b078[280]&&(m.worksheets[b].selectUnLockedCells=!1),f=a.getAttribute(_$_b078[319]),f==_$_b078[280]&&(m.worksheets[b].selectLockedCells=!1),m.worksheets[b].columnDrag=!1,m.worksheets[b].rowDrag=!1);for(l=0;l<m.worksheets[b].data.length;l++)for(m.worksheets[b].data[l]||(m.worksheets[b].data[l]=[]),n=0;n<m.worksheets[b].columns.length;n++)if(null=== | ||
m.worksheets[b].data[l][n]||void 0===m.worksheets[b].data[l][n])m.worksheets[b].data[l][n]=_$_b078[3];m.worksheets[b].minDimensions[0]<n&&(m.worksheets[b].minDimensions[0]=n);m.worksheets[b].minDimensions[1]<l&&(m.worksheets[b].minDimensions[1]=l);1E3>m.worksheets[b].minDimensions[1]&&(m.worksheets[b].textOverflow=!0)},fa=function(a){for(var b=I(_$_b078[33]),f=0;f<b.length;f++){var e=C(a[E.indexOf(b[f])]).querySelector(_$_b078[323]);if(e){var d=b[f].name.replace(_$_b078[288],_$_b078[3]);d=d.replace(_$_b078[289], | ||
_$_b078[3]);var c=I(_$_b078[18]).findIndex(function(u){return u.name===d}),h=e.getAttribute(_$_b078[294]).slice(3);h=_$_b078[296]+h;e=E.findIndex(function(u){return u.name===h});e=C(a[e]);var l=e.querySelector(_$_b078[324]).children,n=Array.from(l).map(function(u){return u.children[0].children[0].querySelector(_$_b078[48]).innerHTML}),p=e.querySelector(_$_b078[325]).children;p=Array.from(p).map(function(u){return u.innerHTML});m.worksheets[c].allowComments=!0;m.worksheets[c].comments={};n.forEach(function(u, | ||
x){var B=l[x].getAttribute(_$_b078[264]);x=l[x].getAttribute(_$_b078[326]);m.worksheets[c].comments[B]=p[x]+_$_b078[327]+u})}}},J=function(a,b){if(!b)return a;b=parseFloat(b);a=a.slice(a[0]===_$_b078[254]?1:0).slice(0,6);var f=[parseInt(a.slice(0,2),16),parseInt(a.slice(2,4),16),parseInt(a.slice(4,6),16)];a=f[0]/255;var e=f[1]/255;f=f[2]/255;var d=Math.max(a,e,f),c=Math.min(a,e,f),h=d-c;if(0===h)a=[0,0,a];else{var l=0;c=d+c;switch(d){case a:l=((e-f)/h+6)%6;break;case e:l=(f-a)/h+2;break;case f:l= | ||
(a-e)/h+4}a=[l/6,h/(1<c?2-c:c),c/2]}a[2]=0>b?a[2]*(1+b):1-(1-a[2])*(1-b);e=a[1];b=a[2];f=2*e*(.5>b?b:1-b);b-=f/2;b=[b,b,b];a=6*a[0];if(0!==e)switch(a|0){case 0:case 6:b[0]+=f;b[1]+=f*a;break;case 1:b[0]+=f*(2-a);b[1]+=f;break;case 2:b[1]+=f;b[2]+=f*(a-2);break;case 3:b[1]+=f*(4-a);b[2]+=f;break;case 4:b[2]+=f;b[0]+=f*(a-4);break;case 5:b[2]+=f*(6-a),b[0]+=f}for(a=0;3!=a;++a)b[a]=Math.round(255*b[a]);a=0;for(e=1;3!=a;++a)e=256*e+(255<b[a]?255:0>b[a]?0:b[a]);return e.toString(16).toUpperCase().slice(1)}, | ||
X=0,Y=function(a){null===k&&(k=this);t=r=null;y=[];A={color:[]};m={worksheets:[]};E=[];L=[];var b=N.label();if(b){X++;if(5<X)return alert(b),!1;console.log(b)}var f=new JSZip;a.url?jSuites.ajax({url:a.url,method:_$_b078[328],dataType:_$_b078[329],success:function(e){f.loadAsync(e).then(function(d){return $jscomp.asyncExecutePromiseGeneratorFunction(function*(){yield R(d,a)})}).catch(function(d){console.error(d);jSuites.loading.hide();if(typeof a.onerror==_$_b078[199])a.onerror(d)})}}):a.file&&f.loadAsync(a.file).then(function(e){return $jscomp.asyncExecutePromiseGeneratorFunction(function*(){yield R(e, | ||
a)})}).catch(function(e){console.error(e);jSuites.loading.hide();if(typeof a.onerror==_$_b078[199])a.onerror(e)})};Y.license=function(a){N(a)};return Y}); | ||
$jscomp.asyncExecutePromiseGenerator=function(g){function k(r){return g.next(r)}function q(r){return g.throw(r)}return new Promise(function(r,t){function w(A){A.done?r(A.value):Promise.resolve(A.value).then(k,q).then(w,t)}w(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(k,q){var r=this;r instanceof String&&(r=String(r));var t=r.length;q=q||0;for(0>q&&(q=Math.max(q+t,0));q<t;q++){var w=r[q];if(w===k||Object.is(w,k))return!0}return!1}},"es7","es3");var _$_b861='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{worksheet{xl/workbook.xml{workbook{xl/styles.xml{styles{xl/theme/theme1.xml{theme{xl/sharedStrings.xml{sharedStrings{xl/worksheets/sheet{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{veryHidden{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{empty{notEmpty{formula{dimension{ref{row[r]{r{row c[r]{A{800px{both{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/{drawings{blip{r:embed{_rels/{Relationship[Id="{media{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{[Threaded comment]\n\nYour version of Excel allows you to read this threaded comment; however, any edits to it will get removed if the file is opened in a newer version of Excel. Learn more: https://go.microsoft.com/fwlink/?linkid=870924\n\nComment:\n {[Target*=\'/comments\']{commentList{GET{blob{object'.split("{"); | ||
(function(g,k){typeof exports===_$_b861[328]&&typeof module!==_$_b861[4]?module.exports=k():typeof define===_$_b861[199]&&define.amd?define(k):g.parser=k()})(this,function(){function g(a){a=Z+864E5*a;a>=aa&&(a-=864E5);return new Date(a)}_$_b861[0];var k=null,q=_$_b861[2],r=null,t=null,w=[],A={},m={},E=[],L=[],N=function(){var a=function(b){a.license=b;a.run()};a.k=[74,50,48,50,48,33].join(_$_b861[3]);a.apply=function(b,f){var e=jSuites.sha512,d=_$_b861[3],c=_$_b861[3];128<b.length&&(b=e(b));for(var h= | ||
0;128>h;h++){var l=b[h]?b[h].charCodeAt(0):0;d+=String.fromCharCode(54^l);c+=String.fromCharCode(92^l)}return e(c+e(d+f))};a.run=function(){if(typeof a.result==_$_b861[4]){a.result=1;try{if(a.license){var b=window.atob(a.license);b=b.split(_$_b861[5]);if(b[1])if(b[1]=window.atob(b[1]),b[0]!=a.apply(a.k,b[1]))a.result=3;else if(b[1]=JSON.parse(b[1]),b[1].date){var f=window.location.hostname||_$_b861[6],e=f.split(_$_b861[7]);f=f.split(_$_b861[7]);2<f.length&&!jSuites.isNumeric(f[f.length-1])&&e.shift(); | ||
e=e.join(_$_b861[7]);f=f.join(_$_b861[7]);-1==b[1].domain.indexOf(e)&&-1==b[1].domain.indexOf(f)?a.result=4:b[1].scope&&0<=b[1].scope.indexOf(_$_b861[8])?(a.result=6,a.name=b[1].name):a.result=5}else a.result=4;else a.result=2}}catch(d){}}return a.result};a.label=function(){var b=_$_b861[3];a.result&&1!=a.result?2==a.result||3==a.result||4==a.result?b=_$_b861[10]:5==a.result&&(b=_$_b861[11]):b=_$_b861[9];return b};a.status=function(){return a.result};return a}(),C=function(a){a=(new DOMParser).parseFromString(a, | ||
_$_b861[12]);a.querySelector(_$_b861[13])&&console.log(_$_b861[14]);return a.firstChild},D=function(a,b,f,e=_$_b861[15]){L.push(f.file(a)[_$_b861[16]](e));E.push({name:a,type:b})},F=function(a,b){b||(b=_$_b861[17]);return E.findIndex(function(f){return f[b]===a})},I=function(a){return E.filter(function(b){return b.type===a})},P=function(a,b){O===_$_b861[7]?H[a]=b:(b=b.split(_$_b861[3]).map(function(f){return f===_$_b861[5]?_$_b861[7]:f===_$_b861[7]?_$_b861[5]:f}),H[a]=b.join(_$_b861[3]))},ba=function(a){H= | ||
{};O=a?(new Intl.NumberFormat(a)).format(1.1).slice(1,2):_$_b861[7];Object.keys(Q).forEach(function(b){P(b,Q[b])})},R=function(a,b){return $jscomp.asyncExecutePromiseGeneratorFunction(function*(){ba(b.locale);jSuites.loading.show();D(_$_b861[19],_$_b861[20],a);D(_$_b861[21],_$_b861[22],a);a.file(_$_b861[23])&&D(_$_b861[23],_$_b861[24],a);a.file(_$_b861[25])&&D(_$_b861[25],_$_b861[26],a);var f=Object.keys(a.files),e=f.filter(function(d){return 0===d.indexOf(_$_b861[27])});e=e.sort(function(d,c){d= | ||
parseInt(d.slice(19));c=parseInt(c.slice(19));return d-c});e.forEach(function(d){D(d,_$_b861[18],a)});f.forEach(function(d){d.includes(_$_b861[28])?D(d,_$_b861[29],a):d.includes(_$_b861[30])?D(d,_$_b861[31],a):d.includes(_$_b861[32])?D(d,_$_b861[33],a):d.includes(_$_b861[34])?D(d,_$_b861[35],a,_$_b861[36]):d.includes(_$_b861[37])&&D(d,_$_b861[38],a)});yield Promise.all(L).then(function(d){var c=F(_$_b861[20]),h=C(d[c]),l=h.querySelector(_$_b861[39]);for(c=0;c<l.children.length;c++){var n={data:[], | ||
columns:[],cells:{},style:{},stripHTML:!1,defaultColAlign:_$_b861[40],defaultColWidth:_$_b861[41],worksheetName:l.children[c].getAttribute(_$_b861[42])},p=l.children[c].getAttribute(_$_b861[43]);!p||p!==_$_b861[44]&&p!==_$_b861[45]||(n.worksheetState=_$_b861[44]);m.worksheets.push(n)}if(h=h.querySelector(_$_b861[46]))for(m.definedNames={},c=0;c<h.children.length;c++)h.children[c].getAttribute(_$_b861[44])||h.children[c].getAttribute(_$_b861[47])||(m.definedNames[h.children[c].getAttribute(_$_b861[42]).toUpperCase()]= | ||
h.children[c].firstChild.nodeValue);c=F(_$_b861[22]);c=C(d[c]);if((h=c.querySelector(_$_b861[77]))&&h.children)for(l=0;l<h.children.length;l++)w.push(h.children[l].getAttribute(_$_b861[68]));else w=[_$_b861[78],_$_b861[79],_$_b861[80],_$_b861[81],_$_b861[82],_$_b861[83],_$_b861[84],_$_b861[85],_$_b861[78],_$_b861[79],_$_b861[80],_$_b861[81],_$_b861[82],_$_b861[83],_$_b861[84],_$_b861[85],_$_b861[86],_$_b861[87],_$_b861[88],_$_b861[89],_$_b861[90],_$_b861[91],_$_b861[92],_$_b861[93],_$_b861[94],_$_b861[95], | ||
_$_b861[96],_$_b861[97],_$_b861[98],_$_b861[99],_$_b861[100],_$_b861[101],_$_b861[88],_$_b861[84],_$_b861[83],_$_b861[85],_$_b861[90],_$_b861[86],_$_b861[91],_$_b861[82],_$_b861[102],_$_b861[97],_$_b861[103],_$_b861[104],_$_b861[105],_$_b861[106],_$_b861[107],_$_b861[108],_$_b861[109],_$_b861[110],_$_b861[111],_$_b861[112],_$_b861[113],_$_b861[114],_$_b861[115],_$_b861[116],_$_b861[117],_$_b861[118],_$_b861[119],_$_b861[120],_$_b861[121],_$_b861[95],_$_b861[122],_$_b861[123]];t=c;c=F(_$_b861[24]); | ||
if(!(0>c)){c=C(d[c]).querySelector(_$_b861[71]).children;for(h=0;h<c.length;h++){l=c[h].children[0];n=l.getAttribute(_$_b861[54]);if(n===_$_b861[72]||n===_$_b861[73])n=l.getAttribute(_$_b861[74]);A.color.push(n)}0<=c[0].tagName.indexOf(_$_b861[75])&&(h=A.color[0],A.color[0]=A.color[1],A.color[1]=h);0<=c[2].tagName.indexOf(_$_b861[75])&&(h=A.color[2],A.color[2]=A.color[3],A.color[3]=h)}c=F(_$_b861[26]);if(0>c)r=void 0;else{c=C(d[c]);h=[];for(l=0;l<c.children.length;l++)if(n=c.children[l],n.children[0].tagName=== | ||
_$_b861[48])n.firstChild.firstChild?h.push(n.firstChild.firstChild.nodeValue):h.push(_$_b861[3]);else{p=_$_b861[3];for(var x=0;x<n.children.length;x++){var y=n.children[x].querySelector(_$_b861[49]);if(y){p+=_$_b861[50];var B=n.children[x].querySelector(_$_b861[48]);B.getAttribute(_$_b861[51])||(p+=_$_b861[52]);var u=y.querySelector(_$_b861[53]);u&&(u=4*u.getAttribute(_$_b861[54])/3,p+=_$_b861[55]+Math.round(u)+_$_b861[56]);(u=y.querySelector(_$_b861[57]))&&(p+=_$_b861[58]+u.getAttribute(_$_b861[54])+ | ||
_$_b861[59]);y.querySelector(_$_b861[60])&&(p+=_$_b861[61]);y.querySelector(_$_b861[62])&&(p+=_$_b861[63]);if(u=y.querySelector(_$_b861[64]))if(y=u.getAttribute(_$_b861[65]))p+=_$_b861[66]+w[y].substr(2)+_$_b861[59];else if(y=u.getAttribute(_$_b861[24]))u=u.getAttribute(_$_b861[67]),p+=_$_b861[66]+J(A.color[y],parseFloat(u))+_$_b861[59];else if(y=u.getAttribute(_$_b861[68]))p+=_$_b861[66]+y.substr(2)+_$_b861[59];p+=_$_b861[69]+B.innerHTML+_$_b861[70]}else if(B=n.children[x].querySelector(_$_b861[48]))p+= | ||
B.innerHTML;else if(B=n.children[x].firstChild)p+=B.data}h.push(p)}r=h}c=I(_$_b861[18]);for(h=0;h<c.length;h++)if(n=C(d[E.indexOf(c[h])]),l=h,n.querySelector(_$_b861[76])&&(m.worksheets[l].gridLine=!1),ca(n,h,d),da(n,h),ea(n,h),l=h,n=n.querySelector(_$_b861[320]))p=n.getAttribute(_$_b861[321]),null!==p&&(m.worksheets[l].freezeColumns=parseInt(p)),n=n.getAttribute(_$_b861[322]),null!==n&&(m.worksheets[l].freezeRows=parseInt(n));fa(d);b.license&&(m.license=b.license);b.onload(m);jSuites.loading.hide()})})}, | ||
Q={0:_$_b861[124],1:_$_b861[125],2:_$_b861[126],3:_$_b861[127],4:_$_b861[128],9:_$_b861[129],10:_$_b861[130],11:_$_b861[131],12:_$_b861[132],13:_$_b861[133],14:_$_b861[134],15:_$_b861[135],16:_$_b861[136],17:_$_b861[137],18:_$_b861[138],19:_$_b861[139],20:_$_b861[140],21:_$_b861[141],22:_$_b861[142],37:_$_b861[143],38:_$_b861[144],39:_$_b861[145],40:_$_b861[146],45:_$_b861[147],46:_$_b861[148],47:_$_b861[149],48:_$_b861[150],49:_$_b861[151],56:_$_b861[3],65535:_$_b861[124]},O,H={},S={thin:[_$_b861[152], | ||
_$_b861[153]],medium:[_$_b861[152],_$_b861[154]],thick:[_$_b861[152],_$_b861[155]],dotted:[_$_b861[156],_$_b861[153]],dashed:[_$_b861[157],_$_b861[153]],double:[_$_b861[158],_$_b861[153]],mediumDashed:[_$_b861[157],_$_b861[154]]},ha=function(a,b,f){var e=_$_b861[3];var d=parseInt(b.getAttribute(_$_b861[159]));if(!isNaN(d)&&(d=t.querySelector(_$_b861[160]).children[d],d.firstChild.getAttribute(_$_b861[161])===_$_b861[152])){d=d.firstChild.firstChild;var c=d.getAttribute(_$_b861[65]);if(w&&w[c])e+= | ||
_$_b861[162]+w[c].substr(2)+_$_b861[59];else if(c=d.getAttribute(_$_b861[24]))d=d.getAttribute(_$_b861[67]),e+=_$_b861[162]+J(A.color[c],parseFloat(d))+_$_b861[59];else if(c=d.getAttribute(_$_b861[68]))e+=_$_b861[162]+c.substr(2)+_$_b861[59]}d=parseInt(b.getAttribute(_$_b861[163]));if(!isNaN(d)){d=t.querySelector(_$_b861[164]).children[d];var h=d.querySelector(_$_b861[53]);h&&(h=parseFloat(h.getAttribute(_$_b861[54])),e+=_$_b861[55]+Math.round(4*h/3)+_$_b861[56]);d.querySelector(_$_b861[60])&&(e+= | ||
_$_b861[61]);d.querySelector(_$_b861[62])&&(e+=_$_b861[63]);(h=d.querySelector(_$_b861[42]))&&(e+=_$_b861[58]+h.getAttribute(_$_b861[54])+_$_b861[59]);var l=d.querySelector(_$_b861[64]);l&&(c=l.getAttribute(_$_b861[65]),w&&w[c]?e+=_$_b861[66]+w[c].substr(2)+_$_b861[59]:(c=l.getAttribute(_$_b861[24]))?(l=l.getAttribute(_$_b861[67]),e+=_$_b861[66]+J(A.color[c],parseFloat(l))+_$_b861[59]):(c=l.getAttribute(_$_b861[68]))&&c&&(e+=_$_b861[66]+c.substr(2)+_$_b861[59]))}if(d=b.querySelector(_$_b861[165])){(h= | ||
d.getAttribute(_$_b861[166]))&&(e+=_$_b861[167]+h+_$_b861[59]);if(h=d.getAttribute(_$_b861[168]))h===_$_b861[169]&&(h=_$_b861[170]),e+=_$_b861[171]+h+_$_b861[59];d.getAttribute(_$_b861[172])&&(e+=_$_b861[173]);if(d=d.getAttribute(_$_b861[174]))m.worksheets[f].cells||(m.worksheets[f].cells={}),m.worksheets[f].cells[a]||(m.worksheets[f].cells[a]={}),d=parseInt(d),90<d&&(d=90-d),m.worksheets[f].cells[a].rotate=d}d=parseInt(b.getAttribute(_$_b861[175]));if(!isNaN(d))for(d=t.querySelector(_$_b861[176]).children[d], | ||
h=0;h<d.children.length;h++){var n=d.children[h].tagName;if(n===_$_b861[177]){if(c=k.helpers.getCoordsFromColumnName(a),0!==c[1]&&(c=k.helpers.getColumnNameFromCoords(c[0],c[1]-1),(c=m.worksheets[f].style[c])&&c.includes(_$_b861[178])))continue}else if(n===_$_b861[40]&&(c=k.helpers.getCoordsFromColumnName(a),0!==c[0]&&(c=k.helpers.getColumnNameFromCoords(c[0]-1,c[1]),(c=m.worksheets[f].style[c])&&c.includes(_$_b861[179]))))continue;if(n!==_$_b861[180]&&(c=d.children[h].getAttribute(_$_b861[181]))&& | ||
((c=S[c])||(c=[_$_b861[152],_$_b861[153]]),e+=_$_b861[182]+n+_$_b861[183]+c[0]+_$_b861[59],e+=_$_b861[182]+n+_$_b861[184]+c[1]+_$_b861[59],l=d.children[h].firstChild))if(c=l.getAttribute(_$_b861[65]))(c=w[c%w.length])||(c=q),e+=_$_b861[182]+n+_$_b861[185]+c.substr(2)+_$_b861[59];else if(c=l.getAttribute(_$_b861[24]))l=l.getAttribute(_$_b861[67]),e+=_$_b861[182]+n+_$_b861[185]+J(A.color[c],parseFloat(l))+_$_b861[59];else if(c=l.getAttribute(_$_b861[68]))6<c.length&&(c=c.substr(2)),e+=_$_b861[182]+ | ||
n+_$_b861[185]+c+_$_b861[59]}e&&(m.worksheets[f].style[a]||(m.worksheets[f].style[a]=_$_b861[3]),m.worksheets[f].style[a]=e);(d=b.getAttribute(_$_b861[186]))&&(e=b.querySelector(_$_b861[187]))&&e.getAttribute(_$_b861[188])==_$_b861[125]&&(m.worksheets[f].cells||(m.worksheets[f].cells={}),m.worksheets[f].cells[a]||(m.worksheets[f].cells[a]={}),m.worksheets[f].cells[a].locked=!1);e=parseInt(b.getAttribute(_$_b861[189]));d=b.getAttribute(_$_b861[190]);if(d!=_$_b861[125]&&0<e){if(H[e])b=H[e];else if(b= | ||
t.querySelector(_$_b861[191]).querySelector(_$_b861[192]+e+_$_b861[193]))b=b.getAttribute(_$_b861[194]),P(e,b);b&&(b=b.replace(new RegExp(_$_b861[195],_$_b861[196]),_$_b861[3]),b=b.replace(new RegExp(_$_b861[197],_$_b861[196]),_$_b861[3]),b!=_$_b861[124]&&(m.worksheets[f].cells||(m.worksheets[f].cells={}),m.worksheets[f].cells[a]||(m.worksheets[f].cells[a]={}),m.worksheets[f].cells[a].type||(e=_$_b861[198],jSuites.mask&&typeof jSuites.mask.getType==_$_b861[199]&&(e=b.split(_$_b861[59]),e=jSuites.mask.getType(e[0])), | ||
m.worksheets[f].cells[a].type=e===_$_b861[200]||e===_$_b861[201]||e===_$_b861[202]||e===_$_b861[203]?_$_b861[200]:_$_b861[198]),m.worksheets[f].cells[a].format=b))}},T=[_$_b861[204],_$_b861[205]],M=function(a){for(var b=0;b<T.length;b++)a=a.replace(new RegExp(T[b],_$_b861[206]),_$_b861[3]);return a},ia={whole:_$_b861[200],decimal:_$_b861[200],list:_$_b861[207],textLength:_$_b861[208],date:_$_b861[209]},ja={notBetween:_$_b861[210],equal:_$_b861[211],notEqual:_$_b861[212],greaterThan:_$_b861[213],lessThan:_$_b861[214], | ||
greaterThanOrEqual:_$_b861[215],lessThanOrEqual:_$_b861[216]},U=function(a,b,f){Array.isArray(m.validations)||(m.validations=[]);b&&b.split(_$_b861[221]).forEach(function(e){m.validations.push(Object.assign({range:m.worksheets[a].worksheetName+_$_b861[222]+e},f))})},Z=Date.UTC(1900,0,0),aa=Date.UTC(1900,1,29),ka=function(a,b,f){m.worksheets[a].columns||(m.worksheets[a].columns=[]);b.forEach(function(e){m.worksheets[a].columns[e]||(m.worksheets[a].columns[e]={});Object.assign(m.worksheets[a].columns[e], | ||
f)})},la=function(a,b,f){m.worksheets[a].cells||(m.worksheets[a].cells={});b.forEach(function(e){m.worksheets[a].cells[e]||(m.worksheets[a].cells[e]={});Object.assign(m.worksheets[a].cells[e],f)})},da=function(a,b){a=a.querySelectorAll(_$_b861[225]);Array.from(a).forEach(function(f){var e={},d=f.getAttribute(_$_b861[17]);e.type=ia[d];if(e.type){e.allowBlank=!!f.getAttribute(_$_b861[226]);e.criteria;e.type!==_$_b861[207]&&(d=f.getAttribute(_$_b861[227]),e.criteria=ja[d]||_$_b861[217]);var c=f.querySelector(_$_b861[228]); | ||
e.value=[];if(e.type===_$_b861[207]){d=f.getAttribute(_$_b861[229]);if(c.innerHTML.startsWith(_$_b861[197])&&c.innerHTML.endsWith(_$_b861[197]))c=c.innerHTML.slice(1,-1),e.value.push(c.split(_$_b861[5]));else{if(d)return;e.value.push(c.innerHTML)}if(!d){a:{d=f.getAttribute(_$_b861[230]);c=d.split(_$_b861[223]);f={type:_$_b861[224]};Array.isArray(e.value[0])?f.source=e.value[0]:f.dynamicSource=e.value[0];if(2===c.length&&(e=k.helpers.getCoordsFromColumnName(c[1]),1048575===e[1]&&(c=k.helpers.getCoordsFromColumnName(c[0]), | ||
0===c[1]))){d=[];for(c=c[0];c<=e[0];c++)d.push(c);ka(b,d,f);break a}la(b,k.helpers.getTokensFromRange(d),f)}return}}else e.type===_$_b861[209]?(d=g(c.innerHTML),c=d.getTimezoneOffset(),d.setMinutes(d.getMinutes()+c),d=jSuites.calendar.getDateString(d,_$_b861[231]),e.value.push(d)):e.value.push(parseFloat(c.innerHTML));if(d=f.querySelector(_$_b861[232]))e.type===_$_b861[209]?(d=g(d.innerHTML),c=d.getTimezoneOffset(),d.setMinutes(d.getMinutes()+c),d=jSuites.calendar.getDateString(d,_$_b861[231]),e.value.push(d)): | ||
e.value.push(parseFloat(d.innerHTML));d=f.getAttribute(_$_b861[233]);e.action=d===_$_b861[218]?_$_b861[219]:_$_b861[220];e.text=f.getAttribute(_$_b861[234]);e.text||(e.text=f.getAttribute(_$_b861[235]));e.text||delete e.text;U(b,f.getAttribute(_$_b861[230]),e)}})},ma=[_$_b861[236],_$_b861[237]].concat([_$_b861[238],_$_b861[239],_$_b861[240],_$_b861[241],_$_b861[242]]),V={equal:_$_b861[211],notEqual:_$_b861[212],greaterThan:_$_b861[213],lessThan:_$_b861[214],greaterThanOrEqual:_$_b861[215],lessThanOrEqual:_$_b861[216], | ||
between:_$_b861[217],notBetween:_$_b861[210]},W={containsText:_$_b861[243],notContains:_$_b861[244],beginsWith:_$_b861[245],endsWith:_$_b861[246]},na=[_$_b861[40],_$_b861[247],_$_b861[177],_$_b861[248]],oa=function(a){var b={};a=a.getAttribute(_$_b861[249]);var f=t.querySelector(_$_b861[250]+(parseInt(a)+1)+_$_b861[251]);(a=f.querySelector(_$_b861[252]))&&a.getAttribute(_$_b861[68])&&(b[_$_b861[253]]=_$_b861[254]+a.getAttribute(_$_b861[68]).slice(2));(a=f.querySelector(_$_b861[255]))&&a.getAttribute(_$_b861[68])&& | ||
(b[_$_b861[64]]=_$_b861[254]+a.getAttribute(_$_b861[68]).slice(2));var e=f.querySelector(_$_b861[256]);e&&na.forEach(function(d){var c=e.querySelector(d);if(c){c=S[c.getAttribute(_$_b861[181])];var h=f.querySelector(_$_b861[64]);h=_$_b861[254]+h.getAttribute(_$_b861[68]).slice(2);b[_$_b861[182]+d]=c[1]+_$_b861[221]+c[0]+_$_b861[221]+h}});return b},ea=function(a,b){a=a.querySelectorAll(_$_b861[257]);Array.from(a).forEach(function(f){var e=f.querySelector(_$_b861[258]);if(e){var d=e.getAttribute(_$_b861[17]); | ||
if(d&&ma.includes(d)){var c={action:_$_b861[259],format:oa(e)};d===_$_b861[236]?c.type=_$_b861[260]:d===_$_b861[237]?c.type=_$_b861[261]:(d=e.getAttribute(_$_b861[227]),V[d]?(c.type=_$_b861[200],c.criteria=V[d],e=e.querySelectorAll(_$_b861[262]),c.value=Array.from(e).map(function(h){return h.innerHTML})):W[d]&&(c.type=_$_b861[198],c.criteria=W[d],e=e.getAttribute(_$_b861[198]),c.value=[e]));f=f.getAttribute(_$_b861[230]);U(b,f,c)}}})},pa=function(a){var b=[0,0],f=a.querySelector(_$_b861[263]);f&& | ||
(b=f.getAttribute(_$_b861[264]),b=-1!==b.indexOf(_$_b861[223])?b.split(_$_b861[223])[1]:b,b=k.helpers.getCoordsFromColumnName(b));f=a.querySelectorAll(_$_b861[265]);var e=1;Array.from(f).forEach(function(c){c=parseInt(c.getAttribute(_$_b861[266]));c>e&&(e=c)});e--;a=a.querySelectorAll(_$_b861[267]);var d=_$_b861[268];Array.from(a).forEach(function(c){c=c.getAttribute(_$_b861[266]);c=/^\D+/.exec(c);c[0].length>=d.length&&c[0]>d&&(d=c[0])});a=[k.helpers.getCoordsFromColumnName(d)[0],e];a=[Math.max(b[0], | ||
a[0]),Math.max(b[1],a[1])];a[0]++;a[1]++;return a},ca=function(a,b,f){var e=I(_$_b861[18]),d=[],c=[],h=pa(a);m.worksheets[b].minDimensions=h;for(var l=0;l<h[1];l++){d[l]=[];for(var n=0;n<h[0];n++)d[l][n]=_$_b861[3]}if(10<h[0]||100<h[1])300<h[1]&&(m.worksheets[b].lazyLoading=!0),m.worksheets[b].tableOverflow=!0,m.worksheets[b].tableHeight=_$_b861[269],m.worksheets[b].tableWidth=_$_b861[269],m.worksheets[b].resize=_$_b861[270];5>h[0]&&(h[0]=5);5>h[1]&&(h[1]=5);if(l=a.querySelector(_$_b861[271]))for(m.worksheets[b].columns= | ||
[],n=0;n<l.children.length;n++){for(var p=parseInt(l.children[n].getAttribute(_$_b861[272])),x=parseInt(l.children[n].getAttribute(_$_b861[273])),y=Math.round(7.15*parseInt(l.children[n].getAttribute(_$_b861[274])))+_$_b861[275],B=parseInt(l.children[n].getAttribute(_$_b861[44]));p-1!==m.worksheets[b].columns.length;)m.worksheets[b].columns.push({type:_$_b861[198]});for(;p<=x&&p<=h[0];p++){var u={width:y};1===B&&(u.type=_$_b861[198],u.visible=!1);m.worksheets[b].columns.push(u)}}if(l=a.querySelector(_$_b861[276]))for(m.worksheets[b].mergeCells= | ||
{},n=0;n<l.children.length;n++)h=l.children[n].getAttribute(_$_b861[264]).split(_$_b861[223]),x=k.helpers.getCoordsFromColumnName(h[0]),y=k.helpers.getCoordsFromColumnName(h[1]),m.worksheets[b].mergeCells[h[0]]=[y[0]-x[0]+1,y[1]-x[1]+1];h=t.querySelector(_$_b861[277]);x=a.querySelector(_$_b861[278]);y=[];for(l=0;l<x.children.length;l++){B=x.children[l];n=B.getAttribute(_$_b861[266])-1;p=B.getAttribute(_$_b861[279]);u=B.getAttribute(_$_b861[44]);if(p||u)m.worksheets[b].rows||(m.worksheets[b].rows= | ||
{}),m.worksheets[b].rows[n]||(m.worksheets[b].rows[n]={}),p&&(m.worksheets[b].rows[n].height=Math.ceil(1.333333333*parseFloat(p))),u===_$_b861[280]&&(m.worksheets[b].rows[n].visible=!1);for(n=0;n<B.children.length;n++){var z=B.children[n];u=z.getAttribute(_$_b861[266]);var v=z.getAttribute(_$_b861[48]);p=z.getAttribute(_$_b861[281]);0<p&&ha(u,h.children[p],b);p=k.helpers.getCoordsFromColumnName(u);p=[parseInt(p[0]),parseInt(p[1])];if(!y.includes(u))if(v===_$_b861[281])d[p[1]][p[0]]=r[z.firstChild.innerHTML]; | ||
else if(v===_$_b861[282])u=z.querySelector(_$_b861[283]),d[p[1]][p[0]]=u.innerHTML;else if(u=z.getElementsByTagName(_$_b861[284])[0],z=z.getElementsByTagName(_$_b861[285])[0],u)if(v=null,z=u.getAttribute(_$_b861[264]),v=u.getAttribute(_$_b861[48]),v==_$_b861[286])c[p[1]]||(c[p[1]]=[]),v=_$_b861[211]+M(u.firstChild.nodeValue),d[p[1]][p[0]]=v,c[p[1]][p[0]]=v,p=-1!==z.indexOf(_$_b861[223])?k.helpers.getTokensFromRange(z):[z],y=y.concat(p);else if(v==_$_b861[287]){if(z){v=z.split(_$_b861[223]);v=[k.helpers.getCoordsFromColumnName(v[0]), | ||
k.helpers.getCoordsFromColumnName(v[1])];z=[parseInt(v[0][0]),parseInt(v[0][1])];v=[parseInt(v[1][0]),parseInt(v[1][1])];Number.isNaN(v[0])&&(v[0]=z[0]);Number.isNaN(v[1])&&(v[1]=z[1]);for(var G=z[1];G<=v[1];G++){c[G]||(c[G]=[]);for(var K=z[0];K<=v[0];K++)c[G][K]=_$_b861[211]+k.helpers.shiftFormula(M(u.textContent),K-z[0],G-z[1])}}c[p[1]]&&c[p[1]][p[0]]&&(d[p[1]][p[0]]=c[p[1]][p[0]])}else d[p[1]][p[0]]=_$_b861[211]+M(u.firstChild.nodeValue);else z&&(v=z.innerHTML,Number(v)==v&&(v=Number(v)),d[p[1]][p[0]]= | ||
v)}}e=e[b].name;var qa=e.slice(0,13)+_$_b861[288]+e.slice(13)+_$_b861[289];e=E.findIndex(function(ra){return ra.name===qa});if(-1<e){e=C(f[e]);if(c=a.querySelector(_$_b861[290]))for(n=0;n<c.children.length;n++)if(l=c.children[n].getAttribute(_$_b861[291]))l=e.querySelector(_$_b861[292]+l+_$_b861[293]),l=l.getAttribute(_$_b861[294]),h=c.children[n].getAttribute(_$_b861[264]),m.worksheets[b].cells[h]?(m.worksheets[b].cells[h].type=_$_b861[295],m.worksheets[b].cells[h].options={url:l}):m.worksheets[b].cells[h]= | ||
{type:_$_b861[295],options:{url:l}};c=a.querySelectorAll(_$_b861[29]);for(n=0;n<c.length;n++)if(l=c[n].getAttribute(_$_b861[291]),l=e.querySelector(_$_b861[292]+l+_$_b861[293]),h=l.getAttribute(_$_b861[294]),h=_$_b861[296]+h.slice(h.lastIndexOf(_$_b861[297])),l=F(h,_$_b861[42]),l=C(f[l]),x=l.querySelector(_$_b861[298]))x=x.getAttribute(_$_b861[299]),h=h.slice(0,12)+_$_b861[300]+h.slice(12)+_$_b861[289],h=F(h,_$_b861[42]),h=C(f[h]).querySelector(_$_b861[301]+x+_$_b861[193]).getAttribute(_$_b861[294]), | ||
h=_$_b861[296]+h.slice(h.lastIndexOf(_$_b861[302])),h=F(h,_$_b861[42]),m.worksheets[b].media||(m.worksheets[b].media=[]),p=l.querySelector(_$_b861[303]),x=l.querySelector(_$_b861[304]),l=l.querySelector(_$_b861[305]),l=[l.querySelector(_$_b861[306]),l.querySelector(_$_b861[307])],l=[parseInt(l[0].innerHTML),parseInt(l[1].innerHTML)],y=k.helpers.getColumnNameFromCoords(l[0],l[1]),d[l[1]]||(d[l[1]]=[]),B=parseInt(x.getAttribute(_$_b861[308]))/9525,x=parseInt(x.getAttribute(_$_b861[309]))/9525,d[l[1]][l[0]]= | ||
_$_b861[310]+f[h],m.worksheets[b].cells[y]={type:_$_b861[35],options:{absolute:!0,width:B,height:x}}}m.worksheets[b].data=d;if(a=a.querySelector(_$_b861[311]))f=a.getAttribute(_$_b861[312]),f==_$_b861[280]&&(m.worksheets[b].locked=!0,f=a.getAttribute(_$_b861[313]),f!=_$_b861[125]&&(m.worksheets[b].columnSorting=!1),f=a.getAttribute(_$_b861[314]),f!=_$_b861[125]&&(m.worksheets[b].allowInsertRow=!1),f=a.getAttribute(_$_b861[315]),f!=_$_b861[125]&&(m.worksheets[b].allowDeleteRow=!1),f=a.getAttribute(_$_b861[316]), | ||
f!=_$_b861[125]&&(m.worksheets[b].allowInsertColumn=!1),f=a.getAttribute(_$_b861[317]),f!=_$_b861[125]&&(m.worksheets[b].allowDeleteColumn=!1),f=a.getAttribute(_$_b861[318]),f==_$_b861[280]&&(m.worksheets[b].selectUnLockedCells=!1),f=a.getAttribute(_$_b861[319]),f==_$_b861[280]&&(m.worksheets[b].selectLockedCells=!1),m.worksheets[b].columnDrag=!1,m.worksheets[b].rowDrag=!1);for(l=0;l<m.worksheets[b].data.length;l++)for(m.worksheets[b].data[l]||(m.worksheets[b].data[l]=[]),n=0;n<m.worksheets[b].columns.length;n++)if(null=== | ||
m.worksheets[b].data[l][n]||void 0===m.worksheets[b].data[l][n])m.worksheets[b].data[l][n]=_$_b861[3];m.worksheets[b].minDimensions[0]<n&&(m.worksheets[b].minDimensions[0]=n);m.worksheets[b].minDimensions[1]<l&&(m.worksheets[b].minDimensions[1]=l);1E3>m.worksheets[b].minDimensions[1]&&(m.worksheets[b].textOverflow=!0)},sa=_$_b861[323],fa=function(a){for(var b=I(_$_b861[33]),f=0;f<b.length;f++){var e=C(a[E.indexOf(b[f])]).querySelector(_$_b861[324]);if(e){var d=b[f].name.replace(_$_b861[288],_$_b861[3]); | ||
d=d.replace(_$_b861[289],_$_b861[3]);var c=I(_$_b861[18]).findIndex(function(n){return n.name===d}),h=e.getAttribute(_$_b861[294]).slice(3);h=_$_b861[296]+h;e=E.findIndex(function(n){return n.name===h});var l={};e=C(a[e]).querySelector(_$_b861[325]).children;Array.from(e).forEach(function(n){var p=n.querySelector(_$_b861[48]);p&&(p=p.innerHTML,p.startsWith(sa)||(n=n.getAttribute(_$_b861[264]),l[n]=p))});Object.keys(l).length&&(m.worksheets[c].allowComments=!0,m.worksheets[c].comments=l)}}},J=function(a, | ||
b){if(!b)return a;b=parseFloat(b);a=a.slice(a[0]===_$_b861[254]?1:0).slice(0,6);var f=[parseInt(a.slice(0,2),16),parseInt(a.slice(2,4),16),parseInt(a.slice(4,6),16)];a=f[0]/255;var e=f[1]/255;f=f[2]/255;var d=Math.max(a,e,f),c=Math.min(a,e,f),h=d-c;if(0===h)a=[0,0,a];else{var l=0;c=d+c;switch(d){case a:l=((e-f)/h+6)%6;break;case e:l=(f-a)/h+2;break;case f:l=(a-e)/h+4}a=[l/6,h/(1<c?2-c:c),c/2]}a[2]=0>b?a[2]*(1+b):1-(1-a[2])*(1-b);e=a[1];b=a[2];f=2*e*(.5>b?b:1-b);b-=f/2;b=[b,b,b];a=6*a[0];if(0!==e)switch(a| | ||
0){case 0:case 6:b[0]+=f;b[1]+=f*a;break;case 1:b[0]+=f*(2-a);b[1]+=f;break;case 2:b[1]+=f;b[2]+=f*(a-2);break;case 3:b[1]+=f*(4-a);b[2]+=f;break;case 4:b[2]+=f;b[0]+=f*(a-4);break;case 5:b[2]+=f*(6-a),b[0]+=f}for(a=0;3!=a;++a)b[a]=Math.round(255*b[a]);a=0;for(e=1;3!=a;++a)e=256*e+(255<b[a]?255:0>b[a]?0:b[a]);return e.toString(16).toUpperCase().slice(1)},X=0,Y=function(a){null===k&&(k=this);t=r=null;w=[];A={color:[]};m={worksheets:[]};E=[];L=[];var b=N.label();if(b){X++;if(5<X)return alert(b),!1; | ||
console.log(b)}var f=new JSZip;a.url?jSuites.ajax({url:a.url,method:_$_b861[326],dataType:_$_b861[327],success:function(e){f.loadAsync(e).then(function(d){return $jscomp.asyncExecutePromiseGeneratorFunction(function*(){yield R(d,a)})}).catch(function(d){console.error(d);jSuites.loading.hide();if(typeof a.onerror==_$_b861[199])a.onerror(d)})}}):a.file&&f.loadAsync(a.file).then(function(e){return $jscomp.asyncExecutePromiseGeneratorFunction(function*(){yield R(e,a)})}).catch(function(e){console.error(e); | ||
jSuites.loading.hide();if(typeof a.onerror==_$_b861[199])a.onerror(e)})};Y.license=function(a){N(a)};return Y}); |
@@ -34,3 +34,3 @@ { | ||
"types": "dist/index.d.ts", | ||
"version": "2.7.1", | ||
"version": "2.7.2", | ||
"bugs": "https://github.com/jspreadsheet/pro/issues", | ||
@@ -37,0 +37,0 @@ "homepage": "https://github.com/jspreadsheet/pro", |
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
Long strings
Supply chain riskContains long string literals, which may be a sign of obfuscated or packed code.
Found 1 instance in 1 package
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
Long strings
Supply chain riskContains long string literals, which may be a sign of obfuscated or packed code.
Found 1 instance in 1 package
39906
200