.NET Framework 4.5.2+
.NET Framework 4.5.2+
.NET Standard 2.0+

Cell.HasQuotePrefix Property

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

Namespace: DevExpress.Spreadsheet

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


bool HasQuotePrefix { get; }

Property Value

Type Description

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


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