Setting several different text formatting

Aspose.Cells Product Family
1

Is it possible to set several different text formatting (like bold, underline, italic, etc.) in the same cell.

2

Yes. Please check http://www.aspose.com/Products/Aspose.Excel/Api/Aspose.Excel.Cell.Characters.html for reference.

3

Thanks a lot

4

@MedeFinance,
Aspose.Excel is discarded now and no more under active development now. It is replaced by Aspose.Cells that is much advanced and contains all the features to format different segments of text within a cell. Here is a sample code to demonstrate this feature:

// Instantiating a Workbook object
Workbook workbook = new Workbook();

// Obtaining the reference of the first(default) worksheet by passing its sheet index
Worksheet worksheet = workbook.Worksheets[0];

// Accessing the "A1" cell from the worksheet
Cell cell = worksheet.Cells["A1"];

// Adding some value to the "A1" cell
cell.PutValue("Bold Underline Italic");

// Setting the font of selected characters to bold and colored.
cell.Characters(0, 4).Font.IsBold = true;
cell.Characters(0, 4).Font.Color = Color.Green;

// Setting underline of the specific chars.
cell.Characters(5, 9).Font.Underline = FontUnderlineType.Dash;

//Setting Italic for the specific chars
cell.Characters(15, 6).Font.IsItalic = true;

//Define style to Wrap text in the cell.
Style style = workbook.CreateStyle();
style.IsTextWrapped = true;
//apply the style.
cell.SetStyle(style);
worksheet.AutoFitColumns();

workbook.Save("output.xlsx");

Refer to the following article for more information on formatting selected characters.
Formatting selected characters in a cell

Download the free latest version here for testing the product features:
Aspose.Cells for .NET (Latest Version)

Here is a ready to run solution which can be used to test the product features with minimal effort.