datasource with formula

[Travis]

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 });

[Dimitar]

Hello Travis,

My colleague has supplied an answer in your second thread on the same topic. I would suggest continuing our communication there in order to prevent thread duplication.
 
Regards,
Dimitar
Progress Telerik