Hi Deivaselvan
Sorry , i think my doubt is not well explained.
I´m tal about this paragraph
"For writing a custom formula method, any convention with respect to passing arguments can be used within the implementation code. Thus, arguments can be a single entry
like A1 or 153 or it can be more complex like A1:C15. The computed value will be returned as a string. The arguments can be enhanced with standard items like cell references,
numbers, other formulas, etc., using the parsing tools of CalcEngine to minimize the amount of code that is required to be written."
Text talk about a parser that work with functions arguments, not to compute. And certanly its a more smart parser.
In example , use of Split to parse string is much simple.
And Calculate not use it, for example in CONCAT :
=CONCAT("use ," , "this , to demonstrate")
if use SPLIT you not know you have double quote and return incorrect result.
But your argument parser made this correct, i think you have more smart parse than a simple SPLIT or REGX.
thanks
