Skip to main content

DevExpress v24.2 Update — Your Feedback Matters

Our What's New in v24.2 webpage includes product-specific surveys. Your response to our survey questions will help us measure product satisfaction for features released in this major update and help us refine our plans for our next major release.

Take the survey Not interested

SpreadsheetClipboardOptions.DisallowDelimiterWithinFields Property

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

Namespace: DevExpress.XtraSpreadsheet

Assembly: DevExpress.Spreadsheet.v24.2.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