WorkbookLocalizationOptions.FunctionNameCulture Property

Specifies whether to localize function names in a workbook.

Namespace: DevExpress.XtraSpreadsheet

Assembly: DevExpress.Spreadsheet.v21.2.Core.dll

NuGet Package: DevExpress.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	Specifies culture settings for function names.

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
WorkbookOptions	.Localization .FunctionNameCulture

Remarks

The DevExpress Office File API library 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 (DevExpress.Document.Processor.de)
• Spanish (DevExpress.Document.Processor.es)
• Japanese (DevExpress.Document.Processor.ja)
• Russian (DevExpress.Document.Processor.ru)

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: Localization Service.

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

C#

using DevExpress.Spreadsheet;
using DevExpress.XtraSpreadsheet;
//...

using (Workbook workbook = new Workbook())
{
    // Specify the workbook's culture.
    workbook.Options.Culture = new System.Globalization.CultureInfo("de-DE");
    // Localize function names.
    workbook.Options.Localization.FunctionNameCulture = FunctionNameCulture.Local;

    Worksheet worksheet = workbook.Worksheets.ActiveWorksheet;
    // Create a simple formula.
    worksheet["B2"].Formula = "ODER(WAHR;FALSCH)";
    workbook.Calculate();
}

VB.NET

Imports DevExpress.Spreadsheet
Imports DevExpress.XtraSpreadsheet
'...

Using workbook As New Workbook()
    ' Specify the workbook's culture.
    workbook.Options.Culture = New System.Globalization.CultureInfo("de-DE")
    ' Localize function names.
    workbook.Options.Localization.FunctionNameCulture = FunctionNameCulture.Local

    Dim worksheet As Worksheet = workbook.Worksheets.ActiveWorksheet
    ' Create a simple formula.
    worksheet("B2").Formula = "ODER(WAHR;FALSCH)"
    workbook.Calculate()
End Using