- Steve McNiven
So here’s a small example, just checks a local array, stripped clean for simplicity
It’s important to note the syntax in the validation definition, it’s R1C1 notation apparently. Relative cell notation, so RC is the current cell, which is why that’s passed into the function.
Here’s another example that shows how to validate for a number
- Note how the args are the variable AND the data type
- defineFunction has to exist BEFORE you initialize the spreadsheet element.