Error when using .Formula


#1

When I try the following

cells[11,3].Formula = “=average(offset(K3,0,-2,1,-1*3))”;

it throws an error about an invalid formula. However, this works with automation and if you just paste the formula into the cell.
I am I doing something wrong?


#2

Hi, thanks for your consideration.

Please see the api document of Cell.Formula. Currently Aspose.Excel does not support “offset” function.

Now if you need this formula, you can set it directly in your designer file.