How to Add Scrolling to an Autofit or CreateCustomTable R Table

Sometimes you may need to add appendix tables or tables of raw data to your Displayr document. If you want to add very customized formatting to these tables you can create an Autofit or CreateCustomTable R Table, but these tables try to fit all of the data in the size of the output. This article describes how to go from an Autofit or CreateCustomTable R table where some of the data is cut off or too scrunched (note the below table actually has 600 rows):

To one that has scrolling enabled:

Requirements

• An Autofit table (see How to Create an Autofit Table) or CreateCustomTable R Table (see How to Create a CreateCustomTable R Table of Sample Sizes)

Method - Autofit table

Method - CreateCustomTable R Table

We will use the row.height argument inside CreateCustomTable() to set the height a certain size instead of having row heights "fit" the space available. This will trigger the scroll to show up.

1. Click on your Calculation output.
2. In the Properties > R CODE box, inside the flipFormat::CreateCustomTable() function, add a line for the row.height argument (note you can change 12px to a different px size based on the font size in your table). For example:
   
   

   #specify the table to be formatted
   mytable = table.Q1a.Spontaneous.Awareness.Spontaneous.Awareness.mention
   
   #format using CreateCustomTable - use row.height to make table scroll
   flipFormat::CreateCustomTable(mytable,
                                   row.height="12px")

3. Click Calculate.

See Also

How to Create an Autofit Table

How to Create a CreateCustomTable R Table of Sample Sizes

How to Customize Colors on a CreateCustomTable R Table

How to Customize Fonts in a CreateCustomTable R Table

How to Add Column Spans to a CreateCustomTable R Table