This project has moved. For the latest updates, please go here.

Copying between sheets.

May 19, 2011 at 9:38 PM

The following executes fine:

ExcelNamedRange template = book.Names["Template";

//ExcelRangeBase cursor = sheet.Cells[1, 1];
ExcelRangeBase cursor = template.Offset(0, 10);

template.Copy(cursor);
However, the following clears the content and format of the template:

ExcelNamedRange template = book.Names["Template"];

ExcelRangeBase cursor = sheet.Cells[1, 1];
//ExcelRangeBase cursor = template.Offset(0, 10);

template.Copy(cursor);

Note that "sheet" is a different worksheet from where "template" is on.

I am clueless as how this occurs, but it looks like a bug to me.
Is there a work-around?

Coordinator
May 26, 2011 at 5:53 PM

Yes, it's a bug. It should be fixed in the latest source.

May 26, 2011 at 6:09 PM

Thanks! EPPlus is my favorite C# library out there.