datasource with formula in Kendo UI for jQuery

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

datasource with formula

1 Answer 15 Views

Spreadsheet

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

Travis asked on 12 Feb 2019, 04:04 AM

I have a spreadsheet with a remote data source, for the most part everything is working. But when I submit my changes thefields with a formula don't have the updated values, just the original values that were read in on the data source read. I set my formula in the data source request end event. The spreadsheet will show the correct values and do calcs in the formula but these values are not reflected in the data in the data source submit. Any help would be appreciated!

sheet.batch(function () {

for (var i = tempRow + 1; i < rowsCount; i++) {

sheet.range("B" + i).formula("L" + (i - 1));

sheet.range("I" + i).formula("E" + i + "+F" + i + "+G" + i + "+H" + i);

sheet.range("L" + i).formula("B" + i + "+C" + i + "+D" + i + "-I" + i + " -J" + i + " -K" + i);

}

}, { layout: true });

1 Answer, 1 is accepted