#4
String literals, numbers, etc. are technically not restricted for Excel functions. However, the practical range of values for numbers and string is likely directly related to the input.
Currently, I have it hardcoded that (for string manipulation functions) numbers do not exceed the length of the input string. Strings, likewise, are either the original input or a substring of it.
Turn this into a modular heuristic.
#4
String literals, numbers, etc. are technically not restricted for Excel functions. However, the practical range of values for numbers and string is likely directly related to the input.
Currently, I have it hardcoded that (for string manipulation functions) numbers do not exceed the length of the input string. Strings, likewise, are either the original input or a substring of it.
Turn this into a modular heuristic.