.NET Framework 4.5.2+
.NET Framework 4.5.2+
.NET Standard 2.0+
A newer version of this page is available. Switch to the current version.

FunctionNameCulture Enum

Lists values that are used to specify the culture settings for function names in a worksheet.

Namespace: DevExpress.XtraSpreadsheet

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

Declaration

public enum FunctionNameCulture

Members

Name Description
English

English function names are used regardless of the spreadsheet control’s culture settings.

Local

Function names are retrieved from a table of localized names for the culture specified for the spreadsheet control. Use the SpreadsheetControl.Options.Culture notation to get access to the spreadsheet control’s culture setting.

Auto

Function names are retrieved from a table of localized names if present; otherwise, invariant names (English) are used.

Related API Members

The following properties accept/return FunctionNameCulture values:

Library Related API Members
WPF Controls SpreadsheetBehaviorOptions.FunctionNameCulture
Office File API SpreadsheetBehaviorOptions.FunctionNameCulture

Remarks

The FunctionNameCulture enumeration values are used by the SpreadsheetBehaviorOptions.FunctionNameCulture property, accessible via the SpreadsheetControl.Options.Behavior.FunctionNameCulture notation.

To localize worksheet function names, obtain a satellite resource assembly for the required culture, add it to the project as described in the Localizing WinForms Controls via Satellite Resource Assemblies document and use the following code (the code snippet below translates function names to French, you have to change the culture as required).

spreadsheetControl1.Options.Behavior.FunctionNameCulture = DevExpress.XtraSpreadsheet.FunctionNameCulture.Local;
spreadsheetControl1.Options.Culture = new System.Globalization.CultureInfo("fr-FR");
See Also