Pivot Table Management?

Webix JS
#1

Hi there…

  1. How can I trap a double click on a pivot table row?
  2. How can I format the number format of values on a pivot?
  3. How can I change the color of the parent rows (group rows) on a pivot?

Thanks a lot

#2

Hey @Mashiane,

1\. Do you mean you want to capture a double click event happening in the pivot table? This is possible with the help of the onDblClick event handler, which allows to track the double click behaviour happening when clicking items with a specified CSS class (in this case we are looking for the .webix_cell class).

Please take a look at this example: https://snippet.webix.com/3t8uch21.

2\. It is possible to set the format inside of the value definition: https://snippet.webix.com/ueg5o30n.

3\. You can iterate over all of the rows and find the ones that don’t have a parent (top level), or simply the ones at the top level (1) and use the addRowCss method to add a custom CSS class with your own styles (i.e. a custom background color): https://snippet.webix.com/gagifkbo.

#3

Thank you so much!