I have a chunk of code that I am using to copy a range of cells from one location to another:
templateWorksheet.Cells["A" + templateRow + ":X" + (templateRow + 4)].Copy(new ExcelRangeBase(templateWorksheet, "A" + (templateRow + 4) + ":X" + (templateRow + 8)));
My issue is that when these cells copy they copy the absolute formula rather than the relative one. For example if I have a row that has the formula
And I copy that to the next line it does not change to:
If I open the excel spread sheet and do the copy manually the rows adjust as they should. Is there anyway to have formulas copy this way?