Skip to main content

SpreadsheetBehaviorOptions.FunctionNameCulture Property

Specifies whether to localize function names in the Spreadsheet control. This is a dependency property.

Namespace: DevExpress.Xpf.Spreadsheet

Assembly: DevExpress.Xpf.Spreadsheet.v24.2.dll

NuGet Package: DevExpress.Wpf.Spreadsheet

Declaration

public FunctionNameCulture FunctionNameCulture { get; set; }

Property Value

Type Description
FunctionNameCulture

Specifies culture settings for function names. The default value is Auto.

Available values:

Name Description
English

English function names are used regardless of the Workbook or Spreadsheet control’s culture settings.

Local

Function names are retrieved from the satellite resource assemblies for the specified culture.

Auto

Function names are retrieved from the satellite resource assemblies for the specified culture. If satellite assemblies are not found, the invariant (English) names are used.

Property Paths

You can access this nested property as listed below:

Object Type Path to FunctionNameCulture
SpreadsheetControlOptions
.Behavior .FunctionNameCulture

Remarks

The DevExpress WPF Spreadsheet control uses the standard localization mechanism from the .NET Framework—Satellite Resource Assemblies (libraries that contain translated resources). Satellite assemblies for the following languages are included in the DevExpress Unified Component Installer and available in the DevExpress NuGet Gallery:

  • German
  • Spanish
  • Japanese

Use the DevExpress Localization Service to obtain satellite assemblies for other cultures. Add translations for strings that correspond to function names, download the modified satellite assemblies, and include them in your project. If you are new to our Localization Service, refer to the following help topic for assistance: Localizing WPF Controls with Satellite Resource Assemblies.

After you add localization resources to your application, use the SpreadsheetControl.Options.Culture property to set the control’s culture. If satellite assemblies for this culture are not found, the invariant (English) culture is used.

See Also