GrapeCity.Documents.Excel.Drawing.ITickLabels.NumberFormatLinked

NumberFormatLinked Property

NumberFormatLinked

Gets or sets whether the tick 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 axis tick labels.

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["A1:B4"]);
IAxis axis = chart.Axes.Item(AxisType.Category, AxisGroup.Primary);
axis.TickLabels.NumberFormatLinked = false;
bool linked = axis.TickLabels.NumberFormatLinked;