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.v23.2.Core.dll

NuGet Package: DevExpress.Spreadsheet.Core

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. 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.

View Example

FormattingActions.cs

// 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.
myGoodStyle.CopyFrom(BuiltInStyleId.Good);

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

FormattingActions.vb

' Add a new style under the "My Good Style" name to the style 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 style's format characteristics if needed.
' ...

Related GitHub Examples

The following code snippet (auto-collected from DevExpress Examples) contains a reference to the CopyFrom(BuiltInStyleId) method.

Note

The algorithm used to collect these code examples remains a work in progress. Accordingly, the links and snippets below may produce inaccurate results. If you encounter an issue with code examples below, please use the feedback form on this page to report the issue.

VB.NET

spreadsheet-document-api-examples-part1/VB/SpreadsheetExamples/SpreadsheetActions/FormattingActions.vb#L73

' Copy all format settings from the built-in Good style.
myGoodStyle.CopyFrom(BuiltInStyleId.Good)
' Modify the required formatting characteristics if needed.