20 มิถุนายน 2555 7:11
In my data base i have data data like this.
10 =Sum(Column1 ) + 10
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
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
- เปลี่ยนแปลงประเภท Cindy Meister MVPMVP, Moderator 4 กรกฎาคม 2555 7:58 it's a question
25 มิถุนายน 2555 2:59
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.
4 กรกฎาคม 2555 8:00ผู้ดูแล
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
7 สิงหาคม 2555 4:34
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