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

FunctionNameCulture Enum

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

Namespace: DevExpress.XtraSpreadsheet

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

Declaration

public enum FunctionNameCulture
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.

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