GrapeCity.Documents.Excel.Drawing.IDataLabel.NumberFormatLinked

NumberFormatLinked Property

NumberFormatLinked

Gets or sets whether the data label number format is linked to the source cells.

If this property is true, changes to the number format in the source cells are reflected in the data label.

Declaration

bool NumberFormatLinked { get; set; }

Property NumberFormatLinked As Boolean

Examples

worksheet.Range["A1:B4"].Value = new object[,] {
    {"Month", "Sales"},
    {"Jan", 1200},
    {"Feb", 1500},
    {"Mar", 1100}
};
IChart chart = worksheet.Shapes.AddChart(ChartType.ColumnClustered, 20, 20, 360, 220).Chart;
chart.SeriesCollection.Add(worksheet.Range["B2:B4"]);
ISeries series = chart.SeriesCollection[0];
IDataLabel dataLabel = series.Points[0].DataLabel;
dataLabel.NumberFormatLinked = false;
bool linked = dataLabel.NumberFormatLinked;