DocumentOptions.Culture Property

Obtains culture-specific settings of the spreadsheet.

Namespace: DevExpress.Spreadsheet

Assembly: DevExpress.Spreadsheet.v24.1.Core.dll

NuGet Package: DevExpress.Spreadsheet.Core

Declaration

C#

public CultureInfo Culture { get; set; }

VB.NET

Public Property Culture As CultureInfo

Property Value

Type	Description
CultureInfo	A CultureInfo object that specifies culture settings currently being used.

Property Paths

You can access this nested property as listed below:

Object Type	Path to Culture
ISpreadsheetComponent	.Options .Culture

Remarks

The Culture affects the following workbook elements:

• Function names
• Argument separators in formulas (including calculated fields in pivot tables)
• Decimal separators for numeric cell content
• Date and time formats

Related GitHub Examples

The following code snippets (auto-collected from DevExpress Examples) contain references to the Culture property.

Note

The algorithm used to collect these code examples remains a work in progress. Accordingly, the links and snippets below may produce inaccurate results. If you encounter an issue with code examples below, please use the feedback form on this page to report the issue.

C#

spreadsheet-document-api-chart-examples/CS/SpreadsheetDocServerChartAPISamples/Form1.cs#L134

codeEditor.BeforeCompile();
workbook.Options.Culture = defaultCulture;
bool loaded = workbook.LoadDocument("Document.xlsx");

spreadsheet-document-api-pivot-table-examples/CS/SpreadsheetDocServerPivotAPI/Form1.cs#L92

codeEditor.BeforeCompile();
workbook.Options.Culture = defaultCulture;
bool loaded = workbook.LoadDocument("PivotTableTemplate.xlsx");

wpf-spreadsheet-chart-api/CS/SpreadsheetWPFChartAPISamples/MainWindow.xaml.cs#L73

IWorkbook workbook = spreadsheetControl1.Document;
workbook.Options.Culture = defaultCulture;
bool loaded = workbook.LoadDocument("Document.xlsx");

wpf-spreadsheet-pivot-table-api-examples/CS/SpreadsheetWPFPivotTableExamples/MainWindow.xaml.cs#L66

IWorkbook workbook = spreadsheetControl1.Document;
workbook.Options.Culture = defaultCulture;
bool loaded = workbook.LoadDocument("PivotTableTemplate.xlsx");

spreadsheet-document-api-examples-part2/CS/SpreadsheetDocServerAPIPart2/Form1.cs#L77

codeEditor.BeforeCompile();
workbook.Options.Culture = defaultCulture;
bool loaded = workbook.LoadDocument("Document.xlsx");

VB.NET

spreadsheet-document-api-chart-examples/VB/SpreadsheetDocServerChartAPISamples/Form1.vb#L127

codeEditor.BeforeCompile()
workbook.Options.Culture = defaultCulture
Dim loaded As Boolean = workbook.LoadDocument("Document.xlsx")

spreadsheet-document-api-pivot-table-examples/VB/SpreadsheetDocServerPivotAPI/Form1.vb#L86

codeEditor.BeforeCompile()
workbook.Options.Culture = defaultCulture
Dim loaded As Boolean = workbook.LoadDocument("PivotTableTemplate.xlsx")

wpf-spreadsheet-chart-api/VB/SpreadsheetWPFChartAPISamples/MainWindow.xaml.vb#L77

Dim workbook As IWorkbook = spreadsheetControl1.Document
workbook.Options.Culture = defaultCulture
Dim loaded As Boolean = workbook.LoadDocument("Document.xlsx")

wpf-spreadsheet-pivot-table-api-examples/VB/SpreadsheetWPFPivotTableExamples/MainWindow.xaml.vb#L66

Dim workbook As IWorkbook = spreadsheetControl1.Document
workbook.Options.Culture = defaultCulture
Dim loaded As Boolean = workbook.LoadDocument("PivotTableTemplate.xlsx")

wpf-spreadsheetcontrol-api-part-2/VB/SpreadsheetControl_WPF_API_Part02/MainWindow.xaml.vb#L32

If example IsNot Nothing Then
    workbook.Options.Culture = System.Globalization.CultureInfo.CurrentCulture
    LoadDocumentFromFile()