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