Last Updated: 24 Nov 2023 13:03 by ADMIN
Release R1.2024-Increment.2(31.Jan.2024)
Created on: 07 Sep 2023 15:51
Category: Spreadsheet
Type: Bug Report
Using defineName method to create qualified names in the Spreadsheet does not work correctly

Bug report

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

  1. Open the Dojo -
  2. Select a cell and type '=Foo'

Current behavior

The returned result is '#NAME?'

Expected/desired behavior

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 ]
Posted on: 27 Sep 2023 09:33

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.

Progress Telerik

Stay tuned by visiting our public roadmap and feedback portal pages! Or perhaps, if you are new to our Kendo family, check out our getting started resources
Posted on: 20 Sep 2023 17:36
This seems to be a very critical issue, as defined names feature was earlier working correctly, seems like new releases caused this issue. It should be fixed on priority.