How to interpret HTML tags in a cell

How to interpret HTML tags in a cell

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

• 

  mbaker

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 17 May 2018, 1: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. 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!

• 

  deepak.sharma

  

  • Post Options:
  • Link
    Copy

  Posted 17 May 2018, 8:19 pm 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 = “HelloWorld”;

  Or you can set this property for the whole spread:

  FpSpread1.EncodeValue=False

  Thanks,
  
  Deepak Sharma