How to display advanced table(s) on a Confluence page?
A Spreadsheet table can be rendered in a Confluence page as a Table or as an Icon. The rendering mode is selected when editing the page itself. When editing a page, click on the Spreadsheet macro and select the Properties button.
A pop-up window will appear in which the rendering mode can be selected:
Display options
Option | Effect |
|---|---|
Table | Your Spreadsheet document will be rendered as an HTML table inside you Confluence page. |
Icon | An icon is displayed with the document name. Clicking on it will open the document in full-screen |
If your document is displayed as an icon, the other properties below are not available.
Buttons options
By default, these buttons are added on the top of the Spreadsheet document rendered as a table :
Spreadsheet buttons options
Full-screen: opens your document in read-only mode
Edit: opens you document in the Spreadsheet editor
Export: exports your document to the Microsoft Excel format (.xlsx)
You can chose to not display these buttons by selecting "No" for the "Show buttons" options.
Width options
Option | Effect |
|---|---|
Same as editor | Your Spreadsheet document original width is conserved. Some scrollbars are added if the document is too large for the Confluence page. |
Fill all the available space | Your Spreadsheet document will try to fit the Confluence page width. This option is not recommended for large documents. |
View options
By default, all tab sheets of your Spreadsheet document are rendered in your Confluence page:
Spreadsheet with diffrent tabs
Viewers can select the sheet to display by clicking on the sheet tab. However, you can select which sheets are displayed by clicking on "Selected sheets" for the "View" option :
View selected sheets in Spreadsheet
Then, you can select one ore more sheets to display via the "Visible sheets" drop-down list :
Set visible sheets in Spreadsheet
The displayed sheets are listed under the "Visible sheets" option. Some actions are available on the sheet list :
Icon | Feature | Description |
|---|---|---|
Sheet order - Up | Change the position of the sheet tab in the Confluence page | |
Sheet order - Down | ||
Remove sheet | Remove the sheet from the displayed sheet list |