Set up the Advanced Table Viewer macro features

The Advanced Table Viewer macro setup mode enables you to set the initial feature configurations for using the macro. The macro setup mode is a full screen view to provide data visibility and a smoother configuration experience of data source and table display options.

The macro provides various features that you can set up and access in both Confluence page view and edit mode.

• It offers a simplified version of the column filtering, row styling, search, row numbering, sort, download, and sum-up features.

• You can enable these features in setup mode to use in Confluence page view and edit mode.

• When you add a new macro, the search and sort features are enabled by default.

• The features configured in macro setup mode are saved as the default for every refresh of the Confluence page.

Macro setup mode

To configure the features, navigate to the macro’s setup mode. Only users with edit permissions can access the setup mode.

1. Open the Confluence page containing the Advanced Table Viewer macro.

2. Edit the Confluence page.

3. Edit the Advanced Table Viewer macro to navigate to the setup mode.

Open

The macro setup mode opens in full-screen view.

• The left panel displays a preview of the data imported from the data source.

• The right panel displays the available feature configurations.

4. To enable or disable any of the features, click the specific feature icon.

   Open

   

   The feature configurations are available at the table and column level.

• Table properties

  • The right panel displays the available feature configuration at the table level.

  • The table properties apply to the entire table, affecting all columns and rows within a single macro.

  • The release offers a simplified version of row styling, search, row numbering, sort, and download features at the table level.

• Column properties

  • The column features apply specifically to the configured table columns.

  • The macro offers a simplified version of the column-level feature, Rename heading, and Sum-up type.

    Open

    

To edit the Data Source in the setup mode, click Edit Data Source on the right panel. The Data Source dialog opens. For more information, refer to Configure Advanced Table Viewer macro - cloud.

Open

Advanced Table Viewer macro features

The Advanced Table Viewer macro table and column properties are listed below.

Table properties

In the right panel, you can enable or disable the macro table features.

• Column filtering: Enable Column filtering to configure column filters for individual columns and filter table data based on specific column values. For more information, refer to Column filtering with Advanced Table Viewer macro - cloud.

  Open

  

• Search: The search feature is enabled by default. It allows to perform a dynamic search on the table data. For more information, refer to Search with Advanced Table Viewer macro - cloud.

  Open

  

  Search

• Row numbering: Enable the row-numbering option to display a column with row numbers and Save the macro.
  Open

  

  Row numbering

• Sort: The Sort option is enabled by default. It allows the sorting of the column values. For more information, refer to Sorting with Advanced Table Viewer macro - cloud.

  Open

  

  Sort

• Download

  • Enable the download option and Save the macro to allow the download of the current table data as a CSV file.

    Open

    

    Download

  • When enabled, the download button is displayed at the top right of the table on the Confluence view and edit page mode. Click Download, and the file is downloaded to your local file system.

    Open

    

• Row Styling: Apply row colors and highlight table rows using the row styling option.

  • Row styling includes two features: Row coloring and Row highlighting. For more information about how to apply row styles, refer to Row styling with Advanced Table Viewer macro - cloud.

    Open

    

Column properties

The Advanced Table Viewer macro offers column-level features, Rename heading, and Sum-up type. To set up the column properties, click the Edit column option ( ).

Open

Edit Column

• Rename heading: Rename the column names after importing the data from the data source. For more information, refer to Rename the table column name with Advanced Table Viewer macro - cloud.

  Open

  

• Sum-up: Automatically calculate and display the Sum, Average, Minimum, Maximum, Count, and Distinct for column values. For more information on how to set up the sum-up type, refer to Summarize column values with Advanced Table Viewer macro.

  Open

  

  Edit sum-up type