Onchange Event

[Marc]

When the user clicks in a certain column, we make it into a dropdown (using range.validation(String here). We have to do this because there are over 10,000 rows and adding different validations to each takes too long.

However - we also have an onchange method, which fires when this dropdown (validation) is added as technically the cell value has changed (from the original value, to the new value which is the same as the original, but part of a validation). Is there any way to stop this event firing? Thanks!

[Michael]

I solved this issued in my projects by doing the following:

var isChanging;

$(document).ready(function(){
    isChanging = true;
    //do validation setting here
    isChanging = false;
});

function onChange(row,col,cell){
    if(isChanging)
        return;

    //other change logic here
}

[Marc]

Hi Michal,

This is a great solution. I'm quite annoyed as I had already implemented this type of thing for when I initially populate the spreadsheet, so I do the same thing with a variable called intialDataLoad. Thanks again for the help!

Marc