Formula value change doesn't reflect in bound datasource.

2 posts, 0 answers
  1. Anna
    Anna avatar
    64 posts
    Member since:
    Jul 2015

    Posted 03 Oct 2017 Link to this post

    Hi folks,

    I have a datasource bound spreasheet. When I enter a value in a cell, the change is reflected in the datasource. That's good.
    Now I have the following:
    A1: 100
    A2: 200
    A3: =SUM(A1:A2)

    On entering the formula in cell A3, the bound datasource gets the sum value 300 correctly. Then I change value in cell A1 from 100 to 150, the displayed value in cell A3 is updated to 350, but my datasource is not updated nor notified about this change. 

    So the spreasheet show:
    A1: 150
    A2: 200
    A3: 350


    But the bound datasource actual have:
    A1: 150
    A2: 200
    A3: 300

    How can I fix this?

    Thanks,

    Anna
  2. Bozhidar
    Admin
    Bozhidar avatar
    1189 posts

    Posted 05 Oct 2017 Link to this post

    Hello,

    The DataSource integration of the Spreadsheet is not designed to work natively with formulas. What you can try is to implement the approach from the following thread:
    http://www.telerik.com/forums/kendo-formula-with-remote-datasource

    Regards,
    Bozhidar
    Progress Telerik
    Try our brand new, jQuery-free Angular 2 components built from ground-up which deliver the business app essential building blocks - a grid component, data visualization (charts) and form elements.
Back to Top