We're sorry Aspose doesn't work properply without JavaScript enabled.

Free Support Forum - aspose.com

Problem with Print_Titles when saving to SpreadsheetML


Here I have a blank XLS spreadsheet that only has its print title defined (in excel, file->page setup->sheet->rows to repeat at top). Nothing else was added to this spreadsheet.

When I save this XLS to SpreadsheetML through Aspose, I’ve noticed that two named ranges for PRINT_TITLES were created in the SpreadsheetML (see line 312 of attached XML).

This causes problems for Office Web Component (OWC) Spreadsheet controls that tries to open this SpreadsheetML because a duplicated named range was found.

Can we change the behavior of Save() for SpreadsheetML so that the PRINT_TITLES named range won’t be duplicated if it already exists in the spreadsheet?


var workbook = new Workbook();

workbook.Open(“C:\print_titles.xls”, FileFormatType.Default);

workbook.Save(“C:\print_titles.xml”, FileFormatType.SpreadsheetML);


Thanks for providing us the template files.

We found the issue as you have described, we will fix it soon.

Thank you.


Please try the attached version, we have fixed this bug.

Thank you.

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

This message was posted using Notification2Forum from Downloads module by Laurence.