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

Free Support Forum - aspose.com

Saving Workbook as SpreadsheetML shifts Single Cell Named Ranges over 1 column to the left

I have a spreadsheet that contains 1 named range in cell B2 called MyNamedRange. When I save the Workbook in SpreadsheetML format, the named range has moved to A2.

When I look at the contents of the SpreadsheetML file i see the following...



I have attached an xls file and the resulting xml (SpreadsheetML) file for reference.

Please let me know if you have any questions.

Thanks

Harry

Hi Harry,<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" />

Thank you for considering Aspose.

After an initial test, we have found the issue you have mentioned. We will fix it and get back to you soon.

Thank You & Best Regards,

Hi Harry,<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" />

Thank you for considering Aspose.

Please try the attached latest fix. We have fixed the issue regarding the Named Ranges in SpreadSheetML.

Thank You & Best Regards,

Thank-You.

The fix works.

Harry

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


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