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

Formula value change doesn't reflect in bound datasource.

1 Answer 71 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:50 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.

A1     

 

Now, I enter a formula, =SUM(A1:B1), in cell C1, on the first time I input the formula in C1, the bound datasource gets the sum value correctly. Then I change value in cell A1 from 100

1 Answer, 1 is accepted

Sort by
0
Anna
Top achievements
Rank 1
answered on 03 Oct 2017, 10:51 PM
Disregard this. I accidentally hit enter and posted.
Tags
Spreadsheet
Asked by
Anna
Top achievements
Rank 1
Answers by
Anna
Top achievements
Rank 1
Share this question
or