SpreadsheetClipboardOptions.UnquoteTabDelimitedText Property
Gets or sets whether to process quotes within a tab-delimited text. This is a dependency property.
Namespace: DevExpress.Xpf.Spreadsheet
Assembly: DevExpress.Xpf.Spreadsheet.v24.2.dll
NuGet Package: DevExpress.Wpf.Spreadsheet
Declaration
Property Value
| Type | Description |
|---|---|
| Boolean | true, to process double quotes within fields; otherwise, false. |
Property Paths
You can access this nested property as listed below:
| Object Type | Path to UnquoteTabDelimitedText |
|---|---|
| SpreadsheetControlOptions |
|
Remarks
When you paste a tab-separated text that has double quotes from the clipboard into the SpreadsheetControl or use the “Paste As: Unformatted text (Tab delimited text)“ option to paste data, the control processes double quotes as escape characters.
| Tab Separated Values | True (default) | False |
|---|---|---|
| “A””B” 123 |  |
 |
This default behavior may lead to unwanted results. For instance, when you insert text that contains an odd number of double quotes. In this case, data is not divided into fields and inserted as a string into a single cell. To fix this behavior, set the UnquoteTabDelimitedText property to false. As a result, the SpreadsheetControl doesn’t process double quotes and splits text by a tab character.
| Tab Separated Values | True (default) | False |
|---|---|---|
| “A”B” 123 |  |
 |