Comment hyperlink does not work

Aspose.Cells Product Family
1

Hi,


A feature in Excel is to add a hyperlink to the shape of a comment so that it can be accessed by the user when clicking on the comment in Show comment mode. Aspose.Cells offers a AddHyperlink method to set this but when saved and opened in Excel 2010 the setting does nothing and the comment isnt hyperlinked. Why is that?

My code:

Workbook book = new Workbook();

book.Worksheets[0].Comments.Add(0, 0);
Aspose.Cells.Comment comment = book.Worksheets[0].Comments[0, 0];

Cell cell = book.Worksheets[0].Cells[1, 1];
cell.PutValue(“cell”);

comment.Note = “Test”;
comment.CommentShape.AddHyperlink(“www.google.com”);

book.Save(“My document.xlsx”);

Thank you

2

Hi,


Thanks for your posting and using Aspose.Cells.

In order to investigate this issue, I created an excel file in Microsoft Excel 2013 and found that hyperlink inside the cell comment is not supported. I even tried to copy a hyperlink from word document into excel comment and hyperlink became text, so it seems this feature is not supported by Microsoft Excel.

If you think, Microsoft Excel can do this, then please provide us sample excel file which you can create manually using Microsoft Excel with a hyperlink inside the excel comment. We will look into it and provide you an equivalent sample code to achieve your requirement. Thanks for your cooperation in this regard and have a good day.

3

Hi,


Thank you! I have created a sample for you, find it attached
4

Hi,


Thanks for your posting and using Aspose.Cells.

I have tested your code with the latest version but cell comment hyperlink is neither getting updated nor a new hyperlink is getting added.

We have logged this issue in our database for investigation. We will look into it and fix this issue. Once the issue is resolved or we have some other update for you, we will let you know asap.

This issue has been logged as

  • CELLSNET-44743 - Adding hyperlink inside the cell comment is not working

5

Hi Will,


This is to update you that the ticket logged earlier as CELLSNET-44743 has been marked resolved. We will shortly share the fix here after ensuring the quality and incorporating other enhancements.
6

Thank you for the speedy fix

7

Hi again,


Please try the latest version of Aspose.Cells for .NET 9.0.1.0 against the problem logged earlier as CELLSNET-44743, and let us know your feedback.

8

Hi


Thank you, adding a hyperlink to a brand new comment is working now but it’s not working for all cases. A hyperlink can’t be added to an existing comment (try it, nothing will happen again) and even removing the existing comment first and then adding another comment with a hyperlink does nothing! Same with removing a comment, saving the document, loading it again and then trying to add a comment on the same cell - nothing

Please can you fix this?
9

Hi Will,


Thank you for your feedback.

I have performed a few tests and I am able to notice the said problems therefore I have raised them in our database for product team’s review. Please find the ticket details as follow.

  • CELLSNET-44758: Hyperlink cannot be added to an existing Comment
  • CELLSNET-44759: Hyperlink cannot be added to a new Comment

Please spare us little time to look further into the said problems and get back to you with updates in this regard.
10

Hi again,


This is to update that we have looked further into the details of the ticket CELLSNET-44759 and have found that the hyperlink in a new comment is working fine. Please use the following piece of code on your side and let us know your feedback.

C#

Workbook book = new Workbook();
book.Worksheets[0].Comments.Add(0, 0);
Aspose.Cells.Comment comment = book.Worksheets[0].Comments[0, 0];
Cell cell = book.Worksheets[0].Cells[1, 1];
cell.PutValue(“cell”);
comment.Note = “Test”;
comment.CommentShape.AddHyperlink(“http://www.google.com”);
comment.IsVisible = true;
book.Save(dir + “output.xlsx”);

11
Hi,

Thanks for using Aspose.Cells.

We have fixed the issues CELLSNET-44758 and CELLSNET-44759.

Please download and try the latest fix: Aspose.Cells for .NET v9.0.3.0 and let us know your feedback.

12

The issues you have found earlier (filed as CELLSNET-44759;CELLSNET-44758;CELLSNET-44743) have been fixed in this update.

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