Hello,
Can i iterate this code through the loop in kendo spreadsheet
sheet.range("AV2").formula("sum(AJ2:AU2)").background("#FFFF00").color("#ffffff");
sheet.range("AV3").formula("sum(AJ3:AU3)").background("#FFFF00").color("#ffffff");
sheet.range("AV4").formula("sum(AJ4:AU4)").background("#FFFF00").color("#ffffff");
sheet.range("AV5").formula("sum(AJ5:AU5)").background("#FFFF00").color("#ffffff");
sheet.range("AV6").formula("sum(AJ6:AU6)").background("#FFFF00").color("#ffffff");
sheet.range("AV7").formula("sum(AJ7:AU7)").background("#FFFF00").color("#ffffff");
sheet.range("AV8").formula("sum(AJ8:AU8)").background("#FFFF00").color("#ffffff");
sheet.range("AV9").formula("sum(AJ9:AU9)").background("#FFFF00").color("#ffffff");
sheet.range("AV10").formula("sum(AJ10:AU10)").background("#FFFF00").color("#ffffff");
sheet.range("AV11").formula("sum(AJ11:AU11)").background("#FFFF00").color("#ffffff");
sheet.range("AV12").formula("sum(AJ12:AU12)").background("#FFFF00").color("#ffffff");
sheet.range("AV13").formula("sum(AJ13:AU13)").background("#FFFF00").color("#ffffff");
sheet.range("AV14").formula("sum(AJ14:AU14)").background("#FFFF00").color("#ffffff");
sheet.range("AV15").formula("sum(AJ15:AU15)").background("#FFFF00").color("#ffffff");
sheet.range("AV16").formula("sum(AJ16:AU16)").background("#FFFF00").color("#ffffff");
sheet.range("AV17").formula("sum(AJ17:AU17)").background("#FFFF00").color("#ffffff");
sheet.range("AV18").formula("sum(AJ18:AU18)").background("#FFFF00").color("#ffffff");
sheet.range("AV19").formula("sum(AJ19:AU19)").background("#FFFF00").color("#ffffff");
sheet.range("AV20").formula("sum(AJ20:AU20)").background("#FFFF00").color("#ffffff");
sheet.range("AV21").formula("sum(AJ21:AU21)").background("#FFFF00").color("#ffffff");
sheet.range("AV22").formula("sum(AJ22:AU22)").background("#FFFF00").color("#ffffff");
sheet.range("AV23").formula("sum(AJ23:AU23)").background("#FFFF00").color("#ffffff");
and what is the validate solution for this loop iterate based on row data available in spreadsheet

I have a grid with an edit button which opens a modal window
Inside that modal window I have a text area
Each time I set the value, it indents
$("#mytextarea").kendoTextArea().data('kendoTextArea').value("A new comment here");
It starts to do this which each successive setting of the value.
<span class="k-input k-textarea k-input-solid k-input-md k-rounded-md" style="width: 100%;">
<span class="k-input k-textarea !k-overflow-y-auto k-input-inner k-input-solid k-input-md k-rounded-md" style="width: 100%; resize: none;">
<span class="k-input k-textarea !k-overflow-y-auto k-input-inner k-input-solid k-input-md k-rounded-md" style="width: 100%; resize: none;">
<span class="k-input k-textarea !k-overflow-y-auto k-input-inner k-input-solid k-input-md k-rounded-md" style="width: 100%; resize: none;">
<textarea id="setup-deliverymethod-dialog-comments-textarea" style="width: 100%; resize: none;" data-role="textarea" aria-disabled="false" rows="1" placeholder="Comments" class="!k-overflow-y-auto k-input-inner" autocomplete="off"></textarea>
</span>
</span>
</span>
</span>
Am I setting the textarea value incorrectly?

am getting below error,
Even your demo site is also giving the same error.

Am getting "SCRIPT5007: Unable to get property 'options' of undefined or null reference On kendo.all.min.js (25,35564)" error,
even your demo site is also giving the same error.

1.I want to set multiple sheet tab name every sheet tab name have a different columns and I want this when click on another tab than that data show
2. how to set validation for model from json file. Json file also contain sequence of column based on that file column should show is it possible?
3.I'm doing validation like this please check zip file
It's too lengthy code how to handle if dynamically any changes on column please help me to solve out this problem
I have Json file like this please check another zip file.I have a multiple json file i want when i click on sheet tab name than that json file columns and data show
We are planning our future development and we will have to migrate our desktop application suite to web application.
We are using Kendo UI for JQuery right now, and reviewing your roadmap it seems like the library will grow next year.
We have to be confident that your roadmap for jquery will assure new features and new component for the future
What about your future development on jquery for the next years? The library will grow as the Angular and Vue one or it will stop?
Thanks for all.