Access and format single characters of a cell

[Christian Nein]

Hi,

does XlsIO offer the functionality to access and format single charcters of a Range like this is possible in MS Excel by Range.Characters() (Range.get_Characters() when using Interop assemblies)? I did not find the corresponding function in XlsIO.

We urgently need this feature as we have to set different fonts for different characters within one cell string.

Thanks in advance & best regards
Christian

[Melba Winshia]

Hi Christian,

Thank you for your interest in Essential XlsIO.

You can format single character of a Range by using IRange.RichText property. But we do not have any similar API Range.Characters() as in MS Excel. If your intention is to get characters of a Range, it can be achieved by using IRange.Text.ToCharArray() method. Please use the below code snippet to set different fonts for different characters within one cell string.

[C#]

//Insert Rich Text
IRange range = sheet.Range["A1"];
range.Text = "RichText";
IRichTextString rtf = range.RichText;

//Formatting first 4 characters
IFont redFont = workbook.CreateFont();
redFont.Bold = true;
redFont.Italic = true;
redFont.RGBColor = Color.FromArgb(0xde, 0x64, 0x13);
rtf.SetFont( 0, 3, redFont );

Please refer to the samples that are shipped with Essential XlsIO to get more details regarding this issue that is found in below location.

C:\Documents and Settings\melbas\My Documents\Syncfusion\EssentialStudio\5.1.0.51\Windows\XlsIO.Windows\Samples\2.0\Rich Text\WriteRichText\cs

Please try this and let me know if this helps.

Thanks,
Melba

[Christian Nein]

Hi Melba,

this works great! Thank you very much for supporting.

Best regards
Christian

[Melba Winshia]

Hi Christian,

Thank you for the update.

Glad to hear that it works fine.

Please let me know if you have any other questions.

Thanks,
Melba