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