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

   
   

   
   

   
   

   
   

   
   

   Note:

   The Number of days option applies only when Days is selected as the only grouping interval. When Days is combined with other intervals (for example, Months, Quarters, or Years), the option is disabled and appears grayed out.

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.

When you operate the PivotTable Panel in the SpreadJS Designer,

1. 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 typeis not Number or Date.

   
   

   
   

2. Click the Number Format or Label Format button, a designer Number Format dialog with richer settings will pop up.