.NET Framework 4.5.2+
.NET Framework 4.5.2+
.NET Standard 2.0+

Style.CopyFrom(BuiltInStyleId) Method

Duplicates the format settings of the specified built-in style into the current Style instance.

Namespace: DevExpress.Spreadsheet

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


void CopyFrom(
    BuiltInStyleId id


Name Type Description
id BuiltInStyleId

A cell style from which format settings should be copied.


You can duplicate a built-in style using the CopyFrom property to create your own custom style. For more information on cell styles and examples on how to manage them, see the Formatting Cells and How to: Create or Modify a Style topics.


  1. Use the StyleCollection.Add method to add a new style to the Workbook.Styles collection.

  2. Call the Style.CopyFrom method for the created style to copy all format settings from the specified Microsoft® Excel® built-in style to the new style.

// Add a new style under the "My Good Style" name to the style collection.
Style myGoodStyle = workbook.Styles.Add("My Good Style");

// Copy all format settings from the built-in Good style.

// Modify the style's format characteristics if needed.
// ...
See Also