We have made the following improvements to tables created by Calculations to make them more consistent with other types of tables in Displayr. These changes impact basic tables created by R in Calculations and not custom formatted tables created by CreateCustomTable.
- Existing R Calculations/tables will automatically upgrade in March 2024
- Upgrading Calculations to the new format
- Calculation tables take up all available space
- Significance testing is retained in calculation tables that reference standard drag-and-drop source tables
- Filter icons in columns and rows are only visible on hover or when activated
- Navigation tools for tables that won't fit on a single page
- Exporting a Paginated Table Created by a Calculation
The following table will serve as the basis for most of the examples included in this article:
Existing R Calculations/tables will automatically upgrade in March 2024
Going forward, you will receive a warning notice that all existing R Calculations/tables will automatically upgrade to the new format in March 2024. This notice will appear at the top of the Object Inspector on the right.
At that time, any existing tables/outputs will change to the new version, meaning that anything with a bounding box larger than the table itself will stretch out and cover more space. Manually upgrading the calculations in advance of the automatic change will help you avoid any issues.
Upgrading Calculations to the new format
To upgrade any calculations in your document to the new format, select a calculation and click one of the buttons in the prompt at the top-right of the object inspector. You can upgrade only the selected calculation by clicking Upgrade or upgrade all of the calculations in the document by clicking Upgrade all tables in this document.
Calculation tables now take up all available space
Tables are automatically stretched to fill all available space it has available. For example, suppose you want to extract the first row from the above table and display it in a calculation.
Significance testing is retained in calculation tables that reference standard drag-and-drop source tables
Calculation tables that are derived from standard tables will automatically retain the significance testing from those tables:
In addition, you can also change the appearance of the arrows or remove them, just like you can in a standard drag-and-drop table.
For example, here is the same table with the arrows but without the different font colors:
Filter icons in columns and rows are only visible on hover or when activated
In prior versions of Displayr, filter icons in columns and rows were visible even before they were applied.
After the upgrade, these icons will only show on hover or after you apply the filter. This change is designed to make the table cleaner and easier to read.
Navigation tools for tables that won't fit on a single page
If a table is too long to display on a single page, the navigation tools below the table will be smaller and less noticeable than they were before.
Exporting a Paginated Table Created by a Calculation
While it is possible to create a table using a calculation where the number of rows exceeds what can be shown on the page, whenever you use one of the following three options, only the rows that are visible on the page will be exported:
PPT Image export
PPT Table export
For example, if you export the following table (created using R code 1:100), only the first 9 rows will be exported.