DataImportOptions.ReferenceStyle Property

Gets or sets whether the reference style is used in data imported as formulas.

Namespace: DevExpress.Spreadsheet

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

Declaration

C#

public ReferenceStyle ReferenceStyle { get; set; }

VB.NET

Public Property ReferenceStyle As ReferenceStyle

Property Value

Type	Description
ReferenceStyle	A ReferenceStyle enumeration value which specifies the style of the cell reference.

Available values:

Name	Description
UseDocumentSettings	The cell range reference is in the reference style used in the workbook.
A1	The cell range reference is in the A1 reference style.
R1C1	The cell range reference is in the R1C1 reference style.

Example

Note

A complete sample project is available at https://github.com/DevExpress-Examples/how-to-import-data-to-worksheet-cells-from-different-data-sources-and-use-tables-e4751

Form1.vb

Dim arrayR1C1() As String = { "a", "b", "=R1C1&R1C2" }
worksheet.Import(arrayR1C1, 0, 0, False, New DataImportOptions() With {.ImportFormulas = True, .ReferenceStyle = ReferenceStyle.R1C1})

Dim arrayLocalized() As String = { "a", "=1,2+1" }
worksheet.Import(arrayLocalized, 1, 0, False, New DataImportOptions() With {.ImportFormulas = True, .FormulaCulture = New System.Globalization.CultureInfo("de-DE")})

Form1.cs

string[] arrayR1C1 = new string[] { "a", "b", "=R1C1&R1C2" };
worksheet.Import(arrayR1C1, 0, 0, false, new DataImportOptions() { ImportFormulas = true, ReferenceStyle = ReferenceStyle.R1C1 });

string[] arrayLocalized = new string[] { "a", "=1,2+1" };
worksheet.Import(arrayLocalized, 1, 0, false, 
    new DataImportOptions() { ImportFormulas = true, FormulaCulture = new System.Globalization.CultureInfo("de-DE") });