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