The code to reproduce the issue is:
- Code: Select all
Workbook wb = new Workbook();
wb.CreateEmptySheets(1);
Worksheet ws = wb.Worksheets[0];
ws.Range[3,2].NumberValue = 10;
ws.Range[1, 2].NumberValue = 30;
ws.PageSetup.PrintArea = ws.Range[1, 2, 2, 3].RangeAddressLocal;
wb.SaveToFile(@"c:\printarea.xls",ExcelVersion.Version97to2003);
This works fine and excel prints only "30". But if I replace last line with:
- Code: Select all
wb.SaveToFile(@"c:\printarea.xlsx",ExcelVersion.Version2007);
Excel prints both "10" and "30" which is incorrect because it's out of print region.
I'm using version 6.0.7 (hotfix), Visual Studio 2008 Sp1, .NET Framework 3.5 SP1 and Excel 2007.
I really hope this time you'll be able to reproduce the issue with the provided code because this problem is the only thing keeping me from buying your tool.
Thanks in advance.