This is a migrated thread and some comments may be shown as answers.

pasting data loops over cell range twice

2 Answers 91 Views
Spreadsheet
This is a migrated thread and some comments may be shown as answers.
Greg
Top achievements
Rank 1
Greg asked on 03 May 2018, 04:34 PM

I've hooked into the change event on the spreadsheet to do some processing of the value entered.  Inside the method, I'm using range.forEachCell() to loop over the cells that changed

Anytime I paste a value into a cell it is looping over the range twice.  Here is a quick snippet from the javascript console:

cell value: 4/3/2018 3:03
*** after forEachCell
cell value: 4/3/2018 3:03
*** after forEachCell

 

Is this expected behavior or is this a bug in your software?

I'm using the current release of your software, testing in the latest version of Firefox 59.0.2 (64bit) and have verified it on Chrome v66 (64bit).

Let me know.

Thanks.
Greg

2 Answers, 1 is accepted

Sort by
0
Greg
Top achievements
Rank 1
answered on 03 May 2018, 05:46 PM

A little bit more clarification on what I'm seeing. Looks like the change event is actually being called twice and the forEachCell is only executing once each time.  I initialized a counter outside of the change event to see how many times each method was executing.

cell value: 4/3/2018 3:03
*** after forEachCell with forEach executions: 1
*** end change() with change executions: 1
cell value: 4/3/2018 3:03
*** after forEachCell with forEach executions: 2
*** end change() with change executions: 2

Hope that helps.

Thanks.

Greg

0
Accepted
Dimitar
Telerik team
answered on 07 May 2018, 11:23 AM
Hello Greg,

Thank you for reporting the issue.

I have logged this as a bug in the Kendo UI GitHub repository from where you could start tracking the progress that we make on this item. 

Also, as a token of gratitude for helping us discover this issue, I have updated your Telerik points accordingly.

Regards,
Dimitar
Progress Telerik
Try our brand new, jQuery-free Angular components built from ground-up which deliver the business app essential building blocks - a grid component, data visualization (charts) and form elements.
Tags
Spreadsheet
Asked by
Greg
Top achievements
Rank 1
Answers by
Greg
Top achievements
Rank 1
Dimitar
Telerik team
Share this question
or