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

Formula value change doesn't reflect in bound datasource.

1 Answer 63 Views
Spreadsheet
This is a migrated thread and some comments may be shown as answers.
Anna
Top achievements
Rank 1
Anna asked on 03 Oct 2017, 10:57 PM
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

1 Answer, 1 is accepted

Sort by
0
Bozhidar
Telerik team
answered on 05 Oct 2017, 11:29 AM
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.
Tags
Spreadsheet
Asked by
Anna
Top achievements
Rank 1
Answers by
Bozhidar
Telerik team
Share this question
or