PP.TS.isAggregationSerie

Syntax

isAggregationSerie (serie);

Parameters

serie. Sets series index.

Description

The isAggregationSerie method determines whether specified series is calculated using an Aggregation formula.

Comments

This method returns True if formula type of the series passed to the method as a parameter, is Aggregation, otherwise the method returns False.

Example

To execute the example, the page must contain the WorkbookBox component named workbookBox (see Example of Creating the WorkbookBox Component), and the following code must be added in the document opening event handler:

var getIsAggregationSerieButt = new PP.Ui.Button({
	ParentNode: document.body, //DOM parent node
	Content: "Get Series Type", //Text      
	Click: PP.Delegate(onClickType)     
}); 
function onClickType()
	{
		var series = wbk.getSeries();
		var messageString = "";					
		for (var i = 0; i<series.length; i++)
			{
				//Determine whether the specified series is calculated by the Aggregation formula
				PP.TS.isAggregationSerie(series[i]) ? addAggregationSerieString(i) : addNonAggregationSerieString(i);				
			}
		function addAggregationSerieString(rowIndex)
			{
				messageString = messageString + "The series number " + i + " - has the Aggregation formula type" + '\n';
			}
		function addNonAggregationSerieString(rowIndex)
			{
				messageString = messageString + "The series number " + i + " -  has the formula type that differs from the Aggregation type" + '\n';
			}	
		alert(messageString);
	}

After executing the example the button named Get Series Type is placed in HTML page. Clicking this button shows a message on whether the series available in the table are calculated using the Aggregation formula.

See also:

PP.TS