When copying sheets, charts lose attributes.
I am generating an Excel file by copying a template sheet a number of times. Afterwards the templates are filled with data. The copies of the sheets are generated as such:
xls.Worksheets.InsertCopy(index, "sheet" + index, ws);
However, on the ‘original’ sheet, the chart that’s on it loses its title. On the copies, the chart also loses one of its Y axes, and both its axis labels. The formatting also changes.
Does anyone know what is going on?