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.)