@jspreadsheet/parser
Advanced tools
Comparing version 2.5.0 to 2.5.1
/** | ||
* Jspreadsheet XLSX parser 2.5.0 | ||
* Jspreadsheet XLSX parser 2.5.1 | ||
* https://JSS.com/v8/plugins/parser | ||
@@ -19,3 +19,3 @@ * @License: this plugin requires a license | ||
$jscomp.polyfillUnisolated=function(g,l,q,t){q=$jscomp.global;g=g.split(".");for(t=0;t<g.length-1;t++){var v=g[t];if(!(v in q))return;q=q[v]}g=g[g.length-1];t=q[g];l=l(t);l!=t&&null!=l&&$jscomp.defineProperty(q,g,{configurable:!0,writable:!0,value:l})}; | ||
$jscomp.polyfillIsolated=function(g,l,q,t){var v=g.split(".");g=1===v.length;t=v[0];t=!g&&t in $jscomp.polyfills?$jscomp.polyfills:$jscomp.global;for(var y=0;y<v.length-1;y++){var z=v[y];if(!(z in t))return;t=t[z]}v=v[v.length-1];q=$jscomp.IS_SYMBOL_NATIVE&&"es6"===q?t[v]:null;l=l(q);null!=l&&(g?$jscomp.defineProperty($jscomp.polyfills,v,{configurable:!0,writable:!0,value:l}):l!==q&&(void 0===$jscomp.propertyToPolyfillSymbol[v]&&(q=1E9*Math.random()>>>0,$jscomp.propertyToPolyfillSymbol[v]=$jscomp.IS_SYMBOL_NATIVE? | ||
$jscomp.polyfillIsolated=function(g,l,q,t){var v=g.split(".");g=1===v.length;t=v[0];t=!g&&t in $jscomp.polyfills?$jscomp.polyfills:$jscomp.global;for(var y=0;y<v.length-1;y++){var A=v[y];if(!(A in t))return;t=t[A]}v=v[v.length-1];q=$jscomp.IS_SYMBOL_NATIVE&&"es6"===q?t[v]:null;l=l(q);null!=l&&(g?$jscomp.defineProperty($jscomp.polyfills,v,{configurable:!0,writable:!0,value:l}):l!==q&&(void 0===$jscomp.propertyToPolyfillSymbol[v]&&(q=1E9*Math.random()>>>0,$jscomp.propertyToPolyfillSymbol[v]=$jscomp.IS_SYMBOL_NATIVE? | ||
$jscomp.global.Symbol(v):$jscomp.POLYFILL_PREFIX+q+"$"+v),$jscomp.defineProperty(t,$jscomp.propertyToPolyfillSymbol[v],{configurable:!0,writable:!0,value:l})))};$jscomp.underscoreProtoCanBeSet=function(){var g={a:!0},l={};try{return l.__proto__=g,l.a}catch(q){}return!1}; | ||
@@ -37,52 +37,52 @@ $jscomp.setPrototypeOf=$jscomp.TRUST_ES6_POLYFILLS&&"function"==typeof Object.setPrototypeOf?Object.setPrototypeOf:$jscomp.underscoreProtoCanBeSet()?function(g,l){g.__proto__=l;if(g.__proto__!==l)throw new TypeError(g+" is not extensible");return g}:null;$jscomp.arrayIteratorImpl=function(g){var l=0;return function(){return l<g.length?{done:!1,value:g[l++]}:{done:!0}}};$jscomp.arrayIterator=function(g){return{next:$jscomp.arrayIteratorImpl(g)}}; | ||
$jscomp.generator.Generator_=function(g){this.next=function(l){return g.next_(l)};this.throw=function(l){return g.throw_(l)};this.return=function(l){return g.return_(l)};this[Symbol.iterator]=function(){return this}};$jscomp.generator.createGenerator=function(g,l){l=new $jscomp.generator.Generator_(new $jscomp.generator.Engine_(l));$jscomp.setPrototypeOf&&g.prototype&&$jscomp.setPrototypeOf(l,g.prototype);return l}; | ||
$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(z){z.done?t(z.value):Promise.resolve(z.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 _$_c488='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>{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{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===_$_c488[323]&&typeof module!==_$_c488[4]?module.exports=l():typeof define===_$_c488[197]&&define.amd?define(l):g.parser=l()})(this,function(){function g(a){a=Z+864E5*a;a>=aa&&(a-=864E5);return new Date(a)}_$_c488[0];var l=null,q=_$_c488[2],t=null,v=null,y=[],z={},m={},D=[],L=[],N=function(){var a=function(d){a.license=d;a.run()};a.k=[74,50,48,50,48,33].join(_$_c488[3]);a.apply=function(d,e){var h=jSuites.sha512,f=_$_c488[3],b=_$_c488[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==_$_c488[4]){a.result=1;try{if(a.license){var d=window.atob(a.license);d=d.split(_$_c488[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||_$_c488[6],h=e.split(_$_c488[7]);e=e.split(_$_c488[7]);2<e.length&&!jSuites.isNumeric(e[e.length-1])&&h.shift(); | ||
h=h.join(_$_c488[7]);e=e.join(_$_c488[7]);-1==d[1].domain.indexOf(h)&&-1==d[1].domain.indexOf(e)?a.result=4:d[1].scope&&0<=d[1].scope.indexOf(_$_c488[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=_$_c488[3];a.result&&1!=a.result?2==a.result||3==a.result||4==a.result?d=_$_c488[10]:5==a.result&&(d=_$_c488[11]):d=_$_c488[9];return d};a.status=function(){return a.result};return a}(),C=function(a){a=(new DOMParser).parseFromString(a, | ||
_$_c488[12]);if(a.querySelector(_$_c488[13]))throw Error(_$_c488[14]);return a.firstChild},E=function(a,d,e,h=_$_c488[15]){L.push(e.file(a)[_$_c488[16]](h));D.push({name:a,type:d})},F=function(a,d){d||(d=_$_c488[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===_$_c488[7]?I[a]=d:(d=d.split(_$_c488[3]).map(function(e){return e===_$_c488[5]?_$_c488[7]:e===_$_c488[7]?_$_c488[5]:e}),I[a]=d.join(_$_c488[3]))},ba=function(a){I= | ||
{};O=a?(new Intl.NumberFormat(a)).format(1.1).slice(1,2):_$_c488[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(_$_c488[18],_$_c488[19],a);E(_$_c488[20],_$_c488[21],a);a.file(_$_c488[22])&&E(_$_c488[22],_$_c488[23],a);a.file(_$_c488[24])&&E(_$_c488[24],_$_c488[25],a);var e=Object.keys(a.files),h=e.filter(function(f){return 0===f.indexOf(_$_c488[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,_$_c488[27],a)});e.forEach(function(f){f.includes(_$_c488[28])?E(f,_$_c488[29],a):f.includes(_$_c488[30])?E(f,_$_c488[31],a):f.includes(_$_c488[32])?E(f,_$_c488[33],a):f.includes(_$_c488[34])?E(f,_$_c488[35],a,_$_c488[36]):f.includes(_$_c488[37])&&E(f,_$_c488[38],a)});yield Promise.all(L).then(function(f){var b=F(_$_c488[19]),c=C(f[b]),k=c.querySelector(_$_c488[39]);for(b=0;b<k.children.length;b++){var n={data:[], | ||
columns:[],cells:{},style:{},stripHTML:!1,defaultColAlign:_$_c488[40],defaultColWidth:_$_c488[41],worksheetName:k.children[b].getAttribute(_$_c488[42])},p=k.children[b].getAttribute(_$_c488[43]);p&&p===_$_c488[44]&&(n.worksheetState=_$_c488[44]);m.worksheets.push(n)}if(c=c.querySelector(_$_c488[45]))for(m.definedNames={},b=0;b<c.children.length;b++)c.children[b].getAttribute(_$_c488[44])||c.children[b].getAttribute(_$_c488[46])||(m.definedNames[c.children[b].getAttribute(_$_c488[42]).toUpperCase()]= | ||
c.children[b].firstChild.nodeValue);b=G(_$_c488[27]);for(c=0;c<b.length;c++)C(f[D.indexOf(b[c])]).querySelector(_$_c488[74])&&(m.worksheets[c].gridLine=!1);b=F(_$_c488[21]);b=C(f[b]);if((c=b.querySelector(_$_c488[75]))&&c.children)for(k=0;k<c.children.length;k++)y.push(c.children[k].getAttribute(_$_c488[67]));else y=[_$_c488[76],_$_c488[77],_$_c488[78],_$_c488[79],_$_c488[80],_$_c488[81],_$_c488[82],_$_c488[83],_$_c488[76],_$_c488[77],_$_c488[78],_$_c488[79],_$_c488[80],_$_c488[81],_$_c488[82],_$_c488[83], | ||
_$_c488[84],_$_c488[85],_$_c488[86],_$_c488[87],_$_c488[88],_$_c488[89],_$_c488[90],_$_c488[91],_$_c488[92],_$_c488[93],_$_c488[94],_$_c488[95],_$_c488[96],_$_c488[97],_$_c488[98],_$_c488[99],_$_c488[86],_$_c488[82],_$_c488[81],_$_c488[83],_$_c488[88],_$_c488[84],_$_c488[89],_$_c488[80],_$_c488[100],_$_c488[95],_$_c488[101],_$_c488[102],_$_c488[103],_$_c488[104],_$_c488[105],_$_c488[106],_$_c488[107],_$_c488[108],_$_c488[109],_$_c488[110],_$_c488[111],_$_c488[112],_$_c488[113],_$_c488[114],_$_c488[115], | ||
_$_c488[116],_$_c488[117],_$_c488[118],_$_c488[119],_$_c488[93],_$_c488[120],_$_c488[121]];v=b;b=F(_$_c488[23]);if(!(0>b)){b=C(f[b]).firstChild.firstChild.children;for(c=0;c<b.length;c++){k=b[c].firstChild.getAttribute(_$_c488[53]);if(k===_$_c488[70]||k===_$_c488[71])k=b[c].firstChild.getAttribute(_$_c488[72]);z.color.push(k)}0<=b[0].tagName.indexOf(_$_c488[73])&&(c=z.color[0],z.color[0]=z.color[1],z.color[1]=c);0<=b[2].tagName.indexOf(_$_c488[73])&&(c=z.color[2],z.color[2]=z.color[3],z.color[3]= | ||
c)}b=F(_$_c488[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===_$_c488[47])n.firstChild.firstChild?c.push(n.firstChild.firstChild.nodeValue):c.push(_$_c488[3]);else{p=_$_c488[3];for(var r=0;r<n.children.length;r++){var u=n.children[r].querySelector(_$_c488[48]);if(u){p+=_$_c488[49];var B=n.children[r].querySelector(_$_c488[47]);B.getAttribute(_$_c488[50])||(p+=_$_c488[51]);var x=u.querySelector(_$_c488[52]);x&&(x=4*x.getAttribute(_$_c488[53])/ | ||
3,p+=_$_c488[54]+Math.round(x)+_$_c488[55]);(x=u.querySelector(_$_c488[56]))&&(p+=_$_c488[57]+x.getAttribute(_$_c488[53])+_$_c488[58]);u.querySelector(_$_c488[59])&&(p+=_$_c488[60]);u.querySelector(_$_c488[61])&&(p+=_$_c488[62]);if(x=u.querySelector(_$_c488[63]))if(u=x.getAttribute(_$_c488[64]))p+=_$_c488[65]+y[u].substr(2)+_$_c488[58];else if(u=x.getAttribute(_$_c488[23]))x=x.getAttribute(_$_c488[66]),p+=_$_c488[65]+J(z.color[u],parseFloat(x))+_$_c488[58];else if(u=x.getAttribute(_$_c488[67]))p+= | ||
_$_c488[65]+u.substr(2)+_$_c488[58];p+=_$_c488[68]+B.innerHTML+_$_c488[69]}else if(B=n.children[r].querySelector(_$_c488[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(_$_c488[27]);for(c=0;c<b.length;c++)if(k=C(f[D.indexOf(b[c])]).querySelector(_$_c488[313]))n=k.getAttribute(_$_c488[314]),null!==n&&(m.worksheets[c].freezeColumns=parseInt(n)),k=k.getAttribute(_$_c488[315]),null!==k&&(m.worksheets[c].freezeRows=parseInt(k));fa(f);d.license&&(m.license= | ||
d.license);d.onload(m);jSuites.loading.hide()})})},Q={0:_$_c488[122],1:_$_c488[123],2:_$_c488[124],3:_$_c488[125],4:_$_c488[126],9:_$_c488[127],10:_$_c488[128],11:_$_c488[129],12:_$_c488[130],13:_$_c488[131],14:_$_c488[132],15:_$_c488[133],16:_$_c488[134],17:_$_c488[135],18:_$_c488[136],19:_$_c488[137],20:_$_c488[138],21:_$_c488[139],22:_$_c488[140],37:_$_c488[141],38:_$_c488[142],39:_$_c488[143],40:_$_c488[144],45:_$_c488[145],46:_$_c488[146],47:_$_c488[147],48:_$_c488[148],49:_$_c488[149],56:_$_c488[3], | ||
65535:_$_c488[122]},O,I={},S={thin:[_$_c488[150],_$_c488[151]],medium:[_$_c488[150],_$_c488[152]],thick:[_$_c488[150],_$_c488[153]],dotted:[_$_c488[154],_$_c488[151]],dashed:[_$_c488[155],_$_c488[151]],double:[_$_c488[156],_$_c488[151]],mediumDashed:[_$_c488[155],_$_c488[152]]},ha=function(a,d,e){var h=_$_c488[3];var f=parseInt(d.getAttribute(_$_c488[157]));if(!isNaN(f)&&(f=v.querySelector(_$_c488[158]).children[f],f.firstChild.getAttribute(_$_c488[159])===_$_c488[150])){f=f.firstChild.firstChild; | ||
var b=f.getAttribute(_$_c488[64]);if(y&&y[b])h+=_$_c488[160]+y[b].substr(2)+_$_c488[58];else if(b=f.getAttribute(_$_c488[23]))f=f.getAttribute(_$_c488[66]),h+=_$_c488[160]+J(z.color[b],parseFloat(f))+_$_c488[58];else if(b=f.getAttribute(_$_c488[67]))h+=_$_c488[160]+b.substr(2)+_$_c488[58]}f=parseInt(d.getAttribute(_$_c488[161]));if(!isNaN(f)){f=v.querySelector(_$_c488[162]).children[f];var c=f.querySelector(_$_c488[52]);c&&(c=parseFloat(c.getAttribute(_$_c488[53])),h+=_$_c488[54]+Math.round(4*c/3)+ | ||
_$_c488[55]);f.querySelector(_$_c488[59])&&(h+=_$_c488[60]);f.querySelector(_$_c488[61])&&(h+=_$_c488[62]);(c=f.querySelector(_$_c488[42]))&&(h+=_$_c488[57]+c.getAttribute(_$_c488[53])+_$_c488[58]);var k=f.querySelector(_$_c488[63]);k&&(b=k.getAttribute(_$_c488[64]),y&&y[b]?h+=_$_c488[65]+y[b].substr(2)+_$_c488[58]:(b=k.getAttribute(_$_c488[23]))?(k=k.getAttribute(_$_c488[66]),h+=_$_c488[65]+J(z.color[b],parseFloat(k))+_$_c488[58]):(b=k.getAttribute(_$_c488[67]))&&b&&(h+=_$_c488[65]+b.substr(2)+_$_c488[58]))}if(f= | ||
d.querySelector(_$_c488[163])){(c=f.getAttribute(_$_c488[164]))&&(h+=_$_c488[165]+c+_$_c488[58]);if(c=f.getAttribute(_$_c488[166]))c===_$_c488[167]&&(c=_$_c488[168]),h+=_$_c488[169]+c+_$_c488[58];f.getAttribute(_$_c488[170])&&(h+=_$_c488[171]);if(f=f.getAttribute(_$_c488[172]))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(_$_c488[173]));if(!isNaN(f))for(f=v.querySelector(_$_c488[174]).children[f], | ||
c=0;c<f.children.length;c++){var n=f.children[c].tagName;if(n===_$_c488[175]){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(_$_c488[176])))continue}else if(n===_$_c488[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(_$_c488[177]))))continue;if(n!==_$_c488[178]&&(b=f.children[c].getAttribute(_$_c488[179]))&& | ||
((b=S[b])||(b=[_$_c488[150],_$_c488[151]]),h+=_$_c488[180]+n+_$_c488[181]+b[0]+_$_c488[58],h+=_$_c488[180]+n+_$_c488[182]+b[1]+_$_c488[58],k=f.children[c].firstChild))if(b=k.getAttribute(_$_c488[64]))(b=y[b%y.length])||(b=q),h+=_$_c488[180]+n+_$_c488[183]+b.substr(2)+_$_c488[58];else if(b=k.getAttribute(_$_c488[23]))k=k.getAttribute(_$_c488[66]),h+=_$_c488[180]+n+_$_c488[183]+J(z.color[b],parseFloat(k))+_$_c488[58];else if(b=k.getAttribute(_$_c488[67]))6<b.length&&(b=b.substr(2)),h+=_$_c488[180]+ | ||
n+_$_c488[183]+b+_$_c488[58]}h&&(m.worksheets[e].style[a]||(m.worksheets[e].style[a]=_$_c488[3]),m.worksheets[e].style[a]=h);(f=d.getAttribute(_$_c488[184]))&&(h=d.querySelector(_$_c488[185]))&&h.getAttribute(_$_c488[186])==_$_c488[123]&&(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(_$_c488[187]));f=d.getAttribute(_$_c488[188]);if(f!=_$_c488[123]&&0<h){if(I[h])d=I[h];else if(d= | ||
v.querySelector(_$_c488[189]).querySelector(_$_c488[190]+h+_$_c488[191]))d=d.getAttribute(_$_c488[192]),P(h,d);d&&(d=d.replace(new RegExp(_$_c488[193],_$_c488[194]),_$_c488[3]),d=d.replace(new RegExp(_$_c488[195],_$_c488[194]),_$_c488[3]),d!=_$_c488[122]&&(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=_$_c488[196],jSuites.mask&&typeof jSuites.mask.getType==_$_c488[197]&&(h=d.split(_$_c488[58]),h=jSuites.mask.getType(h[0])), | ||
m.worksheets[e].cells[a].type=h===_$_c488[198]||h===_$_c488[199]||h===_$_c488[200]||h===_$_c488[201]?_$_c488[198]:_$_c488[196]),m.worksheets[e].cells[a].format=d))}},T=[_$_c488[202],_$_c488[203]],M=function(a){for(var d=0;d<T.length;d++)a=a.replace(new RegExp(T[d],_$_c488[204]),_$_c488[3]);return a},ia={whole:_$_c488[198],decimal:_$_c488[198],list:_$_c488[205],textLength:_$_c488[206],date:_$_c488[207]},ja={notBetween:_$_c488[208],equal:_$_c488[209],notEqual:_$_c488[210],greaterThan:_$_c488[211],lessThan:_$_c488[212], | ||
greaterThanOrEqual:_$_c488[213],lessThanOrEqual:_$_c488[214]},U=function(a,d,e){Array.isArray(m.validations)||(m.validations=[]);d&&d.split(_$_c488[219]).forEach(function(h){m.validations.push(Object.assign({range:m.worksheets[a].worksheetName+_$_c488[220]+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(_$_c488[27]),e=0;e<d.length;e++){var h=C(a[D.indexOf(d[e])]).querySelectorAll(_$_c488[223]);Array.from(h).forEach(function(f){var b={},c=f.getAttribute(_$_c488[17]);b.type=ia[c];if(b.type){b.allowBlank=!!f.getAttribute(_$_c488[224]);b.criteria;b.type!==_$_c488[205]&&(c=f.getAttribute(_$_c488[225]), | ||
b.criteria=ja[c]||_$_c488[215]);var k=f.querySelector(_$_c488[226]);b.value=[];if(b.type===_$_c488[205]){c=f.getAttribute(_$_c488[227]);if(k.innerHTML.startsWith(_$_c488[195])&&k.innerHTML.endsWith(_$_c488[195]))k=k.innerHTML.slice(1,-1),b.value.push(k.split(_$_c488[5]));else{if(c)return;b.value.push(k.innerHTML)}if(!c){a:{c=e;k=f.getAttribute(_$_c488[228]);var n=k.split(_$_c488[221]);f={type:_$_c488[222]};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===_$_c488[207]?(c=g(k.innerHTML),k=c.getTimezoneOffset(),c.setMinutes(c.getMinutes()+k),c=jSuites.calendar.getDateString(c,_$_c488[229]),b.value.push(c)):b.value.push(parseFloat(k.innerHTML));if(c=f.querySelector(_$_c488[230]))b.type===_$_c488[207]?(c=g(c.innerHTML),k=c.getTimezoneOffset(), | ||
c.setMinutes(c.getMinutes()+k),c=jSuites.calendar.getDateString(c,_$_c488[229]),b.value.push(c)):b.value.push(parseFloat(c.innerHTML));c=f.getAttribute(_$_c488[231]);b.action=c===_$_c488[216]?_$_c488[217]:_$_c488[218];b.text=f.getAttribute(_$_c488[232]);b.text||(b.text=f.getAttribute(_$_c488[233]));b.text||delete b.text;U(e,f.getAttribute(_$_c488[228]),b)}})}},ma=[_$_c488[234],_$_c488[235]].concat([_$_c488[236],_$_c488[237],_$_c488[238],_$_c488[239],_$_c488[240]]),V={equal:_$_c488[209],notEqual:_$_c488[210], | ||
greaterThan:_$_c488[211],lessThan:_$_c488[212],greaterThanOrEqual:_$_c488[213],lessThanOrEqual:_$_c488[214],between:_$_c488[215],notBetween:_$_c488[208]},W={containsText:_$_c488[241],notContains:_$_c488[242],beginsWith:_$_c488[243],endsWith:_$_c488[244]},na=[_$_c488[40],_$_c488[245],_$_c488[175],_$_c488[246]],oa=function(a){var d={};a=a.getAttribute(_$_c488[247]);var e=v.querySelector(_$_c488[248]+(parseInt(a)+1)+_$_c488[249]);(a=e.querySelector(_$_c488[250]))&&a.getAttribute(_$_c488[67])&&(d[_$_c488[251]]= | ||
_$_c488[252]+a.getAttribute(_$_c488[67]).slice(2));(a=e.querySelector(_$_c488[253]))&&a.getAttribute(_$_c488[67])&&(d[_$_c488[63]]=_$_c488[252]+a.getAttribute(_$_c488[67]).slice(2));var h=e.querySelector(_$_c488[254]);h&&na.forEach(function(f){var b=h.querySelector(f);if(b){b=S[b.getAttribute(_$_c488[179])];var c=e.querySelector(_$_c488[63]);c=_$_c488[252]+c.getAttribute(_$_c488[67]).slice(2);d[_$_c488[180]+f]=b[1]+_$_c488[219]+b[0]+_$_c488[219]+c}});return d},ea=function(a){for(var d=G(_$_c488[27]), | ||
e=0;e<d.length;e++){var h=C(a[D.indexOf(d[e])]).querySelectorAll(_$_c488[255]);Array.from(h).forEach(function(f){var b=f.querySelector(_$_c488[256]);if(b){var c=b.getAttribute(_$_c488[17]);if(c&&ma.includes(c)){var k={action:_$_c488[257],format:oa(b)};c===_$_c488[234]?k.type=_$_c488[258]:c===_$_c488[235]?k.type=_$_c488[259]:(c=b.getAttribute(_$_c488[225]),V[c]?(k.type=_$_c488[198],k.criteria=V[c],b=b.querySelectorAll(_$_c488[260]),k.value=Array.from(b).map(function(n){return n.innerHTML})):W[c]&& | ||
(k.type=_$_c488[196],k.criteria=W[c],b=b.getAttribute(_$_c488[196]),k.value=[b]));f=f.getAttribute(_$_c488[228]);U(e,f,k)}}})}},pa=function(a){var d=[0,0],e=a.querySelector(_$_c488[261]);e&&(d=e.getAttribute(_$_c488[262]),d=-1!==d.indexOf(_$_c488[221])?d.split(_$_c488[221])[1]:d,d=l.helpers.getCoordsFromColumnName(d));var h=[0,0];a=a.querySelectorAll(_$_c488[263]);a=Array.from(a).map(function(f){return l.helpers.getCoordsFromColumnName(f.getAttribute(_$_c488[264]))});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(_$_c488[27]),e=0;e<d.length;e++){var h=[],f=[],b=C(a[D.indexOf(d[e])]),c=pa(b);console.log(c);console.log(l.helpers.getColumnNameFromCoords(c[0]-1,c[1]-1));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]=_$_c488[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= | ||
_$_c488[265],m.worksheets[e].resize=_$_c488[266],10<c[0]&&(m.worksheets[e].tableWidth=_$_c488[267]);if(k=b.querySelector(_$_c488[268]))for(m.worksheets[e].columns=[],n=0;n<k.children.length;n++){for(var p=parseInt(k.children[n].getAttribute(_$_c488[269])),r=parseInt(k.children[n].getAttribute(_$_c488[270])),u=Math.round(7.15*parseInt(k.children[n].getAttribute(_$_c488[271])))+_$_c488[272],B=parseInt(k.children[n].getAttribute(_$_c488[44]));p-1!==m.worksheets[e].columns.length;)m.worksheets[e].columns.push({type:_$_c488[196]}); | ||
for(;p<=r&&p<=c[0];p++){var x={width:u};1===B&&(x.type=_$_c488[44]);m.worksheets[e].columns.push(x)}}if(k=b.querySelector(_$_c488[273]))for(m.worksheets[e].mergeCells={},n=0;n<k.children.length;n++)c=k.children[n].getAttribute(_$_c488[262]).split(_$_c488[221]),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(_$_c488[274]);r=b.querySelector(_$_c488[275]);u=[];for(k=0;k<r.children.length;k++){B= | ||
r.children[k];n=B.getAttribute(_$_c488[264])-1;p=B.getAttribute(_$_c488[276]);x=B.getAttribute(_$_c488[44]);if(p||x)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))),x===_$_c488[277]&&(m.worksheets[e].rows[n].visible=!1);for(n=0;n<B.children.length;n++){var A=B.children[n];p=A.getAttribute(_$_c488[264]);x=A.getAttribute(_$_c488[47]);var w=A.getAttribute(_$_c488[278]);0<w&&ha(p, | ||
c.children[w],e);w=A.getAttribute(_$_c488[264]);p=l.helpers.getCoordsFromColumnName(w);p=[parseInt(p[0]),parseInt(p[1])];if(!u.includes(w))if(x===_$_c488[278])h[p[1]][p[0]]=t[A.firstChild.innerHTML];else if(x=A.getElementsByTagName(_$_c488[279])[0],A=A.getElementsByTagName(_$_c488[280])[0],x)if(w=null,A=x.getAttribute(_$_c488[262]),w=x.getAttribute(_$_c488[47]),w==_$_c488[281])f[p[1]]||(f[p[1]]=[]),w=_$_c488[209]+M(x.firstChild.nodeValue),h[p[1]][p[0]]=w,f[p[1]][p[0]]=w,p=-1!==A.indexOf(_$_c488[221])? | ||
l.helpers.getTokensFromRange(A):[A],u=u.concat(p);else if(w==_$_c488[282]){if(A){w=A.split(_$_c488[221]);w=[l.helpers.getCoordsFromColumnName(w[0]),l.helpers.getCoordsFromColumnName(w[1])];A=[parseInt(w[0][0]),parseInt(w[0][1])];w=[parseInt(w[1][0]),parseInt(w[1][1])];for(var H=A[1];H<=w[1];H++){f[H]||(f[H]=[]);for(var K=A[0];K<=w[0];K++)f[H][K]=_$_c488[209]+l.helpers.shiftFormula(M(x.innerHTML),K-A[0],H-A[1])}}f[p[1]]&&f[p[1]][p[0]]&&(h[p[1]][p[0]]=f[p[1]][p[0]])}else w!==_$_c488[282]&&(h[p[1]][p[0]]= | ||
_$_c488[209]+M(x.firstChild.nodeValue));else A&&(w=A.innerHTML,Number(w)==w&&(w=Number(w)),h[p[1]][p[0]]=w)}}f=d[e].name;var qa=f.slice(0,13)+_$_c488[283]+f.slice(13)+_$_c488[284];f=D.findIndex(function(ra){return ra.name===qa});if(-1<f){f=C(a[f]);if(k=b.querySelector(_$_c488[285]))for(n=0;n<k.children.length;n++)if(c=k.children[n].getAttribute(_$_c488[286]))c=f.querySelector(_$_c488[287]+c+_$_c488[288]),c=c.getAttribute(_$_c488[289]),r=k.children[n].getAttribute(_$_c488[262]),m.worksheets[e].cells[r]? | ||
(m.worksheets[e].cells[r].type=_$_c488[290],m.worksheets[e].cells[r].options={url:c}):m.worksheets[e].cells[r]={type:_$_c488[290],options:{url:c}};k=b.querySelectorAll(_$_c488[29]);for(n=0;n<k.length;n++)if(c=k[n].getAttribute(_$_c488[286]),c=f.querySelector(_$_c488[287]+c+_$_c488[288]),r=c.getAttribute(_$_c488[289]),r=_$_c488[291]+r.slice(3),c=F(r,_$_c488[42]),c=C(a[c]),u=c.querySelector(_$_c488[292]))u=u.getAttribute(_$_c488[293]),r=r.slice(0,12)+_$_c488[294]+r.slice(12)+_$_c488[284],r=F(r,_$_c488[42]), | ||
r=C(a[r]).querySelector(_$_c488[295]+u+_$_c488[191]).getAttribute(_$_c488[289]),r=_$_c488[291]+r.slice(3),r=F(r,_$_c488[42]),m.worksheets[e].media||(m.worksheets[e].media=[]),p=c.querySelector(_$_c488[296]),u=c.querySelector(_$_c488[297]),c=c.querySelector(_$_c488[298]),c=[c.querySelector(_$_c488[299]),c.querySelector(_$_c488[300])],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(_$_c488[301]))/9525, | ||
u=parseInt(u.getAttribute(_$_c488[302]))/9525,h[c[1]][c[0]]=_$_c488[303]+a[r],m.worksheets[e].cells[B]={type:_$_c488[35],options:{absolute:!0,width:p,height:u}}}m.worksheets[e].data=h;if(h=b.querySelector(_$_c488[304]))b=h.getAttribute(_$_c488[305]),b==_$_c488[277]&&(m.worksheets[e].locked=!0,b=h.getAttribute(_$_c488[306]),b!=_$_c488[123]&&(m.worksheets[e].columnSorting=!1),b=h.getAttribute(_$_c488[307]),b!=_$_c488[123]&&(m.worksheets[e].allowInsertRow=!1),b=h.getAttribute(_$_c488[308]),b!=_$_c488[123]&& | ||
(m.worksheets[e].allowDeleteRow=!1),b=h.getAttribute(_$_c488[309]),b!=_$_c488[123]&&(m.worksheets[e].allowInsertColumn=!1),b=h.getAttribute(_$_c488[310]),b!=_$_c488[123]&&(m.worksheets[e].allowDeleteColumn=!1),b=h.getAttribute(_$_c488[311]),b==_$_c488[277]&&(m.worksheets[e].selectUnLockedCells=!1),b=h.getAttribute(_$_c488[312]),b==_$_c488[277]&&(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]=_$_c488[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(_$_c488[33]),e=0;e<d.length;e++){var h=C(a[D.indexOf(d[e])]).querySelector(_$_c488[316]);if(h){var f=d[e].name.replace(_$_c488[283],_$_c488[3]); | ||
f=f.replace(_$_c488[284],_$_c488[3]);var b=G(_$_c488[27]).findIndex(function(r){return r.name===f}),c=h.getAttribute(_$_c488[289]).slice(3);c=_$_c488[291]+c;h=D.findIndex(function(r){return r.name===c});h=C(a[h]);var k=h.querySelector(_$_c488[317]).children,n=Array.from(k).map(function(r){return r.children[0].children[0].querySelector(_$_c488[47]).innerHTML}),p=h.querySelector(_$_c488[318]).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(_$_c488[262]);u=k[u].getAttribute(_$_c488[319]);m.worksheets[b].comments[B]=p[u]+_$_c488[320]+r})}}},J=function(a,d){if(!d)return a;d=parseFloat(d);a=a.slice(a[0]===_$_c488[252]?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=[];z={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:_$_c488[321],dataType:_$_c488[322],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==_$_c488[197])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==_$_c488[197])a.onerror(h)})};Y.license=function(a){N(a)};return Y}); | ||
$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= | ||
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}); |
@@ -34,3 +34,3 @@ { | ||
"types": "dist/index.d.ts", | ||
"version": "2.5.0", | ||
"version": "2.5.1", | ||
"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
39673
193