How to interpret HTML tags in a cell

Posted by: mbaker on 17 May 2018, 10:41 pm EST

  • Posted 17 May 2018, 10:41 pm EST

    Hello, is there a way to set the text of the cell as html rather than a default string? I have a result set coming back that is marked up in html to post to the cell but the cell is displaying the literal html tags. The html is actually just hyperlink tags, <a href="path to site>Text value</a>. However I can have multiple hrefs coming back from the query so a cell type of hyperlink is not the way I want to go. Also I understand there is a way to map a link to the page based on where it sits on the page but b\c this result set is dynamic and the links are dynamic I don't think this will work.

    What's interesting is when I double click the cell, it formats the way I want it and however the page locks up and I can't click anywhere to have the control fire. So I'm pretty sure the control can do this but I'm missing something. Any suggestions ?

    Thanks in advance!
  • Marked as Answer

    Replied 18 May 2018, 5:19 am EST

    Hello,

    To write HTML code in a cell you need to set 'EncodeValue' property to true. For example :

    FpSpread1.Sheets[0].Cells[1, 1].EncodeValue = false;
    FpSpread1.Sheets[0].Cells[1, 1].Value = "Hello<B>World</B>";

    Or you can set this property for the whole spread:

    FpSpread1.EncodeValue=False


    Thanks,
    Deepak Sharma
Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels