Hello:

I need to copy a formula from one cell to 11 more columns to the right. I want the references in the formula to be updated just like they are in Excel when you copy one cell to many.

When I try this test code:

cells[row, 3].Formula = ("=Sum(D7:D8)");

cells[row, 4].Formula = cells[row, 3].Formula;

cells[row, 5].Formula = cells[row, 3].Formula;

cells[row, 6].Formula = cells[row, 3].Formula;

However, I get the same formula in each column.

So, can you please tell me the easiest way to copy the formula to multiple columns. (Do I have to manually calculate the range for each cell, or will Aspose create the relative references.)

Thanks,

Mark