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

Free Support Forum - aspose.com

Converting an XLS file to XLSM is deleting few chars at last in the link in named ranges

Hi,
I am trying to convert the attached XLS file to XLSM where the output file is trimming the link path.
i.e. the output xlsm file is having the partial path in the link.
In the template file the link is in named ranges.
Please do the needful.

LinkInNameRangeIsHavingPartialPath.zip (80.1 KB)

@vedavyas.velaga,

Thanks for the template file and details.

Could you please provide details where (in which source XML file or data file) we have to locate the difference? Alternatively, if the issue can be seen for the named ranges in MS Excel, kindly do provide details and screenshots to highlight which chars or part of the link Aspose.Cells is removing in the output XLSM file. This will help us to evaluate your issue precisely and we could log appropriate ticket(s) for the issue.

To view the difference in Excel file,
Open the file > Go to Named ranges > select the “NR_Test” named range (only this NR is present in the file.) > In the Refers To section we can see the link.

To view the differences in XML file,
As the original file is XLS, we can’t see it directly, so we can convert the file to XLSM using MS Excel and then can see the content in file “\xl\externalLinks_rels\externalLink1.xml.rels”
In same path we can see the link in the Aspose converted file as well, where we can see the difference.

Attached the screenshots below. for both.
ScreenShots.zip (188.3 KB)

@vedavyas.velaga,

Thanks for the screenshots and details.

Please notice, I am able to reproduce the issue as you mentioned (via screenshots) by using your template file. I found when converting the XLS file to XLSM is deleting few chars at the end in the link of the named ranges:
e.g.
Sample code:

Workbook workbook = new Workbook("e:\\test2\\LinkInNameRangeIsHavingPartialPath.xls");            
workbook.Save("e:\\test2\\out1.xlsm");

I have logged a ticket with an id “CELLSNET-51778” for your issue. We will look into it soon.

Once we have an update on it, we will let you know.

The issues you have found earlier (filed as CELLSNET-51778) have been fixed in this update. This message was posted using Bugs notification tool by johnson.shi