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
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