Back to Devexpress

NumberFormatOptions.IsSourceLinked Property

officefileapi-devexpress-dot-spreadsheet-dot-charts-dot-numberformatoptions-6374a62b.md

latest5.7 KB
Original Source

NumberFormatOptions.IsSourceLinked Property

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

Declaration

csharp
bool IsSourceLinked { get; set; }
vb
Property IsSourceLinked As Boolean

Property Value

TypeDescription
Boolean

true to obtain a format string from the source cells; otherwise, false.

|

Property Paths

You can access this nested property as listed below:

Object TypePath to IsSourceLinked
Axis

.NumberFormat .IsSourceLinked

| | DataLabelBase |

.NumberFormat .IsSourceLinked

| | TrendlineLabel |

.NumberFormat .IsSourceLinked

|

Remarks

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

csharp
chart.Views[0].DataLabels.NumberFormat.FormatCode = "0%";
chart.Views[0].DataLabels.NumberFormat.IsSourceLinked = false;

winforms-spreadsheet-chart-api/CS/SpreadsheetChartAPISamples/CodeExamples/DataLabelsActions.cs#L60

csharp
chart.Views[0].DataLabels.NumberFormat.FormatCode = "0%";
chart.Views[0].DataLabels.NumberFormat.IsSourceLinked = false;

spreadsheet-document-api-chart-examples/CS/SpreadsheetDocServerChartAPISamples/CodeExamples/DataLabelsActions.cs#L68

csharp
chart.Views[0].DataLabels.NumberFormat.FormatCode = "0%";
chart.Views[0].DataLabels.NumberFormat.IsSourceLinked = false;

wpf-spreadsheet-chart-api/VB/SpreadsheetWPFChartAPISamples/CodeExamples/DataLabelsActions.vb#L64

vb
chart.Views(0).DataLabels.NumberFormat.FormatCode = "0%"
chart.Views(0).DataLabels.NumberFormat.IsSourceLinked = False

winforms-spreadsheet-chart-api/VB/SpreadsheetChartAPISamples/CodeExamples/DataLabelsActions.vb#L63

vb
chart.Views(0).DataLabels.NumberFormat.FormatCode = "0%"
chart.Views(0).DataLabels.NumberFormat.IsSourceLinked = False

spreadsheet-document-api-chart-examples/VB/SpreadsheetDocServerChartAPISamples/CodeExamples/DataLabelsActions.vb#L71

vb
chart.Views(0).DataLabels.NumberFormat.FormatCode = "0%"
            chart.Views(0).DataLabels.NumberFormat.IsSourceLinked = False
#End Region ' #DataLabelsNumberFormat

See Also

FormatCode

FormatCodeLocal

NumberFormatOptions Interface

NumberFormatOptions Members

DevExpress.Spreadsheet.Charts Namespace