Sorry for the bad code but this is the only way I can simulate this problem at the moment.
I am sure there is a more straigt forward way of showing this but this example does show the problem.
After my .CopyRow command, I am saving the workbook by creating another instance first and copying the existing workbook.
The file that is saved has a forumla problem.
The formula in cell "A18" should be reading:
=CONCATENATE("MA: ",M17," ",N17," Tier:",Q17)
Instead, it is reading the orginal row numbers like this:
=CONCATENATE("MA: ",M9," ",N9," Tier:",Q9)
Here is a code sample and attached is an excel file I am using as a template.
I am using version 126.96.36.199.
This worked correctly in version 188.8.131.52
Workbook excelWorkbook0 = new Workbook();
Workbook excelWorkbook2 = new Workbook();
int intWS = excelWorkbook2.Worksheets.Add();
Worksheet ws2 = excelWorkbook2.Worksheets[intWS];
Workbook excelWorkbook1 = new Workbook();
Worksheet ws1 = excelWorkbook1.Worksheets;
ws2.Cells.CopyRow(ws1.Cells, 9, 17);
Workbook excelWorkbook3 = new Workbook();