Spread Windows Forms 17
Spread Windows Forms 17.0 Product Documentation / Developer's Guide / Cells / Setting Rich Text in a Cell
In This Topic
    Setting Rich Text in a Cell
    In This Topic

    Spread for Winforms provides the ability to add rich text in a cell. You can add different rich text formatting options such as fonts, text styles, colors, superscripts, and subscripts.

    The RichText Class can be used to set a rich text instance consisting of the string that will have rich text capabilities.

    The following code shows how to add rich text in a cell.

    C#
    Copy Code 
    // Initiating a richtext object
GrapeCity.Spreadsheet.RichText richText = new GrapeCity.Spreadsheet.RichText("This is a rich text");
            
// Defining font styles
GrapeCity.Spreadsheet.Font font = GrapeCity.Spreadsheet.Font.Empty;
GrapeCity.Spreadsheet.Font font2 = GrapeCity.Spreadsheet.Font.Empty;
GrapeCity.Spreadsheet.Font font3 = GrapeCity.Spreadsheet.Font.Empty;
GrapeCity.Spreadsheet.Font font4 = GrapeCity.Spreadsheet.Font.Empty;
GrapeCity.Spreadsheet.Font fontAll = GrapeCity.Spreadsheet.Font.Empty;

// Setting font styles
font.VerticalAlign = GrapeCity.Spreadsheet.VerticalTextAlignment.Subscript;
font2.Color = GrapeCity.Spreadsheet.Color.FromKnownColor(GrapeCity.Core.KnownColor.Violet);
font3.Color = GrapeCity.Spreadsheet.Color.FromKnownColor(GrapeCity.Core.KnownColor.Green);
font4.Italic = true;
fontAll.Bold = true;
fontAll.Size = 24;

// Applying styles to richtext instance
richText.Format(8, 1, font);
richText.Format(15, 4, font2);
richText.Format(0, 4, font3);
richText.Format(10, 4, font4);
richText.Format(fontAll);
            
// Setting test activesheet
GrapeCity.Spreadsheet.IWorksheet TestActiveSheet = fpSpread1.AsWorkbook().ActiveSheet;

// Setting rich text in a cell
TestActiveSheet.Cells["A1"].Value = richText;
    Visual Basic
    Copy Code 
    'Initiating a richtext object
Dim richText As GrapeCity.Spreadsheet.RichText = New GrapeCity.Spreadsheet.RichText("This is a rich text")

'Defining font styles
Dim font As GrapeCity.Spreadsheet.Font = GrapeCity.Spreadsheet.Font.Empty
Dim font2 As GrapeCity.Spreadsheet.Font = GrapeCity.Spreadsheet.Font.Empty
Dim font3 As GrapeCity.Spreadsheet.Font = GrapeCity.Spreadsheet.Font.Empty
Dim font4 As GrapeCity.Spreadsheet.Font = GrapeCity.Spreadsheet.Font.Empty
Dim fontAll As GrapeCity.Spreadsheet.Font = GrapeCity.Spreadsheet.Font.Empty

'Setting font styles
font.VerticalAlign = GrapeCity.Spreadsheet.VerticalTextAlignment.Subscript
font2.Color = GrapeCity.Spreadsheet.Color.FromKnownColor(GrapeCity.Core.KnownColor.Violet)
font3.Color = GrapeCity.Spreadsheet.Color.FromKnownColor(GrapeCity.Core.KnownColor.Green)
font4.Italic = True
fontAll.Bold = True
fontAll.Size = 24

'Applying styles to richtext instance
richText.Format(8, 1, font)
richText.Format(15, 4, font2)
richText.Format(0, 4, font3)
richText.Format(10, 4, font4)
richText.Format(fontAll)

'Setting active testsheet
Dim TestActiveSheet As GrapeCity.Spreadsheet.IWorksheet = FpSpread1.AsWorkbook().ActiveSheet

'Setting rich text in a cell
TestActiveSheet.Cells("A1").Value = richText
    Note: If you edit the rich text in runtime then it behaves as plain text.

    ExcelIO for Rich Text

    Spreadsheets containing rich text formatting can easily be imported from or exported to Excel by setting FpSpread.Features.RichText property to True.

    The following code shows how to import or export an Excel file containing rich text.

    C#
    Copy Code 
    // Enable RichText property
fpSpread1.Features.RichText = true;

// Import file containing rich text
fpSpread1.ActiveSheet.OpenExcel("richtext-file.xlsx", 0);

// Export rich text set in cells to a file
fpSpread1.SaveExcel("excelfile.xlsx", FarPoint.Excel.ExcelSaveFlags.UseOOXMLFormat);
    Visual Basic
    Copy Code 
    'Enable RichText property
FpSpread1.Features.RichText = True

'Import file containing rich text
FpSpread1.ActiveSheet.OpenExcel("richtext-file.xlsx", 0)

'Export rich text set in cells to a file
FpSpread1.SaveExcel("excelfile.xlsx", FarPoint.Excel.ExcelSaveFlags.UseOOXMLFormat)
    Note: PDF export is not supported.