GrapeCity.Documents.Excel.IDisplayFormat.NumberFormat

NumberFormat Property

NumberFormat

Gets a value that represents the format code of the associated range object as displayed in the current user interface.

Use this property to retrieve the effective number format currently shown for the range. This displayed format can differ from the range's own format settings when display-affecting features such as conditional formatting or table styles are applied.

Declaration

string NumberFormat { get; }

ReadOnly Property NumberFormat As String

Examples

IRange range = worksheet.Range["A1"];
range.NumberFormat = "$#,##0.00";
range.Value = 1234.5;
string numberFormat = range.DisplayFormat.NumberFormat;