Error Saving SpreadsheetML when a PRINT_AREA exists

Aspose.Cells Product Family
1

Hi,

I have two XLS files here:

Blank1.xls: An empty spreadsheet
Blank2.xls: An empty spreadsheet with a print area set

When I run the following:

var workbook = new Workbook();
workbook.Open("C:\\Blank1.xls", FileFormatType.Default);
workbook.Save("C:\\Blank1.xml", FileFormatType.SpreadsheetML);

workbook.Open("C:\\Blank2.xls", FileFormatType.Default);
workbook.Save("C:\\Blank2.xml", FileFormatType.SpreadsheetML);

I can open up Blank1.xml with OWC (Office Web Component) without any problem. But when I open up Blank2.xml, an error pops up stating that the named range "PRINT_TITLES" already exists.

Opening the Blank2.xml, I've noticed a problem at line 246:






The named range "PRINT_TITLES" was defined twice in the XML created by Aspose.

Can this be fixed so that we can convert spreadsheets with print areas to spreadsheetML?

Thanks,
-Steve

2

Hi Steve,

Thank you for sharing the details.

After testing your issue by creating some test template files (as per the details provided by you). We have found your mentioned issue. We will fix it and get back to you soon.

Thank You & Best Regards,

3

Hi,

Please try the attached version, we have fixed your issue.

Thank you.

4

The issues you have found earlier (filed as 8118) have been fixed in this update.

This message was posted using Notification2Forum from Downloads module by Amjad Sahi.