The Table Spreadsheet macro allows you to add an Excel-like spreadsheet. You can work with it both in the page view and page edit mode.
Adding the Table Spreadsheet macro
1. Insert the macro on a page:
Start entering /Table Spreadsheet and select the macro
On the editor pane, clickInsert -> View more, find the macro and insert it on the page
The page stores your spreadsheet as an attachment. You can find more information about the attachment or download the file in the page settings.
Main functions of the Table Spreadsheet macro
Text settings (font, size, type, color)
Border style and color
Alignment and text placement
Export to CSV
Import of Excel (xlsx, csv, ods formats)
The following info regarding the import formats should be noted:
xlsx format partially supports formatting;
charts, pivot tables and conditional formatting are not supported to import from Excel currently.
Filtering the spreadsheet
Click the funnel icon on the editor pane
To sort the spreadsheet, choose the sorting type
To filter the spreadsheet, select a column and click Create filter
Choose a condition to filter the column by
Confirm the settings or clear the filter, if no longer needed
Adding a pivot table
Select the pivot table macro on the editor pane
On a new sheet, choose the settings
Adding a chart
Select the chart macro on the editor pane
Choose chart settings
The following chart types are available:
Select a table
Choose Conditional formatting on the editor pane
Select a suitable formatting preset or set your own rule
Reusing of the Table Spreadsheet macro
Save data in the Table Spreadsheet macro via File->Save(to have a generated name) or via File->Save As(to name it yourself).
Get to the page you wish for the spreadsheet's new location. Open the page in the edit mode and insert the Table Spreadsheet macro. Open the spreadsheet created earlier via File->Open->type your spreadsheet's name.
Once any changes on the page are added and saved, it will affect all the spreadsheets, treated as the same spreadsheet. The attachment, however, will be placed only on the source page where the spreadsheet was originally created and saved.
To make an independent copy of the spreadsheet to work with it further on, i.e. add it as an attachment of the selected page and reform it without affecting the original one, save the spreadsheet on the page with another name via File->Save As->type your name->Save