c# 4.0 - Error when put multiply formula into the cells in the table Excel -

c# 4.0 - Error when put multiply formula into the cells in the table Excel -

i working on excel add-in project now. tried set formulas bunch of cells in excel. works when these cells not include in table of worksheet. after formed table @ first, tried assign these formula store in 2d array range. raised bug cells in each column have same formula first 1 cell in column. in fact, formulas in array not different. suppose there has different when people want assign formula cells in or not in table. can not find reference it. way avoid situation seek assign formula cells before form table. have confusion bug.

i found if want go on utilize previous method, need add together appplication.autocorrect.autofillformulasinlists = false loop. not want. switch method using 1 feature of table.for 1 cell, want give formula includes other cells in same line range calculate something, improve if utilize table[[#this row],[columnname]].

excel c#-4.0