EncodeValue Property (Cell)

Visual Basic
C#

'Declaration
 
Public Property EncodeValue As Boolean

'Usage
 
Dim instance As Cell
Dim value As Boolean
 
instance.EncodeValue = value
 
value = instance.EncodeValue

public bool EncodeValue {get; set;}

To write HTML tags in the cells, you would need to set this property to false. If you set this property to false, then you can embed HTML tags in the cell, for example to make part of the text bold by adding <B> and </B> tags. This applies to cells in the headers as well as cells in the data area.

This example sets the EncodeValue property.

C#

FpSpread1.Sheets[0].RowCount = 4;
FpSpread1.Sheets[0].Cells[1, 1].EncodeValue = false;
FpSpread1.Sheets[0].Cells[1, 1].Value = "Hello<B>World</B>";
FpSpread1.Sheets[0].Rows[2].EncodeValue = false;
FpSpread1.Sheets[0].Cells[2, 1].Value = "<a href='http://www.gcpowertools.com'>www.gcpowertools.com</a>";
FpSpread1.Sheets[0].Columns[2].EncodeValue = false;
FpSpread1.Sheets[0].Cells[3, 2].Value = "Break&nbsp;here<BR>to&nbsp;anew&nbsp;line";

VB.NET

FpSpread1.Sheets(0).RowCount = 4
FpSpread1.Sheets(0).Cells(1, 1).EncodeValue = False
FpSpread1.Sheets(0).Cells(1, 1).Value = "Hello<B>World</B>"
FpSpread1.Sheets(0).Rows(2).EncodeValue = False
FpSpread1.Sheets(0).Cells(2, 1).Value = "<a href='http://www.gcpowertools.com'>www.gcpowertools.com</a>"
FpSpread1.Sheets(0).Columns(2).EncodeValue = False
FpSpread1.Sheets(0).Cells(3, 2).Value = "Break&nbsp;here<BR>to&nbsp;anew&nbsp;line"

Reference

Cell Class
Cell Members