Spread for ASP.NET 7.0 Product Documentation
EncodeValue Property
See Also  Example Support Options
FarPoint.Web.Spread Assembly > FarPoint.Web.Spread Namespace > Cell Class : EncodeValue Property


Glossary Item Box

Gets or sets the encode value for a cell.

Syntax

Visual Basic (Declaration) 
Public Property EncodeValue As Boolean
Visual Basic (Usage)Copy Code
Dim instance As Cell
Dim value As Boolean
 
instance.EncodeValue = value
 
value = instance.EncodeValue
C# 
public bool EncodeValue {get; set;}

Remarks

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.

Example

This example sets the EncodeValue property.
C#Copy Code
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.NETCopy Code
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"

Requirements

Target Platforms: Windows 7, Windows 8, Windows Vista, Windows Server 2000, Windows 2000 Professional, Windows XP Professional, Windows NT 4.0 Workstation, SP6, Windows NT 4.0 Server, SP6

See Also

© 2002-2014 ComponentOne, a division of GrapeCity. All Rights Reserved.