SpreadsheetClipboardOptions.KeepThemeFonts Property

Gets or sets whether to keep major and minor theme fonts of the SpreadsheetControl’s document when its data is copied to an external spreadsheet application. This is a dependency property.

Namespace: DevExpress.Xpf.Spreadsheet

Assembly: DevExpress.Xpf.Spreadsheet.v23.2.dll

NuGet Package: DevExpress.Wpf.Spreadsheet

Declaration

C#

public bool KeepThemeFonts { get; set; }

VB.NET

Public Property KeepThemeFonts As Boolean

Property Value

Type	Description
Boolean	true, to keep the document’s theme fonts; otherwise, false.

Property Paths

You can access this nested property as listed below:

Object Type	Path to KeepThemeFonts
SpreadsheetControlOptions	.Clipboard .KeepThemeFonts

Remarks

If you copy data from the SpreadsheetControl to an external spreadsheet application (another SpreadsheetControl instance or Microsoft® Excel®), theme formatting can change for the copied data to use the destination workbook’s theme colors and fonts.

To preserve theme formatting for copied data, set the control’s KeepThemeColors and KeepThemeFonts properties to true. In this case, theme colors are converted to the corresponding custom RGB colors, and theme fonts become user-defined fonts with the font scheme None.

If you programmatically copy data between workbooks with different themes applied, you can use the following properties to preserve the source workbook’s theme colors and fonts:

• SpreadsheetCopyOptions.KeepSourceThemeColors

• SpreadsheetCopyOptions.KeepSourceThemeFonts