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. (Last updated on : Nov 16th 2018).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

Formatting style for a cell

Thread ID:

Created:

Updated:

Platform:

Replies:

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

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 05:02 PM UTC

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.

Warning Icon 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.Close Icon

;