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