SetPrintArea doesn't set the print area in Excel

Jan 19, 2010 at 8:59 AM
Edited Jan 19, 2010 at 9:00 AM

We are trying to use SetPrintArea, but it doesn't work in Excel.

Examples:

 workbook.SetPrintArea(0, "$A$1:$F$8");

 workbook.SetPrintArea(0, 0, 3, 0, 5);

When we open the Excel file, no print area is set.

Is this is a bug or are we missing to set something else?

Environment: NPOI 1.2.2, .NET 2.0, Excel 2003

Oct 26, 2010 at 11:10 AM

See issue tracker, http://npoi.codeplex.com/workitem/7488