getColTotalsButton();
The getColTotalsButton method returns the Column Totals button on the express report tool ribbon.
The method returns an object of the PP.Ui.SplitButton type. On the tool ribbon this button looks as follows:
Executing the example requires that the HTML page contains the ExpressBox component named expressBox (see Example of Creating the ExpressBox Component). In the example given below the following information is displayed: button names, and row's and column's index in the icon table:
var category; getImageInfo = function(button) { // Output button name var str = button.getContent() + ". "; if (button instanceof PP.Ui.SplitButton) { str += "Row index: " // Output row index in icons table str += button.getImageButton().getRowIndex(); str += ", Column index: " // Output column index in icons table str += button.getImageButton().getColumnIndex(); } console.log(str); } // Get view of the Table tab category = expressBox.getRibbonView().getTableCategory(); getImageInfo(category.getColTotalsButton()); getImageInfo(category.getCondFormatButton()); getImageInfo(category.getIndButton()); getImageInfo(category.getRowsTotalsButton()); // Get view of the Data tab category = expressBox.getRibbonView().getDataRibbonCategory(); getImageInfo(category.getFilterButton()); getImageInfo(category.getRankingButton()); getImageInfo(category.getTypeDataButton()); // Get view of the Title tab category = expressBox.getRibbonView().getTitleCategory(); getImageInfo(category.getTitleButton()); // Get view of the View tab category = expressBox.getRibbonView().getViewRibbonCategory(); getImageInfo(category.getDimViewModeButton());
After executing the example the browser console displays the following text:
Column totals. Row index: 5, Column index: 5
Conditional formatting. Row index: 3, Column index: 4
Growth indicator. Row index: 2, Column index: 19
Row totals. Row index: 5, Column index: 4
Filter. Row index: 3, Column index: 1
Show as ranks. Row index: 2, Column index: 18
Convert data. Row index: 1, Column index: 18
Title. Row index: 3, Column index: 20
Side<br />panel.
See also: