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.
5 Answers, 1 is accepted
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")
Our thoughts here at Progress are with those affected by the outbreak.
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?
I added the formula to the cell using the formula field and it was shown as expected on my end.
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.
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:
Apologies for misleading you that the HYPERLINK formula is working with mailto functionality.