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

Hyperlink in cells

4 Answers 126 Views
Spreadsheet
This is a migrated thread and some comments may be shown as answers.
Iwan
Top achievements
Rank 2
Iwan asked on 19 Jul 2018, 10:02 AM

hi,

I'm trying to figure out how to add a clickable hyperlink to a cell, currently I receive the contents from a SQL backend, check if the value contains a link and add it as a cell.Link, it currently shows them as links but they are not clickable, what pony trick am i missing? thanks for you advise. ps: this is in C#

 

if (cellValue.Contains("http://")) {
    cell.Link = cellValue;
}

 

kind regards, iwan

4 Answers, 1 is accepted

Sort by
0
Accepted
Peter Milchev
Telerik team
answered on 23 Jul 2018, 11:31 AM
Hello Iwan,

To open a new page when clicking on a cell link, you should first select the cell and then click on the link for it to work. Double-clicking would also work to open the link in a new page. Here is a screencast demonstrating the explained behavior: https://screencast-o-matic.com/watch/cFi0XUFJsf.

var cellValue = "https://www.telerik.com/";
         
var cell = new Cell() { Index = columnIndex, Value = cellValue };
if (cellValue.Contains("http://") || cellValue.Contains("https://"))
{
    cell.Link = cellValue;
}
row.AddCell(cell);

Regards,
Peter Milchev
Progress Telerik
Try our brand new, jQuery-free Angular components built from ground-up which deliver the business app essential building blocks - a grid component, data visualization (charts) and form elements.
0
Iwan
Top achievements
Rank 2
answered on 23 Jul 2018, 12:17 PM

Hi Peter, yes that is the expected behaviour i would like to see, but for some reason, it is refusing to do so, see my screencast here, with the behaviour of my spreadsheet and hyperlinks

https://screencast-o-matic.com/watch/cFi0loFJLe

0
Peter Milchev
Telerik team
answered on 05 Sep 2018, 07:30 AM
Hello Iwan,

Thank you for the further details and screencast, it helped us replicate the problem. 

This issue is caused by the fact that the filter element is over the link element and when you click the link you actually click the filter overlay. We fixed it for the R3 2018 release which is due mid-September. Meanwhile, you can use the following workaround: 

<style>
    .RadSpreadsheet .k-spreadsheet-filter {
        z-index:50;
    }
 
    .RadSpreadsheet .rssActiveCell {
        outline-color: transparent !important;
        z-index: 10;
    }
</style>

As a small token of gratitude for helping us identify the issue, we have updated your Telerik points.  

Regards,
Peter Milchev
Progress Telerik
Get quickly onboarded and successful with your Telerik and/or Kendo UI products with the Virtual Classroom free technical training, available to all active customers. Learn More.
0
Iwan
Top achievements
Rank 2
answered on 05 Sep 2018, 08:31 AM

Hi Peter,

Thank you very much for providing a work around and I'll be looking forward to the R3 2018 release.

Kind regards,

Iwan

Tags
Spreadsheet
Asked by
Iwan
Top achievements
Rank 2
Answers by
Peter Milchev
Telerik team
Iwan
Top achievements
Rank 2
Share this question
or