Table Filter, Charts & Spreadsheets for Confluence - Knowledge base

Page tree

Versions Compared

Old Version 9

changes.mady.by.user Alexey Mikhaylov

Saved on

compared with

New Version Current

changes.mady.by.user Katerina Rudkovskaya

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


Derive cell ranges from spreadsheets to reuse across your Confluence instance.

The Table Spreadsheet Include macro allows you to use cell ranges from Table Spreadsheet as excerpts in other Confluence pages.

Info

Changing the source Table Spreadsheet will dynamically change corresponding excerpts on other pages.

NOTE: The content of Table Spreadsheet Include is not available for editing, only the source Table Spreadsheet can be edited.

Section
Column
width50%

Source Table Spreadsheet

Source Table Spreadsheet

Column
width50%

Table Spreadsheet Include (an excerpt from the Table Spreadsheet on the left)

Tip

You can easily change the columns width with the help of our Table Transformer.

Table Spreadsheet Include (an excerpt from the Table Spreadsheet on the left)

Adding the Table Spreadsheet Include Macro to a Page

Two options are possible:

  1. Start entering {Table Spreadsheet} and select the macro, OR

  2. On the editor pane, clickInsert more content -> Other macros, find the macro and insert it on the page

Two options are possible:

  1. Start entering /Table Spreadsheet (or {Table Spreadsheet} in the legacy editor) and select the macro, OR

  2. On the editor pane, clickInsert -> View more, find the macro and insert it on the page

Handy Carousel
delay1000
items0

Handy Carousel
delay1000
items0


Using the Table Spreadsheet Include Macro

  1. Specify the name of the page where Table Spreadsheet is located.
  2. Select the specific spreadsheet attachment (if there is only one on the page, it is selected automatically).
  3. Select the specific sheet in your spreadsheet to make an excerpt from (if there is only one sheet, it is selected automatically).
  4. Specify the range in the sheet to make an excerpt of it (you can also select the range in the spreadsheet displayed in the right section of the Table Spreadsheet macro browser).