Introduction
This article describes how to go from a standard table...
...to an CreateCustomTable R table (similar to a table with Autofit checked) with span row labels:
Requirements
A table.
Method
1. Select your table.
2. Copy the name from Properties > GENERAL > Name.
3. Go to Calculation > Custom Code.
4. Paste the below under Properties > R CODE:
#identify mytable
mytable = table.Income
#create list of row spans
rowspans = list(list(height=2,label="Low Income"),
list(height=3,label="Med Income"),
list(height=4,label="High Income"),
list(height=1,label=" "))
#create custom table
flipFormat::CreateCustomTable(mytable,
row.spans=rowspans,
border.color = "black")
- The above code defines the table using the reference name from step 2.
- Next, we create a list of the span labels where the height represents the number of rows the span should cover and the label is what should appear within the span.
- Finally, we use our CreateCustomTable function from the flipFormat R package and parse rowspans into the row.spans argument.
5. OPTIONAL: Add other arguments to CreateCustomTable to set fill colors, padding and font styles.
See Also
Comments
0 comments
Article is closed for comments.