SpreadJS 15
Features / Pivot Table / Context Menu
In This Topic
    Context Menu
    In This Topic

    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

      Context menu of page area

    2. Any empty area

      Context menu of blank area

    3. The header area

      Context menu of header area

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

      Context menu of data type (number)

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

      Context menu of data type (date)

    6. The data area

      Context menu of data area

    7. The grand total area

      Context menu of 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 grand data area context menu to open the dialog window.

    If the field type is either Number or Date, the "Number Format" button is shown on the dialog.

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

    Label format

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