officefileapi-devexpress-dot-spreadsheet-dot-charts-dot-numberformatoptions-6374a62b.md
Specifies whether a number format is obtained from the source cells.
Namespace : DevExpress.Spreadsheet.Charts
Assembly : DevExpress.Spreadsheet.v25.2.Core.dll
NuGet Package : DevExpress.Spreadsheet.Core
bool IsSourceLinked { get; set; }
Property IsSourceLinked As Boolean
| Type | Description |
|---|---|
| Boolean |
true to obtain a format string from the source cells; otherwise, false.
|
You can access this nested property as listed below:
| Object Type | Path to IsSourceLinked |
|---|---|
| Axis |
.NumberFormat .IsSourceLinked
| | DataLabelBase |
.NumberFormat .IsSourceLinked
| | TrendlineLabel |
.NumberFormat .IsSourceLinked
|
If the IsSourceLinked property is true , the Formatting.NumberFormat property of the source cells is used to specify a number format for chart elements.
Disable the IsSourceLinked property and use the NumberFormatOptions.FormatCode or NumberFormatOptions.FormatCodeLocal property to apply a custom number format to chart elements.
The following code snippets (auto-collected from DevExpress Examples) contain references to the IsSourceLinked property.
Note
The algorithm used to collect these code examples remains a work in progress. Accordingly, the links and snippets below may produce inaccurate results. If you encounter an issue with code examples below, please use the feedback form on this page to report the issue.
wpf-spreadsheet-chart-api/CS/SpreadsheetWPFChartAPISamples/CodeExamples/DataLabelsActions.cs#L60
chart.Views[0].DataLabels.NumberFormat.FormatCode = "0%";
chart.Views[0].DataLabels.NumberFormat.IsSourceLinked = false;
winforms-spreadsheet-chart-api/CS/SpreadsheetChartAPISamples/CodeExamples/DataLabelsActions.cs#L60
chart.Views[0].DataLabels.NumberFormat.FormatCode = "0%";
chart.Views[0].DataLabels.NumberFormat.IsSourceLinked = false;
chart.Views[0].DataLabels.NumberFormat.FormatCode = "0%";
chart.Views[0].DataLabels.NumberFormat.IsSourceLinked = false;
wpf-spreadsheet-chart-api/VB/SpreadsheetWPFChartAPISamples/CodeExamples/DataLabelsActions.vb#L64
chart.Views(0).DataLabels.NumberFormat.FormatCode = "0%"
chart.Views(0).DataLabels.NumberFormat.IsSourceLinked = False
winforms-spreadsheet-chart-api/VB/SpreadsheetChartAPISamples/CodeExamples/DataLabelsActions.vb#L63
chart.Views(0).DataLabels.NumberFormat.FormatCode = "0%"
chart.Views(0).DataLabels.NumberFormat.IsSourceLinked = False
chart.Views(0).DataLabels.NumberFormat.FormatCode = "0%"
chart.Views(0).DataLabels.NumberFormat.IsSourceLinked = False
#End Region ' #DataLabelsNumberFormat
See Also