=HYPERLINK formula in spreadsheet

6 posts, 0 answers
  1. Dhruven
    Dhruven avatar
    19 posts
    Member since:
    Jun 2019

    Posted 08 Jul Link to this post

    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.

  2. Stefan
    Admin
    Stefan avatar
    2960 posts

    Posted 09 Jul Link to this post

    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.
  3. Dhruven
    Dhruven avatar
    19 posts
    Member since:
    Jun 2019

    Posted 10 Jul in reply to Stefan Link to this post

    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?

  4. Stefan
    Admin
    Stefan avatar
    2960 posts

    Posted 13 Jul Link to this post

    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

  5. Dhruven
    Dhruven avatar
    19 posts
    Member since:
    Jun 2019

    Posted 13 Jul in reply to Stefan Link to this post

    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. 

     

  6. Stefan
    Admin
    Stefan avatar
    2960 posts

    Posted 14 Jul Link to this post

    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

Back to Top