datasource with formula

2 posts, 0 answers
  1. Travis
    Travis avatar
    14 posts
    Member since:
    Jul 2014

    Posted 11 Feb 2019 Link to this post

    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 });
  2. Dimitar
    Admin
    Dimitar avatar
    796 posts

    Posted 13 Feb 2019 Link to this post

    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.
Back to Top