DataImportOptions.ReferenceStyle Property
In This Article
Gets or sets whether the reference style is used in data imported as formulas.
Namespace: DevExpress.Spreadsheet
Assembly: DevExpress.Spreadsheet.v24.2.Core.dll
NuGet Package: DevExpress.Spreadsheet.Core
#Declaration
public ReferenceStyle ReferenceStyle { get; set; }
#Property Value
Type | Description |
---|---|
Reference |
A Reference |
Available values:
Name | Description |
---|---|
Use |
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
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")})
See Also