ChartDataResolver Class
Resolves chart series data from cell range formulas.
Inheritance
Object
Documents.Spreadsheet.ChartDataResolver
Namespace: Radzen.Documents.Spreadsheet
Assembly: Radzen.Blazor.dll
Syntax
public static class ChartDataResolverMethods
ParseRangeFormulalink
Parses a range formula like "Sheet1!$A$2:$B$10" or "$A$2:$B$10" into a sheet name and range.
Declaration
public static ValueTuple<string, Documents.Spreadsheet.RangeRef> ParseRangeFormula(string formula)Parameters
| Type | Name | Description |
|---|---|---|
| string | formula |
Returns
| Type | Description |
|---|---|
| ValueTuple<string, Documents.Spreadsheet.RangeRef> |
ResolveSeriesDatalink
Resolves chart data points for a series definition from the workbook. Falls back to cached values when live resolution fails.
Declaration
public static List<Documents.Spreadsheet.ChartDataPoint> ResolveSeriesData(Documents.Spreadsheet.ChartSeries series, Documents.Spreadsheet.Workbook workbook, Documents.Spreadsheet.Worksheet currentSheet)Parameters
| Type | Name | Description |
|---|---|---|
| Documents.Spreadsheet.ChartSeries | series | |
| Documents.Spreadsheet.Workbook | workbook | |
| Documents.Spreadsheet.Worksheet | currentSheet |
Returns
| Type | Description |
|---|---|
| List<Documents.Spreadsheet.ChartDataPoint> |