tj_aew
Oct 11, 2022Copper Contributor
Status:
New
Allow a custom function to opt into doing all of its own argument validation
Currently, when a custom function provides type information for its parameters, Excel does some basic validation. For instance, if you say the parameter's type is `number` and the user provides `"x"`...
JamesDuley
Oct 18, 2022Copper Contributor
I believe this is possible if you mark the type as `any` rather than `number`, then you can check the type at the start of the function.