SpreadJS 13
SpreadJS Documentation / Developer's Guide / Features / Manage Data Visualization and Objects / Slicer / Table Slicer with the SpreadJS Designer
In This Topic
    Table Slicer with the SpreadJS Designer
    In This Topic

    You can create a slicer for a table using the SpreadJS Designer.

    Use the following steps to add a slicer.

    1. Add table data and insert a table using the Table option under the Insert tab.

      Table option under the Insert tab

    2. Select the Insert Slicer option under the Tools section.

      Insert Slicer option under the Tools section

    3. The Insert Slicer dialog is displayed. Select the column or columns to create a slicer for.

      nsert Slicer dialog

    4. Use the Options tab to set the caption, height, width, number of columns, and styles.

      Options tab

    5. Use the Slicer Settings dialog in the Slicer section to set additional options for the slicer such as whether to display a header, and so on.

      Slicer Settings dialog

    You can also display a context menu for the slicer by right-clicking on the slicer.

    Context menu for slicer

    The Size and Properties option in the menu displays the following Format Slicer dialog. The dialog contains Position and Layout, Size, and Properties tabs.

    The Format Slicer dialog allows you to set the horizontal and vertical location of the slicer, number of columns, whether to disable resizing and moving the slicer, the scale width and height based on the original size, whether to move and size with cells, and so on.

    Position and Layout tab in Format Slicer dialog

    Size tab in Format Slicer dialog

    Properties tab in Format Slicer dialog

    See Also