Context Menu

SpreadJS provides different context menu options while accessing different areas of a pivot table. These options allow you to quickly execute the common or repetitive operations in the pivot table. The context menu appearing for different areas of a pivot table, when right-clicked, is shown below:

1. The page area

   
   

   
   

2. Any empty area

   
   

   
   

3. The header area

   
   

   
   

4. The data type (number) and select the 'Group' option

   
   

   
   

5. The data type (date) and select the 'Group' option

   
   

   
   

6. The data area

   
   

   
   

7. The Grand Total area

   
   

   
   

Custom Format in Value Fields

SpreadJS supports custom formats for value fields in a pivot table. Choose the "Value Field Settings..." option from the data area or the grand data area context menu to open the dialog window.

The "Number Format" button is shown on the dialog if the field type is either Number or Date.

The "Label Format" button is shown on the dialog if the field type is not Number or Date.

Both the above button open the same "Format Cells" window where you can set custom formats.