FarPoint.Web.Spread Assembly > FarPoint.Web.Spread Namespace > Column Class : EncodeValue Property |
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.
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 here<BR>to anew 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 here<BR>to anew line"
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