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
NuGet Package: DevExpress.Spreadsheet.Core
NuGet Packages: DevExpress.Spreadsheet.Core, DevExpress.WindowsDesktop.Spreadsheet.Core
Declaration
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");