Versions Compared

Old Version 1

changes.mady.by.user Nikita Kamai

Saved on

compared with

New Version Current

changes.mady.by.user Katerina Kovriga

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Published by Scroll Versions from space TFAC and version Draft
Excerpt
hiddentrue


Add and delete Table Filter and , Charts & Spreadsheets' macros in your Confluence instance.

Read more:

Inserting the macros

In the page view mode

To enable live filtration in headers:

To add macros live (i.e. in view mode):

  1. Click the More actions (⋯) menu in the top-Click the Image Removed button on the top right corner of the page beside the Edit button..
  2. Go to Apps → Use Table Filter App Macros.
  3. Choose the required preset and follow Click Enable in the dialog.Start

For example, choose the Table Filter macro and start filtering data

in 

in table headers.

Handy Tip
id34860480447012954

Learn more on this page .

Image Modified

Image Removed Image Removed
Handy Carousel

 Image Added

Image Added

Info

Utilize the benefits of Excel-like spreadsheets right on your Confluence pages. Try spreadsheets for Confluence now!

Learn more about live table filtration in headers on this page.

To insert the macros:

  1. Open a page with a table.
  2. Hover over the table.
  3. Click the  icon.
  4. Select one of the options:
    • Filter table data  (to display the filtration panel)
    • Create a pivot table
    • Create a chart from data series .
Info

You can disable the inline macro insertion and live filtration on a global or individual basis.

Through the action icon in the editor 

  1. Switch Confluence page to the edit mode.
  2. Position the mouse pointer within Place the cursor inside the table.
  3. On the editor pane, click the Filter table data  or Create a pivot table  or Create a chart from data series icon.

Manual

entrying

entering

  1. Switch Confluence page to the edit mode.
