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.
Conditional formatting
- Select a table
- Choose Conditional formatting on the editor pane
- Select a suitable formatting preset or set your own rule
Nesting Table Spreadsheet inside other Table Filter and Charts macros
Table Spreadsheet supports nesting inside the following macros within the Table Filter and Charts app: Table Filter, Pivot Table, Table Transformer, Chart from Table, Table Excerpt. and Table Toolbox.
- Locate the page with the Table Spreadsheet macro.
- Switch the page to the edit mode.
- Add one/multiple Table Filter and Charts macros to be further combined with your Table Spreadsheet.
- Wrap your Table Spreadsheet with the added macro/macro combination.
- Configure the macro/s to fit your needs.
- Save the macro/s and the page.
- Locate the page with the Table Spreadsheet macro.
- Switch the page to the edit mode.
- Add one of the Table Filter and Charts macros to be further combined with your Table Spreadsheet.
- Wrap your Table Spreadsheet with the added macro.
- Configure the macro to fit your needs.
- Save the macro and the page.
To combine your Table Spreadsheet with multiple Table Filter and Charts macros in the Cloud version wrap it with the Table Toolbox macro .