FarPoint.Win.Spread.Chart.SpreadChart.GenerateFromCellRanges

GenerateFromCellRanges Method

GenerateFromCellRanges(SheetView, CellRange[], bool)

Generates from cell ranges.

Declaration

public void GenerateFromCellRanges(SheetView sheetView, CellRange[] cellRanges, bool autoSwitch)

Public Sub GenerateFromCellRanges(sheetView As SheetView, cellRanges As CellRange(), autoSwitch As Boolean)

Parameters

Type	Name	Description
SheetView	sheetView	The sheet view.
CellRange[]	cellRanges	The cell ranges.
bool	autoSwitch	if set to `true`, the processing will switch rows and columns automatically if necessary.

GenerateFromCellRanges(SheetView, CellRange, CellRange, CellRange, bool, bool)

Generates from cell ranges.

Declaration

public void GenerateFromCellRanges(SheetView sheetView, CellRange category, CellRange seriesName, CellRange data, bool autoSwitch, bool autoCreateCategory)

Public Sub GenerateFromCellRanges(sheetView As SheetView, category As CellRange, seriesName As CellRange, data As CellRange, autoSwitch As Boolean, autoCreateCategory As Boolean)

Parameters

Type	Name	Description
SheetView	sheetView	The sheet view.
CellRange	category	The category.
CellRange	seriesName	Name of the series.
CellRange	data	The data.
bool	autoSwitch	if set to `true`, the procesing will switch row and column automatically if it's necessary.
bool	autoCreateCategory	if set to `true`, the generating process will auto detect and create category if the category cell range is NULL.

GenerateFromCellRanges(SheetView, CellRange, CellRange, CellRange, bool)

Generates from cell ranges.

Declaration

public void GenerateFromCellRanges(SheetView sheetView, CellRange category, CellRange seriesName, CellRange data, bool autoSwitch)

Public Sub GenerateFromCellRanges(sheetView As SheetView, category As CellRange, seriesName As CellRange, data As CellRange, autoSwitch As Boolean)

Parameters

Type	Name	Description
SheetView	sheetView	The sheet view.
CellRange	category	The category.
CellRange	seriesName	Name of the series.
CellRange	data	The data.
bool	autoSwitch	if set to `true`, the procesing will switch row and column automatically if it's necessary.