Hyperlink not working when Exported to Excel

Gregory

I'm using the hyperlink on a Textbox (not a HTMLTextbox but rather a plain Textbox). I did this via the Action property and selecting Navigate to URL with Link Selected set to NewWindow. The target URL is set to the following expression:

= Parameters.URLPrefix.Value + CStr(Fields.SERVICEREQUESTIDNUM)

It works great in the Report Viewer and when I export it as a PDF, but not in Excel. How do I fix this? Is this an Excel setting that is preventing me from hyperlinking. Thanks.

Chavdar

Currently Telerik Reporting supports two Excel formats: Microsoft Excel 97-2003 (BIFF, v.8) and Microsoft Excel 2007 and above (OpenXML 2.0). One of the differences between them is the hyperlink support. Please, make sure you are exporting to Excel 2007 in order to have working hyperlinks. More information about the Excel rendering extensions you can find in the Design Considerations for Excel Rendering help article.

Kind regards,
Chavdar
the Telerik team

Do you want to have your say when we set our development plans?
Do you want to know when a feature you care about is added or when a bug fixed?
Explore the
Telerik Public Issue Tracking
system and vote to affect the priority of the items

To avoid the installation of the Open XML SDK you can reference the required assembly from C:\Program Files (x86)\Telerik\Reporting Q1 2011\Examples\bin folder. Note that they require .NET Framework 3.5 SP1 to be installed first.

Hope this helps.

Regards,
Chavdar
the Telerik team

Do you want to have your say when we set our development plans?
Do you want to know when a feature you care about is added or when a bug fixed?
Explore the
Telerik Public Issue Tracking
system and vote to affect the priority of the items

Gregory

Once I added both the Telerik.Reporting.OpenXmlRendering.dll and DocumentFormat.OpenXml.dll to the references, the web viewer (I using the webform version) started showing the extra export options. Interesting that the OpenXML options just say Word Document, Excel Worksheet, and Powerpoint Presentation and do not say "2007" anywhere. That works for me (I probably a good thing not to go that specific). The hyperlinks now work! Thanks for you help!

Chavdar

You are correct. The official name of the rendering extension is Excel Worksheet. Open XML file formats were introduced with Office 2007 so you may refer to it also as Excel 2007.

Best wishes,
Chavdar
the Telerik team

Do you want to have your say when we set our development plans?
Do you want to know when a feature you care about is added or when a bug fixed?
Explore the
Telerik Public Issue Tracking
system and vote to affect the priority of the items

Sam

This is an old post but I'm hoping someone can help me. I am trying to export my report to an Excel file and I've installed the OpenXML 2.0 to get the extra options as noted above. However my links still won't export. I've tried the Excel Worksheet as well as the Excel 97-2003 options and neither works. It exports fine to PDF and Word but just not Excel. I am setting the hyperlink via the value field for an HTML text box. I've also tried setting the Navigate To Url property and that doesn't work either. Any help would be appreciated.

Stef

In XLS files interactivity is not supported. In XLSX files you can have clickable links opening content in the machine's default browser. Note that the HtmlTextBox content is rendered without any formatting in Excel - Design Considerations for Excel Rendering.
Using a NavigateToUrlAction on a TextBox item works as expected, test with Telerik Reporting Q1 2016 SP1.

Do you want to have your say when we set our development plans?
Do you want to know when a feature you care about is added or when a bug fixed?
Explore the
Telerik Feedback Portal
and vote to affect the priority of the items

Progress, Telerik, and certain product names used herein are trademarks or registered trademarks of Progress Software Corporation and/or one of its subsidiaries or affiliates in the U.S. and/or other countries. See Trademarks or appropriate markings.