@jspreadsheet/validations - npm Package Compare versions

Comparing version 1.0.0 to 1.0.1

dist/index.js

@@ -9,13 +9,28 @@ if (!lemonade && typeof(require) === 'function') {
 
-var _$_ebbf=["translate","","status","scope","validations","indexOf","This extension is not included on the scope of this license","License required","version","This extension request Jspreadsheet Pro v9+","config","action","range","!","split","current",":","getTokensFromRange","helpers","splice","push","length","parent","bind","sort","forEach","oldValue","index","value","worksheets","object","keys","every","format","map","entries"," .conditional_formatting_","name","_"," {\x0A",";\x0A","join","\x0A}","jss_validations_","getElementById","style","createElement","id","appendChild","head","getElementsByTagName","innerHTML","getValidations","get","setValidations","set","resetValidations","reset","isArray","JSS: input should be an array","error","stringify","parse","call","setHistory","persistence","onvalidation","dispatch","build","updateAll","getWorksheetName","updateFormula","#REF!","updateWorksheetName","between","is not between","not between","less than","<","less than or equal to","<=","bigger than",">","bigger than or equal to",">=","equal to","=","differente to","!=","contains","not contains","is a valid email","valid email","is a valid url","valid url","is a valid date","valid date","before","on or before","after","on or after","List of Items","different to","toUpperCase","replace","substr","create","instance","calendar","element","a number ","a text ","a date ","an element of the list: ","The content of this cell must be ","type","criteria"," ","list"," [",",","]"," and ","mask","locale","UTC","DateTimeFormat","2012","yyyy","12","mm","19","dd","operator","createType","number","Number","text","Text","date","Date","List","textLength","Text length","setData","children","el","all","classList","display","none","jss_object","add","header","dropdown","createOperator","createPicker","innerText","focus","picker","createColorPicker","color","close","The range is mandatory","The type is mandatory","The criteria is mandatory","className","allowBlank","includes","start","end","formatColor","formatBackgroundColor","background-color","bold","font-weight","italic","font-style","Cell range","Action","Warning message","Reject entry","Format style","Type","Operator","Color","Background color","Add a custom CSS className","Save","Back","records","data-tooltip","removeAttribute","jss_warning","remove","data-validation","getAttribute","v","getColumnNameFromCoords","setAttribute","reject","conditional_formatting_","init","updateDataFromSelection","message","All validations found for this selection","data","filter","No validation found for this selection","closeForm","toolbar","settings","i","Add new validation","getRange","open","items","modal","onevent","onafterchanges","onchangeproperty","onformulachain","x","y","oncreatecell","onbeforechange","onselection","getCoordsFromColumnName","getRangeFromTokens","getCoordsFromRange","onload","onrenameworksheet","onchangereferences","ignoreHistory","historyCascade","onundo","onredo","createModal","Validations","420px","612px","openForm","warning","listContainer","settingsContainer","block","removeValidation","div","append","tools","render","oninit","setPlugins","license","undefined","exports","function","amd"];;;(function(global,factory){ typeof exports=== _$_ebbf[30]&&  typeof module!== _$_ebbf[254]?module[_$_ebbf[255]]= factory(): typeof define=== _$_ebbf[256]&& define[_$_ebbf[257]]?define(factory):global[_$_ebbf[4]]= factory()}(this,(function(){var JSS=null;var T=jSuites[_$_ebbf[0]];var License=function(){var txt=_$_ebbf[1];if(this[_$_ebbf[2]]== 8){if(!this[_$_ebbf[3]]|| this[_$_ebbf[3]][_$_ebbf[5]](_$_ebbf[4])==  -1){txt= _$_ebbf[6]}}else {txt= _$_ebbf[7]};if(!txt){var v=JSS[_$_ebbf[8]]();if(!v||  !v[_$_ebbf[8]] || parseInt(v[_$_ebbf[8]])< 9){txt= _$_ebbf[9]}};return txt};var orderOfPriorities={reject:2,warning:1,format:0};var sortValidations=function(a,b){if(this[_$_ebbf[10]][_$_ebbf[4]][a]&& this[_$_ebbf[10]][_$_ebbf[4]][a][_$_ebbf[11]]){a= this[_$_ebbf[10]][_$_ebbf[4]][a][_$_ebbf[11]]}else {a= 0};if(this[_$_ebbf[10]][_$_ebbf[4]][b]&& this[_$_ebbf[10]][_$_ebbf[4]][b][_$_ebbf[11]]){b= this[_$_ebbf[10]][_$_ebbf[4]][b][_$_ebbf[11]]}else {b= 0};return orderOfPriorities[a]- orderOfPriorities[b]};var cache=function(action,validation,index){if(validation&& validation[_$_ebbf[12]]){var i,t,r,w,cells;if(validation[_$_ebbf[12]][_$_ebbf[5]](_$_ebbf[13])> 0){t= validation[_$_ebbf[12]][_$_ebbf[14]](_$_ebbf[13]);r= t[1];w= W(t[0])}else {r= validation[_$_ebbf[12]];w= JSS[_$_ebbf[15]]};if(!w[_$_ebbf[4]]){return};if(r[_$_ebbf[5]](_$_ebbf[16])===  -1){cells= [r]}else {cells= JSS[_$_ebbf[18]][_$_ebbf[17]](r)};cells[_$_ebbf[25]](function(cellName){if(!w[_$_ebbf[4]][cellName]){w[_$_ebbf[4]][cellName]= []};if(action=== 0){i= w[_$_ebbf[4]][cellName][_$_ebbf[5]](index);if(i>= 0){w[_$_ebbf[4]][cellName][_$_ebbf[19]](i,1)}}else {w[_$_ebbf[4]][cellName][_$_ebbf[20]](index)};if(w[_$_ebbf[4]][cellName][_$_ebbf[21]]> 1){w[_$_ebbf[4]][cellName][_$_ebbf[24]](sortValidations[_$_ebbf[23]](w[_$_ebbf[22]]))}})}};var updateCache=function(records){for(var i=0;i< records[_$_ebbf[21]];i++){if(records[i][_$_ebbf[26]]){cache(0,records[i][_$_ebbf[26]],records[i][_$_ebbf[27]])};if(records[i][_$_ebbf[28]]){cache(1,records[i][_$_ebbf[28]],records[i][_$_ebbf[27]])}}};var createCache=function(spreadsheet){for(var i=0;i< spreadsheet[_$_ebbf[29]][_$_ebbf[21]];i++){spreadsheet[_$_ebbf[29]][i][_$_ebbf[4]]= {}};var o=spreadsheet[_$_ebbf[10]][_$_ebbf[4]];if(o){for(var i=0;i< o[_$_ebbf[21]];i++){cache(1,o[i],i)}}};var destroyCache=function(spreadsheet){for(var i=0;i< spreadsheet[_$_ebbf[29]][_$_ebbf[21]];i++){spreadsheet[_$_ebbf[29]][i][_$_ebbf[4]]= {}}};var Validations=(function(){var compareObjs=function(objA,objB){var typeA= typeof objA;var typeB= typeof objB;if(typeA!== _$_ebbf[30]|| typeB!== _$_ebbf[30]){return objA=== objB};if(objA=== null|| objB=== null){return objA=== objB};var keysA=Object[_$_ebbf[31]](objA);var keysB=Object[_$_ebbf[31]](objB);if(keysA[_$_ebbf[21]]!== keysB[_$_ebbf[21]]){return false};keysA[_$_ebbf[24]]();keysB[_$_ebbf[24]]();for(let i=0;i< keysA[_$_ebbf[21]];i++){if(keysA[i]!== keysB[i]){return false}};return keysA[_$_ebbf[32]](function(key){return compareObjs(objA[key],objB[key])})};var applyCSS=function(spreadsheet){var o=spreadsheet[_$_ebbf[10]][_$_ebbf[4]];if(o&& o[_$_ebbf[21]]){var style=_$_ebbf[1];for(var i=0;i< o[_$_ebbf[21]];i++){if(o[i]&& o[i][_$_ebbf[33]]){var classStyles=Object[_$_ebbf[35]](o[i][_$_ebbf[33]])[_$_ebbf[34]](function([property,value]){return `\t${property}: ${value} !important\n`});style+= _$_ebbf[36]+ spreadsheet[_$_ebbf[37]]+ _$_ebbf[38]+ i+ _$_ebbf[39]+ classStyles[_$_ebbf[41]](_$_ebbf[40])+ _$_ebbf[42]}};var styleTag=document[_$_ebbf[44]](_$_ebbf[43]+ spreadsheet[_$_ebbf[37]]);if(!styleTag){styleTag= document[_$_ebbf[46]](_$_ebbf[45]);styleTag[_$_ebbf[47]]= _$_ebbf[43]+ spreadsheet[_$_ebbf[37]];document[_$_ebbf[50]](_$_ebbf[49])[0][_$_ebbf[48]](styleTag)};styleTag[_$_ebbf[51]]= style}};var insertValidation=function(v){if(!this[_$_ebbf[10]][_$_ebbf[4]]){this[_$_ebbf[10]][_$_ebbf[4]]= []};var index=this[_$_ebbf[10]][_$_ebbf[4]][_$_ebbf[21]];this[_$_ebbf[10]][_$_ebbf[4]][_$_ebbf[20]](v);return index};var updateValidation=function(index,v){this[_$_ebbf[10]][_$_ebbf[4]][index]= v};var component=function(obj){obj[_$_ebbf[52]]= component[_$_ebbf[53]];obj[_$_ebbf[54]]= component[_$_ebbf[55]];obj[_$_ebbf[56]]= component[_$_ebbf[57]]};component[_$_ebbf[55]]= function(updates){if(!Array[_$_ebbf[58]](updates)&&  typeof (updates)=== _$_ebbf[30]){updates= [{value:updates}]};if(!Array[_$_ebbf[58]](updates)){console[_$_ebbf[60]](_$_ebbf[59])}else {var w=this;var validationIndex;var oldValue;var records=[];for(var i=0;i< updates[_$_ebbf[21]];i++){oldValue= null;if(updates[i][_$_ebbf[27]]>= 0){validationIndex= updates[i][_$_ebbf[27]];if(this[_$_ebbf[22]][_$_ebbf[10]][_$_ebbf[4]]&& this[_$_ebbf[22]][_$_ebbf[10]][_$_ebbf[4]][validationIndex]){oldValue= JSON[_$_ebbf[62]](JSON[_$_ebbf[61]](this[_$_ebbf[22]][_$_ebbf[10]][_$_ebbf[4]][validationIndex]))};updateValidation[_$_ebbf[63]](this[_$_ebbf[22]],validationIndex,updates[i][_$_ebbf[28]])}else {validationIndex= insertValidation[_$_ebbf[63]](this[_$_ebbf[22]],updates[i][_$_ebbf[28]])};records[_$_ebbf[20]]({index:validationIndex,oldValue:oldValue,value:updates[i][_$_ebbf[28]]})};this[_$_ebbf[22]][_$_ebbf[64]]({worksheet:this,action:_$_ebbf[54],records:records});this[_$_ebbf[65]](_$_ebbf[54],{data:records});applyCSS(this[_$_ebbf[22]]);updateCache(records);this[_$_ebbf[22]][_$_ebbf[67]](_$_ebbf[66],this,records)}};component[_$_ebbf[53]]= function(k){var o=this[_$_ebbf[22]][_$_ebbf[10]][_$_ebbf[4]];if(k){return o[k]}else {return o}};component[_$_ebbf[57]]= function(records){if(!Array[_$_ebbf[58]](records)){records= [records]};records= records[_$_ebbf[34]](function(v){return {index:v,value:null}});component[_$_ebbf[55]][_$_ebbf[63]](this,records)};component[_$_ebbf[68]]= function(){applyCSS(this);createCache(this)};component[_$_ebbf[69]]= function(referencesToUpdate,referencesToDelete){var v=null;var o=this[_$_ebbf[22]][_$_ebbf[10]][_$_ebbf[4]];var record={};var records=[];if(o&& o[_$_ebbf[21]]){for(var i=0;i< o[_$_ebbf[21]];i++){var record={index:i,value:JSON[_$_ebbf[62]](JSON[_$_ebbf[61]](o[i]))};v= this[_$_ebbf[71]](record[_$_ebbf[28]][_$_ebbf[12]],referencesToUpdate,referencesToDelete,this[_$_ebbf[70]]());if(v!== record[_$_ebbf[28]][_$_ebbf[12]]){if(v[_$_ebbf[5]](_$_ebbf[72])>= 0){record[_$_ebbf[28]]= null}else {record[_$_ebbf[28]][_$_ebbf[12]]= v};records[_$_ebbf[20]](record)}};component[_$_ebbf[55]][_$_ebbf[63]](this,records)}};component[_$_ebbf[73]]= function(f,t){var v=null;var o=this[_$_ebbf[22]][_$_ebbf[10]][_$_ebbf[4]];var records=[];if(o&& o[_$_ebbf[21]]){for(var i=0;i< o[_$_ebbf[21]];i++){v= JSS[_$_ebbf[18]][_$_ebbf[73]](o[i][_$_ebbf[12]],f,t);if(v!== o[i][_$_ebbf[12]]){var record={index:i,value:o[i]};record[_$_ebbf[28]][_$_ebbf[12]]= v;records[_$_ebbf[20]](record)}};component[_$_ebbf[55]][_$_ebbf[63]](this,records)}};return component})();var Criteria={number:[{text:T(_$_ebbf[74]),value:_$_ebbf[74]},{text:T(_$_ebbf[75]),value:_$_ebbf[76]},{text:T(_$_ebbf[77]),value:_$_ebbf[78]},{text:T(_$_ebbf[79]),value:_$_ebbf[80]},{text:T(_$_ebbf[81]),value:_$_ebbf[82]},{text:T(_$_ebbf[83]),value:_$_ebbf[84]},{text:T(_$_ebbf[85]),value:_$_ebbf[86]},{text:T(_$_ebbf[87]),value:_$_ebbf[88]}],text:[{text:T(_$_ebbf[89]),value:_$_ebbf[89]},{text:T(_$_ebbf[90]),value:_$_ebbf[90]},{text:T(_$_ebbf[85]),value:_$_ebbf[86]},{text:T(_$_ebbf[91]),value:_$_ebbf[92]},{text:T(_$_ebbf[93]),value:_$_ebbf[94]}],date:[{text:T(_$_ebbf[95]),value:_$_ebbf[96]},{text:T(_$_ebbf[85]),value:_$_ebbf[86]},{text:T(_$_ebbf[97]),value:_$_ebbf[78]},{text:T(_$_ebbf[98]),value:_$_ebbf[80]},{text:T(_$_ebbf[99]),value:_$_ebbf[82]},{text:T(_$_ebbf[100]),value:_$_ebbf[84]},{text:T(_$_ebbf[74]),value:_$_ebbf[74]},{text:T(_$_ebbf[76]),value:_$_ebbf[76]}],list:[{text:T(_$_ebbf[101]),value:_$_ebbf[1]}],textLength:[{text:T(_$_ebbf[74]),value:_$_ebbf[74]},{text:T(_$_ebbf[75]),value:_$_ebbf[76]},{text:T(_$_ebbf[77]),value:_$_ebbf[78]},{text:T(_$_ebbf[79]),value:_$_ebbf[80]},{text:T(_$_ebbf[81]),value:_$_ebbf[82]},{text:T(_$_ebbf[83]),value:_$_ebbf[84]},{text:T(_$_ebbf[85]),value:_$_ebbf[86]},{text:T(_$_ebbf[102]),value:_$_ebbf[88]}]};var W=function(o,v){if(Array[_$_ebbf[58]](o)){o= o[0]};o= o[_$_ebbf[104]]( new RegExp(/'/g),_$_ebbf[1])[_$_ebbf[103]]();if(v=== undefined){return window[o]?window[o]:null}else {window[o]= v}};var isFormula=function(value){var t=(_$_ebbf[1]+ value)[_$_ebbf[105]](0,1);return t=== _$_ebbf[86]};var Calendar=function(){var self=this;self[_$_ebbf[106]]= function(o){self[_$_ebbf[107]]= jSuites[_$_ebbf[108]](o,this)};var template=`<input class="jss_object" @ready="self.create(this)" style="width: 100%;" />`;return lemonade[_$_ebbf[109]](template,self)};var startOfErrorMessage={number:_$_ebbf[110],text:_$_ebbf[111],date:_$_ebbf[112],list:_$_ebbf[113]};var validationDefaultErrorMessage=function(validation){var message=_$_ebbf[114]+ startOfErrorMessage[validation[_$_ebbf[115]]];if(validation[_$_ebbf[116]]){message+= _$_ebbf[117]+ validation[_$_ebbf[116]]};if(validation[_$_ebbf[115]]=== _$_ebbf[118]){message+= _$_ebbf[119]+ validation[_$_ebbf[28]][0][_$_ebbf[41]](_$_ebbf[120])+ _$_ebbf[121]}else {message+= _$_ebbf[117]+ validation[_$_ebbf[28]][0];if(validation[_$_ebbf[28]][_$_ebbf[21]]> 1){message+= _$_ebbf[122]+ validation[_$_ebbf[28]][1]}};return message};var getMask=function(o){if(o[_$_ebbf[123]]){return o[_$_ebbf[123]]};if(o[_$_ebbf[33]]){return o[_$_ebbf[33]]};var locale=o[_$_ebbf[124]];var date= new Date(Date[_$_ebbf[125]](2012,11,20));var result= new Intl[_$_ebbf[126]](locale)[_$_ebbf[33]](date);result= result[_$_ebbf[104]](_$_ebbf[127],_$_ebbf[128]);result= result[_$_ebbf[104]](_$_ebbf[129],_$_ebbf[130]);result= result[_$_ebbf[104]](_$_ebbf[131],_$_ebbf[132]);return result};var List=function(){var self=this;var template=`<div>
-                <div class="row middle p8">
-                    <div class="column f1 cursor" onclick="self.parent.openForm(self)">
-                        <div class="p2"><b>{{self.type}}</b> <span>({{self.range}})</span></div>
-                        <div class="p2">{{self.criteria}}: {{self.value}}</div>
-                    </div><div>
-                        <div><i class='material-icons cursor' onclick="self.parent.removeValidation(self.index)">delete</i></div>
-                    </div>
-                </div>
-            </div>
-        `;return lemonade[_$_ebbf[109]](template,self)};var Settings=function(){var self=this;var dropdown=null;self[_$_ebbf[133]]= _$_ebbf[1];self[_$_ebbf[134]]= function(o){jSuites[_$_ebbf[154]](o,{data:[{value:_$_ebbf[135],text:T(_$_ebbf[136])},{value:_$_ebbf[137],text:T(_$_ebbf[138])},{value:_$_ebbf[139],text:T(_$_ebbf[140])},{value:_$_ebbf[118],text:T(_$_ebbf[141])},{value:_$_ebbf[142],text:T(_$_ebbf[143])}],onchange:function(a,b,c,d){dropdown[_$_ebbf[144]](Criteria[d]|| []);self[_$_ebbf[133]]= _$_ebbf[1];self[_$_ebbf[116]]= _$_ebbf[1];for(var i=0;i< self[_$_ebbf[146]][_$_ebbf[145]][0][_$_ebbf[145]][_$_ebbf[21]];i++){if(self[_$_ebbf[146]][_$_ebbf[145]][0][_$_ebbf[145]][i][_$_ebbf[148]][_$_ebbf[89]](_$_ebbf[147])|| self[_$_ebbf[146]][_$_ebbf[145]][0][_$_ebbf[145]][i][_$_ebbf[148]][_$_ebbf[89]](d)){self[_$_ebbf[146]][_$_ebbf[145]][0][_$_ebbf[145]][i][_$_ebbf[45]][_$_ebbf[149]]= _$_ebbf[1]}else {self[_$_ebbf[146]][_$_ebbf[145]][0][_$_ebbf[145]][i][_$_ebbf[45]][_$_ebbf[149]]= _$_ebbf[150]}}},onload:function(a,b){b[_$_ebbf[153]][_$_ebbf[148]][_$_ebbf[152]](_$_ebbf[151])}})};self[_$_ebbf[155]]= function(o){dropdown= jSuites[_$_ebbf[154]](o,{data:Criteria[_$_ebbf[135]],autocomplete:true,onchange:function(a,b,c,d){self[_$_ebbf[133]]= d},onload:function(a,b){b[_$_ebbf[153]][_$_ebbf[148]][_$_ebbf[152]](_$_ebbf[151])}})};self[_$_ebbf[156]]= function(o){JSS[_$_ebbf[159]](o,function(){if(o[_$_ebbf[157]][_$_ebbf[5]](_$_ebbf[13])==  -1){o[_$_ebbf[157]]= JSS[_$_ebbf[15]][_$_ebbf[70]]()+ _$_ebbf[13]+ o[_$_ebbf[157]]}else {o[_$_ebbf[157]]= o[_$_ebbf[157]]};self[_$_ebbf[12]]= o[_$_ebbf[157]];jSuites[_$_ebbf[158]](o)})};self[_$_ebbf[160]]= function(o){jSuites[_$_ebbf[161]](o)};self[_$_ebbf[162]]= function(save){if(save){if(!self[_$_ebbf[12]]){alert(T(_$_ebbf[163]));return};if(!self[_$_ebbf[115]]){alert(T(_$_ebbf[164]));return};if(!self[_$_ebbf[116]]){alert(T(_$_ebbf[165]));return};if(self[_$_ebbf[12]][_$_ebbf[5]](_$_ebbf[13])===  -1){self[_$_ebbf[12]]= self[_$_ebbf[107]][_$_ebbf[70]]()+ _$_ebbf[13]+ self[_$_ebbf[12]]};var newValidation={range:self[_$_ebbf[12]],action:self[_$_ebbf[11]],type:self[_$_ebbf[115]],criteria:self[_$_ebbf[116]],text:self[_$_ebbf[137]],className:self[_$_ebbf[166]],allowBlank:self[_$_ebbf[167]]};if(newValidation[_$_ebbf[116]][_$_ebbf[168]](_$_ebbf[74])){newValidation[_$_ebbf[28]]= [self[_$_ebbf[169]],self[_$_ebbf[170]]]}else {newValidation[_$_ebbf[28]]= [self[_$_ebbf[169]]]};if(newValidation[_$_ebbf[11]]=== _$_ebbf[33]){newValidation[_$_ebbf[33]]= {};if(self[_$_ebbf[171]]){newValidation[_$_ebbf[33]][_$_ebbf[161]]= self[_$_ebbf[171]]};if(self[_$_ebbf[172]]){newValidation[_$_ebbf[33]][_$_ebbf[173]]= self[_$_ebbf[172]]};if(self[_$_ebbf[174]]){newValidation[_$_ebbf[33]][_$_ebbf[175]]= _$_ebbf[174]};if(self[_$_ebbf[176]]){newValidation[_$_ebbf[33]][_$_ebbf[177]]= _$_ebbf[176]}};var value={value:newValidation};if(self[_$_ebbf[27]]!== null){value[_$_ebbf[27]]= self[_$_ebbf[27]]};self[_$_ebbf[107]][_$_ebbf[54]](value)}};var template=`<div>
+var _$_662b=["translate","","status","scope","validations","indexOf","This extension is not included on the scope of this license","License required","version","This extension request Jspreadsheet Pro v9+","config","action","range","!","split","current",":","getTokensFromRange","helpers","splice","push","length","parent","bind","sort","forEach","oldValue","index","value","worksheets","object","keys","every","format","map","entries"," .conditional_formatting_","name","_"," {\n",";\n","join","\n}",
+"jss_validations_","getElementById","style","createElement","id","appendChild","head","getElementsByTagName","innerHTML","getValidations","get","setValidations","set","resetValidations","reset","isArray","JSS: input should be an array","error","stringify","parse","call","setHistory","persistence","onvalidation","dispatch","build","updateAll","getWorksheetName","updateFormula","#REF!","updateWorksheetName","between","is not between","not between","less than","<","less than or equal to","<=","bigger than",
+">","bigger than or equal to",">=","equal to","=","different to","!=","contains","not contains","begins with","ends with","is a valid email","valid email","is a valid url","valid url","is a valid date","valid date","before","on or before","after","on or after","different to","toUpperCase","replace","substr","create","instance","calendar","element","a number ","a text ","a date ","an element of the list: ","The content of this cell must be ","type","criteria"," ","list"," [",",","]"," and ","mask",
+"locale","UTC","DateTimeFormat","2012","yyyy","12","mm","19","dd","operator","createType","number","Number","text","Text","date","Date","List","textLength","Text length","exist","Cell is empty","not exist","Cell is not empty","setData","children","el","all","classList","display","none","jss_object","add","header","dropdown","createOperator","createPicker","innerText","focus","picker","createColorPicker","color","close","The range is mandatory","The type is mandatory","The criteria is mandatory","className",
+"allowBlank","includes","start","end","formatColor","formatBackgroundColor","background-color","bold","font-weight","italic","font-style","Cell range","Action","Warning message","Reject entry","Format style","Type","Operator","Color","Background color","Add a custom CSS className","Save","Back","records","data-tooltip","removeAttribute","jss_warning","remove","data-validation","getAttribute","v","getColumnNameFromCoords","setAttribute","reject","conditional_formatting_","init","updateDataFromSelection",
+"message","All validations found for this selection","data","filter","No validation found for this selection","closeForm","toolbar","settings","i","Add new validation","getRange","open","items","modal","onevent","onafterchanges","onchangeproperty","onformulachain","x","y","oncreatecell","onbeforechange","onselection","getCoordsFromColumnName","getRangeFromTokens","getCoordsFromRange","onload","onrenameworksheet","onchangereferences","ignoreHistory","historyCascade","onundo","onredo","createModal",
+"Validations","420px","612px","openForm","warning","listContainer","settingsContainer","block","removeValidation","div","append","tools","render","oninit","setPlugins","license","undefined","exports","function","amd"];
+(function(p,g){typeof exports===_$_662b[30]&&typeof module!==_$_662b[259]?module[_$_662b[260]]=g():typeof define===_$_662b[261]&&define[_$_662b[262]]?define(g):p[_$_662b[4]]=g()})(this,function(){var p=null,g=jSuites[_$_662b[0]],E=function(){var a=_$_662b[1];8==this[_$_662b[2]]?this[_$_662b[3]]&&-1!=this[_$_662b[3]][_$_662b[5]](_$_662b[4])||(a=_$_662b[6]):a=_$_662b[7];if(!a){var e=p[_$_662b[8]]();if(!e||!e[_$_662b[8]]||9>parseInt(e[_$_662b[8]]))a=_$_662b[9]}return a},z={reject:2,warning:1,format:0},
+F=function(a,e){a=this[_$_662b[10]][_$_662b[4]][a]&&this[_$_662b[10]][_$_662b[4]][a][_$_662b[11]]?this[_$_662b[10]][_$_662b[4]][a][_$_662b[11]]:0;e=this[_$_662b[10]][_$_662b[4]][e]&&this[_$_662b[10]][_$_662b[4]][e][_$_662b[11]]?this[_$_662b[10]][_$_662b[4]][e][_$_662b[11]]:0;return z[a]-z[e]},v=function(a,e,f){if(e&&e[_$_662b[12]]){var b;if(0<e[_$_662b[12]][_$_662b[5]](_$_662b[13])){e=e[_$_662b[12]][_$_662b[14]](_$_662b[13]);var c=e[1];var d=u(e[0])}else c=e[_$_662b[12]],d=p[_$_662b[15]];d[_$_662b[4]]&&
+(e=-1===c[_$_662b[5]](_$_662b[16])?[c]:p[_$_662b[18]][_$_662b[17]](c),e[_$_662b[25]](function(h){d[_$_662b[4]][h]||(d[_$_662b[4]][h]=[]);if(0===a){if(b=d[_$_662b[4]][h][_$_662b[5]](f),0<=b)d[_$_662b[4]][h][_$_662b[19]](b,1)}else d[_$_662b[4]][h][_$_662b[20]](f);if(1<d[_$_662b[4]][h][_$_662b[21]])d[_$_662b[4]][h][_$_662b[24]](F[_$_662b[23]](d[_$_662b[22]]))}))}},A=function(a){for(var e=0;e<a[_$_662b[29]][_$_662b[21]];e++)a[_$_662b[29]][e][_$_662b[4]]={};if(a=a[_$_662b[10]][_$_662b[4]])for(e=0;e<a[_$_662b[21]];e++)v(1,
+a[e],e)},G=function(a){for(var e=0;e<a[_$_662b[29]][_$_662b[21]];e++)a[_$_662b[29]][e][_$_662b[4]]={}},t=function(){var a=function(c){var d=c[_$_662b[10]][_$_662b[4]];if(d&&d[_$_662b[21]]){for(var h=_$_662b[1],l=0;l<d[_$_662b[21]];l++)if(d[l]&&d[l][_$_662b[33]]){var k=Object[_$_662b[35]](d[l][_$_662b[33]])[_$_662b[34]](function([n,m]){return`\t${n}: ${m} !important\n`});h+=_$_662b[36]+c[_$_662b[37]]+_$_662b[38]+l+_$_662b[39]+k[_$_662b[41]](_$_662b[40])+_$_662b[42]}d=document[_$_662b[44]](_$_662b[43]+
+c[_$_662b[37]]);d||(d=document[_$_662b[46]](_$_662b[45]),d[_$_662b[47]]=_$_662b[43]+c[_$_662b[37]],document[_$_662b[50]](_$_662b[49])[0][_$_662b[48]](d));d[_$_662b[51]]=h}},e=function(c){this[_$_662b[10]][_$_662b[4]]||(this[_$_662b[10]][_$_662b[4]]=[]);var d=this[_$_662b[10]][_$_662b[4]][_$_662b[21]];this[_$_662b[10]][_$_662b[4]][_$_662b[20]](c);return d},f=function(c,d){this[_$_662b[10]][_$_662b[4]][c]=d},b=function(c){c[_$_662b[52]]=b[_$_662b[53]];c[_$_662b[54]]=b[_$_662b[55]];c[_$_662b[56]]=b[_$_662b[57]]};
+b[_$_662b[55]]=function(c){Array[_$_662b[58]](c)||typeof c!==_$_662b[30]||(c=[c]);if(Array[_$_662b[58]](c)){for(var d,h,l=[],k=0;k<c[_$_662b[21]];k++)h=null,0<=c[k][_$_662b[27]]?(d=c[k][_$_662b[27]],this[_$_662b[22]][_$_662b[10]][_$_662b[4]]&&this[_$_662b[22]][_$_662b[10]][_$_662b[4]][d]&&(h=JSON[_$_662b[62]](JSON[_$_662b[61]](this[_$_662b[22]][_$_662b[10]][_$_662b[4]][d]))),f[_$_662b[63]](this[_$_662b[22]],d,c[k][_$_662b[28]])):d=e[_$_662b[63]](this[_$_662b[22]],c[k][_$_662b[28]]),l[_$_662b[20]]({index:d,
+oldValue:h,value:c[k][_$_662b[28]]});this[_$_662b[22]][_$_662b[64]]({worksheet:this,action:_$_662b[54],records:l});this[_$_662b[65]](_$_662b[54],{data:l});a(this[_$_662b[22]]);for(c=0;c<l[_$_662b[21]];c++)l[c][_$_662b[26]]&&v(0,l[c][_$_662b[26]],l[c][_$_662b[27]]),l[c][_$_662b[28]]&&v(1,l[c][_$_662b[28]],l[c][_$_662b[27]]);this[_$_662b[22]][_$_662b[67]](_$_662b[66],this,l)}else console[_$_662b[60]](_$_662b[59])};b[_$_662b[53]]=function(c){var d=this[_$_662b[22]][_$_662b[10]][_$_662b[4]];return c?
+d[c]:d};b[_$_662b[57]]=function(c){Array[_$_662b[58]](c)||(c=[c]);c=c[_$_662b[34]](function(d){return{index:d,value:null}});b[_$_662b[55]][_$_662b[63]](this,c)};b[_$_662b[68]]=function(){a(this);A(this)};b[_$_662b[69]]=function(c,d){var h=this[_$_662b[22]][_$_662b[10]][_$_662b[4]],l=[];if(h&&h[_$_662b[21]]){for(var k=0;k<h[_$_662b[21]];k++){var n={index:k,value:JSON[_$_662b[62]](JSON[_$_662b[61]](h[k]))};var m=this[_$_662b[71]](n[_$_662b[28]][_$_662b[12]],c,d,this[_$_662b[70]]());m!==n[_$_662b[28]][_$_662b[12]]&&
+(0<=m[_$_662b[5]](_$_662b[72])?n[_$_662b[28]]=null:n[_$_662b[28]][_$_662b[12]]=m,l[_$_662b[20]](n))}b[_$_662b[55]][_$_662b[63]](this,l)}};b[_$_662b[73]]=function(c,d){var h=this[_$_662b[22]][_$_662b[10]][_$_662b[4]],l=[];if(h&&h[_$_662b[21]]){for(var k=0;k<h[_$_662b[21]];k++){var n=p[_$_662b[18]][_$_662b[73]](h[k][_$_662b[12]],c,d);if(n!==h[k][_$_662b[12]]){var m={index:k,value:h[k]};m[_$_662b[28]][_$_662b[12]]=n;l[_$_662b[20]](m)}}b[_$_662b[55]][_$_662b[63]](this,l)}};return b}(),B={number:[{text:g(_$_662b[74]),
+value:_$_662b[74]},{text:g(_$_662b[75]),value:_$_662b[76]},{text:g(_$_662b[77]),value:_$_662b[78]},{text:g(_$_662b[79]),value:_$_662b[80]},{text:g(_$_662b[81]),value:_$_662b[82]},{text:g(_$_662b[83]),value:_$_662b[84]},{text:g(_$_662b[85]),value:_$_662b[86]},{text:g(_$_662b[87]),value:_$_662b[88]}],text:[{text:g(_$_662b[89]),value:_$_662b[89]},{text:g(_$_662b[90]),value:_$_662b[90]},{text:g(_$_662b[91]),value:_$_662b[91]},{text:g(_$_662b[92]),value:_$_662b[92]},{text:g(_$_662b[85]),value:_$_662b[86]},
+{text:g(_$_662b[93]),value:_$_662b[94]},{text:g(_$_662b[95]),value:_$_662b[96]}],date:[{text:g(_$_662b[97]),value:_$_662b[98]},{text:g(_$_662b[85]),value:_$_662b[86]},{text:g(_$_662b[99]),value:_$_662b[78]},{text:g(_$_662b[100]),value:_$_662b[80]},{text:g(_$_662b[101]),value:_$_662b[82]},{text:g(_$_662b[102]),value:_$_662b[84]},{text:g(_$_662b[74]),value:_$_662b[74]},{text:g(_$_662b[76]),value:_$_662b[76]}],textLength:[{text:g(_$_662b[74]),value:_$_662b[74]},{text:g(_$_662b[75]),value:_$_662b[76]},
+{text:g(_$_662b[77]),value:_$_662b[78]},{text:g(_$_662b[79]),value:_$_662b[80]},{text:g(_$_662b[81]),value:_$_662b[82]},{text:g(_$_662b[83]),value:_$_662b[84]},{text:g(_$_662b[85]),value:_$_662b[86]},{text:g(_$_662b[103]),value:_$_662b[88]}]},u=function(a,e){Array[_$_662b[58]](a)&&(a=a[0]);a=a[_$_662b[105]](new RegExp(/'/g),_$_662b[1])[_$_662b[104]]();if(void 0===e)return window[a]?window[a]:null;window[a]=e},H=function(){var a=this;a[_$_662b[107]]=function(e){a[_$_662b[108]]=jSuites[_$_662b[109]](e,
+this)};return lemonade[_$_662b[110]]('<input class="jss_object" @ready="self.create(this)" style="width: 100%;" />',a)},I={number:_$_662b[111],text:_$_662b[112],date:_$_662b[113],list:_$_662b[114]},J=function(a){var e=_$_662b[115]+I[a[_$_662b[116]]];a[_$_662b[117]]&&(e+=_$_662b[118]+a[_$_662b[117]]);a[_$_662b[116]]===_$_662b[119]?e+=_$_662b[120]+a[_$_662b[28]][0][_$_662b[41]](_$_662b[121])+_$_662b[122]:(e+=_$_662b[118]+a[_$_662b[28]][0],1<a[_$_662b[28]][_$_662b[21]]&&(e+=_$_662b[123]+a[_$_662b[28]][1]));
+return e},C=function(){return lemonade[_$_662b[110]]('<div>\n                <div class="row middle p8">\n                    <div class="column f1 cursor" onclick="self.parent.openForm(self)">\n                        <div class="p2"><b>{{self.type}}</b> <span>({{self.range}})</span></div>\n                        <div class="p2">{{self.criteria}}: {{self.value}}</div>\n                    </div><div>\n                        <div><i class=\'material-icons cursor\' onclick="self.parent.removeValidation(self.index)">delete</i></div>\n                    </div>\n                </div>\n            </div>\n        ',
+this)},K=function(){var a=this,e=null;a[_$_662b[134]]=_$_662b[1];a[_$_662b[135]]=function(b){jSuites[_$_662b[159]](b,{data:[{value:_$_662b[136],text:g(_$_662b[137])},{value:_$_662b[138],text:g(_$_662b[139])},{value:_$_662b[140],text:g(_$_662b[141])},{value:_$_662b[119],text:g(_$_662b[142])},{value:_$_662b[143],text:g(_$_662b[144])},{value:_$_662b[145],text:g(_$_662b[146])},{value:_$_662b[147],text:g(_$_662b[148])}],onchange:function(c,d,h,l){e[_$_662b[149]](B[l]||[]);a[_$_662b[134]]=_$_662b[1];a[_$_662b[117]]=
+_$_662b[1];for(c=0;c<a[_$_662b[151]][_$_662b[150]][0][_$_662b[150]][_$_662b[21]];c++)a[_$_662b[151]][_$_662b[150]][0][_$_662b[150]][c][_$_662b[153]][_$_662b[89]](_$_662b[152])||a[_$_662b[151]][_$_662b[150]][0][_$_662b[150]][c][_$_662b[153]][_$_662b[89]](l)?a[_$_662b[151]][_$_662b[150]][0][_$_662b[150]][c][_$_662b[45]][_$_662b[154]]=_$_662b[1]:a[_$_662b[151]][_$_662b[150]][0][_$_662b[150]][c][_$_662b[45]][_$_662b[154]]=_$_662b[155]},onload:function(c,d){d[_$_662b[158]][_$_662b[153]][_$_662b[157]](_$_662b[156])}})};
+a[_$_662b[160]]=function(b){e=jSuites[_$_662b[159]](b,{data:B[_$_662b[136]],autocomplete:!0,onchange:function(c,d,h,l){a[_$_662b[134]]=l},onload:function(c,d){d[_$_662b[158]][_$_662b[153]][_$_662b[157]](_$_662b[156])}})};a[_$_662b[161]]=function(b){p[_$_662b[164]](b,function(){-1==b[_$_662b[162]][_$_662b[5]](_$_662b[13])?b[_$_662b[162]]=p[_$_662b[15]][_$_662b[70]]()+_$_662b[13]+b[_$_662b[162]]:b[_$_662b[162]]=b[_$_662b[162]];a[_$_662b[12]]=b[_$_662b[162]];jSuites[_$_662b[163]](b)})};a[_$_662b[165]]=
+function(b){jSuites[_$_662b[166]](b)};a[_$_662b[167]]=function(b){b&&(a[_$_662b[12]]?a[_$_662b[116]]?a[_$_662b[117]]?(-1===a[_$_662b[12]][_$_662b[5]](_$_662b[13])&&(a[_$_662b[12]]=a[_$_662b[108]][_$_662b[70]]()+_$_662b[13]+a[_$_662b[12]]),b={range:a[_$_662b[12]],action:a[_$_662b[11]],type:a[_$_662b[116]],criteria:a[_$_662b[117]],text:a[_$_662b[138]],className:a[_$_662b[171]],allowBlank:a[_$_662b[172]]},b[_$_662b[117]][_$_662b[173]](_$_662b[74])?b[_$_662b[28]]=[a[_$_662b[174]],a[_$_662b[175]]]:b[_$_662b[28]]=
+[a[_$_662b[174]]],b[_$_662b[11]]===_$_662b[33]&&(b[_$_662b[33]]={},a[_$_662b[176]]&&(b[_$_662b[33]][_$_662b[166]]=a[_$_662b[176]]),a[_$_662b[177]]&&(b[_$_662b[33]][_$_662b[178]]=a[_$_662b[177]]),a[_$_662b[179]]&&(b[_$_662b[33]][_$_662b[180]]=_$_662b[179]),a[_$_662b[181]]&&(b[_$_662b[33]][_$_662b[182]]=_$_662b[181])),b={value:b},null!==a[_$_662b[27]]&&(b[_$_662b[27]]=a[_$_662b[27]]),a[_$_662b[108]][_$_662b[54]](b)):alert(g(_$_662b[170])):alert(g(_$_662b[169])):alert(g(_$_662b[168])))};var f=`<div>
             <div>
@@ -26,3 +41,3 @@ <!-- Validation type -->
                         <div class="form-group">
-                            <label class="label">${T(_$_ebbf[178])}</label>
+                            <label class="label">${g(_$_662b[183])}</label>
                             <div @ready="self.createPicker(this)" @bind="self.range"></div>
@@ -33,7 +48,7 @@ </div>
                         <div class="form-group">
-                            <label class="label">${T(_$_ebbf[179])}</label>
+                            <label class="label">${g(_$_662b[184])}</label>
                             <select style="padding: 8px;" @bind="self.action">
-                                <option value="warning">${T(_$_ebbf[180])}</option>
-                                <option value="reject">${T(_$_ebbf[181])}</option>
-                                <option value="format">${T(_$_ebbf[182])}</option>
+                                <option value="warning">${g(_$_662b[185])}</option>
+                                <option value="reject">${g(_$_662b[186])}</option>
+                                <option value="format">${g(_$_662b[187])}</option>
                             </select>
@@ -48,3 +63,3 @@ </div>
                             <div class="form-group">
-                                <label class="label">${T(_$_ebbf[180])}</label>
+                                <label class="label">${g(_$_662b[185])}</label>
                                 <input type="text" @bind="self.text" class="jss_object w100">
@@ -59,3 +74,3 @@ </div>
                         <div class="form-group">
-                            <label class="label">${T(_$_ebbf[183])}</label>
+                            <label class="label">${g(_$_662b[188])}</label>
                             <div @ready="self.createType(this)" @bind="self.type"></div>
@@ -65,3 +80,3 @@ </div>
                         <div class="form-group">
-                            <label class="label">${T(_$_ebbf[184])}</label>
+                            <label class="label">${g(_$_662b[189])}</label>
                             <div @ready="self.createOperator(this)" @bind="self.criteria"></div>
@@ -138,3 +153,3 @@ </div>
                                         <div class="form-group">
-                                            <label class="label">${T(_$_ebbf[185])}</label><br>
+                                            <label class="label">${g(_$_662b[190])}</label><br>
                                             <input @ready="self.createColorPicker(this)" @bind="self.formatColor" class="jss_object w100">
@@ -145,3 +160,3 @@ </div>
                                         <div class="form-group">
-                                            <label class="label">${T(_$_ebbf[186])}</label><br>
+                                            <label class="label">${g(_$_662b[191])}</label><br>
                                             <input @ready="self.createColorPicker(this)" @bind="self.formatBackgroundColor" class="jss_object w100">
@@ -154,3 +169,3 @@ </div>
                                         <div class="form-group">
-                                            <input type="text" placeholder="${T(_$_ebbf[187])}" @bind="self.className" class="jss_object">
+                                            <input type="text" placeholder="${g(_$_662b[192])}" @bind="self.className" class="jss_object">
                                         </div>
@@ -176,3 +191,3 @@ </div>
                         <div class='form-group center'>
-                            <button type="button" class="jbutton dark w100" onclick="self.close(true)">${T(_$_ebbf[188])}</button>
+                            <button type="button" class="jbutton dark w100" onclick="self.close(true)">${g(_$_662b[193])}</button>
                         </div>
@@ -182,4 +197,16 @@ </div>
             </div>
-            <p onclick="self.parent.closeForm()" class="cursor">${T(_$_ebbf[189])}</p>
-        </div>`;return lemonade[_$_ebbf[109]](template,self,{Calendar:Calendar,List:List})};var removeValidation=function(x,y){if(this[_$_ebbf[190]][y]&& this[_$_ebbf[190]][y][x]&& this[_$_ebbf[190]][y][x][_$_ebbf[109]]){this[_$_ebbf[190]][y][x][_$_ebbf[109]][_$_ebbf[192]](_$_ebbf[191]);this[_$_ebbf[190]][y][x][_$_ebbf[109]][_$_ebbf[148]][_$_ebbf[194]](_$_ebbf[193]);var classes=this[_$_ebbf[190]][y][x][_$_ebbf[109]][_$_ebbf[196]](_$_ebbf[195]);if(classes){classes= classes[_$_ebbf[14]](_$_ebbf[120]);for(var i=0;i< classes[_$_ebbf[21]];i++){this[_$_ebbf[190]][y][x][_$_ebbf[109]][_$_ebbf[148]][_$_ebbf[194]](classes[i])}};this[_$_ebbf[190]][y][x][_$_ebbf[109]][_$_ebbf[192]](_$_ebbf[195])}};var applyValidation=function(x,y,value,ignoreRejection){if(!this[_$_ebbf[22]][_$_ebbf[10]][_$_ebbf[4]]||  !(this[_$_ebbf[190]][y]&& this[_$_ebbf[190]][y][x]&& this[_$_ebbf[190]][y][x][_$_ebbf[109]])){return};removeValidation[_$_ebbf[63]](this,x,y);if(value== null|| value== undefined){value= this[_$_ebbf[190]][y][x][_$_ebbf[197]]};var w=this;var cellName=JSS[_$_ebbf[18]][_$_ebbf[198]](x,y);if(this[_$_ebbf[190]][y][x][_$_ebbf[109]]&& (this[_$_ebbf[4]]&& this[_$_ebbf[4]][cellName]!== undefined)){var validationIndexes=this[_$_ebbf[4]][cellName];for(var i=0;i< validationIndexes[_$_ebbf[21]];i++){var validationIndex=validationIndexes[i];var validation=this[_$_ebbf[22]][_$_ebbf[10]][_$_ebbf[4]][validationIndex];if(!validation){return};var valid=jSuites[_$_ebbf[4]](value,validation);if(!valid){if(validation[_$_ebbf[11]]!== _$_ebbf[33]){var text=validation[_$_ebbf[137]]|| validationDefaultErrorMessage(validation);this[_$_ebbf[190]][y][x][_$_ebbf[109]][_$_ebbf[199]](_$_ebbf[191],text);this[_$_ebbf[190]][y][x][_$_ebbf[109]][_$_ebbf[148]][_$_ebbf[152]](_$_ebbf[193]);if(validation[_$_ebbf[11]]=== _$_ebbf[200]&&  !ignoreRejection){setTimeout(function(){w[_$_ebbf[190]][y][x][_$_ebbf[109]][_$_ebbf[192]](_$_ebbf[191]);w[_$_ebbf[190]][y][x][_$_ebbf[109]][_$_ebbf[148]][_$_ebbf[194]](_$_ebbf[193])},2500);return false};break}}else {if(validation[_$_ebbf[11]]=== _$_ebbf[33]){var classes=[];if(validation[_$_ebbf[166]]){classes= validation[_$_ebbf[166]][_$_ebbf[14]](_$_ebbf[120])};classes[_$_ebbf[20]](_$_ebbf[201]+ this[_$_ebbf[22]][_$_ebbf[37]]+ _$_ebbf[38]+ validationIndex);for(var j=0;j< classes[_$_ebbf[21]];j++){this[_$_ebbf[190]][y][x][_$_ebbf[109]][_$_ebbf[148]][_$_ebbf[152]](classes[j])};this[_$_ebbf[190]][y][x][_$_ebbf[109]][_$_ebbf[199]](_$_ebbf[195],classes)}}}}};var pluginValidations=function(spreadsheet,spreadsheetConfig){var self={};self[_$_ebbf[202]]= function(worksheet){Validations(worksheet)};self[_$_ebbf[203]]= function(h,range){if(h[_$_ebbf[21]]&& this[_$_ebbf[22]][_$_ebbf[10]][_$_ebbf[4]]){var x1=h[0];var y1=h[1];var x2=h[2];var y2=h[3];var indexes=[];var cells=null;if(cells= this[_$_ebbf[4]]){for(var j=y1;j<= y2;j++){for(var i=x1;i<= x2;i++){var cellName=this[_$_ebbf[18]][_$_ebbf[198]](i,j);if(cells[cellName]){for(var t=0;t< cells[cellName][_$_ebbf[21]];t++){indexes[cells[cellName][t]]= true}}}}};var temp=this[_$_ebbf[22]][_$_ebbf[10]][_$_ebbf[4]][_$_ebbf[34]](function(validation,i){return {...validation,index:i}});self[_$_ebbf[204]]= T(_$_ebbf[205])+ _$_ebbf[117]+ (range|| _$_ebbf[1]);self[_$_ebbf[206]]= temp[_$_ebbf[207]](function(v,k){return indexes[k]})}else {self[_$_ebbf[206]]= []};if(!self[_$_ebbf[206]][_$_ebbf[21]]){self[_$_ebbf[204]]= T(_$_ebbf[208])+ _$_ebbf[117]+ (range|| _$_ebbf[1])};self[_$_ebbf[209]]()};self[_$_ebbf[210]]= function(toolbar){toolbar[_$_ebbf[216]][_$_ebbf[20]]({content:_$_ebbf[211],type:_$_ebbf[212],title:T(_$_ebbf[213]),onclick:function(){var range=JSS[_$_ebbf[15]][_$_ebbf[214]]();if(range){range= range[_$_ebbf[14]](_$_ebbf[13])[1]};self[_$_ebbf[215]](JSS[_$_ebbf[15]],range)}});return toolbar};self[_$_ebbf[215]]= function(instance,range){self[_$_ebbf[211]][_$_ebbf[107]]= instance;self[_$_ebbf[217]][_$_ebbf[215]]()};self[_$_ebbf[218]]= function(event,instance,a,b,c,d){if(event=== _$_ebbf[219]|| event=== _$_ebbf[220]|| event=== _$_ebbf[221]){a[_$_ebbf[25]](function(record){if(record[_$_ebbf[222]]&& record[_$_ebbf[223]]){applyValidation[_$_ebbf[63]](instance,record[_$_ebbf[222]],record[_$_ebbf[223]],null,true)}})}else {if(event=== _$_ebbf[224]){applyValidation[_$_ebbf[63]](instance,b,c)}else {if(event=== _$_ebbf[225]){if(!isFormula(d)){return applyValidation[_$_ebbf[63]](instance,b,c,d)}}else {if(event=== _$_ebbf[226]){self[_$_ebbf[203]][_$_ebbf[63]](instance,[a,b,c,d])}else {if(event=== _$_ebbf[66]){var affectedCells=null;a[_$_ebbf[25]](function(record){if(record[_$_ebbf[26]]&& record[_$_ebbf[26]][_$_ebbf[12]]){var cells=JSS[_$_ebbf[18]][_$_ebbf[17]](record[_$_ebbf[26]][_$_ebbf[12]]);cells[_$_ebbf[25]](function(cell){if(!affectedCells){affectedCells= {}};affectedCells[cell]= true})}});a[_$_ebbf[25]](function(record){if(record[_$_ebbf[28]]&& record[_$_ebbf[28]][_$_ebbf[12]]){var cells=JSS[_$_ebbf[18]][_$_ebbf[17]](record[_$_ebbf[28]][_$_ebbf[12]]);cells[_$_ebbf[25]](function(cell){if(!affectedCells){affectedCells= {}};affectedCells[cell]= true})}});if(affectedCells){var cells=Object[_$_ebbf[31]](affectedCells);cells[_$_ebbf[25]](function(cell){var t=cell[_$_ebbf[14]](_$_ebbf[13]);cell= JSS[_$_ebbf[18]][_$_ebbf[227]](t[1]);applyValidation[_$_ebbf[63]](W(t[0]),cell[0],cell[1],null,true)});var range=JSS[_$_ebbf[18]][_$_ebbf[228]](Object[_$_ebbf[31]](affectedCells));var selection=JSS[_$_ebbf[18]][_$_ebbf[229]](range);self[_$_ebbf[203]][_$_ebbf[63]](instance,selection,range)}}else {if(event=== _$_ebbf[230]){Validations[_$_ebbf[68]][_$_ebbf[63]](instance);var affectedCells=null;var o=instance[_$_ebbf[10]][_$_ebbf[4]];if(o&& o[_$_ebbf[21]]){o[_$_ebbf[25]](function(record){if(record[_$_ebbf[12]]){var cells=JSS[_$_ebbf[18]][_$_ebbf[17]](record[_$_ebbf[12]]);cells[_$_ebbf[25]](function(cell){if(!affectedCells){affectedCells= {}};affectedCells[cell]= true})}});if(affectedCells){var cells=Object[_$_ebbf[31]](affectedCells);cells[_$_ebbf[25]](function(cell){var t=cell[_$_ebbf[14]](_$_ebbf[13]);cell= JSS[_$_ebbf[18]][_$_ebbf[227]](t[1]);applyValidation[_$_ebbf[63]](W(t[0]),cell[0],cell[1],null,true)})}}}else {if(event=== _$_ebbf[231]|| event=== _$_ebbf[232]){if(!instance[_$_ebbf[22]][_$_ebbf[233]]){instance[_$_ebbf[22]][_$_ebbf[234]]= true;if(event=== _$_ebbf[231]){Validations[_$_ebbf[73]][_$_ebbf[63]](instance,c,b)}else {destroyCache(instance[_$_ebbf[22]]);Validations[_$_ebbf[69]][_$_ebbf[63]](instance,a,b);createCache(instance[_$_ebbf[22]])};instance[_$_ebbf[22]][_$_ebbf[234]]= false}}else {if(event=== _$_ebbf[235]){if(a[_$_ebbf[11]]== _$_ebbf[54]){var records=[];for(var i=0;i< a[_$_ebbf[190]][_$_ebbf[21]];i++){var record={index:a[_$_ebbf[190]][i][_$_ebbf[27]],value:a[_$_ebbf[190]][i][_$_ebbf[26]]};records[_$_ebbf[20]](record)};instance[_$_ebbf[54]](records)}}else {if(event=== _$_ebbf[236]){if(a[_$_ebbf[11]]== _$_ebbf[54]){instance[_$_ebbf[54]](a[_$_ebbf[190]])}}}}}}}}}}};self[_$_ebbf[237]]= function(o){self[_$_ebbf[217]]= jSuites[_$_ebbf[217]](o,{title:_$_ebbf[238],closed:true,width:_$_ebbf[239],height:_$_ebbf[240],backdrop:false})};self[_$_ebbf[241]]= function(s){self[_$_ebbf[211]][_$_ebbf[27]]= s[_$_ebbf[27]];self[_$_ebbf[211]][_$_ebbf[12]]= s[_$_ebbf[12]]|| self[_$_ebbf[211]][_$_ebbf[107]][_$_ebbf[214]]();self[_$_ebbf[211]][_$_ebbf[11]]= s[_$_ebbf[11]]|| _$_ebbf[242];self[_$_ebbf[211]][_$_ebbf[115]]= s[_$_ebbf[115]]|| _$_ebbf[135];self[_$_ebbf[211]][_$_ebbf[116]]= s[_$_ebbf[116]]|| _$_ebbf[74];if(s[_$_ebbf[28]]){self[_$_ebbf[211]][_$_ebbf[169]]= s[_$_ebbf[28]][0];self[_$_ebbf[211]][_$_ebbf[170]]= s[_$_ebbf[28]][1]}else {self[_$_ebbf[211]][_$_ebbf[169]]= _$_ebbf[1];self[_$_ebbf[211]][_$_ebbf[170]]= _$_ebbf[1]};self[_$_ebbf[171]]= _$_ebbf[1];self[_$_ebbf[172]]= _$_ebbf[1];self[_$_ebbf[174]]= _$_ebbf[1];self[_$_ebbf[176]]= _$_ebbf[1];self[_$_ebbf[166]]= _$_ebbf[1];self[_$_ebbf[243]][_$_ebbf[45]][_$_ebbf[149]]= _$_ebbf[150];self[_$_ebbf[244]][_$_ebbf[45]][_$_ebbf[149]]= _$_ebbf[245]};self[_$_ebbf[209]]= function(){self[_$_ebbf[243]][_$_ebbf[45]][_$_ebbf[149]]= _$_ebbf[245];self[_$_ebbf[244]][_$_ebbf[45]][_$_ebbf[149]]= _$_ebbf[150]};self[_$_ebbf[246]]= function(index){var range=spreadsheet[_$_ebbf[10]][_$_ebbf[4]][index][_$_ebbf[12]];self[_$_ebbf[211]][_$_ebbf[107]][_$_ebbf[56]](index)};var ComponentPlugin=function(){var template=`<div @ready="self.createModal(this)">
+            <p onclick="self.parent.closeForm()" class="cursor">${g(_$_662b[194])}</p>
+        </div>`;return lemonade[_$_662b[110]](f,a,{Calendar:H,List:C})},L=function(a,e){if(this[_$_662b[195]][e]&&this[_$_662b[195]][e][a]&&this[_$_662b[195]][e][a][_$_662b[110]]){this[_$_662b[195]][e][a][_$_662b[110]][_$_662b[197]](_$_662b[196]);this[_$_662b[195]][e][a][_$_662b[110]][_$_662b[153]][_$_662b[199]](_$_662b[198]);var f=this[_$_662b[195]][e][a][_$_662b[110]][_$_662b[201]](_$_662b[200]);if(f){f=f[_$_662b[14]](_$_662b[121]);for(var b=0;b<f[_$_662b[21]];b++)this[_$_662b[195]][e][a][_$_662b[110]][_$_662b[153]][_$_662b[199]](f[b])}this[_$_662b[195]][e][a][_$_662b[110]][_$_662b[197]](_$_662b[200])}},
+r=function(a,e,f,b){if(this[_$_662b[22]][_$_662b[10]][_$_662b[4]]&&this[_$_662b[195]][e]&&this[_$_662b[195]][e][a]&&this[_$_662b[195]][e][a][_$_662b[110]]){L[_$_662b[63]](this,a,e);if(null==f||void 0==f)f=this[_$_662b[195]][e][a][_$_662b[202]];var c=this,d=p[_$_662b[18]][_$_662b[203]](a,e);if(this[_$_662b[195]][e][a][_$_662b[110]]&&this[_$_662b[4]]&&void 0!==this[_$_662b[4]][d]){d=this[_$_662b[4]][d];for(var h=0;h<d[_$_662b[21]];h++){var l=d[h],k=this[_$_662b[22]][_$_662b[10]][_$_662b[4]][l];if(!k)break;
+if(!jSuites[_$_662b[4]](f,k)){if(k[_$_662b[11]]!==_$_662b[33]){f=k[_$_662b[138]]||J(k);this[_$_662b[195]][e][a][_$_662b[110]][_$_662b[204]](_$_662b[196],f);this[_$_662b[195]][e][a][_$_662b[110]][_$_662b[153]][_$_662b[157]](_$_662b[198]);if(k[_$_662b[11]]===_$_662b[205]&&!b)return setTimeout(function(){c[_$_662b[195]][e][a][_$_662b[110]][_$_662b[197]](_$_662b[196]);c[_$_662b[195]][e][a][_$_662b[110]][_$_662b[153]][_$_662b[199]](_$_662b[198])},2500),!1;break}}else if(k[_$_662b[11]]===_$_662b[33]){var n=
+[];k[_$_662b[171]]&&(n=k[_$_662b[171]][_$_662b[14]](_$_662b[121]));n[_$_662b[20]](_$_662b[206]+this[_$_662b[22]][_$_662b[37]]+_$_662b[38]+l);for(k=0;k<n[_$_662b[21]];k++)this[_$_662b[195]][e][a][_$_662b[110]][_$_662b[153]][_$_662b[157]](n[k]);this[_$_662b[195]][e][a][_$_662b[110]][_$_662b[204]](_$_662b[200],n)}}}}},M=function(a,e){var f={};f[_$_662b[207]]=function(b){t(b)};f[_$_662b[208]]=function(b,c){if(b[_$_662b[21]]&&this[_$_662b[22]][_$_662b[10]][_$_662b[4]]){var d=b[0],h=b[1],l=b[2];b=b[3];
+var k=[],n=null;if(n=this[_$_662b[4]])for(;h<=b;h++)for(var m=d;m<=l;m++){var q=this[_$_662b[18]][_$_662b[203]](m,h);if(n[q])for(var w=0;w<n[q][_$_662b[21]];w++)k[n[q][w]]=!0}d=this[_$_662b[22]][_$_662b[10]][_$_662b[4]][_$_662b[34]](function(D,x){return Object.assign({},D,{index:x})});f[_$_662b[209]]=g(_$_662b[210])+_$_662b[118]+(c||_$_662b[1]);f[_$_662b[211]]=d[_$_662b[212]](function(D,x){return k[x]})}else f[_$_662b[211]]=[];f[_$_662b[211]][_$_662b[21]]||(f[_$_662b[209]]=g(_$_662b[213])+_$_662b[118]+
+(c||_$_662b[1]));f[_$_662b[214]]()};f[_$_662b[215]]=function(b){b[_$_662b[221]][_$_662b[20]]({content:_$_662b[216],type:_$_662b[217],title:g(_$_662b[218]),onclick:function(){var c=p[_$_662b[15]][_$_662b[219]]();c&&(c=c[_$_662b[14]](_$_662b[13])[1]);f[_$_662b[220]](p[_$_662b[15]],c)}});return b};f[_$_662b[220]]=function(b,c){f[_$_662b[216]][_$_662b[108]]=b;f[_$_662b[222]][_$_662b[220]]()};f[_$_662b[223]]=function(b,c,d,h,l,k){if(b===_$_662b[224]||b===_$_662b[225]||b===_$_662b[226])d[_$_662b[25]](function(m){if(m[_$_662b[227]]&&
+m[_$_662b[228]])r[_$_662b[63]](c,m[_$_662b[227]],m[_$_662b[228]],null,!0)});else if(b===_$_662b[229])r[_$_662b[63]](c,h,l);else if(b===_$_662b[230]){if((_$_662b[1]+k)[_$_662b[106]](0,1)!==_$_662b[86])return r[_$_662b[63]](c,h,l,k)}else if(b===_$_662b[231])f[_$_662b[208]][_$_662b[63]](c,[d,h,l,k]);else if(b===_$_662b[66]){var n=null;d[_$_662b[25]](function(m){if(m[_$_662b[26]]&&m[_$_662b[26]][_$_662b[12]])p[_$_662b[18]][_$_662b[17]](m[_$_662b[26]][_$_662b[12]])[_$_662b[25]](function(q){n||(n={});n[q]=
+!0})});d[_$_662b[25]](function(m){if(m[_$_662b[28]]&&m[_$_662b[28]][_$_662b[12]])p[_$_662b[18]][_$_662b[17]](m[_$_662b[28]][_$_662b[12]])[_$_662b[25]](function(q){n||(n={});n[q]=!0})});n&&(d=Object[_$_662b[31]](n),d[_$_662b[25]](function(m){var q=m[_$_662b[14]](_$_662b[13]);m=p[_$_662b[18]][_$_662b[232]](q[1]);r[_$_662b[63]](u(q[0]),m[0],m[1],null,!0)}),d=p[_$_662b[18]][_$_662b[233]](Object[_$_662b[31]](n)),b=p[_$_662b[18]][_$_662b[234]](d),f[_$_662b[208]][_$_662b[63]](c,b,d))}else if(b===_$_662b[235])t[_$_662b[68]][_$_662b[63]](c),
+n=null,(d=c[_$_662b[10]][_$_662b[4]])&&d[_$_662b[21]]&&(d[_$_662b[25]](function(m){if(m[_$_662b[12]])p[_$_662b[18]][_$_662b[17]](m[_$_662b[12]])[_$_662b[25]](function(q){n||(n={});n[q]=!0})}),n&&(d=Object[_$_662b[31]](n),d[_$_662b[25]](function(m){var q=m[_$_662b[14]](_$_662b[13]);m=p[_$_662b[18]][_$_662b[232]](q[1]);r[_$_662b[63]](u(q[0]),m[0],m[1],null,!0)})));else if(b===_$_662b[236]||b===_$_662b[237]){if(!c[_$_662b[22]][_$_662b[238]]){c[_$_662b[22]][_$_662b[239]]=!0;if(b===_$_662b[236])t[_$_662b[73]][_$_662b[63]](c,
+l,h);else G(c[_$_662b[22]]),t[_$_662b[69]][_$_662b[63]](c,d,h),A(c[_$_662b[22]]);c[_$_662b[22]][_$_662b[239]]=!1}}else if(b===_$_662b[240]){if(d[_$_662b[11]]==_$_662b[54]){b=[];for(h=0;h<d[_$_662b[195]][_$_662b[21]];h++)b[_$_662b[20]]({index:d[_$_662b[195]][h][_$_662b[27]],value:d[_$_662b[195]][h][_$_662b[26]]});c[_$_662b[54]](b)}}else if(b===_$_662b[241]&&d[_$_662b[11]]==_$_662b[54])c[_$_662b[54]](d[_$_662b[195]])};f[_$_662b[242]]=function(b){f[_$_662b[222]]=jSuites[_$_662b[222]](b,{title:_$_662b[243],
+closed:!0,width:_$_662b[244],height:_$_662b[245],backdrop:!1})};f[_$_662b[246]]=function(b){f[_$_662b[216]][_$_662b[27]]=b[_$_662b[27]];f[_$_662b[216]][_$_662b[12]]=b[_$_662b[12]]||f[_$_662b[216]][_$_662b[108]][_$_662b[219]]();f[_$_662b[216]][_$_662b[11]]=b[_$_662b[11]]||_$_662b[247];f[_$_662b[216]][_$_662b[116]]=b[_$_662b[116]]||_$_662b[136];f[_$_662b[216]][_$_662b[117]]=b[_$_662b[117]]||_$_662b[74];b[_$_662b[28]]?(f[_$_662b[216]][_$_662b[174]]=b[_$_662b[28]][0],f[_$_662b[216]][_$_662b[175]]=b[_$_662b[28]][1]):
+(f[_$_662b[216]][_$_662b[174]]=_$_662b[1],f[_$_662b[216]][_$_662b[175]]=_$_662b[1]);f[_$_662b[176]]=_$_662b[1];f[_$_662b[177]]=_$_662b[1];f[_$_662b[179]]=_$_662b[1];f[_$_662b[181]]=_$_662b[1];f[_$_662b[171]]=_$_662b[1];f[_$_662b[248]][_$_662b[45]][_$_662b[154]]=_$_662b[155];f[_$_662b[249]][_$_662b[45]][_$_662b[154]]=_$_662b[250]};f[_$_662b[214]]=function(){f[_$_662b[248]][_$_662b[45]][_$_662b[154]]=_$_662b[250];f[_$_662b[249]][_$_662b[45]][_$_662b[154]]=_$_662b[155]};f[_$_662b[251]]=function(b){f[_$_662b[216]][_$_662b[108]][_$_662b[56]](b)};
+e=document[_$_662b[46]](_$_662b[252]);a[_$_662b[254]][_$_662b[253]](e);lemonade[_$_662b[255]](function(){var b=`<div @ready="self.createModal(this)">
                 <div @ref="self.listContainer">
@@ -190,5 +217,5 @@ <div>
                     </div>
-                    <p><input type="button" value="${T(_$_ebbf[213])}" onclick="self.openForm({ index: null })" class="jbutton dark" /></p>
+                    <p><input type="button" value="${g(_$_662b[218])}" onclick="self.openForm({ index: null })" class="jbutton dark" /></p>
                 </div>
                 <div @ref="self.settingsContainer" style="display: none;"><Settings @ref="self.settings" /></div>
-             </div>`;return lemonade[_$_ebbf[109]](template,self,{Settings:Settings,List:List})};var container=document[_$_ebbf[46]](_$_ebbf[247]);spreadsheet[_$_ebbf[249]][_$_ebbf[248]](container);lemonade[_$_ebbf[250]](ComponentPlugin,container);return self};var P=(function(){return true});P[_$_ebbf[251]]= function(spreadsheet,options){var message=License[_$_ebbf[63]](spreadsheet);if(message){console[_$_ebbf[60]](message)}else {spreadsheet[_$_ebbf[252]]({validations:pluginValidations})}};P[_$_ebbf[253]]= function(v){if(JSS=== null){JSS= this}};return P})))
+             </div>`;return lemonade[_$_662b[110]](b,f,{Settings:K,List:C})},e);return f},y=function(){return!0};y[_$_662b[256]]=function(a,e){if(e=E[_$_662b[63]](a))console[_$_662b[60]](e);else a[_$_662b[257]]({validations:M})};y[_$_662b[258]]=function(a){null===p&&(p=this)};return y});

package.json

@@ -31,6 +31,6 @@ {
         "jszip": "^3.7.1",
-        "jsuites": "^4.12.3"
+        "jsuites": "^4.12.10"
     },
     "main": "dist/index.js",
-    "version": "1.0.0",
+    "version": "1.0.1",
     "bugs": "https://github.com/jspreadsheet/pro/issues",
@@ -37,0 +37,0 @@ "homepage": "https://github.com/jspreadsheet/pro",

New alerts

Minified code

Quality

This package contains minified code. This may be harmless in some cases where minified code is included in packaged libraries, however packages on npm should not minify code.

Found 1 instance in 1 package

Worsened metrics

Total package byte prevSize

30102

decreased by-15.35%

Lines of code

248

decreased by-4.25%

Number of low quality alerts

1

increased byInfinity%

Dependency changes

• Updatedjsuites@^4.12.10