{"action":"opened","issue":{"url":"https://api.github.com/repos/handsontable/handsontable/issues/2708","labels_url":"https://api.github.com/repos/handsontable/handsontable/issues/2708/labels{/name}","comments_url":"https://api.github.com/repos/handsontable/handsontable/issues/2708/comments","events_url":"https://api.github.com/repos/handsontable/handsontable/issues/2708/events","html_url":"https://github.com/handsontable/handsontable/issues/2708","id":99157287,"number":2708,"title":"How to change cell color in after change.","user":{"login":"kvnandini","id":12949824,"avatar_url":"https://avatars.githubusercontent.com/u/12949824?v=3","gravatar_id":"","url":"https://api.github.com/users/kvnandini","html_url":"https://github.com/kvnandini","followers_url":"https://api.github.com/users/kvnandini/followers","following_url":"https://api.github.com/users/kvnandini/following{/other_user}","gists_url":"https://api.github.com/users/kvnandini/gists{/gist_id}","starred_url":"https://api.github.com/users/kvnandini/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/kvnandini/subscriptions","organizations_url":"https://api.github.com/users/kvnandini/orgs","repos_url":"https://api.github.com/users/kvnandini/repos","events_url":"https://api.github.com/users/kvnandini/events{/privacy}","received_events_url":"https://api.github.com/users/kvnandini/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":0,"created_at":"2015-08-05T08:59:59Z","updated_at":"2015-08-05T08:59:59Z","closed_at":null,"body":"@AMBudnik, I have to change the color of certain cell based on data pasted only if the cell is null, basically my cell are nothing but fields on CRM, so i need to make some of them mandatory.\r\n\r\n afterChange: function (changes, source, isValid) { \r\n\t\t\t     \r\n\t\t\t\t if (cleanCalled) {\r\n\t\t\t\t\t// detected clear call so we skip it\r\n\t\t\t\t\tcleanCalled = false;\r\n\t\t\t\t\treturn;\r\n\t\t\t\t  }else{\r\n\t\t\t\t\t  var changesJson = JSON.stringify(changes);\r\n\t\t\t\t\t  if ((source == \"edit\" || source == \"paste\") ) { \r\n\t\t\t\t\t\tfor(var i=0; i< changes.length ; i++) {\r\n\t\t\t\t\t\t\tfor(var j = 0; j < globalchanges.length; j++){\r\n                                                           console.log(changes[i][0].toString()+changes[i][1].toString());\r\n                    if(changes[i][0].toString()+changes[i][1].toString() === \"44\" && changes[i][3].toString() === ''){\r\n                       console.log('RED--- @AMBudnik --- I NEED TO CHANGE HERE.. HOW CAN I DO THIS');\r\n                       console.log('did it');\r\n                    } \r\n\t\t\t\t\t\t\t   if(changes[i][0].toString()+','+changes[i][1].toString() === globalchanges[j][0].toString()+','+globalchanges[j][1].toString()){\r\n\t\t\t\t\t\t\t\t\tglobalchanges.splice(j,1);                            \r\n\t\t\t\t\t\t\t\t} \r\n\t\t\t\t\t\t\t\t\t\t\t\t\t \r\n\t\t\t\t\t\t\t }\r\n\t\t\t\t\t\t\t globalchanges.push([changes[i][0],changes[i][1],changes[i][2],changes[i][3]]);\r\n\t\t\t\t\t\t }\r\n\t\t\t\t\t\t console.log('Changes'+JSON.stringify(changes)); \r\n\t\t\t\t\t\t console.log('GlobalChanges'+JSON.stringify(globalchanges));\r\n\t\t\t\t\t   }  \r\n\t\t\t\t   } \r\n\t\t\t },\r\n\t\t\t afterValidate: function (isValid, value, row, prop, source) {\r\n\t\t\t\t if (source == \"paste\") {                \r\n\t\t\t\t\t if (!isValid){\r\n\t\t\t\t\t   alert(isValid);\r\n\t\t\t\t\t   if(errorflag == \"false\") { \r\n\t\t\t\t\t\t alert('{!$Label.IPM_FinancialGrid_MSG3}');\r\n\t\t\t\t\t\t errorflag = \"true\"; \r\n\t\t\t\t\t\t document.getElementById(\"btn13\").click();             \r\n\t\t\t\t\t\t}                                             \r\n\t\t\t\t\t }\r\n\r\n\t\t\t\t }else if (source == \"edit\" ) {\r\n\t\t\t\t\t if (!isValid){\r\n\t\t\t\t\t\t alert('{!$Label.IPM_FinancialGrid_MSG3}'); \r\n\t\t\t\t\t\t document.getElementById(\"btn13\").click();                                                            \r\n\t\t\t\t\t }\r\n\r\n\t\t\t\t }\r\n\t\t\t }"}}