Back to Devexpress

Cell.HasQuotePrefix Property

officefileapi-devexpress-dot-spreadsheet-dot-cell-877b7f39.md

latest1.6 KB
Original Source

Cell.HasQuotePrefix Property

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

Namespace : DevExpress.Spreadsheet

Assembly : DevExpress.Spreadsheet.v25.2.Core.dll

NuGet Package : DevExpress.Spreadsheet.Core

Declaration

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

Property Value

TypeDescription
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

Cell Interface

Cell Members

DevExpress.Spreadsheet Namespace