GrapeCity.Documents.Excel.Drawing.IDataLabels.NumberFormat

NumberFormat Property

NumberFormat

Gets or sets the number format code for the data labels.

When the number format is linked to the source cells, the returned format code reflects the linked cell format. If no custom format code is available, this method returns "General".

Declaration

string NumberFormat { get; set; }

Property NumberFormat As String

Examples

worksheet.Range["A1:B3"].Value = new object[,] {
    {"Month", "Sales"},
    {"Jan", 1200},
    {"Feb", 1500}
};
worksheet.Range["B2:B3"].NumberFormat = "$#,##0";
IChart chart = worksheet.Shapes.AddChart(ChartType.ColumnClustered, 20, 20, 300, 200).Chart;
chart.SeriesCollection.Add(worksheet.Range["A1:B3"], RowCol.Columns);
ISeries series = chart.SeriesCollection[0];
series.HasDataLabels = true;
string numberFormat = series.DataLabels.NumberFormat;