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.v19.1.Core.dll

Declaration

C#

void CopyFrom(
    BuiltInStyleId id
)

VB.NET

Sub CopyFrom(
    id As BuiltInStyleId
)

Parameters

Name	Type	Description
id	BuiltInStyleId	A cell style from which format settings should be copied.

Remarks

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.

Example

1. Add a new style to the Workbook.Styles collection by calling the StyleCollection.Add method with the style name passed as a parameter.

2. To copy all format settings from a Microsoft® Excel® built-in style to the newly created style, use the Style.CopyFrom method with the built-in style id (a BuiltInStyleId enumeration member) passed as a parameter.

3. Use properties of the newly created Style object to change the required format settings of the style.

Note

A complete sample project is available at https://github.com/DevExpress-Examples/spreadsheet-document-server-api-e4339

FormattingActions.cs

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

// Copy all format settings from the built-in Good style.
myGoodStyle.CopyFrom(BuiltInStyleId.Good);

// Modify the required formatting characteristics if needed.
// ...

FormattingActions.vb

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

' Copy all format settings from the built-in Good style.
myGoodStyle.CopyFrom(BuiltInStyleId.Good)

' Modify the required formatting characteristics if needed.
' ...