The requested page is not available for the requested platform. You are viewing the content for .NET Framework 4.5.2+ platform.
.NET Framework 4.5.2+
.NET Framework 4.5.2+
.NET Standard 2.0+
Row

Cell.HasQuotePrefix Property

Indicates whether or not the cell value is prefixed with a single quote.

Namespace: DevExpress.Spreadsheet

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

Declaration

bool HasQuotePrefix { get; }
ReadOnly Property HasQuotePrefix As Boolean
bool HasQuotePrefix { get; }
ReadOnly Property HasQuotePrefix As Boolean

Property Value

Type Description
Boolean

true, if the cell value contains a leading quote; otherwise, false.

Property Value

Type Description
Boolean

true, if the cell value contains a leading quote; otherwise, false.

Remarks

Use the HasQuotePrefix property to obtain cells with a single quote prefix. A leading quote before a cell value indicates that this value should be interpreted as a single text without further conversion to any other type. Thus, a number, date or formula entered with a leading single quote is treated as a text value and cannot be used in calculations.

Note that the Cell.DisplayText and CellValue.TextValue properties return the string value without a leading quote.

See Also