This is a migrated thread and some comments may be shown as answers.

Hyperlink not working when Exported to Excel

9 Answers 604 Views
General Discussions
This is a migrated thread and some comments may be shown as answers.
Gregory
Top achievements
Rank 1
Gregory asked on 18 May 2011, 11:42 PM
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.

9 Answers, 1 is accepted

Sort by
0
Chavdar
Telerik team
answered on 23 May 2011, 05:29 PM
Hello Gregory,

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
0
Gregory
Top achievements
Rank 1
answered on 23 May 2011, 11:39 PM
The only export options I have are:

Acrobat
CSV
Excel 97-2003
Rich Text Format
TIFF
Web Archive
XPS

I running Telerik reporting Q1.
0
Chavdar
Telerik team
answered on 24 May 2011, 08:58 AM
Hi Gregory,

It seems like the new Open XML rendering extensions (Word, PowerPoint, Excel 2007) are missing from the export options. To enable them you have to reference
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
0
Gregory
Top achievements
Rank 1
answered on 24 May 2011, 03:17 PM
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!
0
Chavdar
Telerik team
answered on 24 May 2011, 03:48 PM
Hello Gregory,

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
0
Sam
Top achievements
Rank 1
answered on 15 Mar 2016, 01:12 AM

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. 

 

0
Stef
Telerik team
answered on 16 Mar 2016, 05:52 PM
Hello Sam,

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.

To generate an XLSX file, in the start project you need to have references to Telerik.Reporting.OpenXmlRendering.dll and Open XML SDK 2.0 for Microsoft Office(DocumentFormat.OpenXml.dll v.2.0.5022.0 or above with proper binding redirect).


Let us know if you have any further questions.

Regards,
Stef
Telerik
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
0
Sam
Top achievements
Rank 1
answered on 16 Mar 2016, 05:54 PM
Thanks Stef for the reply. I'm using TextBox instead. 
0
Keira
Top achievements
Rank 1
answered on 04 Apr 2018, 05:55 AM

To fix the issue try to recreate the Hyperlinks again.
Solution:
Try recreating the Hyperlinks again to target renamed worksheet.
Make use of the correct address presented in current worksheet.

Or else try this

Open Excel Workbook > File > Options >Advanced
Locate the General tab > click Web Options
Now Web options Windows appears > click Files > Uncheck box for “Update Links on save”
And click OK button to save the option.

source: http://www.repairmsexcel.com/blog/troubleshoot-excel-hyperlinks-not-working

Tags
General Discussions
Asked by
Gregory
Top achievements
Rank 1
Answers by
Chavdar
Telerik team
Gregory
Top achievements
Rank 1
Sam
Top achievements
Rank 1
Stef
Telerik team
Keira
Top achievements
Rank 1
Share this question
or