@jspreadsheet/pivot - npm Package Compare versions

Comparing version 1.0.6 to 1.1.0

dist/index.js

@@ -29,10 +29,8 @@ /**
 
-function a0_0x2e92(){const a='calendar;onevent;reverse;Show as;value;updateSortableField;symbol;isArray;coords;cardThatFollowsTheMouse;updateModal;Pivot table settings;removeFilter;values;showOptions;getSortingOptions;call;Existing worksheet;div;equal to;3XzNiIo;MAX;removeThisItem;create;target;526988EGCvwg;visibility;on or before;removeColumn;toFixed;collapsed;The source must be a range;bigger than or equal to;children;different to;cascade;exists symbol;notification;before;date;default;Filter by value;object;tokenIdentifier;defineProperty;Method;getColumnName;pivot-table-position-marker-card;move;closed;start;helpers;yCoordOfTheCenter;createAnchorPicker;getWorksheetInstanceByName;rows;showAs;deletedColumns;license;dateToNum;total-%;Value;License required;row-%;pivot-table-config-list;Total ;getBoundingClientRect;Ascending;moveItem;push;filterByValue;setOptions;mousemove;AVERAGE;createPicker;remove;updateFilter;exists;cancel;updateRows;The source must be a range, not a single cell;COUNT;has;none;getCell;Order by;get;begins with;onclick;some;validation;pivot-table-movement-card;conditionDropdownOptions;endDate;on or after;sourceWorksheet;STDEV;data-control;is-last-row;ignoreEvents;documentElement;top;height;Values;columns;card;appendChild;Criteria;message;filters;entries;ignore;STDEVP;dictionary;difference;new;Source;parentElement;updateColumn;between;Cell where the table should be inserted; of;name;forEach;updateColumns;mousedown;fields;[data-control];cut;openCreateModal;is a valid url;map;Cell is not empty;all;jss_pivot_table;innerHTML;status;parent;open;source;clipboard;lastIndexOf;getCoordsFromCellName;querySelectorAll;text;sourceAnchor;updateRow;refresh;jtoolbar-disabled;openEditModal;tools;sort;valid;onload;destinationAnchor;columnIndex;Number;exports;marginTop;anchor;is-highlighted-row;isLoaded;getRange;2457889muQrQf;pivotTableId;locationOption;classList;undefined;valid url;last column;endTime;pivotTable;length;getHighlighted;instance;isSelected;VAR.S;criteria;getCellNameFromCoords;pivot-table-card-background;close;Column ;set;slice;1899-12-31 ;grab;addEventListener;material-icons;268452vxhRfQ;sourcePicker;setComponents;isCollapsed;findIndex;method;setChain;createSourcePicker;concat;includes;less than;oldValue;blur;Date;boolean;data-visible;userSelect;oldSource;is-header;not between; must contain no content other than the table itself.;edit;createElement;options;less than or equal to;VAR;Create pivot table;allowEmptyCriteria;removeField;createColumnPicker;contains;Something went wrong;highlighted;existing;left;removeRow;createWorksheet;is not between;Descending;formula;selection;modal;number;Invalid sorting option;getCellObject;is-highlighted-column;MEDIAN;removeCell;<i class="material-icons">pivot_table_chart</i>;toolbar;destinationWorksheet;The pivot tables extension is not included on the scope of this license;Total;oninit;undoChanges;editButtons;insertBefore;loadModalLists;ascendingOrder;row;% of the total;clientY;Time;innerText;getDataFromRange;Columns;3232eeKEjD;Grand Total;filter;setProperty;end;title; of ;121330AnLprf;validationElement;cursor;12384tDFlXD;onchange;element;base;createFilterPicker;updateCells;fill;replaceWith;<div>\n                    <div><Create :ref="self.create" /></div>\n                    <div><Edit :ref="self.edit" /></div>\n                </div>;append;% of the row total;style;setValue;pivotTables;guid;insert;MIN;unshift;parse;error;Cell is empty;% of the column total;scope;type;Default;filter1;#SPILL;setAttribute;removeEventListener;column;splice;picker;applyValidation;Type;startDate;visible;getCoordsFromRange;size;trunc;delete;criterias;insertedColumns;updateFilters;find;key;pivot;newValue;range;controls;plugins;onDragStart;width;function;max;positionMarkerCard;SUM;valid date;2250995IVcvwa;add;updateField;getRangeFromCoords;sortBy;from;possibleValues;ends with;cells;not contains;time;moveFilter;highlightedRows;Cancel;indexOf;bigger than;createCellPicker;columnName;current;update;history;display;pivot-table-group-cell;Text;startTime;VARP;559920RmGKam;Delete;worksheet;pivot_table_chart;textLength;styleInfo'.split(";");
-a0_0x2e92=function(){return a};return a0_0x2e92()}function a0_0x2294(a,B){const x=a0_0x2e92();return a0_0x2294=function(G,J){return x[G-202]},a0_0x2294(a,B)}(function(a,B){const x=a0_0x2294;for(a=a();;)try{if(-parseInt(x(323))+parseInt(x(396))/2*(parseInt(x(508))/3)+parseInt(x(513))/4+parseInt(x(456))/5+parseInt(x(482))/6+parseInt(x(298))/7+-parseInt(x(389))/8*(parseInt(x(399))/9)===B)break;else a.push(a.shift())}catch(G){a.push(a.shift())}})(a0_0x2e92,262702);
-(function(a,B){const x=a0_0x2294;"object"===typeof exports&&typeof module!==x(302)?module[x(292)]=B():typeof define===x(451)&&define.amd?define(B):a[x(444)]=B()})(this,function(){const a=a0_0x2294;let B=null;const x=function(b){const c=a0_0x2294;return"undefined"!==typeof document&&document[c(248)]?document[c(248)][b]||b:b},G=function(b){return JSON[a0_0x2294(417)](JSON.stringify(b))},J=b=>{const c=a0_0x2294,d=b[c(276)]("!");return[b[c(318)](0,d),b.slice(d+1)]};class K extends Error{}const na=b=>
-{const c=a0_0x2294;try{if(!B[c(539)].tokenIdentifier(b))throw new K(c(519));let d=b[c(276)]("!");0>d&&(d=void 0);if(0>b[c(470)](":",d))throw new K("The source must be a range, not a single cell");const f=B.helpers[c(435)](b);if(f[0]===f[2]&&f[1]===f[3])throw new K(c(215));}catch(d){if(d instanceof K)throw d;throw new K(c(354));}},ya=function(){const b=a0_0x2294;let c=this;c.createSourcePicker=function(f){B.picker(f,{worksheetName:!0,onchange:function(e){c[a0_0x2294(274)]=e}})};c[b(541)]=function(f){B[b(430)](f,
-{worksheetName:!0,onchange:function(e){c[b(294)]=e}})};c[b(273)]=function(){c[b(300)]=b(250);c[b(294)]="";c[b(324)][b(386)]=c[b(274)];c[b(364)][b(273)]()};c[b(213)]=function(){c[b(364)][b(315)]()};c[b(414)]=function(){var f=c[b(274)];try{na(f)}catch(h){jSuites[b(525)]({error:1,message:x(h.message)});return}f={id:jSuites[b(413)](),source:f};if(c[b(300)]===b(356)){var e=c[b(294)];try{const h=a0_0x2294;try{if(!B.helpers[h(531)](e))throw new K("The anchor must be a reference to a cell");var g=e[h(276)]("!");
-0>g&&(g=void 0);if(-1<e[h(470)](":",g))throw new K("The anchor must be a single cell, not a range");}catch(n){if(n instanceof K)throw n;throw new K("Something went wrong");}}catch(h){jSuites[b(525)]({error:1,message:x(h[b(243)])});return}g=J(e);e=c[b(309)].getWorksheetInstanceByName(g[0]);f[b(294)]=g[1];H[b(504)](e,f)}else f[b(294)]="A1",c[b(309)][b(359)]({minDimensions:[20,20],pivotTables:[f]});c[b(364)].close()};const d=[{text:x("New worksheet"),value:b(250)},{text:x(b(505)),value:b(356)}];return f=>
-f`
-            <lm-modal icon="pivot_table_chart" title="${x(b(349))}" :ref="self.modal" :closable="true" :draggable="true" :width="420" :height="370" :closed="true" :onclose="self.cancel">
+;(function(a,B){const x=a0_0x567c;for(a=a();;)try{if(parseInt(x(377))/1*(parseInt(x(440))/2)+parseInt(x(285))/3+-parseInt(x(393))/4*(parseInt(x(433))/5)+parseInt(x(414))/6+parseInt(x(486))/7+-parseInt(x(272))/8*(-parseInt(x(172))/9)+-parseInt(x(522))/10===B)break;else a.push(a.shift())}catch(G){a.push(a.shift())}})(a0_0x27a5,867724);function a0_0x567c(a,B){const x=a0_0x27a5();return a0_0x567c=function(G,J){return x[G-154]},a0_0x567c(a,B)}
+(function(a,B){const x=a0_0x567c;typeof exports===x(391)&&typeof module!==x(438)?module.exports=B():"function"===typeof define&&define[x(468)]?define(B):a[x(318)]=B()})(this,function(){const a=a0_0x567c;let B=null;const x=function(b){const c=a0_0x567c;return typeof document!==c(438)&&document[c(399)]?document[c(399)][b]||b:b},G=function(b){const c=a0_0x567c;return JSON[c(452)](JSON[c(437)](b))},J=b=>{const c=a0_0x567c,d=b[c(254)]("!");return[b.slice(0,d),b[c(397)](d+1)]};class K extends Error{}const na=
+b=>{const c=a0_0x567c;try{if(!B[c(382)][c(415)](b))throw new K("The source must be a range");let d=b.lastIndexOf("!");0>d&&(d=void 0);if(0>b[c(389)](":",d))throw new K("The source must be a range, not a single cell");const f=B[c(382)][c(376)](b);if(f[0]===f[2]&&f[1]===f[3])throw new K(c(176));}catch(d){if(d instanceof K)throw d;throw new K(c(368));}},ya=function(){const b=a0_0x567c;let c=this;c[b(266)]=function(f){B[b(432)](f,{worksheetName:!0,onchange:function(e){c[b(298)]=e}})};c[b(240)]=function(f){B.picker(f,
+{worksheetName:!0,onchange:function(e){c.anchor=e}})};c.open=function(){c.locationOption="new";c[b(354)]="";c[b(167)].innerText=c[b(298)];c.modal[b(472)]()};c.cancel=function(){c.modal[b(177)]()};c[b(386)]=function(){var f=c.source;try{na(f)}catch(k){jSuites[b(227)]({error:1,message:x(k[b(317)])});return}f={id:jSuites.guid(),source:f};if(c[b(490)]===b(156)){var e=c[b(354)];try{const k=a0_0x567c;try{if(!B[k(382)][k(415)](e))throw new K(k(308));var g=e[k(254)]("!");0>g&&(g=void 0);if(-1<e[k(389)](":",
+g))throw new K(k(257));}catch(l){if(l instanceof K)throw l;throw new K("Something went wrong");}}catch(k){jSuites[b(227)]({error:1,message:x(k[b(317)])});return}g=J(e);e=c[b(281)][b(234)](g[0]);f[b(354)]=g[1];H[b(519)](e,f)}else f[b(354)]="A1",c[b(281)].createWorksheet({minDimensions:[20,20],pivotTables:[f]});c[b(218)].close()};const d=[{text:x(b(388)),value:b(238)},{text:x(b(249)),value:b(156)}];return f=>f`
+            <lm-modal icon="pivot_table_chart" title="${x(b(402))}" :ref="self.modal" :closable="true" :minimizable="true" :draggable="true" :width="420" :height="370" :closed="true" :onclose="self.cancel">
                 <div class="jss_object jss_style_p20">
@@ -55,6 +53,6 @@ <div class='jss_style_row jss_style_p2'>
                     </div>
-                    <div class='jss_style_row jss_style_p2 lm-row' lm-render="${this.locationOption===b(356)}">
+                    <div class='jss_style_row jss_style_p2 lm-row' lm-render="${this[b(490)]===b(156)}">
                     <div class='jss_style_column jss_style_f1'>
                         <div class="jss_style_form_group">
-                            <label>${x(b(255))}</label>
+                            <label>${x("Cell where the table should be inserted")}</label>
                             <div :ready="self.createAnchorPicker" data-single="true"></div>
@@ -68,3 +66,3 @@ </div>
                                 <button type="button" class="jss_style_button" onclick="self.insert">${x("Create")}</button>
-                                <button type="button" class="jss_style_button" onclick="self.cancel">${x(b(469))}</button>
+                                <button type="button" class="jss_style_button" onclick="self.cancel">${x(b(489))}</button>
                             </div>
@@ -75,18 +73,18 @@ </div>
             </lm-modal>
-        `},za=[{text:x(a(202)),value:!0},{text:x(a(361)),value:!1}],oa=(b,c,d)=>{b[a(410)].left=c.left+"px";b.style[a(236)]=Math[a(437)](d[a(384)]-c[a(540)])+"px"},pa=(b,c,d)=>{B[a(476)][a(246)]=!0;d[a(272)][a(234)]=!0;d[a(392)](c);d[a(411)](b,null,!0);d.parent[a(234)]=!1;B[a(476)][a(246)]=!1},N=b=>{const c=new Set([a(269),"is-header",a(368),a(295),a(233)]);return b&&b[a(258)](d=>{c["delete"](d)}),{base:b,difference:[...c]}},aa=([b,c],d,f)=>{d=B[a(539)][a(277)](d[a(294)]);const [e,g]=d;d=N()[a(249)];
-for(let h=0;h<c;h++){const n=h+g;for(let l=0;l<b;l++){const k=l+e;f[a(367)](k,n);f[a(219)](k,n)[a(301)][a(210)](...d)}}},Aa=(b,[c,d],[f,e],g,h)=>{g=B[a(539)].getCoordsFromCellName(g[a(294)]);const [n,l]=g,{headerHeight:k,hasHighlightedColumn:w,highlightedRows:p=new Set}=b;b=N(["jss_pivot_table",a(341)]);for(g=0;g<k;g++){var r=g+l;for(var m=0;m<f;m++){var q=m+n;h[a(367)](q,r);q=h[a(219)](q,r)[a(301)];q[a(210)](...b.difference);q.add(...b[a(402)])}}b=N([a(269),"is-highlighted-row"]);if(w)for(g=N([a(269),
-a(368)]),r=k;r<e-1;r++)m=r+l,h[a(367)](n,m),m=h[a(219)](n,m).classList,q=p[a(217)](r)?b:g,m[a(210)](...q[a(249)]),m[a(457)](...q[a(402)]);g=w?1:0;r=N(["jss_pivot_table"]);for(m=k;m<e-1;m++){q=m+l;const v=p[a(217)](m)?b:r;for(let u=g;u<f;u++){var t=u+n;h[a(367)](t,q);t=h[a(219)](t,q);t.classList[a(210)](...v[a(249)]);t[a(301)][a(457)](...v.base)}}b=e-1+l;g=N([a(269),a(233)]);for(r=0;r<f;r++)m=r+n,h.getCellObject(m,b),m=h[a(219)](m,b),m.classList.remove(...g[a(249)]),m[a(301)][a(457)](...g[a(402)]);
-b=N()[a(249)];for(g=0;g<e;g++)for(r=g+l,m=f;m<c;m++)q=m+n,h[a(367)](q,r),h[a(219)](q,r)[a(301)].remove(...b);for(f=e;f<d;f++)for(e=f+l,g=0;g<c;g++)r=g+n,h[a(367)](r,e),h[a(219)](r,e).classList.remove(...b)},W=function(b){var c=G(b);delete c[a(436)];!this[a(346)][a(412)]&&(this[a(346)][a(412)]=[]);const d=this.options[a(412)],f=V(c.id,d);b={newValue:G(c)};if(0>f)d[a(204)](c);else{const e=G(d[f]);c[a(436)]=e[a(436)];delete e[a(436)];b[a(334)]=e;d[f]=c}L(c,this);c=this[a(272)][a(448)][a(444)];return!c.edit[a(364)][a(537)]&&
-c[a(344)].updateModal(),b},ba=function(b,c){const {anchor:d,size:f}=b;var e=B.helpers[a(277)](d);const [g,h]=e;e=[];const n=[],[l,k]=f,{records:w}=c;for(let r=0;r<k;r++){const m=h+r,q=w[m];for(let t=0;t<l;t++){var p=g+t;e.push({x:p,y:m,value:null});n.push({x:p,y:m,value:null});(p=q[p])&&delete p[a(444)]}}pa(e,n,c);aa(f,b,c)},ca=function(b){var c=this[a(346)][a(412)];b=V(b,c);c=c[a(429)](b,1)[0];b=G(c);return ba(c,this),b},qa=(b,c)=>{b=B[a(539)][a(277)](b[a(294)]);c.updateSelectionFromCoords(...b)},
-da=(b,c)=>{const d=B[a(539)][a(277)](b[a(294)]);d[a(204)](d[0]+b[a(436)][0]-1,d[1]+b[a(436)][1]-1);c.updateSelectionFromCoords(...d)},V=(b,c)=>{if(!c)return-1;const d=c[a(307)];for(let f=0;f<d;f++)if(c[f].id===b)return f;return-1},ea=(b,c)=>{c=c[a(346)].pivotTables;b=V(b,c);return-1<b?c[b]:null},H=function(b){const c=W[a(504)](this,b);B.history[a(504)](this[a(272)],{worksheet:this,undo:()=>{c[a(334)]?W[a(504)](this,c[a(334)]):ca[a(504)](this,c.id);qa(c.newValue,this)},redo:()=>{W.call(this,c[a(445)]);
-qa(c[a(445)],this)}})},Ba=function(b){const c=ca[a(504)](this,b);B[a(476)][a(504)](this.parent,{worksheet:this,undo:()=>{W[a(504)](this,c);da(c,this)},redo:()=>{ca[a(504)](this,c.id);da(c,this)}})},fa=function(b,c,d,f){{const h=b[a(346)][a(412)],n=V(d,h);if(0>n)b=void 0;else{var e=G(h[n]),g=e[a(294)];b===c&&g===f?b=void 0:(ba(e,b),h[a(429)](n,1),e[a(294)]=f,e.size=[0,0],!c[a(346)][a(412)]&&(c.options[a(412)]=[]),c[a(346)][a(412)][a(204)](e),L(e,c),e=b[a(272)][a(448)].pivot,b=(e&&e[a(344)]&&!e[a(344)][a(364)][a(537)]&&
-e[a(344)][a(498)](),{sourceWorksheet:b,destinationWorksheet:c,sourceAnchor:g,destinationAnchor:f,pivotTableId:d}))}}(d=ea(d,c))&&da(d,c);return b},Ca=function(b,c,d,f){const e=fa(b,c,d,f);B[a(476)].call(b.parent,{worksheet:b,undo:()=>{fa(e[a(373)],e[a(230)],e[a(299)],e[a(280)])},redo:()=>{fa(e[a(230)],e[a(373)],e.pivotTableId,e[a(289)])}})},ha=b=>{b[a(449)]=function(f){var e=f[a(512)];if(e===b[a(240)]){document.documentElement[a(410)][a(339)]=a(218);document[a(235)][a(410)][a(398)]=a(320);var g=b[a(473)];
-var h=document[a(345)](a(506));g=(h[a(301)][a(457)](a(314),a(535)),h[a(270)]="<div><h3>"+g+"</h3></div>",h);b[a(453)]=g;e[a(252)][a(406)](g);e=b[a(473)];h=document[a(345)](a(506));e=(h[a(301)][a(457)](a(226)),h.innerHTML="<h3>"+e+"</h3>",h);h=g.getBoundingClientRect();const n=getComputedStyle(g);g=g[a(521)][0];g=getComputedStyle(g);e[a(410)][a(450)]=g.width;b[a(497)]=e;document.body[a(241)](e);g={yCoordOfTheCenter:parseInt(n[a(293)])+h[a(237)]/2,left:h[a(357)]};b.coords=g;oa(e,g,f);document[a(321)]("mousemove",
-c);document[a(321)]("mouseup",d,{once:!0})}};const c=function(f){let e=f[a(512)];for(oa(b[a(497)],b[a(496)],f);e!==document[a(235)]&&!e[a(301)][a(353)]("pivot-table-card-background")&&!e.classList[a(353)](a(552));)e=e[a(252)];if(e.classList[a(353)]("pivot-table-config-list"))e[a(241)](b[a(453)]);else if(e[a(301)][a(353)]("pivot-table-card-background")&&!e[a(301)][a(353)]("pivot-table-position-marker-card")){f=f[a(384)];var g=e[a(554)]();g=g.y+g[a(237)]/2;if(f<g)e[a(252)][a(379)](b[a(453)],e);else(f=
-e.nextElementSibling)?f[a(252)][a(379)](b.positionMarkerCard,f):e[a(252)][a(241)](b[a(453)])}},d=function(){document[a(427)](a(207),c);document[a(235)][a(410)][a(339)]="";document[a(235)].style[a(398)]="";b[a(497)].remove();var f=b[a(453)][a(252)];const e=f.id[a(318)](12,-5);f=Array[a(461)](f[a(521)])[a(470)](b[a(453)]);b[a(536)](b.id||b[a(290)],e,f)}},Da=[{text:x("SUM"),value:a(454)},{text:x("COUNTA"),value:"COUNTA"},{text:x(a(216)),value:"COUNT"},{text:x("COUNTUNIQUE"),value:"COUNTUNIQUE"},{text:x(a(208)),
-value:a(208)},{text:x("MAX"),value:a(509)},{text:x(a(415)),value:a(415)},{text:x("MEDIAN"),value:a(369)},{text:x("PRODUCT"),value:"PRODUCT"},{text:x("STDEV"),value:a(231)},{text:x(a(247)),value:"STDEVP"},{text:x(a(348)),value:a(311)},{text:x(a(481)),value:"VAR.P"}],ra=[{text:x(a(423)),value:a(528)},{text:x(a(409)),value:a(551)},{text:x(a(420)),value:"column-%"},{text:x(a(383)),value:a(548)}],Ea=[{value:a(365),text:x(a(291))},{value:"text",text:x(a(479))},{value:a(527),text:x(a(336))},{value:a(466),
-text:x(a(385))},{value:a(486),text:x("Text length")},{value:"empty",text:x(a(419))},{value:"notEmpty",text:x(a(267))}],Fa={number:[{text:x(a(254)),value:"between"},{text:x(a(360)),value:a(342)},{text:x(a(333)),value:"<"},{text:x("less than or equal to"),value:"<="},{text:x("bigger than"),value:">"},{text:x(a(520)),value:">="},{text:x(a(507)),value:"="},{text:x(a(522)),value:"!="}],text:[{text:x("contains"),value:"contains"},{text:x("not contains"),value:a(465)},{text:x(a(222)),value:"begins with"},
-{text:x(a(463)),value:a(463)},{text:x("equal to"),value:"="},{text:x("is a valid email"),value:"valid email"},{text:x(a(265)),value:a(303)}],date:[{text:x("is a valid date"),value:a(455)},{text:x(a(507)),value:"="},{text:x(a(526)),value:"<"},{text:x(a(515)),value:"<="},{text:x("after"),value:">"},{text:x(a(229)),value:">="},{text:x(a(254)),value:a(254)},{text:x(a(342)),value:a(342)}],time:[{text:x("between"),value:"between"},{text:x(a(360)),value:a(342)},{text:x("less than"),value:"<"},{text:x(a(347)),
-value:"<="},{text:x(a(471)),value:">"},{text:x(a(520)),value:">="},{text:x(a(507)),value:"="},{text:x(a(522)),value:"!="}],textLength:[{text:x(a(254)),value:"between"},{text:x("is not between"),value:"not between"},{text:x("less than"),value:"<"},{text:x("less than or equal to"),value:"<="},{text:x(a(471)),value:">"},{text:x("bigger than or equal to"),value:">="},{text:x(a(507)),value:"="},{text:x(a(522)),value:"!="}]};lemonade[a(325)]({FieldCard:function(){const b=this;return ha(b),b[a(400)]=function(c){if(c===
-a(460)||"ascendingOrder"===c)c={[c]:b[c]},b.update(b[a(290)],c)},c=>c`
+        `},za=[{text:x(a(447)),value:!0},{text:x(a(155)),value:!1}],oa=(b,c,d)=>{b[a(274)][a(355)]=c[a(355)]+"px";b[a(274)][a(186)]=Math.trunc(d[a(455)]-c[a(224)])+"px"},pa=(b,c,d)=>{B[a(313)].ignore=!0;d[a(420)][a(410)]=!0;d[a(421)](c);d[a(484)](b,null,!0);d[a(420)].ignoreEvents=!1;B[a(313)][a(518)]=!1},N=b=>{const c=new Set(["jss_pivot_table",a(473),a(396),"is-highlighted-row",a(216)]);return b&&b[a(509)](d=>{c[a(336)](d)}),{base:b,difference:[...c]}},aa=([b,c],d,f)=>{d=B.helpers[a(492)](d[a(354)]);
+const [e,g]=d;d=N()[a(496)];for(let k=0;k<c;k++){const l=k+g;for(let p=0;p<b;p++){const h=p+e;f[a(360)](h,l);f[a(300)](h,l)[a(154)][a(305)](...d)}}},Aa=(b,[c,d],[f,e],g,k)=>{var l=B.helpers[a(492)](g[a(354)]);const [p,h]=l;g&&g[a(325)]&&(g=f-k[a(214)][a(516)],l=e-k[a(196)][a(516)],0<g&&k[a(344)](g),0<l&&k[a(411)](l));const {headerHeight:v,hasHighlightedColumn:r,highlightedRows:q=new Set}=b;b=N([a(183),a(473)]);for(g=0;g<v;g++){l=g+h;for(var m=0;m<f;m++){var n=m+p;k[a(360)](n,l);n=k[a(300)](n,l)[a(154)];
+n[a(305)](...b[a(496)]);n[a(195)](...b[a(251)])}}b=N(["jss_pivot_table",a(450)]);if(r)for(g=N(["jss_pivot_table",a(396)]),l=v;l<e-1;l++)m=l+h,k[a(360)](p,m),m=k.getCell(p,m).classList,n=q[a(404)](l)?b:g,m[a(305)](...n[a(496)]),m[a(195)](...n.base);g=r?1:0;l=N(["jss_pivot_table"]);for(m=v;m<e-1;m++){n=m+h;const w=q[a(404)](m)?b:l;for(let t=g;t<f;t++){var u=t+p;k[a(360)](u,n);u=k[a(300)](u,n);u[a(154)][a(305)](...w[a(496)]);u.classList[a(195)](...w.base)}}b=e-1+h;g=N([a(183),a(216)]);for(l=0;l<f;l++)m=
+l+p,k[a(360)](m,b),m=k[a(300)](m,b),m[a(154)].remove(...g[a(496)]),m[a(154)].add(...g[a(251)]);b=N().difference;for(g=0;g<e;g++)for(l=g+h,m=f;m<c;m++)n=m+p,k[a(360)](n,l),k.getCell(n,l)[a(154)][a(305)](...b);for(f=e;f<d;f++)for(e=f+h,g=0;g<c;g++)l=g+p,k[a(360)](l,e),k[a(300)](l,e)[a(154)][a(305)](...b)},W=function(b){var c=G(b);delete c.size;!this[a(348)].pivotTables&&(this.options[a(230)]=[]);const d=this[a(348)][a(230)],f=V(c.id,d);b={newValue:G(c)};if(0>f)d[a(223)](c);else{const e=G(d[f]);c[a(325)]=
+e.size;delete e[a(325)];b.oldValue=e;d[f]=c}L(c,this);c=this[a(420)][a(231)].pivot;return!c[a(322)][a(218)].closed&&c[a(322)][a(363)](),b},ba=function(b,c){const {anchor:d,size:f}=b;var e=B[a(382)][a(492)](d);const [g,k]=e;e=[];const l=[],[p,h]=f,{records:v}=c;for(let q=0;q<h;q++){const m=k+q,n=v[m];for(let u=0;u<p;u++){var r=g+u;e[a(223)]({x:r,y:m,value:null});l[a(223)]({x:r,y:m,value:null});(r=n[r])&&delete r.pivot}}pa(e,l,c);aa(f,b,c)},ca=function(b){var c=this.options.pivotTables;b=V(b,c);c=c[a(481)](b,
+1)[0];b=G(c);return ba(c,this),b},qa=(b,c)=>{b=B.helpers[a(492)](b[a(354)]);c[a(228)](...b)},da=(b,c)=>{const d=B[a(382)][a(492)](b.anchor);d[a(223)](d[0]+b.size[0]-1,d[1]+b.size[1]-1);c[a(228)](...d)},V=(b,c)=>{if(!c)return-1;const d=c[a(516)];for(let f=0;f<d;f++)if(c[f].id===b)return f;return-1},ea=(b,c)=>{c=c[a(348)].pivotTables;b=V(b,c);return-1<b?c[b]:null},H=function(b){const c=W[a(519)](this,b);B[a(313)][a(519)](this.parent,{worksheet:this,undo:()=>{c[a(327)]?W.call(this,c[a(327)]):ca.call(this,
+c.id);qa(c[a(290)],this)},redo:()=>{W[a(519)](this,c.newValue);qa(c.newValue,this)}})},Ba=function(b){const c=ca[a(519)](this,b);B[a(313)].call(this.parent,{worksheet:this,undo:()=>{W.call(this,c);da(c,this)},redo:()=>{ca[a(519)](this,c.id);da(c,this)}})},fa=function(b,c,d,f){{const k=b[a(348)][a(230)],l=V(d,k);if(0>l)b=void 0;else{var e=G(k[l]),g=e[a(354)];b===c&&g===f?b=void 0:(ba(e,b),k[a(481)](l,1),e[a(354)]=f,e.size=[0,0],!c[a(348)][a(230)]&&(c[a(348)][a(230)]=[]),c[a(348)].pivotTables[a(223)](e),
+L(e,c),e=b.parent.plugins[a(318)],b=(e&&e.edit&&!e[a(322)][a(218)][a(444)]&&e[a(322)].updateModal(),{sourceWorksheet:b,destinationWorksheet:c,sourceAnchor:g,destinationAnchor:f,pivotTableId:d}))}}(d=ea(d,c))&&da(d,c);return b},Ca=function(b,c,d,f){const e=fa(b,c,d,f);B[a(313)].call(b.parent,{worksheet:b,undo:()=>{fa(e.destinationWorksheet,e[a(441)],e[a(515)],e[a(288)])},redo:()=>{fa(e[a(441)],e.destinationWorksheet,e[a(515)],e.destinationAnchor)}})},ha=b=>{b[a(334)]=function(f){var e=f.target;if(e===
+b.card){document.documentElement[a(274)].userSelect=a(497);document[a(429)][a(274)][a(301)]=a(304);var g=b[a(424)];var k=document.createElement("div");g=(k.classList[a(195)]("pivot-table-card-background",a(326)),k.innerHTML=a(171)+g+a(379),k);b[a(206)]=g;e[a(488)][a(276)](g);e=b[a(424)];k=document[a(258)]("div");e=(k[a(154)][a(195)]("pivot-table-movement-card"),k[a(431)]=a(273)+e+a(527),k);k=g.getBoundingClientRect();const l=getComputedStyle(g);g=g[a(323)][0];g=getComputedStyle(g);e[a(274)][a(215)]=
+g.width;b[a(508)]=e;document[a(239)].appendChild(e);g={yCoordOfTheCenter:parseInt(l[a(426)])+k[a(217)]/2,left:k[a(355)]};b[a(193)]=g;oa(e,g,f);document[a(448)](a(525),c);document.addEventListener("mouseup",d,{once:!0})}};const c=function(f){let e=f[a(237)];for(oa(b[a(508)],b[a(193)],f);e!==document[a(429)]&&!e[a(154)][a(310)](a(340))&&!e[a(154)][a(310)](a(320));)e=e[a(488)];if(e[a(154)][a(310)](a(320)))e[a(291)](b.positionMarkerCard);else if(e[a(154)][a(310)](a(340))&&!e[a(154)][a(310)](a(326))){f=
+f[a(455)];const g=e[a(359)]();if(f<g.y+g.height/2)e[a(488)][a(345)](b.positionMarkerCard,e);else(f=e.nextElementSibling)?f[a(488)][a(345)](b[a(206)],f):e[a(488)][a(291)](b[a(206)])}},d=function(){document[a(158)](a(525),c);document[a(429)][a(274)].userSelect="";document[a(429)][a(274)][a(301)]="";b[a(508)].remove();var f=b[a(206)][a(488)];const e=f.id.slice(12,-5);f=Array[a(403)](f[a(323)])[a(389)](b.positionMarkerCard);b[a(219)](b.id||b[a(401)],e,f)}},Da=[{text:x(a(245)),value:a(245)},{text:x(a(351)),
+value:a(351)},{text:x(a(306)),value:a(306)},{text:x("COUNTUNIQUE"),value:"COUNTUNIQUE"},{text:x(a(384)),value:a(384)},{text:x(a(443)),value:"MAX"},{text:x(a(241)),value:"MIN"},{text:x(a(341)),value:a(341)},{text:x("PRODUCT"),value:a(394)},{text:x("STDEV"),value:a(324)},{text:x(a(235)),value:a(235)},{text:x(a(175)),value:a(365)},{text:x(a(374)),value:a(362)}],ra=[{text:x(a(236)),value:"default"},{text:x(a(269)),value:a(270)},{text:x("% of the column total"),value:a(162)},{text:x("% of the total"),
+value:"total-%"}],Ea=[{value:a(353),text:x(a(331))},{value:a(367),text:x(a(229))},{value:a(178),text:x("Date")},{value:a(185),text:x(a(435))},{value:a(464),text:x("Text length")},{value:"empty",text:x(a(307))},{value:a(445),text:x(a(400))}],Fa={number:[{text:x(a(390)),value:a(390)},{text:x(a(458)),value:a(302)},{text:x("less than"),value:"<"},{text:x(a(294)),value:"<="},{text:x("bigger than"),value:">"},{text:x(a(319)),value:">="},{text:x(a(493)),value:"="},{text:x("different to"),value:"!="}],text:[{text:x("contains"),
+value:"contains"},{text:x(a(523)),value:a(523)},{text:x(a(405)),value:"begins with"},{text:x("ends with"),value:a(226)},{text:x(a(493)),value:"="},{text:x("is a valid email"),value:a(408)},{text:x("is a valid url"),value:a(361)}],date:[{text:x(a(383)),value:a(164)},{text:x(a(493)),value:"="},{text:x(a(465)),value:"<"},{text:x("on or before"),value:"<="},{text:x(a(295)),value:">"},{text:x("on or after"),value:">="},{text:x(a(390)),value:a(390)},{text:x(a(302)),value:a(302)}],time:[{text:x(a(390)),
+value:a(390)},{text:x("is not between"),value:a(302)},{text:x(a(246)),value:"<"},{text:x(a(294)),value:"<="},{text:x("bigger than"),value:">"},{text:x(a(319)),value:">="},{text:x("equal to"),value:"="},{text:x("different to"),value:"!="}],textLength:[{text:x(a(390)),value:"between"},{text:x(a(458)),value:a(302)},{text:x("less than"),value:"<"},{text:x(a(294)),value:"<="},{text:x(a(199)),value:">"},{text:x(a(319)),value:">="},{text:x("equal to"),value:"="},{text:x("different to"),value:"!="}]};lemonade[a(260)]({FieldCard:function(){const b=
+this;return ha(b),b[a(187)]=function(c){if(c===a(520)||c===a(470))c={[c]:b[c]},b[a(247)](b.columnIndex,c)},c=>c`
             <div class="pivot-table-card-background">
@@ -97,3 +95,3 @@ <div :ref="self.card" class="pivot-table-card" onmousedown="self.onDragStart">
                         <div class="lm-column lm-f1">
-                            <label>${x(a(220))}</label>
+                            <label>${x("Order by")}</label>
                             <Dropdown :data="self.sortingOptions" :bind="self.sortBy" :allowEmpty="false" width="230" />
@@ -109,3 +107,3 @@ </div>
             </div>
-        `},ValueCard:function(){const b=this;return ha(b),b[a(296)]=!1,b[a(288)]=function(){!b[a(544)]&&(b[a(544)]=ra[0][a(492)]);b.isLoaded=!0},b.onchange=function(c){"method"!==c&&c!==a(544)||!b.isLoaded||(c={[c]:b[c]},b[a(475)](b.id,c))},b[a(510)]=function(){b.remove(b.id)},c=>c`
+        `},ValueCard:function(){const b=this;return ha(b),b[a(501)]=!1,b[a(338)]=function(){!b[a(278)]&&(b[a(278)]=ra[0][a(267)]);b.isLoaded=!0},b[a(187)]=function(c){c!==a(284)&&c!==a(278)||!b[a(501)]||(c={[c]:b[c]},b[a(247)](b.id,c))},b[a(160)]=function(){b[a(305)](b.id)},c=>c`
             <div class="pivot-table-card-background">
@@ -116,7 +114,7 @@ <div :ref="self.card" class="pivot-table-card" onmousedown="self.onDragStart">
                         <div class="lm-column lm-f1">
-                            <label>${x(a(533))}</label>
+                            <label>${x(a(434))}</label>
                             <Dropdown :data="${Da}" :bind="self.method" :allowEmpty="false" width="230" />
                         </div>
                         <div class="lm-column lm-f1">
-                            <label>${x(a(491))}</label>
+                            <label>${x(a(163))}</label>
                             <Dropdown :data="${ra}" :bind="self.showAs" :allowEmpty="false" width="230" />
@@ -128,8 +126,8 @@ </div>
             </div>
-        `},FilterCard:function(b,{track:c}){const d=this;c(a(424));ha(d);d.possibleValues=[];d[a(227)]=[{value:"empty",text:x(a(419))},{value:"notEmpty",text:x(a(267))}];const f=function(){var l=J(d[a(274)]),k=B[a(539)][a(435)](l[1]);k[0]+=d.columnIndex;k[2]=k[0];k[1]++;k=J(B[a(539)][a(459)](k))[1];l=d.worksheet[a(387)](l[0]+"!"+k);k=l.length;const w=new Set;for(let p=1;p<k;p++)w.add(l[p][0]);return[...w][a(286)]()};d.visible=function(){d.el[a(278)](a(262))[a(258)](function(l){let k=l.getAttribute(a(232)),
-w;k===a(393)?w=d[a(312)]?.[a(332)](a(254)):k===a(287)&&(w=!d[a(312)]?.[a(332)](a(287)));l[a(426)](a(338),w)});d.criteriaInput[a(410)][a(514)]=d[a(439)]?"":"hidden"};d[a(502)]=function(){d[a(538)]="";d[a(393)]="";d[a(439)]=Fa[d.type]||null;let l=d[a(397)].children;for(let k=0;k<l[a(307)];k++)l[k][a(301)].contains(a(268))||l[k][a(301)][a(353)](d[a(422)])?l[k][a(410)].display="":l[k][a(410)][a(477)]=a(218);d[a(350)]=!d[a(439)];d.criteria=d[a(439)]?d[a(439)][0][a(492)]:"";d.visible()};d[a(377)]=function(){const l=
-f();d[a(462)]=l[a(266)](k=>({value:k,text:k}));d[a(424)]?d[a(205)]=d[a(424)]:d[a(205)]=l;d[a(422)]=d[a(225)].type;d.criteria=d[a(225)][a(312)];d.validation[a(492)]&&("date"===d.type?(d[a(433)]=d[a(225)][a(492)][0],d[a(228)]=d.validation[a(492)][1]):d[a(422)]===a(466)?(d[a(480)]=d[a(225)][a(492)][0],d[a(305)]=d[a(225)][a(492)][1]):(d.start=d.validation.value[0],d[a(393)]=d.validation[a(492)][1]))};d.onload=function(){d.undoChanges()};const e=()=>{if(!d[a(205)])return[];const l=f();return d.filterByValue.length===
-l.length?d.filterByValue.every(k=>l[a(332)](k))?void 0:[...d.filterByValue]:[...d[a(205)]]},g=()=>{const l=e();if(!d.type)return{validation:void 0,filter:l};const k={type:d[a(422)],criteria:d.criteria};d[a(422)]===a(527)?k.criteria?.[a(332)](a(254))?k.value=[d[a(433)],d[a(228)]]:k[a(492)]=[d[a(433)]]:d[a(422)]===a(466)?k.criteria&&k[a(312)][a(332)](a(254))?k.value=[jSuites[a(488)][a(547)](a(319)+d[a(480)]),jSuites[a(488)][a(547)](a(319)+d[a(305)])]:k[a(492)]=[jSuites[a(488)][a(547)](a(319)+d.startTime)]:
-k[a(312)]?.[a(332)](a(254))?k[a(492)]=[d[a(538)],d.end]:k.value=[d[a(538)]];return{validation:k,filter:l}};d[a(431)]=function(){d.update(d[a(290)],g())};const h=[a(205),a(422),"criteria",a(433),a(228),a(480),a(305),a(538),a(393)],n=()=>{const {filter:l,validation:k}=g();if(Array.isArray(l)&&Array[a(495)](d[a(424)])){if(l[a(224)]((w,p)=>p>=d[a(424)][a(307)]||w!==d[a(424)][p]))return!1}else if(l||d[a(424)])return!1;if(!k)return!d.validation;if(!d[a(225)]||k[a(422)]!==d[a(225)][a(422)]||k[a(312)]!==
-d[a(225)][a(312)])return!1;if(k[a(492)]&&d[a(225)][a(492)]){if(k.value[0]!=d.validation[a(492)][0]||k[a(492)][1]!=d.validation[a(492)][1])return!1}else if(k.value||d[a(225)][a(492)])return!1;return!0};return d.onchange=function(l){"type"===l?d.showOptions():l===a(312)&&d[a(434)]();h[a(332)](l)&&(l=!n(),d[a(378)][a(410)][a(477)]=l?"":a(218))},l=>l`
+        `},FilterCard:function(b,{track:c}){const d=this;c("filter1");ha(d);d[a(507)]=[];d[a(244)]=[{value:a(514),text:x(a(307))},{value:a(445),text:x(a(400))}];const f=function(){var p=J(d[a(298)]),h=B[a(382)][a(376)](p[1]);h[0]+=d.columnIndex;h[2]=h[0];h[1]++;h=J(B[a(382)][a(510)](h))[1];p=d[a(265)][a(505)](p[0]+"!"+h);h=p[a(516)];const v=new Set;for(let r=1;r<h;r++)v[a(195)](p[r][0]);return[...v].sort()};d[a(203)]=function(){d.el[a(373)](a(292))[a(509)](function(p){let h=p.getAttribute(a(198)),
+v;h===a(191)?v=d[a(512)]?.includes(a(390)):h===a(174)&&(v=!d[a(512)]?.[a(170)]("valid"));p.setAttribute(a(439),v)});d[a(289)].style[a(422)]=d[a(498)]?"":a(213)};d.showOptions=function(){d[a(478)]="";d[a(191)]="";d[a(498)]=Fa[d[a(179)]]||null;let p=d.validationElement[a(323)];for(let h=0;h<p[a(516)];h++)p[h][a(154)][a(310)](a(181))||p[h].classList[a(310)](d[a(179)])?p[h].style[a(328)]="":p[h][a(274)][a(328)]=a(497);d.allowEmptyCriteria=!d[a(498)];d[a(512)]=d[a(498)]?d[a(498)][0][a(267)]:"";d[a(203)]()};
+d[a(500)]=function(){const p=f();d[a(507)]=p[a(467)](h=>({value:h,text:h}));d[a(332)]?d[a(277)]=d[a(332)]:d.filterByValue=p;d.type=d.validation[a(179)];d[a(512)]=d[a(369)][a(512)];d[a(369)].value&&(d[a(179)]===a(178)?(d.startDate=d[a(369)][a(267)][0],d[a(190)]=d[a(369)].value[1]):d[a(179)]===a(185)?(d[a(173)]=d[a(369)].value[0],d.endTime=d[a(369)][a(267)][1]):(d[a(478)]=d.validation[a(267)][0],d[a(191)]=d[a(369)][a(267)][1]))};d.onload=function(){d[a(500)]()};const e=()=>{if(!d[a(277)])return[];const p=
+f();return d[a(277)][a(516)]===p[a(516)]?d[a(277)][a(425)](h=>p[a(170)](h))?void 0:[...d[a(277)]]:[...d[a(277)]]},g=()=>{const p=e();if(!d[a(179)])return{validation:void 0,filter:p};const h={type:d[a(179)],criteria:d.criteria};"date"===d.type?h.criteria?.[a(170)](a(390))?h.value=[d.startDate,d.endDate]:h[a(267)]=[d[a(201)]]:d[a(179)]===a(185)?h[a(512)]&&h.criteria[a(170)](a(390))?h[a(267)]=[jSuites[a(207)][a(466)](a(491)+d.startTime),jSuites[a(207)].dateToNum("1899-12-31 "+d[a(263)])]:h[a(267)]=[jSuites[a(207)].dateToNum(a(491)+
+d[a(173)])]:h.criteria?.[a(170)](a(390))?h.value=[d[a(478)],d.end]:h[a(267)]=[d.start];return{validation:h,filter:p}};d.applyValidation=function(){d.update(d[a(401)],g())};const k=[a(277),"type",a(512),a(201),a(190),"startTime","endTime",a(478),a(191)],l=()=>{const {filter:p,validation:h}=g();if(Array[a(476)](p)&&Array.isArray(d[a(332)])){if(p[a(225)]((v,r)=>r>=d[a(332)].length||v!==d.filter1[r]))return!1}else if(p||d[a(332)])return!1;if(!h)return!d[a(369)];if(!d[a(369)]||h[a(179)]!==d[a(369)][a(179)]||
+h.criteria!==d[a(369)].criteria)return!1;if(h[a(267)]&&d[a(369)].value){if(h[a(267)][0]!=d[a(369)].value[0]||h[a(267)][1]!=d[a(369)][a(267)][1])return!1}else if(h[a(267)]||d[a(369)].value)return!1;return!0};return d[a(187)]=function(p){p===a(179)?d.showOptions():p===a(512)&&d[a(203)]();k[a(170)](p)&&(p=!l(),d[a(407)][a(274)].display=p?"":a(497))},p=>p`
             <div class="pivot-table-card-background">
@@ -139,7 +137,7 @@ <div :ref="self.card" class="pivot-table-card" onmousedown="self.onDragStart">
 
-                    <h4>${x(a(529))}</h4>
+                    <h4>${x(a(188))}</h4>
 
                     <div class="lm-row">
                         <div class="lm-column lm-f1">
-                            <label>${x("Values")}</label>
+                            <label>${x(a(339))}</label>
                             <Dropdown :data="self.possibleValues" :bind="self.filterByValue" :multiple="true" :width="512" />
@@ -158,3 +156,3 @@ </div>
                                     <div class="lm-form-group">
-                                        <label class="label">${x(a(432))}</label>
+                                        <label class="label">${x(a(286))}</label>
                                         <Dropdown :data="${Ea}" :bind="self.type" />
@@ -165,3 +163,3 @@ </div>
                                     <div class="lm-form-group" :ref="self.criteriaInput">
-                                        <label class="label">${x(a(242))}</label>
+                                        <label class="label">${x(a(480))}</label>
                                         <Dropdown :data="self.criterias" :bind="self.criteria" :allowEmpty="self.allowEmptyCriteria" />
@@ -178,3 +176,3 @@ </div>
                                     <div class="lm-form-group">
-                                        <label class="label">${x(a(549))}</label>
+                                        <label class="label">${x("Value")}</label>
                                         <input type="text" :bind="self.start" class="lm-input" />
@@ -197,3 +195,3 @@ </div>
                                     <div class="lm-form-group">
-                                        <label class="label">${x(a(549))}</label>
+                                        <label class="label">${x(a(413))}</label>
                                         <input type="text" :bind="self.start" class="lm-input" />
@@ -226,3 +224,3 @@ </div>
                                     <div class="lm-form-group">
-                                        <label class="label">${x(a(549))}</label>
+                                        <label class="label">${x(a(413))}</label>
                                         <input type="text" :bind="self.startTime" data-mask='hh:mm:ss' class="lm-input" />
@@ -249,44 +247,50 @@ </div>
             </div>
-        `}});const O=Symbol("last row"),X=Symbol(a(304)),E=Symbol("internal properties"),M=Symbol("total symbol"),ia=Symbol(a(524)),P=(b,c)=>{b=B[a(362)][b]([c]);return b instanceof Error?b[a(243)]:b},Ga=function(b,c,d){const f=b[a(543)]||[],e=b.columns||[],g=b.cells||[],h=function(m,q){if(typeof m===a(302))return{exists:!1,values:[]};if(m.get(X)||0===e.length&&(0===f[a(307)]||m[a(221)](O)))return m=m.get(E)[a(221)](q[a(290)]),{exists:!0,values:Array[a(495)](m)?m:[]};const t={exists:!1,values:[]};
-return m[a(258)]((v,u)=>{typeof u!==a(494)&&(v=h(v,q),t[a(212)]=t.exists||v[a(212)],t[a(501)][a(204)](...v[a(501)]))}),t},n=function(m,q){const t=c[f[m][a(290)]],v=m===f[a(307)]-1;for(let z=0;z<t[a(307)];z++){var u=t[z];if(u=q[a(221)](u)){if(v)l(0,u);else{n(m+1,u);var y=new Map;u[a(317)](M,y);w(u,y)}if(0!==g[a(307)])for(y=0;y<g[a(307)];y++){const C=g[y];var {values:A}=h(u,C);0<A[a(307)]&&(A=P(C.method,A),!u[a(217)](E)&&u[a(317)](E,new Map),u.get(E)[a(317)](C[a(328)]+"-"+C[a(290)],A))}else({exists:y}=
-h(u,{columnIndex:void 0})),y&&(!u.has(E)&&u.set(E,new Map),u[a(221)](E).set(ia,!0))}}},l=function(m,q){if(0!==e[a(307)]){var t=c[e[m].columnIndex],v=m===e[a(307)]-1;for(let C=0;C<t[a(307)];C++){var u=t[C];u=q?q[a(221)](u):void 0;if(v)for(var y=0;y<g[a(307)];y++){var A=g[y],z=u?u[a(221)](E).get(A[a(290)]):void 0;typeof z!==a(302)&&(z=P(A[a(328)],z),u[a(221)](E).set(A[a(328)]+"-"+A[a(290)],z))}else for(l(m+1,u),y=0;y<g[a(307)];y++)A=g[y],{values:z}=h(u,A),0<z[a(307)]&&(z=P(A[a(328)],z),!u[a(217)](E)&&
-u.set(E,new Map),u.get(E).set(A[a(328)]+"-"+A[a(290)],z))}}},k=function(m,q,t){if("undefined"===typeof m)return{exists:!1,values:[]};if(0===f[a(307)]||m[a(221)](O)){for(let u=0;u<t.length;u++)if(m=m[a(221)](t[u]),typeof m===a(302))return{exists:!1,values:[]};return h(m,q)}const v={exists:!1,values:[]};return m.forEach((u,y)=>{typeof y!==a(494)&&(u=k(u,q,t),v[a(212)]=v[a(212)]||u[a(212)],v[a(501)][a(204)](...u[a(501)]))}),v},w=function(m,q,t=[]){if(0!==e.length){var v=t[a(307)],u=c[e[v][a(290)]];v=
-v===e[a(307)]-1;for(let z=0;z<u[a(307)];z++){const C=u[z];var y=[...t,C];const D=new Map;q[a(317)](C,D);!v&&w(m,D,y);if(0!==g[a(307)]){const F=new Map;for(let I=0;I<g[a(307)];I++){const Y=g[I];var {values:A}=k(m,Y,y);0<A[a(307)]&&(A=P(Y.method,A),F[a(317)](Y.method+"-"+Y[a(290)],A))}0!==F[a(436)]&&D[a(317)](E,F)}else({exists:y}=k(m,{columnIndex:void 0},y)),y&&D[a(317)](ia,!0);if(0===D[a(436)])q[a(438)](C);else v&&D[a(317)](X,!0)}}};0!==f.length&&n(0,d);!d[a(217)](E)&&d.set(E,new Map);b=d[a(221)](E);
-var p=new Map;d[a(317)](M,p);w(d,p);for(p=0;p<g[a(307)];p++){const m=g[p];var {values:r}=h(d,m);0<r.length&&(r=P(m.method,r),b[a(317)](m[a(328)]+"-"+m.columnIndex,r))}},Q=function(b,c,d){const f=b[a(328)]+"-"+b[a(290)],e=f+"-"+b[a(544)];c instanceof Map?c[a(258)]((g,h)=>{h===f?(g=(g/d*100).toFixed(2)+"%",c[a(317)](e,g)):"object"===typeof g&&Q(b,g,d)}):Object[a(245)](c)[a(258)](([g,h])=>{g===f?(g=(h/d*100)[a(517)](2)+"%",c[e]=g):typeof h===a(530)&&Q(b,h,d)})},sa=(b,c,d)=>{const f=c.get(O);var e=b[a(328)]+
-"-"+b[a(290)];const g=e+"-"+b[a(544)];if(f||!1===d){d=c.get(E);const h=d[a(221)](e);d.set(g,"100.00%");c[a(258)]((n,l)=>{typeof l!==a(494)&&Q(b,n,h)})}else c[a(258)]((h,n)=>{typeof n!==a(494)&&sa(b,h)});if(d=c[a(221)](M))c=c.get(E),e=c[a(221)](e),c[a(317)](g,"100.00%"),Q(b,d,e)},ja=(b,c,d)=>{if(c[a(217)](E)){var f=b[a(328)]+"-"+b[a(290)];const g=f+"-"+b[a(544)];var e=c.get(E)[a(221)](f);f=d[a(221)](E)[a(221)](f);e=(e/f*100)[a(517)](2)+"%";c[a(221)](E).set(g,e)}c.forEach((g,h)=>{typeof h!==a(494)&&
-ja(b,g,d[a(221)](h))})},ta=(b,c,d,f)=>{if(c[a(221)](O))c[a(258)]((n,l)=>{"symbol"!==typeof l&&ja(b,n,d[a(221)](l))});else{c[a(258)]((n,l)=>{typeof l!==a(494)&&ta(b,n,d,f)});var e=c[a(221)](M);e&&ja(b,e,d)}if(c=c[a(221)](E)){var g=b[a(328)]+"-"+b[a(290)];e=g+"-"+b.showAs;var h=c[a(221)](g);g=f[a(221)](g);h=(h/g*100)[a(517)](2)+"%";c[a(317)](e,h)}},Ha=function(b,c){var d=c.length;const f=b[a(543)]||[];var e=b[a(239)]||[],g=f[a(331)](e);const h=g.map(z=>z[a(290)]);var n=h[a(307)];const l=b[a(464)]||
-[],k=[...(new Set(l.map(z=>z[a(290)])))],w=k[a(307)],p=b[a(244)]||[],r=p[a(307)],m=new Map,q={};for(let z=1;z<d;z++){const C=c[z];if(0!==r){var t=void 0;for(t=0;t<r;t++){var v=p[t],u=C[v.columnIndex],y=v[a(391)];if(y){var A=y[a(307)];let D;for(D=0;D<A&&u!==y[D];D++);if(D===A)break}if((v=v.validation)&&!jSuites.validations(u,v))break}if(t!==r)continue}t=m;for(u=0;u<n;u++)v=h[u],y=C[v],t.has(y)||(A=new Map,u===f[a(307)]-1&&A[a(317)](O,!0),t.set(y,A)),t=t[a(221)](y),!q[v]&&(q[v]=new Set),q[v][a(457)](y);
-0!==e.length&&!t[a(217)](X)&&t[a(317)](X,!0);!t[a(217)](E)&&t.set(E,new Map);t=t[a(221)](E);for(u=0;u<w;u++)v=k[u],y=C[v],!t[a(217)](v)&&t[a(317)](v,[]),t[a(221)](v)[a(204)](y)}for(c=0;c<n;c++)d=g[c],e=q[d[a(290)]]?[...q[d[a(290)]]]:[],e[a(286)](),!d.ascendingOrder&&e[a(490)](),q[d[a(290)]]=e;Ga(b,q,m);if(0!==l[a(307)])for(b=0;b<l[a(307)];b++)g=l[b],g[a(544)]&&g[a(544)]!==a(528)&&("total-%"===g.showAs?(n=m.get(E).get(g[a(328)]+"-"+g.columnIndex),Q(g,m,n)):g[a(544)]===a(551)?sa(g,m,0!==f[a(307)]):
-"column-%"===g.showAs&&(n=m[a(221)](M),ta(g,m,n,m.get(E))));return{obj:m,fieldsPossibleValues:q}},R=b=>{const c=b.method+"-"+b[a(290)];return b[a(544)]&&b[a(544)]!==a(528)?c+"-"+b[a(544)]:c},Ia=function(b,c,d,f,e,g){const h=d[a(543)]||[],n=d[a(239)]||[],l=d[a(464)]||[],k=function(m,q,t,v){var u=h[q];const y=S(f[u.columnIndex],u,t,l,!0);({collapsed:u}=u);const A=q===h[a(307)]-1;for(let F=0;F<y[a(307)];F++){var z=y[F],C=t[a(221)](z);let I;A?I=w(m,0,C,v):((!u||!u[a(332)](z))&&k(m,q+1,C,v),I=p(m,C[a(221)](M),
-v));z=C[a(221)](E);for(C=0;C<l.length;C++){var D=R(l[C]);D=z?.get(D);typeof D!==a(302)&&(e[c][I]=D);I++}c++}},w=function(m,q,t,v){if(0===n[a(307)])return m;var u=n[q];var y=f[u[a(290)]];y=S(y,u,v,l,!1);({collapsed:u}=u);const A=q===n[a(307)]-1;for(let F=0;F<y[a(307)];F++){var z=y[F],C=t?t[a(221)](z):void 0;if(A)for(z=0;z<l[a(307)];z++){var D=R(l[z]);D=C?.[a(221)](E)?.[a(221)](D);typeof D!==a(302)&&(e[c][m]=D);m++}else for(u&&u.includes(z)||(m=w(m,q+1,C,v[a(221)](z))),C=C?.[a(221)](E),z=0;z<l[a(307)];z++)D=
-R(l[z]),D=C?.get(D),typeof D!==a(302)&&(e[c][m]=D),m++}return m},p=function(m,q,t,v=[]){if(0===n[a(307)])return m;var u=v[a(307)],y=n[u];var A=f[y[a(290)]];A=S(A,y,t,l,!1);u=u===n[a(307)]-1;({collapsed:y}=y);typeof e[c]===a(302)&&(e[c]=[]);for(let D=0;D<A.length;D++){var z=A[D],C=[...v,z];const F=q?.[a(221)](z);u||y&&y[a(332)](z)||(m=p(m,F,t[a(221)](z),C));for(z=0;z<l.length;z++)C=R(l[z]),C=F?.[a(221)](E)?.[a(221)](C),"undefined"!==typeof C&&(e[c][m]=C),m++}return m};d=g.get(M);0!==h.length&&k(b,
-0,g,d);b=p(b,d,d);for(d=0;d<l[a(307)];d++){var r=R(l[d]);r=g[a(221)](E)[a(221)](r);typeof r!==a(302)&&(e[a(307)]<=c&&(e[c]=[]),e[c][b]=r);b++}},S=(b,{sortBy:c,ascendingOrder:d},f,e,g)=>{if(c&&c!==a(257)){e=e[a(442)](n=>n.id===c);if(!e)throw Error(a(366));const h=e[a(328)]+"-"+e[a(290)];b=b[a(266)](n=>{const l=f.get(n)?.get(E);return[n,l?l[a(221)](h):void 0]});b=b.filter(n=>typeof n[1]!==a(302));b[a(286)]((n,l)=>n[1]-l[1]);b=b.map(n=>n[0])}else b=b[a(391)](h=>{h=f[a(221)](h);return g&&(h=h?.[a(221)](E)),
-h&&(0!==h[a(436)]||h[a(221)](ia))})[a(286)]();return!d&&b[a(490)](),b},Ja=function(b,c,d,f,e,g){const h=c[a(543)]||[],n=c[a(464)]||[],l=new Set,k=function(w,p,r,m){const q=h[r];var t=d[q[a(290)]];t=S(t,q,m,n,!0);const v=r===h.length-1,{collapsed:u}=q;for(let A=0;A<t[a(307)];A++){const z=t[A];f[a(307)]<=p&&(f[p]=[]);f[p][w]=z;if(!v){"object"!==typeof g[p]&&(g[p]={});var y=u&&u[a(332)](z);g[p][w]={columnIndex:q[a(290)],value:typeof z!==a(302)?z:"",isCollapsed:y};y||(p=k(w+1,p,r+1,m[a(221)](z)),f[a(307)]<=
-p&&(f[p]=[]),y="",typeof z!==a(302)&&null!==z&&(y=z+" "),y+=a(375),f[p][w]=y,l.add(p))}p++}return p};b=k(0,b,0,e);return f[a(307)]<=b&&f[a(204)]([]),f[b][0]=a(390),l},Ka=function(b,c,d,f,e,g,h,n){const l=d[a(239)]||[],k=d[a(464)]||[],w=b[1]-1,p=function(r,m,q,t){const v=l[q];var u=f[v[a(290)]];u=S(u,v,t,k,!1);const y=q===l[a(307)]-1,{collapsed:A}=v;for(let I=0;I<u[a(307)];I++){var z=u[I];e[a(307)]<=m&&(e[m]=[]);e[m][r]=z;if(y)if(1<k.length)for(z=0;z<k[a(307)];z++){var C=k[z];e.length<=m+1&&(e[m+1]=
-[]);var D=C[a(328)]+a(256);typeof g[0][C[a(290)]]!==a(302)&&(D+=" "+g[0][C[a(290)]]);e[m+1][r]=D;r++}else r++;else if("object"!==typeof n[m]&&(n[m]={}),C=A&&A[a(332)](z),n[m][r]={columnIndex:v[a(290)],value:typeof z!==a(302)?z:"",isCollapsed:C},C)if(0!==k[a(307)]){for(;w>=e[a(307)];)e[a(204)]([]);for(C=0;C<k[a(307)];C++){D=k[C];var F="";typeof z!==a(302)&&(F=z+" ");F+=D[a(328)];typeof g[0][D.columnIndex]!==a(302)&&(F+=a(395)+g[0][D[a(290)]]);e[w][r]=F;r++}}else r++;else if(C=r,r=p(r,m+1,q+1,t[a(221)](z)),
-C!==r)if(0!==k[a(307)])for(C=0;C<k[a(307)];C++)D=k[C],F="","undefined"!==typeof z&&(F=z+" "),F+=D[a(328)],typeof g[0][D[a(290)]]!==a(302)&&(F+=a(395)+g[0][D[a(290)]]),e[m][r]=F,r++;else e[m][r]=z+" Total",r++}return r};b=0!==l[a(307)]?p(b[0],1,0,h[a(221)](M)):b[0];if(1>k[a(307)])e[a(307)]<=c&&(e[c]=[]),e[c][b]=a(375);else for(e[a(307)]<=c&&(e[c]=[]),d=0;d<k[a(307)];d++){h=k[d];let r=a(553)+h[a(328)];typeof g[0][h.columnIndex]!==a(302)&&(r+=a(395)+g[0][h.columnIndex]);e[c][b]=r;b++}};class T extends Error{constructor(b){super("SPILL");
-this[a(496)]=b}}const Ma=function({data:b,groups:c},[d,f],e,g){var h=g[a(436)]||[0,0];const [n,l]=h,{records:k,options:{data:w}}=e;e=b[a(307)];h=Math[a(452)](...b.map(A=>A[a(307)]));if(h>n)for(var p=0;p<l;p++){var r=f+p,m=k[r],q=w[r];for(var t=n;t<h;t++){var v=d+t;if(m){var u=m[v];if(u&&null!==u.v&&typeof u.v!==a(302))throw new T({x:v,y:r});}if(q&&(u=q[v],null!==u&&""!==u&&typeof u!==a(302)))throw new T({x:v,y:r});}}for(p=l;p<e;p++)for(r=f+p,m=k[r],q=w[r],t=0;t<h;t++){v=d+t;if(m&&(u=m[v])&&null!==
-u.v&&typeof u.v!==a(302))throw new T({x:v,y:r});if(q&&(u=q[v],null!==u&&""!==u&&"undefined"!==typeof u))throw new T({x:v,y:r});}p=[];r=[];for(m=0;m<e;m++){v=b[m];u=c[m];q=f+m;for(t=0;t<h;){const A=d+t;var y=v[t];p[a(204)]({x:A,y:q,value:"undefined"!==typeof y?y:null});if(u&&u[t])y=u[t],r[a(204)]({x:A,y:q,value:{type:La,readOnly:!0,options:{...y,pivotTableId:g.id}}});else r[a(204)]({x:A,y:q,value:{type:a(279),readOnly:!0}});t++}for(;t<n;)v=d+t,p.push({x:v,y:q,value:null}),r.push({x:v,y:q,value:null}),
-t++}return{dataRecords:p,propertyRecords:r,size:[h,e]}},ua=function(b,[c,d],[f],e){b=[{x:c,y:d,value:e?a(425):null}];e=[{x:c,y:d,value:e?"text":{type:Na}}];for(let g=1;g<f;g++){const h=c+g;b[a(204)]({x:h,y:d,value:null});e[a(204)]({x:h,y:d,value:null})}return{dataRecords:b,propertyRecords:e,size:[1,1]}},ka=Symbol("coordinate of the cell that prevented the table from being drawn"),Oa=function(b,c,d){var f=B[a(539)][a(277)](c.anchor);const [e,g]=f;var h=c[a(436)]||[0,0];const [n,l]=h;var k=[];let w=
-[];var p;let r=!1;try{b?(p=Ma(b,f,d,c),Aa(b[a(487)],h,p[a(436)],c,d)):(p=ua(c,f,h),aa(h,c,d)),delete c[ka]}catch(y){if(!(y instanceof T))throw y;c[ka]=y[a(496)];r=!0;p=ua(c,f,h,!0);aa(h,c,d)}({dataRecords:k,propertyRecords:w}=p);[h,f]=p.size;({records:p}=d);for(var m=0;m<f;m++){var q=g+m,t=p[q];for(var v=0;v<h;v++){var u=e+v;d[a(367)](u,q).pivot=!0}for(q=h;q<n;q++)(v=t[e+q])&&delete v.pivot}for(m=f;m<l;m++)for(t=g+m,q=p[t],v=0;v<n;v++)u=e+v,delete q[u].pivot,k[a(204)]({x:u,y:t,value:null}),w[a(204)]({x:u,
-y:t,value:null});pa(k,w,d);r&&(d[a(367)](e,g),d=d[a(219)](e,g),{data:k}=b,b=k.length,k=Math[a(452)](...k.map(y=>y[a(307)])),b=c[a(294)]+":"+B[a(539)][a(313)](k-1,b-1),d[a(426)](a(394),"For the table to be displayed, the range "+b+a(343)));c.size=[h,f]},L=function(b,c){var d=b[a(543)]||[],f=b[a(239)]||[];var e=b[a(464)]||[];if(0===d[a(307)]&&0===f[a(307)]&&0===e[a(307)])e=null;else{var g=b[a(274)],h=c,n=J(g);h=h[a(542)](n[0]);g=h.records;n=B[a(539)][a(435)](n[1]);var l=[];for(var k=n[1];k<=n[3];k++){var w=
-g[k],p=[];for(var r=n[0];r<=n[2];r++)h[a(219)](r,k),p.push(w[r].v);l[a(204)](p)}var {obj:m,fieldsPossibleValues:q}=Ha(b,l);g=d[a(307)];k=f[a(307)];w=Array(g)[a(405)](null);n=l[0];h=[];if(0<k){for(p=0;p<k;p++)r=f[p],w[a(204)](n[r[a(290)]]);1<e[a(307)]&&w[a(204)](a(238));h[a(204)](w)}f=[g,0<k?k+1+(0===k||1<e.length?1:0):1];k={};Ka(f,h[a(307)],b,q,h,l,m,k);for(l=f[1]-1;h.length<=l;)h[a(204)]([]);l=h[l];for(w=0;w<g;w++)l[w]=n[d[w][a(290)]];g={headerHeight:f[1]-1,hasHighlightedColumn:1<g};d[a(307)]&&(d=
-Ja(f[1],b,q,h,m,k),g[a(468)]=d);e=(0!==e[a(307)]&&Ia(f[0],f[1],b,q,h,m),{data:h,groups:k,styleInfo:g})}Oa(e,b,c)},Z=[a(543),a(239)],U=[a(464),a(543),a(239),"filters"],la=U.length,va=(b,c)=>{const d={columnIndex:b[a(290)]};c===a(464)?(d.id=jSuites[a(413)](),d[a(328)]="SUM"):c!==a(543)&&c!==a(239)||(d[a(460)]=b.sortBy||a(257),d[a(381)]=typeof b.ascendingOrder===a(337)?b[a(381)]:!0,typeof b[a(518)]!==a(337)||(d[a(518)]=b[a(518)]));return d},Pa=function(){let b=this;b.rows=[];b[a(239)]=[];b[a(464)]=[];
-b[a(244)]=[];b[a(261)]=[];const c=f=>f?f[a(266)](e=>({...e,columnName:b[a(261)][e.columnIndex]})):[];b[a(503)]=function(){const f={text:x("Name"),value:a(257)};if(!b[a(306)][a(464)])return[f];const e=b.pivotTable[a(464)].map(g=>({text:g[a(328)]+a(395)+b[a(261)][g[a(290)]],value:g.id}));return e[a(416)](f),e};b.updateSortableField=function(f){return function(){const e=a0_0x2294,g=b[e(503)]();b[f]=c(b.pivotTable[f])[e(266)](h=>(h.sortingOptions=G(g),h));b.refresh(f)}};b[a(214)]=b[a(493)](a(543));b[a(259)]=
-b[a(493)]("columns");b[a(404)]=function(){b.cells=c(b[a(306)][a(464)]);b.refresh(a(464))};b.updateFilters=function(){b[a(244)]=c(b[a(306)][a(244)]).map(({filter:f,...e})=>(e.filter1=f,e));b[a(282)](a(244))};b[a(380)]=function(){var f=J(b[a(306)][a(274)]);const e=B[a(539)][a(435)](f[1]);e[3]=e[1];const g=J(B[a(539)][a(459)](e))[1];f=b[a(309)].getDataFromRange(f[0]+"!"+g);b[a(261)]=f[0][a(266)]((h,n)=>typeof h!==a(302)&&null!==h&&""!==h?h:a(316)+B[a(539)][a(534)](n+e[0]));b[a(404)]();b[a(214)]();b[a(259)]();
-b[a(441)]()};b[a(498)]=function(){b[a(306)]=b[a(309)][a(346)][a(412)][b.tableIndex];b.source=b.pivotTable[a(274)];b.sourcePicker[a(386)]=b.source;b[a(380)]()};b[a(273)]=function(){b[a(498)]();b[a(340)]=b[a(306)][a(274)];b[a(364)].open()};b[a(209)]=f=>function(e){const g=jSuites[a(430)](e,{data:[],content:a(457),onchange:function(h,n,l,k,w){h={columnIndex:b[a(261)].indexOf(l),sortBy:"name",ascendingOrder:!0};n=G(b[a(306)]);!n[f]&&(n[f]=[]);n[f][a(204)](h);H[a(504)](b[a(309)],n)}});e[a(521)][0][a(321)](a(260),
-function(){const h=[...b[a(543)],...b[a(239)]].map(l=>l[a(290)]),n=b.fields[a(391)]((l,k)=>!h[a(332)](k));g.setOptions({data:n});g[a(273)]()})};b.createRowPicker=b[a(209)](a(543));b[a(352)]=b[a(209)]("columns");b[a(472)]=function(f){const e=jSuites[a(430)](f,{data:[],content:a(457),onchange:function(g,h,n,l,k){g={id:jSuites[a(413)](),columnIndex:b[a(261)][a(470)](n),method:a(454)};h=G(b[a(306)]);!h[a(464)]&&(h[a(464)]=[]);h[a(464)][a(204)](g);H.call(b.instance,h)}});f[a(521)][0][a(321)](a(260),function(){e[a(206)]({data:b[a(261)]});
-e[a(273)]()})};b[a(403)]=function(f){const e=jSuites[a(430)](f,{data:[],content:"add",onchange:function(g,h,n,l,k){g={columnIndex:b[a(261)][a(470)](n)};h=G(b[a(306)]);!h[a(244)]&&(h[a(244)]=[]);h[a(244)].push(g);H.call(b.instance,h)}});f[a(521)][0][a(321)]("mousedown",function(){const g=b[a(244)][a(266)](n=>n[a(290)]),h=b[a(261)].filter((n,l)=>!g[a(332)](l));e[a(206)]({data:h});e[a(273)]()})};const d=function(){var f=b.source;const e=G(b[a(306)]),g=e[a(274)];e[a(274)]=f;f=J(f);f=B[a(539)][a(435)](f[1]);
-const h=f[2]-f[0]+1;U[a(258)](n=>{var l=e[n];l&&(l=l[a(391)](k=>k[a(290)]<h),Z.includes(n)&&l[a(258)](k=>{k[a(460)]!==a(257)&&0>e[a(464)][a(327)](w=>w.id===k.sortBy)&&(k[a(460)]=a(257),k.ascendingOrder=!0)}),e[n]=l)});H.call(b[a(309)],e);wa(e,b[a(309)],g)};return b[a(330)]=function(){B[a(430)](b[a(324)],{worksheetName:!0,onchange:function(f){b[a(274)]=f}});b[a(324)][a(321)](a(335),function(f){try{na(b.source)}catch(e){jSuites[a(525)]({error:1,message:x(e.message)});b[a(324)].innerText=b[a(340)];return}b[a(340)]=
-b[a(274)];d()})},b.updateField=function(f){return function(e,g){const h=a0_0x2294,n=G(b[h(306)]),l=n[f][h(442)](k=>k[h(290)]===e);Object[h(245)](g)[h(258)](([k,w])=>{l[k]=w});H[h(504)](b.instance,n)}},b[a(281)]=b[a(458)](a(543)),b[a(253)]=b[a(458)](a(239)),b[a(211)]=b.updateField(a(244)),b[a(351)]=function(f){return function(e){const g=a0_0x2294,h=G(b[g(306)]),n=h[f],l=n[g(327)](k=>k.columnIndex===e);n[g(429)](l,1);H[g(504)](b[g(309)],h)}},b[a(358)]=b[a(351)](a(543)),b[a(516)]=b[a(351)](a(239)),b[a(500)]=
-b[a(351)](a(244)),b.updateCell=function(f,e){const g=G(b[a(306)]),h=g[a(464)][a(442)](n=>n.id===f);Object[a(245)](e)[a(258)](([n,l])=>{h[n]=l});H[a(504)](b[a(309)],g)},b[a(370)]=function(f){const e=G(b[a(306)]),g=e.cells.findIndex(h=>h.id===f);e[a(464)].splice(g,1);[...e[a(543)],...e[a(239)]].forEach(h=>{h[a(460)]===f&&(h[a(460)]=a(257),h[a(381)]=!0)});H.call(b[a(309)],e)},b.moveItem=function(f){return function(e,g,h){const n=a0_0x2294,l=G(b[n(306)]);var k=l[f];const w="number"===typeof e?k[n(327)](r=>
-r[n(290)]===e):k[n(327)](r=>r.id===e),p=k[n(429)](w,1)[0];k=l[g];if(f===g)k.splice(h,0,p);else if(g===n(464))g=va(p,g),k[n(429)](h,0,g);else{f===n(464)&&Z[n(258)](m=>{l[m].forEach(q=>{const t=a0_0x2294;q[t(460)]===p.id&&(q[t(460)]=t(257),q[t(381)]=!0)})});const r=p[n(290)];(g===n(244)?k:[...l[n(543)],...l[n(239)]])[n(224)](m=>m.columnIndex===r)||(g=va(p,g),k.splice(h,0,g))}H.call(b[n(309)],l)}},b.moveRow=b[a(203)](a(543)),b.moveColumn=b[a(203)](a(239)),b.moveCell=b.moveItem("cells"),b[a(467)]=b[a(203)](a(244)),
-b.onchange=function(f){f===a(464)&&(b[a(214)](),b[a(259)]())},f=>f`
+        `}});const O=Symbol(a(297)),X=Symbol(a(487)),E=Symbol(a(316)),M=Symbol(a(220)),ia=Symbol(a(385)),P=(b,c)=>{b=B[a(211)][b]([c]);return b instanceof Error?b[a(317)]:b},Ga=function(b,c,d){const f=b.rows||[],e=b.columns||[],g=b[a(283)]||[],k=function(m,n){if("undefined"===typeof m)return{exists:!1,values:[]};if(m[a(312)](X)||0===e[a(516)]&&(0===f[a(516)]||m.get(O)))return m=m.get(E)[a(312)](n[a(401)]),{exists:!0,values:Array[a(476)](m)?m:[]};const u={exists:!1,values:[]};return m[a(509)]((w,t)=>
+{typeof t!==a(184)&&(w=k(w,n),u[a(250)]=u[a(250)]||w[a(250)],u.values[a(223)](...w.values))}),u},l=function(m,n){const u=c[f[m][a(401)]],w=m===f[a(516)]-1;for(let y=0;y<u[a(516)];y++){var t=u[y];if(t=n[a(312)](t)){if(w)p(0,t);else{l(m+1,t);var z=new Map;t[a(248)](M,z);v(t,z)}if(0!==g.length)for(z=0;z<g[a(516)];z++){const C=g[z];var {values:A}=k(t,C);0<A[a(516)]&&(A=P(C[a(284)],A),!t[a(404)](E)&&t[a(248)](E,new Map),t[a(312)](E).set(C.method+"-"+C[a(401)],A))}else({exists:z}=k(t,{columnIndex:void 0})),
+z&&(!t[a(404)](E)&&t[a(248)](E,new Map),t[a(312)](E)[a(248)](ia,!0))}}},p=function(m,n){if(0!==e[a(516)]){var u=c[e[m][a(401)]],w=m===e[a(516)]-1;for(let C=0;C<u.length;C++){var t=u[C];t=n?n[a(312)](t):void 0;if(w)for(var z=0;z<g[a(516)];z++){var A=g[z],y=t?t[a(312)](E)[a(312)](A[a(401)]):void 0;typeof y!==a(438)&&(y=P(A[a(284)],y),t[a(312)](E).set(A[a(284)]+"-"+A[a(401)],y))}else for(p(m+1,t),z=0;z<g[a(516)];z++)A=g[z],{values:y}=k(t,A),0<y.length&&(y=P(A[a(284)],y),!t[a(404)](E)&&t[a(248)](E,new Map),
+t[a(312)](E)[a(248)](A.method+"-"+A.columnIndex,y))}}},h=function(m,n,u){if(typeof m===a(438))return{exists:!1,values:[]};if(0===f.length||m[a(312)](O)){for(let t=0;t<u[a(516)];t++)if(m=m[a(312)](u[t]),typeof m===a(438))return{exists:!1,values:[]};return k(m,n)}const w={exists:!1,values:[]};return m[a(509)]((t,z)=>{"symbol"!==typeof z&&(t=h(t,n,u),w[a(250)]=w[a(250)]||t[a(250)],w[a(387)][a(223)](...t[a(387)]))}),w},v=function(m,n,u=[]){if(0!==e[a(516)]){var w=u[a(516)],t=c[e[w].columnIndex];w=w===
+e.length-1;for(let y=0;y<t[a(516)];y++){const C=t[y];var z=[...u,C];const D=new Map;n[a(248)](C,D);!w&&v(m,D,z);if(0!==g[a(516)]){const F=new Map;for(let I=0;I<g[a(516)];I++){const Y=g[I];var {values:A}=h(m,Y,z);0<A[a(516)]&&(A=P(Y[a(284)],A),F[a(248)](Y.method+"-"+Y[a(401)],A))}0!==F[a(325)]&&D[a(248)](E,F)}else({exists:z}=h(m,{columnIndex:void 0},z)),z&&D[a(248)](ia,!0);if(0===D.size)n[a(336)](C);else w&&D[a(248)](X,!0)}}};0!==f[a(516)]&&l(0,d);!d.has(E)&&d[a(248)](E,new Map);b=d[a(312)](E);var r=
+new Map;d[a(248)](M,r);v(d,r);for(r=0;r<g[a(516)];r++){const m=g[r];var {values:q}=k(d,m);0<q[a(516)]&&(q=P(m[a(284)],q),b[a(248)](m[a(284)]+"-"+m[a(401)],q))}},Q=function(b,c,d){const f=b[a(284)]+"-"+b.columnIndex,e=f+"-"+b[a(278)];c instanceof Map?c[a(509)]((g,k)=>{k===f?(g=(g/d*100).toFixed(2)+"%",c[a(248)](e,g)):typeof g===a(391)&&Q(b,g,d)}):Object.entries(c)[a(509)](([g,k])=>{g===f?(g=(k/d*100)[a(375)](2)+"%",c[e]=g):"object"===typeof k&&Q(b,k,d)})},sa=(b,c,d)=>{const f=c[a(312)](O);var e=b[a(284)]+
+"-"+b.columnIndex;const g=e+"-"+b[a(278)];if(f||!1===d){d=c[a(312)](E);const k=d[a(312)](e);d[a(248)](g,"100.00%");c[a(509)]((l,p)=>{typeof p!==a(184)&&Q(b,l,k)})}else c[a(509)]((k,l)=>{typeof l!==a(184)&&sa(b,k)});if(d=c[a(312)](M))c=c[a(312)](E),e=c[a(312)](e),c[a(248)](g,a(299)),Q(b,d,e)},ja=(b,c,d)=>{if(c.has(E)){var f=b.method+"-"+b[a(401)];const g=f+"-"+b[a(278)];var e=c.get(E)[a(312)](f);f=d[a(312)](E).get(f);e=(e/f*100)[a(375)](2)+"%";c[a(312)](E)[a(248)](g,e)}c[a(509)]((g,k)=>{typeof k!==
+a(184)&&ja(b,g,d[a(312)](k))})},ta=(b,c,d,f)=>{if(c[a(312)](O))c.forEach((l,p)=>{typeof p!==a(184)&&ja(b,l,d[a(312)](p))});else{c.forEach((l,p)=>{"symbol"!==typeof p&&ta(b,l,d,f)});var e=c[a(312)](M);e&&ja(b,e,d)}if(c=c[a(312)](E)){var g=b[a(284)]+"-"+b[a(401)];e=g+"-"+b[a(278)];var k=c[a(312)](g);g=f.get(g);k=(k/g*100)[a(375)](2)+"%";c[a(248)](e,k)}},Ha=function(b,c){var d=c[a(516)];const f=b[a(196)]||[];var e=b[a(459)]||[],g=f[a(406)](e);const k=g.map(y=>y[a(401)]);var l=k[a(516)];const p=b[a(283)]||
+[],h=[...(new Set(p[a(467)](y=>y[a(401)])))],v=h[a(516)],r=b.filters||[],q=r[a(516)],m=new Map,n={};for(let y=1;y<d;y++){const C=c[y];if(0!==q){var u=void 0;for(u=0;u<q;u++){var w=r[u],t=C[w[a(401)]],z=w.filter;if(z){var A=z[a(516)];let D;for(D=0;D<A&&t!==z[D];D++);if(D===A)break}if((w=w[a(369)])&&!jSuites.validations(t,w))break}if(u!==q)continue}u=m;for(t=0;t<l;t++)w=k[t],z=C[w],u[a(404)](z)||(A=new Map,t===f.length-1&&A.set(O,!0),u[a(248)](z,A)),u=u[a(312)](z),!n[w]&&(n[w]=new Set),n[w][a(195)](z);
+0!==e[a(516)]&&!u[a(404)](X)&&u[a(248)](X,!0);!u.has(E)&&u[a(248)](E,new Map);u=u[a(312)](E);for(t=0;t<v;t++)w=h[t],z=C[w],!u[a(404)](w)&&u[a(248)](w,[]),u[a(312)](w)[a(223)](z)}for(c=0;c<l;c++)d=g[c],e=n[d[a(401)]]?[...n[d.columnIndex]]:[],e[a(169)](),!d.ascendingOrder&&e[a(349)](),n[d.columnIndex]=e;Ga(b,n,m);if(0!==p[a(516)])for(b=0;b<p[a(516)];b++)g=p[b],g[a(278)]&&g[a(278)]!==a(210)&&("total-%"===g[a(278)]?(l=m[a(312)](E).get(g[a(284)]+"-"+g[a(401)]),Q(g,m,l)):g[a(278)]===a(270)?sa(g,m,0!==f[a(516)]):
+g[a(278)]===a(162)&&(l=m[a(312)](M),ta(g,m,l,m[a(312)](E))));return{obj:m,fieldsPossibleValues:n}},R=b=>{const c=b[a(284)]+"-"+b[a(401)];return b[a(278)]&&b[a(278)]!==a(210)?c+"-"+b[a(278)]:c},Ia=function(b,c,d,f,e,g){const k=d.rows||[],l=d[a(459)]||[],p=d[a(283)]||[],h=function(m,n,u,w){var t=k[n];var z=f[t[a(401)]];z=S(z,t,u,p,!0);({collapsed:t}=t);const A=n===k.length-1;for(let F=0;F<z[a(516)];F++){var y=z[F],C=u[a(312)](y);let I;A?I=v(m,0,C,w):((!t||!t.includes(y))&&h(m,n+1,C,w),I=r(m,C[a(312)](M),
+w));y=C.get(E);for(C=0;C<p[a(516)];C++){var D=R(p[C]);D=y?.get(D);"undefined"!==typeof D&&(e[c][I]=D);I++}c++}},v=function(m,n,u,w){if(0===l.length)return m;var t=l[n];var z=f[t[a(401)]];z=S(z,t,w,p,!1);({collapsed:t}=t);const A=n===l[a(516)]-1;for(let F=0;F<z[a(516)];F++){var y=z[F],C=u?u.get(y):void 0;if(A)for(y=0;y<p[a(516)];y++){var D=R(p[y]);D=C?.[a(312)](E)?.[a(312)](D);"undefined"!==typeof D&&(e[c][m]=D);m++}else for(t&&t[a(170)](y)||(m=v(m,n+1,C,w[a(312)](y))),C=C?.get(E),y=0;y<p.length;y++)D=
+R(p[y]),D=C?.[a(312)](D),"undefined"!==typeof D&&(e[c][m]=D),m++}return m},r=function(m,n,u,w=[]){if(0===l[a(516)])return m;var t=w[a(516)],z=l[t];var A=f[z[a(401)]];A=S(A,z,u,p,!1);t=t===l[a(516)]-1;({collapsed:z}=z);typeof e[c]===a(438)&&(e[c]=[]);for(let D=0;D<A[a(516)];D++){var y=A[D],C=[...w,y];const F=n?.[a(312)](y);t||z&&z.includes(y)||(m=r(m,F,u[a(312)](y),C));for(y=0;y<p[a(516)];y++)C=R(p[y]),C=F?.[a(312)](E)?.[a(312)](C),"undefined"!==typeof C&&(e[c][m]=C),m++}return m};d=g[a(312)](M);0!==
+k.length&&h(b,0,g,d);b=r(b,d,d);for(d=0;d<p[a(516)];d++){var q=R(p[d]);q=g[a(312)](E)[a(312)](q);"undefined"!==typeof q&&(e[a(516)]<=c&&(e[c]=[]),e[c][b]=q);b++}},S=(b,{sortBy:c,ascendingOrder:d},f,e,g)=>{if(c&&c!==a(314)){e=e[a(423)](l=>l.id===c);if(!e)throw Error("Invalid sorting option");const k=e[a(284)]+"-"+e[a(401)];b=b[a(467)](l=>{const p=f[a(312)](l)?.get(E);return[l,p?p[a(312)](k):void 0]});b=b[a(282)](l=>typeof l[1]!==a(438));b[a(169)]((l,p)=>l[1]-p[1]);b=b[a(467)](l=>l[0])}else b=b[a(282)](k=>
+{k=f[a(312)](k);return g&&(k=k?.[a(312)](E)),k&&(0!==k[a(325)]||k.get(ia))})[a(169)]();return!d&&b[a(349)](),b},Ja=function(b,c,d,f,e,g){const k=c[a(196)]||[],l=c.cells||[],p=new Set,h=function(v,r,q,m){const n=k[q];var u=d[n[a(401)]];u=S(u,n,m,l,!0);const w=q===k[a(516)]-1,{collapsed:t}=n;for(let A=0;A<u.length;A++){const y=u[A];f.length<=r&&(f[r]=[]);f[r][v]=y;if(!w){"object"!==typeof g[r]&&(g[r]={});var z=t&&t[a(170)](y);g[r][v]={columnIndex:n[a(401)],value:"undefined"!==typeof y?y:"",isCollapsed:z};
+z||(r=h(v+1,r,q+1,m.get(y)),f[a(516)]<=r&&(f[r]=[]),z="",typeof y!==a(438)&&null!==y&&(z=y+" "),z+="Total",f[r][v]=z,p.add(r))}r++}return r};b=h(0,b,0,e);return f[a(516)]<=b&&f[a(223)]([]),f[b][0]=a(309),p},Ka=function(b,c,d,f,e,g,k,l){const p=d[a(459)]||[],h=d[a(283)]||[],v=b[1]-1,r=function(q,m,n,u){const w=p[n];var t=f[w[a(401)]];t=S(t,w,u,h,!1);const z=n===p[a(516)]-1,{collapsed:A}=w;for(let I=0;I<t[a(516)];I++){var y=t[I];e.length<=m&&(e[m]=[]);e[m][q]=y;if(z)if(1<h[a(516)])for(y=0;y<h[a(516)];y++){var C=
+h[y];e[a(516)]<=m+1&&(e[m+1]=[]);var D=C.method+" of";typeof g[0][C[a(401)]]!==a(438)&&(D+=" "+g[0][C[a(401)]]);e[m+1][q]=D;q++}else q++;else if("object"!==typeof l[m]&&(l[m]={}),C=A&&A.includes(y),l[m][q]={columnIndex:w.columnIndex,value:"undefined"!==typeof y?y:"",isCollapsed:C},C)if(0!==h[a(516)]){for(;v>=e[a(516)];)e.push([]);for(C=0;C<h.length;C++){D=h[C];var F="";typeof y!==a(438)&&(F=y+" ");F+=D[a(284)];"undefined"!==typeof g[0][D[a(401)]]&&(F+=a(350)+g[0][D[a(401)]]);e[v][q]=F;q++}}else q++;
+else if(C=q,q=r(q,m+1,n+1,u[a(312)](y)),C!==q)if(0!==h[a(516)])for(C=0;C<h[a(516)];C++)D=h[C],F="",typeof y!==a(438)&&(F=y+" "),F+=D.method,typeof g[0][D[a(401)]]!==a(438)&&(F+=a(350)+g[0][D[a(401)]]),e[m][q]=F,q++;else e[m][q]=y+a(427),q++}return q};b=0!==p[a(516)]?r(b[0],1,0,k[a(312)](M)):b[0];if(1>h[a(516)])e[a(516)]<=c&&(e[c]=[]),e[c][b]=a(451);else for(e[a(516)]<=c&&(e[c]=[]),d=0;d<h[a(516)];d++){k=h[d];let q="Total "+k[a(284)];typeof g[0][k[a(401)]]!==a(438)&&(q+=a(350)+g[0][k[a(401)]]);e[c][b]=
+q;b++}};class T extends Error{constructor(b){super("SPILL");this.coords=b}}const Ma=function({data:b,groups:c},[d,f],e,g){var k=g[a(325)]||[0,0];const [l,p]=k,{records:h,options:{data:v}}=e;e=b[a(516)];k=Math.max(...b[a(467)](A=>A[a(516)]));if(k>l)for(var r=0;r<p;r++){var q=f+r,m=h[q],n=v[q];for(var u=l;u<k;u++){var w=d+u;if(m){var t=m[w];if(t&&null!==t.v&&typeof t.v!==a(438))throw new T({x:w,y:q});}if(n&&(t=n[w],null!==t&&""!==t&&"undefined"!==typeof t))throw new T({x:w,y:q});}}for(r=p;r<e;r++)for(q=
+f+r,m=h[q],n=v[q],u=0;u<k;u++){w=d+u;if(m&&(t=m[w])&&null!==t.v&&"undefined"!==typeof t.v)throw new T({x:w,y:q});if(n&&(t=n[w],null!==t&&""!==t&&typeof t!==a(438)))throw new T({x:w,y:q});}r=[];q=[];for(m=0;m<e;m++){w=b[m];t=c[m];n=f+m;for(u=0;u<k;){const A=d+u;var z=w[u];r[a(223)]({x:A,y:n,value:typeof z!==a(438)?z:null});t&&t[u]?(z=t[u],q[a(223)]({x:A,y:n,value:{type:La,readOnly:!0,options:{...z,pivotTableId:g.id}}})):q.push({x:A,y:n,value:{type:"text",readOnly:!0}});u++}for(;u<l;)w=d+u,r.push({x:w,
+y:n,value:null}),q[a(223)]({x:w,y:n,value:null}),u++}return{dataRecords:r,propertyRecords:q,size:[k,e]}},ua=function(b,[c,d],[f],e){b=[{x:c,y:d,value:e?a(275):null}];e=[{x:c,y:d,value:e?"text":{type:Na}}];for(let g=1;g<f;g++){const k=c+g;b[a(223)]({x:k,y:d,value:null});e.push({x:k,y:d,value:null})}return{dataRecords:b,propertyRecords:e,size:[1,1]}},ka=Symbol(a(262)),Oa=function(b,c,d){var f=B[a(382)][a(492)](c[a(354)]);const [e,g]=f;var k=c[a(325)]||[0,0];const [l,p]=k;var h=[];let v=[];var r;let q=
+!1;try{b?(r=Ma(b,f,d,c),Aa(b[a(166)],k,r[a(325)],c,d)):(r=ua(c,f,k),aa(k,c,d)),delete c[ka]}catch(t){if(!(t instanceof T))throw t;c[ka]=t[a(193)];q=!0;r=ua(c,f,k,!0);aa(k,c,d)}({dataRecords:h,propertyRecords:v}=r);[k,f]=r.size;({records:r}=d);for(var m=0;m<f;m++){var n=g+m,u=r[n];for(var w=0;w<k;w++)d.getCellObject(e+w,n)[a(318)]=!0;for(n=k;n<l;n++)(w=u[e+n])&&delete w[a(318)]}for(m=f;m<p;m++)for(u=g+m,n=r[u],w=0;w<l;w++){const t=e+w;delete n[t][a(318)];h[a(223)]({x:t,y:u,value:null});v[a(223)]({x:t,
+y:u,value:null})}pa(h,v,d);q&&(d[a(360)](e,g),d=d[a(300)](e,g),{data:h}=b,b=h[a(516)],h=Math.max(...h.map(t=>t[a(516)])),b=c.anchor+":"+B[a(382)][a(380)](h-1,b-1),d[a(494)](a(293),a(232)+b+a(495)));c.size=[k,f]},L=function(b,c){var d=b.rows||[],f=b[a(459)]||[];var e=b[a(283)]||[];if(0===d.length&&0===f[a(516)]&&0===e[a(516)])e=null;else{var g=c,k=J(b.source);g=g[a(234)](k[0]);var l=g[a(412)];k=B[a(382)][a(376)](k[1]);var p=[];for(var h=k[1];h<=k[3];h++){var v=l[h],r=[];for(var q=k[0];q<=k[2];q++){g.getCell(q,
+h);const u=v[q];r[a(223)](u.v)}p.push(r)}var {obj:m,fieldsPossibleValues:n}=Ha(b,p);l=d[a(516)];h=f[a(516)];v=Array(l)[a(453)](null);k=p[0];g=[];if(0<h){for(r=0;r<h;r++)q=f[r],v[a(223)](k[q[a(401)]]);1<e.length&&v[a(223)]("Values");g[a(223)](v)}f=[l,0<h?h+1+(0===h||1<e.length?1:0):1];h={};Ka(f,g[a(516)],b,n,g,p,m,h);for(p=f[1]-1;g[a(516)]<=p;)g[a(223)]([]);p=g[p];for(v=0;v<l;v++)p[v]=k[d[v][a(401)]];l={headerHeight:f[1]-1,hasHighlightedColumn:1<l};d.length&&(d=Ja(f[1],b,n,g,m,h),l[a(482)]=d);e=(0!==
+e[a(516)]&&Ia(f[0],f[1],b,n,g,m),{data:g,groups:h,styleInfo:l})}Oa(e,b,c)},Z=[a(196),a(459)],U=[a(283),a(196),a(459),a(462)],la=U.length,va=(b,c)=>{const d={columnIndex:b[a(401)]};c===a(283)?(d.id=jSuites[a(346)](),d[a(284)]=a(245)):c!==a(196)&&c!==a(459)||(d[a(520)]=b.sortBy||a(314),d.ascendingOrder="boolean"===typeof b.ascendingOrder?b.ascendingOrder:!0,"boolean"!==typeof b[a(222)]||(d[a(222)]=b.collapsed));return d},Pa=function(){let b=this;b.rows=[];b[a(459)]=[];b[a(283)]=[];b[a(462)]=[];b[a(417)]=
+[];b[a(474)]=!0;const c=f=>f?f[a(467)](e=>({...e,columnName:b[a(417)][e[a(401)]]})):[];b[a(381)]=function(){const f={text:x(a(477)),value:a(314)};if(!b[a(436)][a(283)])return[f];const e=b[a(436)][a(283)][a(467)](g=>({text:g[a(284)]+" of "+b[a(417)][g.columnIndex],value:g.id}));return e[a(504)](f),e};b[a(209)]=function(f){return function(){const e=a0_0x567c,g=b[e(381)]();b[f]=c(b.pivotTable[f])[e(467)](k=>(k[e(342)]=G(g),k));b[e(321)](f)}};b[a(180)]=b.updateSortableField(a(196));b[a(204)]=b.updateSortableField(a(459));
+b.updateCells=function(){b.cells=c(b[a(436)][a(283)]);b[a(321)](a(283))};b[a(329)]=function(){b[a(462)]=c(b[a(436)][a(462)]).map(({filter:f,...e})=>(e[a(332)]=f,e));b[a(321)](a(462))};b[a(259)]=function(){var f=J(b.pivotTable[a(298)]);const e=B[a(382)][a(376)](f[1]);e[3]=e[1];const g=J(B[a(382)].getRangeFromCoords(e))[1];f=b[a(281)][a(505)](f[0]+"!"+g);b[a(417)]=f[0][a(467)]((k,l)=>"undefined"!==typeof k&&null!==k&&""!==k?k:a(330)+B[a(382)][a(202)](l+e[0]));b[a(194)]();b[a(180)]();b[a(204)]();b[a(329)]()};
+b[a(363)]=function(){b.pivotTable=b[a(281)][a(348)][a(230)][b[a(366)]];b[a(298)]=b[a(436)][a(298)];b.sourcePicker[a(409)]=b[a(298)];b.loadModalLists()};b.open=function(){b[a(363)]();b.oldSource=b[a(436)][a(298)];b.modal[a(472)]()};b.createPicker=f=>function(e){const g=jSuites[a(432)](e,{data:[],content:"add",onchange:function(k,l,p,h,v){k={columnIndex:b.fields[a(389)](p),sortBy:a(314),ascendingOrder:!0};l=G(b[a(436)]);!l[f]&&(l[f]=[]);l[f][a(223)](k);H.call(b[a(281)],l)}});e[a(323)][0][a(448)](a(513),
+function(){const k=[...b.rows,...b.columns].map(p=>p[a(401)]),l=b[a(417)][a(282)]((p,h)=>!k[a(170)](h));g[a(471)]({data:l});g[a(472)]()})};b[a(364)]=b[a(159)](a(196));b[a(182)]=b[a(159)](a(459));b[a(370)]=function(f){const e=jSuites[a(432)](f,{data:[],content:a(195),onchange:function(g,k,l,p,h){g={id:jSuites[a(346)](),columnIndex:b.fields.indexOf(l),method:a(245)};k=G(b[a(436)]);!k[a(283)]&&(k[a(283)]=[]);k[a(283)][a(223)](g);H[a(519)](b[a(281)],k)}});f.children[0][a(448)]("mousedown",function(){e[a(471)]({data:b[a(417)]});
+e[a(472)]()})};b[a(428)]=function(f){const e=jSuites[a(432)](f,{data:[],content:a(195),onchange:function(g,k,l,p,h){g={columnIndex:b[a(417)][a(389)](l)};k=G(b[a(436)]);!k.filters&&(k[a(462)]=[]);k[a(462)].push(g);H.call(b.instance,k)}});f[a(323)][0][a(448)]("mousedown",function(){const g=b[a(462)][a(467)](l=>l[a(401)]),k=b.fields.filter((l,p)=>!g[a(170)](p));e[a(471)]({data:k});e[a(472)]()})};const d=function(){var f=b[a(298)];const e=G(b[a(436)]),g=e[a(298)];e.source=f;f=J(f);f=B[a(382)][a(376)](f[1]);
+const k=f[2]-f[0]+1;U[a(509)](l=>{var p=e[l];p&&(p=p[a(282)](h=>h[a(401)]<k),Z[a(170)](l)&&p[a(509)](h=>{h[a(520)]!==a(314)&&0>e[a(283)][a(189)](v=>v.id===h[a(520)])&&(h[a(520)]=a(314),h[a(470)]=!0)}),e[l]=p)});H[a(519)](b[a(281)],e);wa(e,b[a(281)],g)};return b[a(266)]=function(){B[a(432)](b[a(167)],{worksheetName:!0,onchange:function(f){b[a(298)]=f}});b.sourcePicker[a(448)]("blur",function(f){try{na(b[a(298)])}catch(e){jSuites[a(227)]({error:1,message:x(e.message)});b.sourcePicker[a(409)]=b[a(280)];
+return}b[a(280)]=b[a(298)];d()})},b[a(335)]=function(f){return function(e,g){const k=a0_0x567c,l=G(b[k(436)]),p=l[f].find(h=>h[k(401)]===e);Object[k(343)](g)[k(509)](([h,v])=>{p[h]=v});H.call(b[k(281)],l)}},b[a(419)]=b[a(335)]("rows"),b[a(233)]=b[a(335)](a(459)),b.updateFilter=b[a(335)](a(462)),b[a(418)]=function(f){return function(e){const g=a0_0x567c,k=G(b[g(436)]),l=k[f],p=l[g(189)](h=>h[g(401)]===e);l[g(481)](p,1);H[g(519)](b[g(281)],k)}},b[a(524)]=b.removeField(a(196)),b[a(521)]=b[a(418)](a(459)),
+b[a(256)]=b.removeField(a(462)),b[a(511)]=function(f,e){const g=G(b[a(436)]),k=g[a(283)][a(423)](l=>l.id===f);Object.entries(e).forEach(([l,p])=>{k[l]=p});H[a(519)](b[a(281)],g)},b[a(502)]=function(f){const e=G(b[a(436)]),g=e[a(283)][a(189)](k=>k.id===f);e[a(283)][a(481)](g,1);[...e[a(196)],...e[a(459)]][a(509)](k=>{k.sortBy===f&&(k[a(520)]=a(314),k[a(470)]=!0)});H.call(b[a(281)],e)},b[a(221)]=function(f){return function(e,g,k){const l=a0_0x567c,p=G(b[l(436)]);var h=p[f];const v=typeof e===l(353)?
+h.findIndex(q=>q.columnIndex===e):h[l(189)](q=>q.id===e),r=h.splice(v,1)[0];h=p[g];if(f===g)h[l(481)](k,0,r);else if(g===l(283))g=va(r,g),h.splice(k,0,g);else{f===l(283)&&Z.forEach(m=>{p[m][l(509)](n=>{n[l(520)]===r.id&&(n[l(520)]=l(314),n[l(470)]=!0)})});const q=r.columnIndex;("filters"===g?h:[...p[l(196)],...p.columns])[l(225)](m=>m[l(401)]===q)||(g=va(r,g),h[l(481)](k,0,g))}H[l(519)](b[l(281)],p)}},b.moveRow=b[a(221)](a(196)),b[a(378)]=b[a(221)](a(459)),b[a(268)]=b[a(221)]("cells"),b.moveFilter=
+b[a(221)](a(462)),b[a(187)]=function(f){f===a(283)&&(b[a(180)](),b[a(204)]())},f=>f`
             <div class="jss_object">
-                <lm-modal icon="pivot_table_chart" title="${x(a(499))}" position="right" overflow="true" :ref="self.modal" :closable="true" :width="600" :height="600" :closed="true" :onclose="self.cancel" :focus="false">
+                <lm-modal icon="pivot_table_chart" title="${x(a(430))}" position="right" overflow="true" :ref="self.modal" :closable="true" :width="600" :height="600" :closed="true" :onclose="self.cancel" :focus="false">
                     <div>
-                        <div class="pivot-table-config">
+                        <div class="pivot-table-config lm-p10">
                             <div>
+                                <label class="lm-switch pivot-table-auto-open">
+                                    <input type="checkbox" :bind="self.autoOpenEnabled" />
+                                    <span>${x(a(395))}</span>
+                                </label>
+                            </div>
+                            <div>
                                 <div class="pivot-table-title">
-                                <h3>${x(a(251))}</h3>
+                                <h3>${x(a(271))}</h3>
                                 </div>
@@ -301,3 +305,3 @@ <div class="pivot-table-title">
                                 <div class="pivot-table-title">
-                                    <h3>${x("Rows")}</h3>
+                                    <h3>${x(a(356))}</h3>
                                     <div :ready="self.createRowPicker"></div>
@@ -320,3 +324,3 @@ </div>
                                 <div class="pivot-table-title">
-                                    <h3>${x(a(388))}</h3>
+                                    <h3>${x(a(212))}</h3>
                                     <div :ready="self.createColumnPicker"></div>
@@ -339,3 +343,3 @@ </div>
                                 <div class="pivot-table-title">
-                                    <h3>${x(a(238))}</h3>
+                                    <h3>${x(a(339))}</h3>
                                     <div :ready="self.createCellPicker"></div>
@@ -357,3 +361,3 @@ </div>
                                 <div class="pivot-table-title">
-                                    <h3>${x("Filters")}</h3>
+                                    <h3>${x(a(479))}</h3>
                                     <div :ready="self.createFilterPicker"></div>
@@ -379,16 +383,19 @@ </div>
             </div>
-        `},Na={createCell:(b,c,d,f,e,g)=>{b.innerHTML=a(371)},updateCell:(b,c)=>!1,openEditor:(b,c,d,f,e)=>!1,closeEditor:()=>!1},La={createCell:(b,c,d,f,e,{options:g})=>{d=document[a(345)](a(506));d.classList[a(457)](a(478));f=document[a(345)]("i");f[a(386)]=g[a(326)]?a(457):a(210);f[a(301)][a(457)](a(322));f[a(223)]=()=>{const h=a0_0x2294,{columnIndex:n,pivotTableId:l}=g,k=G(e[h(346)][h(412)][h(442)](p=>l===p.id)),w=(k[h(543)]||[]).concat(k[h(239)]||[])[h(442)](p=>p[h(290)]===n);if(g[h(326)]){if(w[h(518)]){const p=
-w[h(518)][h(470)](g[h(492)]);w[h(518)][h(429)](p,1)}}else!w[h(518)]&&(w[h(518)]=[]),0>w[h(518)][h(470)](g[h(492)])&&w[h(518)].push(g.value);H[h(504)](e,k)};d.appendChild(f);f=document[a(345)]("div");f.innerText=c||"";d.appendChild(f);b[a(270)]="";b[a(241)](d)},updateCell:(b,c)=>{b[a(521)][0][a(521)][1][a(386)]=c||""},openEditor:(b,c,d,f,e)=>!1,closeEditor:()=>!1},Qa=function(b,c){Object[a(532)](this,b,{get:c,configurable:!1,enumerable:!1,extensible:!1})},Ra=(b,c)=>{const d=c.w[a(346)][a(412)],f=d[a(327)](e=>
-c.id===e.id);d[f]=G(b);L(d[f],c.w)},Sa=function(b,{from:c,to:d,quantity:f},e){if(b<c)return b>=d?b+f:b;if(b>c+f-1)return b<=d?b-f:b;b=d+b-c;return b<e[0]||b>e[2]?void 0:b},Ta=function(b,c){const d=c[a(307)];for(let f=0;f<d;f++)b>=c[f]&&b++;return b},Ua=function(b,c){const d=c[a(307)];let f=0;for(;f<d;){const e=c[f];if(b<e)break;else if(b===e)return;f++}return b-f},xa=(b,c)=>{const {value:d,updates:f}=b;b=c.w.options.pivotTables[a(442)](q=>c.id===q.id);d&&(b.source=d,c[a(446)]=d);var e=J(b.source);
-const g=B[a(539)][a(435)](e[1]);if(f.movedColumns){let q,t;e=Object[a(245)](f.movedColumns);e[a(258)](v=>{v[0]=parseInt(v[0]);(typeof q===a(302)||v[0]<q)&&(q=v[0],t=v[1])});e=e[a(307)];e={from:q,to:t,quantity:e};var h=b[a(464)];for(var n=0;n<la;n++){var l=U[n],k=b[l];if(k){var w=[],p=k[a(307)];for(var r=0;r<p;r++){const v=k[r];var m=Sa(v[a(290)]+g[0],e,g);typeof m!==a(302)?v[a(290)]=m-g[0]:w[a(204)](r);Z.includes(l)&&"name"!==v[a(460)]&&!h.find(u=>u.id===v[a(460)])&&(v.sortBy=a(257),v.ascendingOrder=
-!0)}w[a(286)]((v,u)=>u-v);l=w[a(307)];for(p=0;p<l;p++)k[a(429)](w[p],1)}}}else if(f[a(440)])for(e=f.insertedColumns[a(266)](q=>q-g[0]),h=0;h<la;h++){if(n=b[U[h]])for(k=n[a(307)],w=0;w<k;w++)l=n[w],l.columnIndex=Ta(l[a(290)],e)}else if(f[a(545)])for(e=[...(new Set(f[a(545)]))][a(286)]((q,t)=>q-t)[a(266)](q=>q-g[0]),h=b.cells,n=0;n<la;n++)if(l=U[n],k=b[l]){w=[];p=k.length;for(r=0;r<p;r++){const q=k[r];m=Ua(q[a(290)],e);typeof m!==a(302)?q[a(290)]=m:w.push(r);Z[a(332)](l)&&q[a(460)]!==a(257)&&!h[a(442)](t=>
-t.id===q[a(460)])&&(q.sortBy=a(257),q[a(381)]=!0)}w.sort((q,t)=>t-q);l=w[a(307)];for(p=0;p<l;p++)k[a(429)](w[p],1)}L(b,c.w)},wa=(b,c,d)=>{!c[a(447)][a(444)]&&(c.controls.pivot=[]);const {id:f}=b;if(d){var e=c[a(447)][a(444)][a(327)](g=>g.id===f);-1<e&&(e=c[a(447)][a(444)].splice(e,1)[0],c.setChain(e,d))}d={type:a(444),id:f,range:b.source,handler:function(g,h){if(h){if(B[a(476)].progress)return!1;var n=ea(f,c);const l=G(n);B[a(476)].cascade=!0;B[a(476)][a(504)](c[a(272)],{worksheet:c,undo:()=>{Ra(l,
-g)},redo:()=>{xa(h,g)}});B[a(476)][a(523)]=!1;xa(h,g)}else n=ea(f,c),L(n,c)}};Qa[a(504)](d,"w",()=>c);c[a(447)].pivot[a(204)](d);c[a(329)](d,b[a(274)],!0)},Va=function(b){let c={openCreateModal:function(l){const k=a0_0x2294;c[k(511)][k(309)]=l;c[k(511)][k(274)]=l[k(297)]();c[k(511)].open()},openEditModal:function(l,k){const w=a0_0x2294;c[w(344)][w(309)]=l;c.edit.tableIndex=k;c.edit[w(273)]()}};c[a(372)]=function(l){return l.items[a(204)]({content:a(485),type:"i",tooltip:x("Insert pivot table"),onclick:function(){c[a(264)](B[a(474)])},
-updateState:function(k,w,p,r){r.isEditable()?p[a(301)].remove(a(283)):p.classList[a(457)](a(283))}}),l};var d=l=>function(k,w,p){if(k=w[a(346)].pivotTables){w=k[a(307)];p=p[a(266)](m=>m[l?a(382):a(428)]);const r=l?1:0;for(let m=0;m<w;m++){const q=k[m],t=B[a(539)][a(277)](q[a(294)]);let v=t[r];const u=q.size[r];for(let y=0;y<p[a(307)];y++){const A=p[y];if(A<=v)v++;else if(A<v+u)return!1}l?q[a(294)]=B.helpers[a(313)](t[0],v):q[a(294)]=B[a(539)][a(313)](v,t[1])}}};const f=l=>function(k,w,p){if(k=w.options[a(412)]){w=
-k.length;const r=l?1:0;for(let m=0;m<w;m++){const q=k[m],t=B.helpers[a(277)](q[a(294)]);let v=t[r];const u=q[a(436)][r];for(let y=p[a(307)]-1;-1<y;y--){const A=p[y];if(A<v)v--;else if(A<v+u)return!1}l?q[a(294)]=B[a(539)][a(313)](t[0],v):q[a(294)]=B.helpers.getCellNameFromCoords(v,t[1])}}},e=l=>function(k,w,p,r,m){if(k=w.options[a(412)]){w=l?1:0;const q=k[a(307)];for(let t=0;t<q;t++){const v=k[t],u=B[a(539)][a(277)](v[a(294)]);let y=u[w];const A=v.size[w];if(p<y+A&&p+m-1>=y)return!1;p<r&&r++;if(r>
-y&&r<y+A)return!1;p>r?p>y&&r<=y&&(y+=m):p<y&&r>y&&(y-=m);l?v[a(294)]=B.helpers.getCellNameFromCoords(u[0],y):v[a(294)]=B[a(539)].getCellNameFromCoords(y,u[1])}}},g=(l,k)=>{if(l=l[a(346)][a(412)]){const w=l[a(307)];for(let p=0;p<w;p++){const r=l[p];if(k[3]-k[1]+1!==r[a(436)][1]||k[2]-k[0]+1!==r.size[0])continue;const m=B.helpers.getCoordsFromCellName(r[a(294)]);if(k[0]===m[0]&&k[1]===m[1])return r}}return null},h=new Set,n={onselection:function(l,k,w,p,r,m){if(w===r&&p===m)if(l=k.options[a(412)])if(r=
-l[a(307)],0!==r)for(let q=0;q<r;q++){m=l[q];const t=B[a(539)].getCoordsFromCellName(m[a(294)]);t[a(204)](t[0]+m[a(436)][0]-1,t[1]+m[a(436)][1]-1);if(w>=t[0]&&w<=t[2]&&p>=t[1]&&p<=t[3]){setTimeout(()=>{c[a(284)](k,q)},100);break}else!c[a(344)][a(364)][a(537)]&&c.edit.modal.close()}else c[a(344)][a(364)][a(315)]();else c[a(344)][a(364)][a(315)]();else c.edit[a(364)][a(315)]()},onbeforechanges:function(l,k,w){if(l=k[a(346)][a(412)]){const p=l[a(307)],r=w.length;for(let m=0;m<p;m++){const q=l[m],t=B[a(539)].getCoordsFromCellName(q.anchor);
-t[a(204)](t[0]+q[a(436)][0]-1,t[1]+q[a(436)][1]-1);for(let v=0;v<r;v++){const u=w[v];if(k[a(310)](u.x,u.y,t)){ba(q,k);q[a(436)]=void 0;h[a(457)](q);break}}}}},onafterchanges:function(l,k,w){if(l=k[a(346)][a(412)]){const r=l.length;for(let m=0;m<r;m++){const q=l[m];if(h[a(217)](q)){L(q,k);h["delete"](q);continue}var p=q[ka];if(!p)continue;const {x:t,y:v}=p;p=w;const u=p[a(307)];for(let y=0;y<u;y++){const A=p[y];if(A.y===v&&A.x===t){typeof A.value!==a(302)&&null!==A[a(492)]&&""!==A.value||L(q,k);break}}}}},
-onbeforeinsertcolumn:d(!1),onbeforedeletecolumn:f(!1),onbeforemovecolumn:e(!1),onbeforeinsertrow:d(!0),onbeforedeleterow:f(!0),onbeforemoverow:e(!0),onbeforepaste:function(l,k,w,p,r,m){if(m[a(355)]&&1===m[a(355)][a(307)]&&(l=m[a(484)],w=g(l,[m[a(363)][0],m[a(363)][1],m.selection[0]+w[0][a(307)]-1,m[a(363)][1]+w[a(307)]-1])))return p=B.helpers[a(313)](p,r),m[a(263)]?(Ca(l,k,w.id,p),B[a(275)].reset[a(504)](l,!0)):(k=G(w),k.id=jSuites[a(413)](),k.anchor=p,H.call(l,k)),!1},onkeydown:function(l,k,w){w[a(443)]===
-a(483)&&(l=k[a(308)](),1===l[a(307)]&&(l=g(k,l[0]))&&Ba.call(k,l.id))}};c[a(489)]=function(l){const k=n[l];if(k)return k.apply(this,arguments)};c.init=function(l){const k=l[a(346)].pivotTables;if(k){const w=k.length;for(let p=0;p<w;p++){const r=k[p];L(r,l);wa(r,l)}}};d=document[a(345)](a(506));return b[a(285)][a(408)](d),lemonade.render(function(){let l=a(407);return lemonade[a(401)](l,c,{Create:ya,Edit:Pa})},d),c},ma=function(b){return!0};return ma[a(376)]=function(b){var c;const d=a0_0x2294;var f=
-"";(c=(8==b[d(271)]?(!b[d(421)]||-1==b.scope[d(470)](d(444)))&&(f=d(374)):f=d(550),f))?console[a(418)](c):b.setPlugins({pivot:Va})},ma[a(546)]=function(){null===B&&(B=this)},ma});
+        `},Na={createCell:(b,c,d,f,e,g)=>{b[a(431)]=a(506)},updateCell:(b,c)=>!1,openEditor:(b,c,d,f,e)=>!1,closeEditor:()=>!1},La={createCell:(b,c,d,f,e,{options:g})=>{const k=()=>{const l=a0_0x567c,{columnIndex:p,pivotTableId:h}=g,v=G(e[l(348)][l(230)].find(q=>h===q.id)),r=(v.rows||[])[l(406)](v[l(459)]||[])[l(423)](q=>q[l(401)]===p);if(g.isCollapsed){if(r.collapsed){const q=r.collapsed[l(389)](g[l(267)]);r[l(222)].splice(q,1)}}else!r[l(222)]&&(r[l(222)]=[]),0>r[l(222)][l(389)](g[l(267)])&&r[l(222)][l(223)](g[l(267)]);
+H[l(519)](e,v)};d=document[a(258)]("div");d[a(154)][a(195)](a(446));f=document[a(258)]("i");f[a(409)]=g[a(242)]?a(195):"remove";f[a(154)].add(a(157));f[a(469)]=l=>{l.stopPropagation()};f[a(526)]=l=>{l[a(208)]();k()};d.appendChild(f);f=document[a(258)](a(264));f[a(409)]=c||"";d[a(291)](f);b[a(431)]="";b[a(291)](d)},updateCell:(b,c)=>{b.children[0][a(323)][1][a(409)]=c||""},openEditor:(b,c,d,f,e)=>!1,closeEditor:()=>!1},Qa=function(b,c){Object.defineProperty(this,b,{get:c,configurable:!1,enumerable:!1,
+extensible:!1})},Ra=(b,c)=>{const d=c.w[a(348)][a(230)],f=d.findIndex(e=>c.id===e.id);d[f]=G(b);L(d[f],c.w)},Sa=function(b,{from:c,to:d,quantity:f},e){if(b<c)return b>=d?b+f:b;if(b>c+f-1)return b<=d?b-f:b;b=d+b-c;return b<e[0]||b>e[2]?void 0:b},Ta=function(b,c){const d=c.length;for(let f=0;f<d;f++)b>=c[f]&&b++;return b},Ua=function(b,c){const d=c[a(516)];let f=0;for(;f<d;){const e=c[f];if(b<e)break;else if(b===e)return;f++}return b-f},xa=(b,c)=>{const {value:d,updates:f}=b;b=c.w.options[a(230)][a(423)](n=>
+c.id===n.id);d&&(b.source=d,c[a(315)]=d);var e=J(b[a(298)]);const g=B.helpers.getCoordsFromRange(e[1]);if(f[a(253)]){let n,u;e=Object[a(343)](f.movedColumns);e[a(509)](w=>{w[0]=parseInt(w[0]);("undefined"===typeof n||w[0]<n)&&(n=w[0],u=w[1])});e=e[a(516)];e={from:n,to:u,quantity:e};var k=b[a(283)];for(var l=0;l<la;l++){var p=U[l],h=b[p];if(h){var v=[],r=h.length;for(var q=0;q<r;q++){const w=h[q];var m=Sa(w.columnIndex+g[0],e,g);typeof m!==a(438)?w[a(401)]=m-g[0]:v[a(223)](q);Z[a(170)](p)&&w[a(520)]!==
+a(314)&&!k[a(423)](t=>t.id===w[a(520)])&&(w[a(520)]=a(314),w[a(470)]=!0)}v[a(169)]((w,t)=>t-w);p=v[a(516)];for(r=0;r<p;r++)h[a(481)](v[r],1)}}}else if(f[a(261)])for(e=f[a(261)][a(467)](n=>n-g[0]),k=0;k<la;k++){if(l=b[U[k]])for(h=l[a(516)],v=0;v<h;v++)p=l[v],p.columnIndex=Ta(p[a(401)],e)}else if(f[a(372)])for(e=[...(new Set(f[a(372)]))][a(169)]((n,u)=>n-u)[a(467)](n=>n-g[0]),k=b[a(283)],l=0;l<la;l++)if(p=U[l],h=b[p]){v=[];r=h[a(516)];for(q=0;q<r;q++){const n=h[q];m=Ua(n[a(401)],e);typeof m!==a(438)?
+n[a(401)]=m:v[a(223)](q);Z.includes(p)&&n.sortBy!==a(314)&&!k[a(423)](u=>u.id===n[a(520)])&&(n[a(520)]="name",n[a(470)]=!0)}v[a(169)]((n,u)=>u-n);p=v[a(516)];for(r=0;r<p;r++)h[a(481)](v[r],1)}L(b,c.w)},wa=(b,c,d)=>{!c[a(461)].pivot&&(c.controls.pivot=[]);const {id:f}=b;if(d){var e=c[a(461)].pivot[a(189)](g=>g.id===f);-1<e&&(e=c[a(461)].pivot.splice(e,1)[0],c[a(442)](e,d))}d={type:a(318),id:f,range:b.source,handler:function(g,k){if(k){if(B.history.progress)return!1;var l=ea(f,c);const p=G(l);B[a(313)][a(357)]=
+!0;B[a(313)].call(c[a(420)],{worksheet:c,undo:()=>{Ra(p,g)},redo:()=>{xa(k,g)}});B.history.cascade=!1;xa(k,g)}else l=ea(f,c),L(l,c)}};Qa.call(d,"w",()=>c);c.controls[a(318)].push(d);c[a(442)](d,b.source,!0)},Va=function(b){let c={};c[a(517)]=function(h){c[a(475)][a(281)]=h;c[a(475)][a(298)]=h[a(255)]();c[a(475)][a(472)]()};c[a(347)]=function(h,v){c[a(322)][a(281)]=h;c[a(322)].tableIndex=v;c[a(322)][a(472)]()};const d=function(h,v,r){h=h[a(348)][a(230)];if(!h)return-1;for(let m=0;m<h.length;m++){var q=
+h[m];if(!q.size)continue;const n=B.helpers[a(492)](q.anchor),u=n[0]+q[a(325)][0]-1;q=n[1]+q[a(325)][1]-1;if(v>=n[0]&&v<=u&&r>=n[1]&&r<=q)return m}return-1};c[a(485)]=function(h,v,r,q,m,n){if("cell"!==n||c[a(322)].autoOpenEnabled)return m;const u=d(h,v,r);return-1===u?m:(m[a(504)]({title:x(a(463)),icon:a(454),onclick:function(){c.openEditModal(h,u)}},{type:"line"}),m)};c[a(456)]=function(h){return h[a(358)][a(223)]({content:a(454),type:"i",tooltip:x(a(371)),onclick:function(){c[a(517)](B[a(192)])},
+updateState:function(v,r,q,m){m[a(243)]()?q[a(154)][a(305)](a(503)):q[a(154)][a(195)]("jtoolbar-disabled")}}),h};var f=h=>function(v,r,q){if(v=r[a(348)].pivotTables){r=v.length;q=q.map(n=>n[h?a(449):a(460)]);const m=h?1:0;for(let n=0;n<r;n++){const u=v[n],w=B[a(382)][a(492)](u[a(354)]);let t=w[m];const z=u[a(325)][m];for(let A=0;A<q[a(516)];A++){const y=q[A];if(y<=t)t++;else if(y<t+z)return!1}h?u[a(354)]=B[a(382)][a(380)](w[0],t):u.anchor=B[a(382)].getCellNameFromCoords(t,w[1])}}};const e=h=>function(v,
+r,q){if(v=r[a(348)][a(230)]){r=v[a(516)];const m=h?1:0;for(let n=0;n<r;n++){const u=v[n],w=B[a(382)][a(492)](u[a(354)]);let t=w[m];const z=u.size[m];for(let A=q[a(516)]-1;-1<A;A--){const y=q[A];if(y<t)t--;else if(y<t+z)return!1}h?u.anchor=B[a(382)][a(380)](w[0],t):u[a(354)]=B[a(382)][a(380)](t,w[1])}}},g=h=>function(v,r,q,m,n){if(v=r[a(348)][a(230)]){r=h?1:0;const u=v[a(516)];for(let w=0;w<u;w++){const t=v[w],z=B.helpers[a(492)](t.anchor);let A=z[r];const y=t[a(325)][r];if(q<A+y&&q+n-1>=A)return!1;
+q<m&&m++;if(m>A&&m<A+y)return!1;q>m?q>A&&m<=A&&(A+=n):q<A&&m>A&&(A-=n);h?t[a(354)]=B[a(382)].getCellNameFromCoords(z[0],A):t.anchor=B[a(382)][a(380)](A,z[1])}}},k=(h,v)=>{if(h=h[a(348)][a(230)]){const r=h[a(516)];for(let q=0;q<r;q++){const m=h[q];if(v[3]-v[1]+1!==m[a(325)][1]||v[2]-v[0]+1!==m[a(325)][0])continue;const n=B.helpers[a(492)](m[a(354)]);if(v[0]===n[0]&&v[1]===n[1])return m}}return null},l=new Set,p={onselection:function(h,v,r,q,m,n){if(c.edit[a(474)])if(r===m&&q===n)if(h=v[a(348)][a(230)])if(m=
+h[a(516)],0!==m)for(let u=0;u<m;u++){n=h[u];const w=B[a(382)].getCoordsFromCellName(n[a(354)]);w[a(223)](w[0]+n[a(325)][0]-1,w[1]+n.size[1]-1);if(r>=w[0]&&r<=w[2]&&q>=w[1]&&q<=w[3]){setTimeout(()=>{c[a(347)](v,u)},100);break}else!c.edit.modal.closed&&c.edit[a(218)][a(177)]()}else c.edit.modal[a(177)]();else c[a(322)][a(218)].close();else c[a(322)][a(218)][a(177)]()},onbeforechanges:function(h,v,r){if(h=v[a(348)].pivotTables){const q=h.length,m=r[a(516)];for(let n=0;n<q;n++){const u=h[n],w=B[a(382)][a(492)](u[a(354)]);
+w[a(223)](w[0]+u[a(325)][0]-1,w[1]+u[a(325)][1]-1);for(let t=0;t<m;t++){const z=r[t];if(v[a(483)](z.x,z.y,w)){ba(u,v);u.size=void 0;l.add(u);break}}}}},onafterchanges:function(h,v,r){if(h=v[a(348)][a(230)]){const m=h.length;for(let n=0;n<m;n++){const u=h[n];if(l[a(404)](u)){L(u,v);l[a(336)](u);continue}var q=u[ka];if(!q)continue;const {x:w,y:t}=q;q=r;const z=q[a(516)];for(let A=0;A<z;A++){const y=q[A];if(y.y===t&&y.x===w){"undefined"!==typeof y[a(267)]&&null!==y[a(267)]&&""!==y[a(267)]||L(u,v);break}}}}},
+onbeforeinsertcolumn:f(!1),onbeforedeletecolumn:e(!1),onbeforemovecolumn:g(!1),onbeforeinsertrow:f(!0),onbeforedeleterow:e(!0),onbeforemoverow:g(!0),onbeforepaste:function(h,v,r,q,m,n){if(n.highlighted&&1===n[a(352)][a(516)]&&(h=n[a(265)],r=k(h,[n.selection[0],n[a(279)][1],n[a(279)][0]+r[0][a(516)]-1,n[a(279)][1]+r[a(516)]-1])))return q=B[a(382)].getCellNameFromCoords(q,m),n.cut?(Ca(h,v,r.id,q),B[a(165)][a(200)][a(519)](h,!0)):(v=G(r),v.id=jSuites[a(346)](),v.anchor=q,H[a(519)](h,v)),!1},onkeydown:function(h,
+v,r){r[a(416)]===a(161)&&(h=v[a(205)](),1===h[a(516)]&&(h=k(v,h[0]))&&Ba[a(519)](v,h.id))}};c[a(303)]=function(h){const v=p[h];if(v)return v[a(333)](this,arguments)};c.init=function(h){const v=h[a(348)][a(230)];if(v){const r=v.length;for(let q=0;q<r;q++){const m=v[q];L(m,h);wa(m,h)}}};f=document.createElement("div");return b[a(499)][a(457)](f),lemonade[a(168)](function(){let h=a(392);return lemonade[a(252)](h,c,{Create:ya,Edit:Pa})},f),c},ma=function(b){return!0};return ma[a(296)]=function(b){var c=
+a0_0x567c;var d="";(c=(8==b[c(197)]?(!b.scope||-1==b[c(287)][c(389)]("pivot"))&&(d=c(337)):d="License required",d))?console[a(311)](c):b[a(398)]({pivot:Va})},ma.license=function(){null===B&&(B=this)},ma});
+function a0_0x27a5(){const a='For the table to be displayed, the range ;updateColumn;getWorksheetInstanceByName;STDEVP;Default;target;new;body;createAnchorPicker;MIN;isCollapsed;isEditable;conditionDropdownOptions;SUM;less than;update;set;Existing worksheet;exists;base;element;movedColumns;lastIndexOf;getRange;removeFilter;The anchor must be a single cell, not a range;createElement;loadModalLists;setComponents;insertedColumns;coordinate of the cell that prevented the table from being drawn;endTime;div;worksheet;createSourcePicker;value;moveCell;% of the row total;row-%;Source;7264knScRE;<h3>;style;#SPILL;replaceWith;filterByValue;showAs;selection;oldSource;instance;filter;cells;method;32268TZOUhl;Type;scope;sourceAnchor;criteriaInput;newValue;appendChild;[data-control];title;less than or equal to;after;oninit;last row;source;100.00%;getCell;cursor;not between;onevent;grab;remove;COUNT;Cell is empty;The anchor must be a reference to a cell;Grand Total;contains;error;get;history;name;range;internal properties;message;pivot;bigger than or equal to;pivot-table-config-list;refresh;edit;children;STDEV;size;pivot-table-position-marker-card;oldValue;display;updateFilters;Column ;Number;filter1;apply;onDragStart;updateField;delete;The pivot tables extension is not included on the scope of this license;onload;Values;pivot-table-card-background;MEDIAN;sortingOptions;entries;insertColumn;insertBefore;guid;openEditModal;options;reverse; of ;COUNTA;highlighted;number;anchor;left;Rows;cascade;items;getBoundingClientRect;getCellObject;valid url;VAR.P;updateModal;createRowPicker;VAR.S;tableIndex;text;Something went wrong;validation;createCellPicker;Insert pivot table;deletedColumns;querySelectorAll;VARP;toFixed;getCoordsFromRange;22CnSjRE;moveColumn;</h3></div>;getCellNameFromCoords;getSortingOptions;helpers;is a valid date;AVERAGE;exists symbol;insert;values;New worksheet;indexOf;between;object;<div>\n                    <div><Create :ref="self.create" /></div>\n                    <div><Edit :ref="self.edit" /></div>\n                </div>;1864utzSfU;PRODUCT;Open modal on cell selection;is-highlighted-column;slice;setPlugins;dictionary;Cell is not empty;columnIndex;Create pivot table;from;has;begins with;concat;editButtons;valid email;innerText;ignoreEvents;insertRow;records;Value;3481170MFGXqa;tokenIdentifier;key;fields;removeField;updateRow;parent;setProperty;visibility;find;columnName;every;marginTop; Total;createFilterPicker;documentElement;Pivot table;innerHTML;picker;9565UmiMtI;Method;Time;pivotTable;stringify;undefined;data-visible;8170GePlwk;sourceWorksheet;setChain;MAX;closed;notEmpty;pivot-table-group-cell;Ascending;addEventListener;row;is-highlighted-row;Total;parse;fill;pivot_table_chart;clientY;toolbar;append;is not between;columns;column;controls;filters;Edit pivot table;textLength;before;dateToNum;map;amd;onmousedown;ascendingOrder;setOptions;open;is-header;autoOpenEnabled;create;isArray;Name;start;Filters;Criteria;splice;highlightedRows;isSelected;setValue;contextMenu;11641560IWaBLL;last column;parentElement;Cancel;locationOption;1899-12-31 ;getCoordsFromCellName;equal to;setAttribute; must contain no content other than the table itself.;difference;none;criterias;tools;undoChanges;isLoaded;removeCell;jtoolbar-disabled;unshift;getDataFromRange;<i class="material-icons">pivot_table_chart</i>;possibleValues;cardThatFollowsTheMouse;forEach;getRangeFromCoords;updateCell;criteria;mousedown;empty;pivotTableId;length;openCreateModal;ignore;call;sortBy;removeColumn;12085150xTvuiO;not contains;removeRow;mousemove;onclick;</h3>;classList;Descending;existing;material-icons;removeEventListener;createPicker;removeThisItem;Delete;column-%;Show as;valid date;clipboard;styleInfo;sourcePicker;render;sort;includes;<div><h3>;6183rUTJAg;startTime;valid;VAR;The source must be a range, not a single cell;close;date;type;updateRows;all;createColumnPicker;jss_pivot_table;symbol;time;top;onchange;Filter by value;findIndex;endDate;end;current;coords;updateCells;add;rows;status;data-control;bigger than;reset;startDate;getColumnName;visible;updateColumns;getHighlighted;positionMarkerCard;calendar;stopPropagation;updateSortableField;default;formula;Columns;hidden;cols;width;is-last-row;height;modal;move;total symbol;moveItem;collapsed;push;yCoordOfTheCenter;some;ends with;notification;updateSelectionFromCoords;Text;pivotTables;plugins'.split(";");a0_0x27a5=
+function(){return a};return a0_0x27a5()};

dist/style.css

@@ -1,5 +0,1 @@
-.jss_pivot_table {
-    color: #000 !important;
-}
-
 .jss_pivot_table.is-header {
@@ -12,2 +8,3 @@ background-color: #1E88E5;
     background-color: #BBDEFB;
+    color: #000 !important;
 }
@@ -17,2 +14,3 @@
     background-color: #90CAF9;
+    color: #000 !important;
 }
@@ -56,3 +54,2 @@
     border-radius: 10px;
-
     cursor: grab;
@@ -63,7 +60,5 @@ user-select: none;
 .pivot-table-card-close-button {
-    background-color: white;
     position: absolute;
     top: 10px;
     right: 10px;
-
     cursor: pointer;
@@ -80,7 +75,5 @@ }
 .pivot-table-position-marker-card > div {
-    background-color: white;
     padding: 15px;
     box-shadow: rgba(100, 100, 111, 0.2) 0px 7px 29px 0px;
     border-radius: 10px;
-
     opacity: 0.6;
@@ -90,3 +83,2 @@ }
 .pivot-table-movement-card {
-    background-color: white;
     position: fixed;
@@ -97,5 +89,3 @@ margin: 20px;
     border-radius: 10px;
-
     pointer-events: none;
-
     z-index: 30;
@@ -114,1 +104,10 @@ }
 }
+
+.pivot-table-auto-open {
+    margin-top: 20px;
+    margin-left: 10px;
+}
+
+.pivot-table-group-cell > i.material-icons {
+    font-size: inherit;
+}

package.json

@@ -30,7 +30,7 @@ {
         "lemonadejs": "^5.3.6",
-        "jsuites": "^6.1.1"
+        "jsuites": "^6.3.4"
     },
     "main": "dist/index.js",
     "types": "dist/index.d.ts",
-    "version": "1.0.6",
+    "version": "1.1.0",
     "bugs": "https://github.com/jspreadsheet/pro/issues",
@@ -37,0 +37,0 @@ "homepage": "https://github.com/jspreadsheet/pro",

New alerts

Long strings

Supply chain risk

Contains long string literals, which may be a sign of obfuscated or packed code.

Found 1 instance in 1 package

Fixed alerts

Long strings

Supply chain risk

Contains long string literals, which may be a sign of obfuscated or packed code.

Found 1 instance in 1 package

Improved metrics

Total package byte prevSize

63349

1.9%

Lines of code

562

1.63%

Dependency changes

• Updated

  jsuites@^6.3.4