SpreadsheetClipboardOptions.DisallowDelimiterWithinFields Property
Gets or sets whether to process double quotes within an inserted tab-delimited text.
Namespace: DevExpress.XtraSpreadsheet
Assembly: DevExpress.Spreadsheet.v19.1.Core.dll
Declaration
Property Value
| Type | Default | Description |
|---|---|---|
| Boolean | **false** | true, if double quotes within a field are not processed; otherwise, false. |
Property Paths
You can access this nested property as listed below:
| Library | Object Type | Path to DisallowDelimiterWithinFields |
|---|---|---|
| WinForms Controls | SpreadsheetControlOptions |
|
| Office File API | DocumentOptions |
|
Remarks
When you paste a tab-separated text that contains 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 | False (default) | True |
|---|---|---|
| “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 DisallowDelimiterWithinFields property to true. As a result, the Spreadsheet doesn’t process double quotes and splits text by a tab character.
| Tab Separated Values | False (default) | True |
|---|---|---|
| “A”B” 123 |  |
 |