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

=HYPERLINK formula in spreadsheet

5 Answers 55 Views
Wrappers for React
This is a migrated thread and some comments may be shown as answers.
Dhruven
Top achievements
Rank 1
Veteran
Dhruven asked on 08 Jul 2020, 06:39 PM

Hi,

I am working with kendo ui spreadsheet and I am trying attach a function to a cell, where I click on a link and it can take me to my mail client and open up the compose email window, where all the values of From, Subject, and, Body will be pulled in from other cells.

I can do this in the excel using =HYPERLINK(“mailto:” & B4 & “?subject=“& B5 & “&body=“ & B6, ”Send Email”) formula but I am not able to do the same thing into the kendo ui spreadsheet component using the same formula (Although I can see that the "HYPERLINK" formula is supported by kendo ui spreadsheet in the documentation).

Is there something that I am doing wrong or it's an actual issue? If there is a functionality available in the kendo ui spreadsheet, can you provide me an example for how I can do it through UI and through the code as well.

 

Thank you.

5 Answers, 1 is accepted

Sort by
0
Stefan
Telerik team
answered on 09 Jul 2020, 11:32 AM

Hello, Dhruven,

I can assume that there is a syntax error as when I placed the same value in Excel it also did not accept it.

Then I tried with this one and it was working on both Excel and the Kendo UI Spreadsheet:

=HYPERLINK("mailto:"&B4&"?subject=“& B5 & “&body=“ & B6,", "test")

Regards,
Stefan
Progress Telerik

Progress is here for your business, like always. Read more about the measures we are taking to ensure business continuity and help fight the COVID-19 pandemic.
Our thoughts here at Progress are with those affected by the outbreak.
0
Dhruven
Top achievements
Rank 1
Veteran
answered on 10 Jul 2020, 10:40 PM

Hi Stefan, 

Sorry for the syntax mistake but I tried your syntax but still not able to make it work. 
Can you please provide me an example?

0
Stefan
Telerik team
answered on 13 Jul 2020, 12:38 PM

Hello, Dhruven,

I added the formula to the cell using the formula field and it was shown as expected on my end.

This is an example:

https://stackblitz.com/edit/kendo-react-spreadsheet-vedwaz?file=app%2Fmain.js

Regards,
Stefan
Progress Telerik

0
Dhruven
Top achievements
Rank 1
Veteran
answered on 13 Jul 2020, 07:43 PM

HI Stefen,

Thank you so much for the example.
I don't know why it is not opening up my mail client and a compose window when I do this from the kendo UI spreadsheet but that works when I does that from the excel. Also, I am attaching a couple of screenshots about how it behaves for me on the same link that you provided.

Again, I am not sure why it is happening on my system but thank you so much fro the help. And please let me know if I am doing something wrong. 

 

0
Stefan
Telerik team
answered on 14 Jul 2020, 11:48 AM

Hello, Dhruven,

After more research, I noticed that the formula is making a standard link with `https` instead of mailto and this is why it is opening a browser window.

Then we checked it with the team and I can confirm that the HYPERLINK formula currently only works for inserting standard links to webpages. In order to support mailto it has to be enhanced with a new feature.

This is why I can suggest opening a feature request for it and then based on its popularity we will plan it accordingly:

https://feedback.telerik.com/kendo-jquery-ui?listMode=Recent&categoryId=1674

Apologies for misleading you that the HYPERLINK formula is working with mailto functionality.

Regards,
Stefan
Progress Telerik

Tags
Wrappers for React
Asked by
Dhruven
Top achievements
Rank 1
Veteran
Answers by
Stefan
Telerik team
Dhruven
Top achievements
Rank 1
Veteran
Share this question
or