When the reference to a cell in a specific Sheet is added in the defineName function, using the name leads to invalid result.
The returned result is '#NAME?'
The returned result should depend on the referenced cell value. In the example above B2 have a value 5, thus the value in the selected cell should be also 5.
The issue also appears when importing an Excel file with defined names in the Spreadsheet. The names in the attached Excel file are created as in the image below:
Hello Naveen,
This bug is listed with the highest priority and will be handled soon.
I suggest subscribing to the GitHub issue to receive automatic notifications when its status changes.
Regards,
Nikolay
Progress Telerik