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

Free Support Forum - aspose.com

Issue with hyperlink from Excel Workbook .xlsx file to external excel file (aspose-cells-8.0.2.jar)

Hi ,

I am using aspose cells for java version aspose-cells-8.0.2.jar

Hyperlink to sheet1 in external file (Book1.xlsx) from XLSOldFormatFile.xls (older format) work without any issue with aspose api call.

Hyperlink to sheet1 in external file (Book1.xlsx) from XLSXNewFormatWorkbook.xlsx (new workbook format) does not work. attached is the output file.

Note: Using the fully qualified path in hyperlink address works but that option would not work for us. Is there any other alternate way to link external worksheet cell without using absolutefile path in hyperlink address?

Following is my test code. and attached are generated out put files for both test case

public class CostVolume633LinkTest {

public static void main(String[] args) throws Exception{

//Test case # 1 Instantiating a Workbook object -- for older (Excel 97-2003) file format

Workbook xlsFile = new Workbook();

//Obtaining the reference of the first worksheet.

WorksheetCollection xlsSheets = xlsFile.getWorksheets();

Worksheet xlsSheet = xlsSheets.get(0);

HyperlinkCollection xlsHyperLink = xlsSheet.getHyperlinks();

//Adding a link to the external file

xlsHyperLink.add("A5", 1, 1, "Book1.xlsx#sheet1!A1");

//Saving the Excel file

xlsFile.save("C:\\asposeTest\\XLSOldFormatFile.xls");

System.out.println("Excel 2003 format file hyperlink address "+xlsFile.getWorksheets().get(0).getHyperlinks().get(0).getAddress());

////Test case # 2 Instantiating a Workbook object -- for new file format(excel workbook )

Workbook xlsxFile = new Workbook();

//Obtaining the reference of the first worksheet.

WorksheetCollection xlsxSheets = xlsxFile.getWorksheets();

Worksheet xlsxSheet = xlsxSheets.get(0);

HyperlinkCollection xlsxHyperLink = xlsxSheet.getHyperlinks();

//Adding a link to the external file

xlsxHyperLink.add("A5", 1, 1, "Book1.xlsx#sheet1!A1");

//Saving the Excel file

xlsxFile.save("C:\\asposeTest\\XLSXNewFormatWorkbook.xlsx");

System.out.println("Excel 2003 format file hyperlink address "+xlsxFile.getWorksheets().get(0).getHyperlinks().get(0).getAddress());

}

}

Thanks,

I tested with latest aspose-cells-8.2.1.jar and same results as before- hyper link does not work as before.

Thanks,

Hi Rita,


Thank you for contacting Aspose support.

We have evaluated your presented scenario on our end while using the latest version of Aspose.Cells for Java 8.2.1, and we are able to observe the problem of invalid reference when resultant spreadsheet is saved in XLSX format. We have logged the problem in our bug tracking system under the ticket CELLSJAVA-41010 for further investigation purposes. Please spare us little time to properly analyze the problem cause, and to provide a fix (if applicable). In the meanwhile, we will keep you posted with updates in this regard.

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

Thank you taking a look at the issue. As this is critical fix for our next release. It would be helpful if you provide timeline for the fix.

Appreciate your assistance.

Thanks,

Rita

Hi Rita,

Thanks for your posting and using Aspose.Cells for Java.

We have checked your issue status from database and found this issue is resolved now. Hopefully, we will provide you a fix in next few days. Once, this is available for you, we will let you know asap by posting in this thread.

Hi Shakeel,

Thank you for your quick response. We will wait and check on this thread for the fix.

Thanks again!

Rita

Hi Rita,

Sure, we will keep you updated. Also, you will get email notification in your inbox once we will post on this thread. So, you do not need to check this thread again and again. You can only check it at the time when you receive the email notification in your inbox.

Hi,

Thanks for using Aspose.Cells for Java.

Please download and try this fix:

Aspose.Cells for

Java v8.2.1.1 and let us know your feedback.

Hello Shakeel,

Thank you for quick response to fix the issue. Hyperlink to external document works as expected with this patch version. And now wondering when would it roll into regular version?

Thanks again,

Rita

Hi Rita,

Thanks for your feedback and using Aspose.Cells.

It is good to know that your issue is resolved with the latest fix. Let us know if you encounter any other issue, we will be glad to look into it and help you further.

This is a minor release and you can use it for your production use without any concern. The regular major release will hopefully be published near the 10th of October 2014.

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


This message was posted using Notification2Forum from Downloads module by Aspose Notifier.