Position the mouse pointer in the appropriate place on the page
  1. Click on the line where you want to insert the macro.
  2. Start entering
    {
      • /Table Filter
    }
      • ,
      {
      • /Pivot Table
    }
      • ,
     {
      • /Chart from Table
    }
      • ,
     {
      • /Table Transformer
    }
      • ,
    {
      • /Table
    Excerpt}, {Table Excerpt Include}, {Table from CSV}
      • Toolbox, etc. (for the
    legacy
      • new editor on Cloud)
    /
      • {Table Filter},
     /
      • {Pivot Table},
     /
      • {Chart from Table},
    /
      • {Table Transformer},
    /
      • {Table
    Excerpt, /Table Excerpt Include, /Table from CSV, /Table Toolbox
      • Toolbox}, etc. (for the
    new
      • legacy editor on Cloud )
    2. From the prompted list of macro choices, select the macro.
    3. Place the table within the macro.

    Image Added

    1. Switch Confluence page to the edit mode.
    Position the mouse pointer in the appropriate place on the page
    1. Click on the line where you want to insert the macro.
    2. Start entering
      • {Table Filter},
     
      • {Pivot Table},
     
      • {Chart from Table},
     
      • {Table Transformer}, {Table Excerpt},
     
      • {Table
    Excerpt Include}, {Table
      • from CSV}, etc. 
    2. From the prompted list of macro choices, select the macro.
    3. Place the table within the macro.

    Image Modified

    Selecting in the Select macro form

    1. Switch Confluence page to the edit mode.

    2. Position the mouse pointer in the appropriate place on the pageClick on the line where you want to insert the macro.

    3. On the editor pane, click Insert more content -> Other macros.

    4. In the Select Macro form, find the macro and insert it on the page.

    5. Place the table within the macro.


    Image Added

    Copying a table into the macros 

    1. Switch Confluence page to the edit mode.
    2. Position Place the mouse pointer cursor into any cell of the table you want to copy.
    3. Click the Copy Table  icon on the editor pane.
    4. Paste the table into the Table Filter / Pivot Table / Chart from Table macro on the same or on a new page.
    Info

    To copy a table into the macro in Confluence Cloud legacy editor highlight the table (as shown in the screencast below), copy and paste it into the macro body:

    Panel
    borderColor#3b7fc4
    titleColor#FFFFFF
    titleBGColor#3b7fc4
    borderStylesolid
    titleCopying a table in Confluence Cloud

    Removing the macros from tables

    In the page view mode (Table Filter, Pivot Table, Chart from Table)

    1. Click the cogwheel icon on the filtration panel or on the pivot table or chart control panel.
    2. Select the Remove the macro option.
    3. Click Remove in the dialog.

    Image RemovedImage Added

    In the page edit mode (all the macros)

    1. Switch Confluence page to the edit mode.
    2. Copy the table and paste it outside the macro body.
    3. Select the macro and click Remove.

    Image Added

    1. Switch Confluence page to the edit mode.
    2. Select the Table Filter/Pivot Table/Chart from Table/Table Transformer/Table Excerpt macro.
    3. Click Unwrap.
    Info

    You can remove all the macros bundled with the app from your pages on the global level.

    Image Modified

    Configuring inline macro insertion and live filtration

    On the global level
    Anchor
    Configuringinlinemacroinsertion
    Configuringinlinemacroinsertion

    1. Navigate to Confluence administration console.
    2. On the sidebar, locate the Table Filter and , Charts & Spreadsheets menu group. Select Select Configuration .
    3. To enable inline macro insertion/live filtration globally, check the corresponding box.
    4. Define additional parameters, as follows:
      • Groups - enter the names of user groups who can use the inline macro insertion/live filtration.
      • Individual users - enter the names of individual users who can use the inline macro insertion/live filtration.
      • Anonymous - check the box to allow anonymous users to use the inline macro insertion/live filtration.

    To disable inline macro insertion/live filtration:

    1. Clear the Inline macro insertion box.

    To disable inline macro insertion/live filtration for the group/user:

    1. Click the  icon for a specific user or group.
    Handy Carousel

    Image Removed Image RemovedImage Added Image Added

    On the user's level
    Anchor
    Configuringinlinemacroinsertionindividual
    Configuringinlinemacroinsertionindividual

    To enable inline macro insertion/live filtration:

    1. In the top-right part of the screen, locate your profile picture and click it.

    2. Select Settings.

    3. On the navigational sidebar, select select Table Filter and , Charts & Spreadsheets.

    4. Select the Inline macro insertion or live filtration options.

    To disable inline macro insertion/live filtration:

    1. Clear the option.
    Info

    This modification will override the global configuration settings for user groups you are associated with.

    Image Removed

    Image Added

    Hiding inline macro insertion and live filtration buttons

    Add the following CSS to the global, space stylesheet or the HTML macro to hide buttons for the whole instance, for a space or the specific page: 

    To hide all buttons:

    Code Block
     #tfac-macro-inserter, #tfac-macro-inserter-container, .tf-inline-filter:not(.btn, .trigger) {
  display: none !important;
 }

    To hide one of three inline insertion buttons:

    • Table Filter button
    Code Block
    #tfac-macro-inserter [data-macro="table-filter"] {
display: none !important;
}
    • Pivot Table button
    Code Block
    #tfac-macro-inserter [data-macro="pivot-table"] {
display: none !important;
}

    • Chart from Table button

    Code Block
    #tfac-macro-inserter [data-macro="table-chart"] {
display: none !important;
}
    Info

    You can combine CSS to hide two of three buttons.

    Info

    Add <style> ...</style> to CSS in the HTML macro.

    Code Block
    <style>
#tfac-macro-inserter, #tfac-macro-inserter-container, .tf-inline-filter:not(.btn, .trigger) {
    display: none !important;
 }
</style>
    Handy Carousel

    Removing all the macros from pages
    Anchor
    REMOVEALLMACROS
    REMOVEALLMACROS

    The Table Filter and , Charts app & Spreadsheets app allows you to remove all the macros bundled with the app, including the following:

    • Table Filter
    • Pivot Table
    • Chart from Table
    • Table Transformer
    • Table Excerpt
    • Table Excerpt Include

    The source data tables and macros outputting table data will not be affected anyhow and will be preserved in your Confluence after completion of the procedure.

    To remove all app macros from Confluence pages:

    Note

    Please perform the full Confluence backup prior to running this procedure. This operation may require some time depending on the size of your Confluence and number of app's macros on your Confluence pages.

    1. Switch to the Add-on Macro Cleanup tab.
    2. Click Clean up.
    3. Confirm the operation.