officefileapi-devexpress-dot-spreadsheet-dot-dataimportoptions-73205a5b.md
Gets or sets whether the reference style is used in data imported as formulas.
Namespace : DevExpress.Spreadsheet
Assembly : DevExpress.Spreadsheet.v25.2.Core.dll
NuGet Package : DevExpress.Spreadsheet.Core
public ReferenceStyle ReferenceStyle { get; set; }
Public Property ReferenceStyle As ReferenceStyle
| 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.
|
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")})
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") });
See Also