Inconsistency with merged cell having a formula that pulls from a cell on a different column such as {cell_name} = A1:B1 D3 ={cell

Progress® Kendo UI® for jQuery Feedback Portal

Create an account Log In

Back to Feed

Request a Feature Report a Bug

Completed

Last Updated: 02 Dec 2021 13:38 by ADMIN

Release 2021.R3.SP.next

Software

Created on: 11 Nov 2021 18:36

Category: Spreadsheet

Type: Bug Report

Inconsistency with merged cell having a formula that pulls from a cell on a different column such as {cell_name} = A1:B1 D3 ={cell_name} will return #VALUE

In Excel I can create a merged cell. For this example, I will merge A1:B1 and name the range MyCell. Next I name the single cell D5, and call it MyAnswer. I can enter the following formula into MyAnswer, =MyCell and Excel will return the result.

Using Telerik if I create the same layout I get a #Value or #Spill error because Telerik requires MyAnswer to be the same merge configuration as MyCell which creates a significant disadvantage in usability.

Can you please advise when this issue will be fixed in Telerik.

I have attached a screen recording of this not working in your Dojo named "Telerik merge cell reference not working when not same col.mov".

Thank you so much.

Attached Files:

telerik-merge-cell-reference-not-working-when-not-same-col-mov.zip

4 comments

ADMIN

Neli

Posted on: 26 Nov 2021 13:43

Hello,

Following your report, I have increased the priority of the item. Thus, it will take precedence over other issues in the queue.

Feel free to contact us again, if you have any questions or comments.

Regards,
Neli
Progress Telerik

Love the Telerik and Kendo UI products and believe more people should try them? Invite a fellow developer to become a Progress customer and each of you can get a $50 Amazon gift voucher.

Software

Posted on: 19 Nov 2021 16:01

Good morning, Nencho.

I hope you are doing well!

Can you please schedule this issue to be fixed as soon as possible? This issue was reported on December 27th, 2019:

https://github.com/telerik/kendo-ui-core/issues/5500

And then the issue was reported again on November 27th, 2020:

https://github.com/telerik/kendo-ui-core/issues/6163

Thank you very much in advance for your assistance in resolving this bug.

ADMIN

Nencho

Posted on: 17 Nov 2021 07:38

Hello,

I can confirm that the demonstrated issue is a bug and I have converted this thread to a bug report. That said, it enters our backlog and you can follow this item, in order to track the progress of the bugfix.

In addition, I have updated your Telerik points for pointing that issue out.

Please excuse us for any inconveniences caused by the bug.

Regards,
Nencho
Progress Telerik

Virtual Classroom, the free self-paced technical training that gets you up to speed with Telerik and Kendo UI products quickly just got a fresh new look + new and improved content including a brand new Blazor course! Check it out at https://learn.telerik.com/.

ADMIN

Nencho

Posted on: 12 Nov 2021 16:37

Hello,

Thank you for the provided video.

We are now investigating the reason for the demonstrated behavior in an attempt to evaluate the exact reason. I will update you in this thread immediately after we have some further information on the matter.

Thank you in advance for your patience!

Regards,
Nencho
Progress Telerik