Spreadsheet render event

[Bruce]

When I put code in the onRender(e) event, the OnRender event keeps firing causing stack overflow errors.

What I've succeeded in doing is:
loading my model (Columns A-N) 

 

What I'd like to do after the model has loaded is:

1. Disable columns A:B

2. Add formulas in Columns (O-Q)

 

How do I do this?

 

[Dimitar]

Hello Bruce,

I apologize for the delayed response.

Disabling cells can be achieved by retrieving the specified range, which we would like to disable and then using the Spreadsheet Range's enable() method. This is demonstrated in the following Spreadsheet demo:

• https://demos.telerik.com/kendo-ui/spreadsheet/disabled-cells

For applying a formula to a cell, the Spreadsheet Range's formula() method can be used. Check out the following Dojo example, where you can see the method in action:

• https://dojo.telerik.com/oPeGUs

I hope this helps. Should you have any additional questions, please let me know.

Regards,
Dimitar
Progress Telerik

[Bruce]

Thank you for the answer BUT I was asking specifically how to do this after the spreadsheet has rendered i.e. the render event. Now I'm using a button because I get a stack overflow error after binding an MVC model against the spreadsheet.

Another question in the same vein is how to add formulas to a model bound spreadsheet and then add headings to them. When I do this via code it corrupts my model (please see attached example)

[Dimitar]

Hello Bruce,

I am attaching and ASP.NET MVC solution, where a similar scenario to the one described is demonstrated (Disabling column cells and adding formula after the initialization of the Spreadsheet).

Indeed you are correct that the render event is not suitable to be used in this case. In order to set disabled cells and add custom formulas after the Spreadsheet is completely rendered and the data is loaded, the DataSource's requestEnd event can be used:

<script>
function onRequestEnd (e) {
if (e.type === "read") {
setTimeout(function () {
var spreadsheet = $("#spreadsheet").data("kendoSpreadsheet");
var sheet = spreadsheet.activeSheet();

var data = sheet.toJSON();
var totalRowsCount = data.rows.length;

var range = sheet.range("A1");
range.value("Employee Name");

var rowsCount = spreadsheet.options.rows;
sheet.range("A1:A1" + rowsCount).enable(false);

var range = sheet.range("F1");
range.value("Total Year");

var range = sheet.range("F2:F" + totalRowsCount);
range.formula("SUM(B2:E2");
}, 0);
}
}
</script>

You will notice that the entire coolumn cells that contain value can be disabled by using the following approach:

var rowsCount = spreadsheet.options.rows;
sheet.range("A1:A1" + rowsCount).enable(false);

Concerning the model changes, it is expected that when changing the model data (e.g field title), that the dirty flag of the model will be set to true. Can you elaborate a bit more on what are your concerns regarding this behavior in the specific use case?

Regards,
Dimitar
Progress Telerik