For Each worksheet As Worksheet In officeDocument.Worksheets
For Each hpl As Aspose.Cells.Hyperlink In worksheet.Hyperlinks
Try
TextToDisplay = hpl.TextToDisplay
Catch ex As Exception
TextToDisplay = “n.a”
End Try
TextToDisplay shows still PDF Contract.
I attached original document (original.xls) and updated document (Output.xls) plus I attached screenshots.
Unfortunately I do not have project as this development is part of big project but coding is simple.
Search for word contract in cells and replace it with ASPOSE. Loop through hyperlinks collection and check TextToDisplay which is wrong. If you check in Excel over Edit Hyperlink you’ll see that TextToDisplay is correct.
Can you please investigate?
Thanks,
Oliver