Lists values that are used to specify the culture settings for function names in a worksheet.
English function names are used regardless of the spreadsheet control’s culture settings.
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.
Function names are retrieved from a table of localized names if present; otherwise, invariant names (English) are used.
Related API Members
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).
A complete sample project is available at https://github.com/DevExpress-Examples/how-to-localize-worksheet-function-names-t144036
spreadsheetControl1.Options.Behavior.FunctionNameCulture = DevExpress.XtraSpreadsheet.FunctionNameCulture.Local; spreadsheetControl1.Options.Culture = new System.Globalization.CultureInfo("fr-FR");