DocumentOptions.Culture Property

Provides access to the culture-specific settings of the spreadsheet.

Namespace: DevExpress.Spreadsheet

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

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:

Library	Object Type	Path to Culture
WinForms Controls	SpreadsheetControl	.Options.Culture
Office File API	ISpreadsheetComponent	.Options.Culture
	Workbook	.Options.Culture

Remarks

To localize worksheet function names, specify the culture using the SpreadsheetControl.Options.Culture notation.

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-examples-part2/CS/SpreadsheetDocServerAPIPart2/Form1.cs#L77

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

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

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

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

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

winforms-spreadsheet-pivot-table-api-t298650/CS/SpreadsheetPivotTableExamples/Form1.cs#L114

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

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

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

VB.NET

spreadsheet-document-api-examples-part2/VB/SpreadsheetDocServerAPIPart2/Form1.vb#L72

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

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

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

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

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

winforms-spreadsheet-pivot-table-api-t298650/VB/SpreadsheetPivotTableExamples/Form1.vb#L109

Dim workbook As IWorkbook = spreadsheet.Document
workbook.Options.Culture = defaultCulture
Dim loaded As Boolean = workbook.LoadDocument("Documents\PivotTableTemplate.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")