WorkbookLocalizationOptions.LocalizeBooleanValues Property
Specifies whether to localize TRUE and FALSE values in a workbook.
Namespace: DevExpress.XtraSpreadsheet
Assembly: DevExpress.Spreadsheet.v24.1.Core.dll
NuGet Package: DevExpress.Spreadsheet.Core
Declaration
Property Value
Type | Default | Description |
---|---|---|
Boolean | true | true to localize Boolean values; otherwise, false. |
Property Paths
You can access this nested property as listed below:
Object Type | Path to LocalizeBooleanValues |
---|---|
WorkbookOptions |
|
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)
Use the DevExpress Localization Service to obtain satellite assemblies for other cultures. Add translations for the XtraSpreadsheetFunctionNameStringId.True
and XtraSpreadsheetFunctionNameStringId.False
strings to localize Boolean values, 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.
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();
}