Skip to main content
All docs
V24.2
Row

DevExpress v24.2 Update — Your Feedback Matters

Our What's New in v24.2 webpage includes product-specific surveys. Your response to our survey questions will help us measure product satisfaction for features released in this major update and help us refine our plans for our next major release.

Take the survey Not interested

Cell.GetRtfContent(RtfCellContentExportOptions) Method

Gets cell content as a string in RTF format. Allows you to specify export options.

Namespace: DevExpress.Spreadsheet

Assembly: DevExpress.Spreadsheet.v24.2.Core.dll

NuGet Package: DevExpress.Spreadsheet.Core

#Declaration

string GetRtfContent(
    RtfCellContentExportOptions options
)

#Parameters

Name Type Description
options RtfCellContentExportOptions

A RtfCellContentExportOptions object that specifies export settings.

#Returns

Type Description
String

The string that contains cell content in RTF format.

#Remarks

Use the GetRtfContent method to export cell content to RTF with the specified export options and obtain the result as a string.

The IgnoreDisplayFormat option allows you to specify whether to ignore the display format.

#Example

The following snippet loads a document from a file and exports content from cell B3. The IgnoreDisplayFormat property is set to true:

using DevExpress.Spreadsheet;
using DevExpress.XtraSpreadsheet.Export;
//... 

using (Workbook workbook = new Workbook()) {
    workbook.LoadDocument("Documents\\Document.xlsx", DocumentFormat.Xlsx);
    workbook.Calculate();
    Worksheet worksheet = workbook.Worksheets[0];

    Cell cell = worksheet[4, 1]; //B3
    RtfCellContentExportOptions rtfExportOptions = new RtfCellContentExportOptions();
    rtfExportOptions.IgnoreDisplayFormat = true;
    string rtfContentString = cell.GetRtfContent(rtfExportOptions);
}

Spreadsheet - Conditional Formatting

The resulting HTML string looks as follows:

plaintext
{\rtf1\deff0{\fonttbl{\f0 Calibri;}}{\colortbl;}{\fs22 cell with conditional formatting}}
See Also