IXlCell.HasQuotePrefix Property

Returns or specifies whether a cell value is prefixed with a single quote.

Namespace: DevExpress.Export.Xl

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

NuGet Package: DevExpress.Printing.Core

Declaration

C#

bool HasQuotePrefix { get; set; }

VB.NET

Property HasQuotePrefix As Boolean

Property Value

Type	Description
Boolean	true if the cell contains a leading quote; otherwise, false.

Remarks

Enable this option to specify that a number, date, or formula in a cell should be treated as text and cannot be used in calculations.

C#

using (IXlCell cell = row.CreateCell())
{
    cell.Value = "=A2";
    cell.HasQuotePrefix = true;
}

VB.NET

Using cell As IXlCell = row.CreateCell()
    cell.Value = "=A2"
    cell.HasQuotePrefix = True
End Using