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

Copying between sheets.

May 19, 2011 at 8:38 PM

The following executes fine:

ExcelNamedRange template = book.Names["Template";

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

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


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?

May 26, 2011 at 4:53 PM

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

May 26, 2011 at 5:09 PM

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