Completed
Last Updated: 24 Nov 2023 13:03 by ADMIN
Release R1.2024-Increment.2(31.Jan.2024)
Mohd
Created on: 07 Sep 2023 15:51
Category: Spreadsheet
Type: Bug Report
2
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 - https://dojo.telerik.com/@NeliKondova/eWeVASOK
  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:
image

test.xlsx

The issue is a regression starting with the 2022 R2 SP1 (2022.2.621) release

Environment

  • Kendo UI version: 2023.2.829
  • Browser: [all ]
2 comments
ADMIN
Nikolay
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.

Regards,
Nikolay
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
Naveen
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.