In this section the following topics is described:
- Copy Sheet
- Filter Sheet
- Refresh Sheet
When copying a worksheet, using the OfficeReports feature in the menu, all OfficeReports settings for tables, charts and text lists in the worksheet are saved.
This is a nice feature, for example if you have many tables on a sheet, all with no filters. Now if you need all the same tables but new with a filter, this is an easy way to create these many tables.
We recommend that you use this feature to copy worksheets containing OfficeReports tables/charts/text lists.
If you need a general filter for all tables/charts/texts list in one worksheet, this feature can be useful.
this filter setting will overrule any individual filter that has already been added to the tables/charts/text list on the worksheet.
Refreshes all OfficeReports content on the selected sheet.