Hello,
I have an excel table and one of the columns contains reference to a file on the computer file system. I have to link the cell value to that file, so when you click the cell the file opens.
I know that to do this i have to use the APPLYFORMULA in this way
xFoglio.Rows(rownumber).Cells(columnnumber).ApplyFormula("=HYPERLINK("C:\MyFile.txt";"MyFile.txt")")
It works, but there is only one problem: the value of the cell is "MyFile.txt" but it is not showed as an hyperlink (I mean, it is not underlined and not in blue color), it appears as normal text. To obtain the hyperlink you have to select the cell and press enter.
So the cell actually behaves like an hyperlink (if you click the cell the file is opened) but it is not showed as an hyperlink
Claudio Di Flumeri
Hello ,
I have created a small sample where I have a UltraWinGrid with one URL column and when you click ultraButton1, application export the grid to Excel. When open the exported Excel,
You will see that the cell, which contain URL, is underling like link and behave as link. For the sample I was using Infragistics 11.1, and the exported excel is *.xlsx format. Please run the sample and let me know if this is what you are looking for.
Please let me know if you have any further questions or I am missing something.