HEX2DEC Formula when implemented it does not work.

[chandantiwari02]

Following quick code implemented for above formula

case BuiltinFunctionNames.HEX2DEC_EN:

region HEX2DEC

                args = GetFunctionArgs(cell, funNode.Children, 1, 2);                  
                    if (args[0].type != FormulaValueType.Number)
                    {
                        throw new FormulaParameterMismatchException(cell);
                    }
                return int.Parse(args[0], System.Globalization.NumberStyles.HexNumber);

But above HEX2DEC get wrongly truncated to HEX2 for cell value , may be it is following (?\$?[A-Z]+\$?[0-9]+)

But when we change above formula name to HEXTODEC it works.

[jingwood]

Looks like the function name HEX2 was recognized as a cell address.

[jingwood]

Consider change to parse cell address from an entire word to avoid this.