Thanks for you reply:
I am doing the following:
I have a web page where the user can input some text, the user can format font type, color, size etc.
for instance the following text
this is only a comment text
generates:
this is only a comment text
which is what I store on the DB. Then I can use this info to export to a Excel file. programatically I got a function that populate my required fields on the Excel cells:
private void AddFastPlay(Aspose.Cells.Workbook workbook, string title, string productionId)
{
int fastPlayId = workbook.Worksheets.Add( Aspose.Cells.SheetType.Worksheet );
workbook.Worksheets[fastPlayId].Name = "FastPlay";
Worksheet sheet = workbook.Worksheets[ fastPlayId ];
DataRow dsFastPlay = GetFastPlay( productionId ); // retrieves info from DB
sheet.Cells[0,0].PutValue(title + "-Fastplay"); // sets page title
mergeHeading(sheet, 0, 0, 17); // merge title cells
setCellFormatsHeader(sheet.Cells[1, 0]);// formats header
sheet.Cells[1, 0].PutValue("Lock date: ");// set header text
sheet.Cells[1,1].PutValue( dsFastPlay["lockDate"]);// set header text
sheet.Cells[1,1].Style.Custom = "m/d/yyy"; // format date cell
sheet.Cells.StandardWidth = 10;
mergeCell( sheet, 1, 1, 16, Color.FromArgb(211, 211, 211));
sheet.Cells[2,0].PutValue( Tools.UnScape(dsFastPlay["data"].ToString())); // here is where the problem arises, it shows all formatting tags, instead of formatting the text
mergeCell(sheet, 2, 0, 17, Color.White);
}
So the question is, is there anything I can do to show the formatted on my Excel export??