SpreadsheetBehaviorOptions.FunctionNameCulture Property
Enables you to specify the culture setting for function names in a worksheet that is different from the control’s culture settings.
Namespace: DevExpress.XtraSpreadsheet
Assembly: DevExpress.Spreadsheet.v18.2.Core.dll
Declaration
[DefaultValue(FunctionNameCulture.Auto)]
public FunctionNameCulture FunctionNameCulture { get; set; }Property Value
| Type | Default | Description |
|---|---|---|
| FunctionNameCulture | **Auto** | A FunctionNameCulture enumeration member specifying the culture settings used for the names of the worksheet functions. |
Available values:
| 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. |
Property Paths
You can access this nested property as listed below:
| Object Type | Path to FunctionNameCulture |
|---|---|
| SpreadsheetControlOptions |
|
Remarks
The Culture property (accessible by using the SpreadsheetControl.Options.Culture notation) allows you to specify the culture settings for the SpreadsheetControl. The FunctionNameCulture property allows you to fine tune localization to avoid using localized function names in the worksheet, while applying culture-specific number and date formats.