Problem with Print_Titles when saving to SpreadsheetML

Aspose.Cells Product Family
1

Hi,



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?



-Steve



var workbook = new Workbook();

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

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

2

Hi,

Thanks for providing us the template files.

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

Thank you.

3

Hi,

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

Thank you.

4

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.