List Object with Inconsistent formula

Question

Hi,

In my data base i have data data like this.

Column1 Colum2

10            =Sum(Column1 ) + 10

20

30

I have followed the following steps.

1. Retrieve Data into Data Table.

2.Bind above data to list object.

3.After binding list object shows the values in excel sheet like

Column1 Colum2

10            20

20 20

30 20

Here is my question .. why Excel auto fills data in remaining cells for column 2 ?

Even i have turn off auto fill formula setting in Excel.

Same is not the case when u have first cell empty.

Any help is appreciated.

---

K K Sanghi

Answer 1

Hi Krishna,
 
Sorry for that I probably cannot contribute any helpful information. But I'm wondering what's the formula look like in your spreadsheet, cause when I put =SUM(COLUMN(A:A))+10 in B1 I can only get 11.

Regards,
Fermin

Answer 2

Hi Krishna

I've changed the message type to "question" so that it goes into the list of unanswered posts. That will put it back on the radar, as well as my replying to "bump" it. But I have a question for you:

Is this a VSTO list object, or just a "plain" Excel list object? If it's not VSTO-specific behavior you might have a better chance getting help in the Excel for Developers forum. I can move the question there, if you wish - please reply :-)

---

Cindy Meister, VSTO/Word MVP

Answer 3

Hi Cindy,

Sorry for the late reply.. it's a VSTO List object that i am using.

Let me know if you require additional information.

---

K K Sanghi