I am loading the attached workbook into a GridDesktop component (Aspose.Cells.GridDesktop 22.214.171.1240) that contains hyperlinks. When accessing the Cells collection of the Worksheet, the Value property returns the hyperlink. When accessing the Hyperlinks collection of the worksheet using the cell reference, the returned Hyperlink object only has a single property, URL. I notice that in the Aspose.Cells namespace (which is completly different to the Aspose.Cells.GridDesktop namespace for some reason), the Hyperlink class has a property called TextToDisplay. This is not available in the Aspose.Cells.GridDesktop namespace.
I have noticed that if I create a workbook with a Hyperlink, it is being read fine. The issue arises in the attached workbook, cell F5, which does not appear to be returning the correct Cell.Value even though when opened in Excel it displays correctly.