FormulaReplacementMode Enum

Specifies how to replace copied formulas if they contain references to worksheets that do not exist in the destination workbook.

Namespace: DevExpress.Spreadsheet

Assembly: DevExpress.Spreadsheet.v25.1.Core.dll

NuGet Package: DevExpress.Spreadsheet.Core

Declaration

C#

public enum FormulaReplacementMode

VB.NET

Public Enum FormulaReplacementMode

Members

Name	Description
UseExternalReferences	Converts references to other sheets in the source workbook to external references.
KeepFormulaValuesOnly	Copies only calculated values for formulas with external references.

Related API Members

The following properties accept/return FormulaReplacementMode values:

• WorksheetCopyOptions.InvalidFormulaReplacementMode