addSelectedSeries (value);
value. Sets a series or series array.
The addSelectedSeries method adds series to an array of selected series.
To execute the example, the page must contain the WorkbookBox component named workbookBox (see Example of Creating the WorkbookBox Component), and also add the following code in the handler, that processes document opening event:
var gv = workbookBox.getDataView().getGridView();//._TabSheet
var addSelectedSeries = new PP.Ui.Button({
ParentNode: document.body, //DOM parent object
Content: "AddSelectedSeries", //text
Click: PP.Delegate(AddSelectedSeriesOnClick)
});
function AddSelectedSeriesOnClick()
{
//Get an instance of the PP.TS.Workbook class
var source = wbk.getActiveSheet();
//Get array of series of workbook data model
var series = source.getSeries();
//Remove all selected series from the array of selected workbook series
source.removeAllSelectedSeries();
//Select all chosen series
for (var i = 0; i<series.length; i++)
{
wbk.addSelectedSeries(series[i]);
}
var selSers = wbk.getSelectedSeries();
selectedIndexSeries = new Array();
for (var i = 0; i < selSers.length; i++)
{
selectedIndexSeries.push(selSers[i].index);
}
var selectedIndexCols = new Array();
for (var i = 0; i < gv._TabSheet._Model._Measures._MaxColumn; i++)
{
selectedIndexCols.push(i);
}
//Set selected workbook series
tsService.setSelectedSeries(wbk, selectedIndexSeries, selectedIndexCols, function (){});
//get arrays of selected workbook series and columns
var selRows = source.getSelectedIndexSeries();
var selCols = source.getSelectedIndexCols();
//Select component to display workbook table (LanerBox)
gv._GridSelection._SelectedAreas[0].Range._Corners.blCoord.colIndex = selCols[0]+2;
gv._GridSelection._SelectedAreas[0].Range._Corners.blCoord.rowIndex = selRows[selRows.length-1]+1;
gv._GridSelection._SelectedAreas[0].Range._Corners.brCoord.colIndex = selCols[selCols.length-1];
gv._GridSelection._SelectedAreas[0].Range._Corners.brCoord.rowIndex = selRows[selRows.length-1]+1;
gv._GridSelection._SelectedAreas[0].Range._Corners.tlCoord.colIndex = selCols[0]+2;
gv._GridSelection._SelectedAreas[0].Range._Corners.tlCoord.rowIndex = selRows[0]+1;
gv._GridSelection._SelectedAreas[0].Range._Corners.trCoord.colIndex = selCols[selCols.length-1];
gv._GridSelection._SelectedAreas[0].Range._Corners.trCoord.rowIndex = selRows[0]+1;
workbookBox.getDataView()._TabStatPanel.expand();
workbookBox.getDataView()._TabStatPanel.collapse();
}
After executing the example a button named AddSelectedSeries is placed in the HTML page. Clicking this button selects all series in workbook table.
See also: