Ban Extra Input
Key Ban Extra Input in ExCfgShtOp refers to a boolean that dermines how irrelevant key-value pairs entered as arguments in the Excel Deriscope formula are treated.
A TRUE setting has the effect that the formula fails with an informative error message about the unneeded arguments.
A FALSE setting means the unneeded arguments are silently ignored and the formula proceeds by processing the relevant input only.
It is recommended to use TRUE to avoid having the false impression that what appears as input to the formula is also actually processed by the formula.
For those situations where it is not desirable to change the structure of what goes inside a Deriscope formula, an alternative solution is to use the special dsi Excel formula, which is like ds with the only difference that ignores irrelevant input.
