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.v20.2.Core.dll

NuGet Package: DevExpress.Spreadsheet.Core

NuGet Packages: DevExpress.Spreadsheet.Core, DevExpress.WindowsDesktop.Spreadsheet.Core

Declaration

C#

[DefaultValue(FunctionNameCulture.Auto)]
public FunctionNameCulture FunctionNameCulture { get; set; }

VB.NET

<DefaultValue(FunctionNameCulture.Auto)>
Public Property FunctionNameCulture As FunctionNameCulture

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	.Behavior .FunctionNameCulture

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.