Skip to main content

SpreadsheetClipboardOptions.DisallowDelimiterWithinFields Property

Gets or sets whether to process double quotes within an inserted tab-delimited text.

Namespace: DevExpress.XtraSpreadsheet

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

NuGet Package: DevExpress.Spreadsheet.Core

Declaration

[DefaultValue(false)]
public bool DisallowDelimiterWithinFields { get; set; }

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:

Object Type Path to DisallowDelimiterWithinFields
DocumentOptions
.Clipboard .DisallowDelimiterWithinFields

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 DisallowDelimiterWithinFields_False DisallowDelimiterWithinFields_True

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 DisallowDelimiterWithinFields_False_OddQuotes DisallowDelimiterWithinFields_True_OddQuotes
See Also