This is a migrated thread and some comments may be shown as answers.
datasource with formula
1 Answer 15 Views
This is a migrated thread and some comments may be shown as answers.
Travis
Top achievements
Rank 1
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

Sort by
0
Dimitar
Telerik team
answered on 13 Feb 2019, 01:06 PM
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
Get quickly onboard and successful with your Telerik and/or Kendo UI products with the Virtual Classroom free technical training, available to all active customers. Learn More.
Asked by
Travis
Top achievements
Rank 1
Answers by
Dimitar
Telerik team
Share this question
or