We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy.
Unfortunately, activation email could not send to your email. Please try again.

Formatting style for a cell

Thread ID:

Created:

Updated:

Platform:

Replies:

51804 Nov 14,2006 11:10 AM Nov 14,2006 12:02 PM ASP.NET Web Forms (Classic) 1
loading
Tags: XlsIO
Nora Eabdenbitsen
Asked On November 14, 2006 11:10 AM

Hi all,
Is it possible to make many styles (for example: BOLD_TEXT + ITALIC_TEXT) in the same cell in excel sheet.

Chella Pandian B [Syncfusion]
Replied On November 14, 2006 12:02 PM

Hi Nora

It is possible to make many styles in the same cell. I have created a sample please check it out.

IRange Range = sheet.Range["A1"];
Range.Text = "Bold and Italic";
IRichTextString rtf = Range.RichText;
IFont Font = workbook.CreateFont();
Font.Bold = true;
Font.Italic = true;
rtf.SetFont(0, Range.Text.Length-1,Font);

Sample:
BoldItalic.zip

with regards,
Chella.

CONFIRMATION

This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.

;