When the reference to a cell in a specific Sheet is added in the defineName function, using the name leads to invalid result.
Reproduction of the problem
- Open the Dojo - https://dojo.telerik.com/@NeliKondova/eWeVASOK
- Select a cell and type '=Foo'
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:
The issue is a regression starting with the 2022 R2 SP1 (2022.2.621) release
- Kendo UI version: 2023.2.829
- Browser: [all ]