isLeadSerie (serie);
serie. Sets series index.
The isLeadSerie method determines whether specified series is calculated using the Lead formula.
This method returns True if formula type of the series passed to the method as a parameter, is Lead, otherwise the method returns False.
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 getIsLeadSerieButt = 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 Lead formula PP.TS.isLeadSerie(series[i]) ? addLeadSerieString(i) : addLeadModSerieString(i); } function addLeadSerieString(rowIndex) { messageString = messageString + "The series number " + i + " - has the Lead formula type" + '\n'; } function addLeadModSerieString(rowIndex) { messageString = messageString + "The series number " + i + " - has the formula type that differs from the Lead 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 Lead formula.
See also: