Hi There,
I am facing one issue in kendo spreadsheet onchange event.
Suppose I have applied formula on one cell A1 and formula is =SUM(B1:B3)
Now one change of values in B1 to B3 on change event gets fired but whenever cell A1 values gets updated i.e. on entering value in B1 to B2, on change event doesn’t get fired.
How can I make onchange event fire for formula cell.
Thank you,
Rakesh
Hi,
Please do that because as per me it would be good.
Thank you,
Rakesh
Hello Rakesh,
Indeed, the change event is not triggered for cells, which value is changed due to some references in the formulas. The reason is the fact that there is no user interaction (all of the components follow this practice) and the is no actual change in the cell - the formula is the same.
If you feel like such a functionality would be suitable, I would suggest having it submitted in our public feedback portal. Just let me know, and I will convert the thread to such or submit a new one on your behalf.
Regards,
Nencho
Progress Telerik