We are using Version 8.1.20081.2013 CLR 2 with asp.net. We have a UltraWebGrid that has the first column (a primary key) as a URL/Hyperlink:
protected void uwg_InitializeRow(object sender, RowEventArgs e) { UltraGridCell refNbr = e.Row.Cells.FromKey("PrimaryKey"); refNbr.Column.Type = ColumnType.HyperLink; refNbr.TargetURL = string.Format("@{0}/FormX.aspx?PrimaryKey={1}", Request.ApplicationPath.TrimEnd('/'), refNbr.Value); refNbr.AllowEditing = AllowEditing.No; }
The hyperlink displays and works correclty in the grid. But when exporting to Excel via UltraWebGridExcelExporter, the hyperlink column does not work as a hyperlink...it is simply underlined and colored blue...but it is not a hyperlink.
Is there a way for a hyperlink column in an UltraWebGrid to be exported as an Excel formatted hyperlink when using the UltraWebGridExcelExporter?
Thanks!
Hi,
I am having the same problem. Did you get any solution for this? Please share with me.
Thanks
Saravanan
Hyperlink style cells are not currently supported by the Excel library, so the grid exporters cannot export hyperlinks. However, you can manually convert the cell value to a hyperlink after the cell has been exported by applying a formula like this: =HYPERLINK(<hyperlink>). You can do this with the ApplyFormula method on the WorksheetCell instance.