|
Available in the following macros:
Table Filter
Pivot Table
Chart from Table
Table Transformer
Steps to export:
On the filtration or control pane, locate the cogwheel icon and click it.
Click Export to PDF.
Save the file to your local computer for opening.
Available in the following macros:
Table Filter
Pivot Table
Chart from Table
Table Transformer
Steps to export:
Available in the folloving macros:
Table Filter
Pivot Table
Table Transformer
The add-on allows you to export data to CSV, as follows:
The default CSV format uses the following parameters:
The сustom CSV format uses the following parameters:
To export filtered data or pivot table to CSV (with default settings):
To export hyperlinks as clickable links to CSV:
|
To export filtered data or pivot table to CSV (with custom settings):
Available in the folloving macros:
Chart from Table
Steps to export:
Apply the required filters to your data table or configure the pivot table or chart.
Chose any export option.
All the information from the page will be exported.
The app supports space and page tree export from the version 4.4.x. If macros were created in the version of the app 4.3.x or older version you need to view every page containing macros before the first export (i.e. once) to prepare it for export. |
Note that after changing page permissions for a user, viewing the restricted data within the Table Filter, Charts & Spreadsheets app macros is still possible in the space, the page tree export to PDF or Word until this user or another with the same restrictions revisit the page.The reason for this is that the user has already viewed or exported restricted data on the page earlier. |
You can share the results achieved with the filtration pane of Table Filter with your colleagues. The sharing link contains all the necessary filtration parameters and the sorting order that can temporarily override the currently set filtration parameters and sorting. The saved filtration parameters are not affected anyhow by this method until you rewrite them by saving changes.
To share the filtration results:
See also a blog post: One-Click Table Filtration in Confluence |
To display export features as links, you can create a user macro.
If you have only one Table Filter, Pivot Table or Chart from Table macro on the page, then create the following user macro and insert it on the page:
## @noparams <a href="#" onclick="$('.export-file-csv').eq(0).click();return false">Export to CSV</a> |
## @noparams <a href="#" onclick="$('.export-file-pdf').eq(0).click();return false">Export to PDF</a> |
## @noparams <a href="#" onclick="$('.export-file-doc').eq(0).click();return false">Export to Word</a> |
If you have multiple macros on the page, then create the following user macro and insert it inside one or multiple macros:
## @noparams <a href="#" onclick="$(this).parents('.tablefilter-outer-wrapper, .pivot-content, .table-chart-contents').eq(0).find('.export-file-csv').eq(0).click();return false">Export to CSV</a> |
## @noparams <a href="#" onclick="$(this).parents('.tablefilter-outer-wrapper, .pivot-content, .table-chart-contents').eq(0).find('.export-file-pdf').eq(0).click();return false">Export to PDF</a> |
## @noparams <a href="#" onclick="$(this).parents('.tablefilter-outer-wrapper, .pivot-content, .table-chart-contents').eq(0).find('.export-file-doc').eq(0).click();return false">Export to Word</a> |
|