ClassWorkbookFormulaChartData
Formula-based chart data that resolves to cell ranges within a workbook for dynamic chart series and values.
Definition
Namespace:Telerik.Windows.Documents.Spreadsheet.Model.Charts
Assembly:Telerik.Windows.Documents.Spreadsheet.dll
Syntax:
public class WorkbookFormulaChartData : FormulaChartData, IChartDataInheritance: objectFormulaChartDataWorkbookFormulaChartData
Implements:
Inherited Members
Constructors
WorkbookFormulaChartData(Workbook, string)
Initializes a new WorkbookFormulaChartData with a formula string that references chart data in the workbook.
WorkbookFormulaChartData(Worksheet, params CellRange[])
Initializes a new WorkbookFormulaChartData from cell ranges in the specified worksheet.
Properties
Methods
Clone()
Creates a deep copy of this chart data instance with the same formula and workbook reference.
Declaration
public override IChartData Clone()Returns
The deep copy of the object.
Overrides
EnumerateCellRanges(out Worksheet)
Resolves the formula to cell ranges and returns them along with the containing worksheet.
Declaration
public IEnumerable<CellRange> EnumerateCellRanges(out Worksheet worksheet)Parameters
worksheet
Returns
IEnumerable<CellRange>
The result cell ranges.
Exceptions
Thrown when the formula referring to the data cannot be parsed to cell ranges.
TryEnumerateCellRanges(out IEnumerable<CellRange>, out Worksheet)
Attempts to resolve the formula to cell ranges and returns whether the resolution succeeded.
Declaration
public bool TryEnumerateCellRanges(out IEnumerable<CellRange> resultCellRanges, out Worksheet worksheet)Parameters
resultCellRanges
IEnumerable<CellRange>
The result cell ranges.
worksheet
The worksheet the cell ranges are located in.
Returns
A value indicating whether the ranges have been retrieved.