Skip to main content
All docs
V25.1
  • IXlCell.HasQuotePrefix Property

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

    Namespace: DevExpress.Export.Xl

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

    NuGet Package: DevExpress.Printing.Core

    Declaration

    bool HasQuotePrefix { get; set; }

    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.

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