Spread ASP.NET 14
FarPoint.Web.Spread Assembly / FarPoint.Web.Spread Namespace / Row Class / EncodeValue Property

In This Topic
    EncodeValue Property (Row)
    In This Topic
    Gets or sets the encode value setting for a row.
    Public Property EncodeValue As Boolean
    Dim instance As Row
    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.
    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";
    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"
    See Also