Set table layout and table width. Default to fixed algorithm.
If layout is fixed, column widths will be used to display the table;
width is ignored.
If layout is autofit, column widths will not be used; table width is used (as a percentage).
Arguments
- x
flextable object
- layout
'autofit' or 'fixed' algorithm. Default to 'autofit'.
- width
The parameter has a different effect depending on the output format. Users should consider it as a minimum width. In HTML, it is the minimum width of the space that the table should occupy. In Word, it is a preferred size and Word may decide not to strictly stick to it. It has no effect on PowerPoint and PDF output. Its default value is 0, as an effect, it only use necessary width to display all content. It is not used by the PDF output.
- align
alignment in document (only Word, HTML and PDF), supported values are 'left', 'center' and 'right'.
- opts_html
html options as a list. Supported elements are:
'extra_css': extra css instructions to be integrated with the HTML code of the table.
'scroll': NULL or a list if you want to add a scroll-box.
Use an empty list to add an horizontal scroll. The with is fixed, corresponding to the container's width.
If the list has a value named
heightit will be used as height and the scroll will happen also vertically. The height will be in pixel if numeric, if a string it should be a valid css measure.If the list has a value named
freeze_first_columnset toTRUE, the first column is set as a sticky column.If the list has a value named
add_cssit will be used as extra css to add, .i.e:border:1px solid red;.
'extra_class': extra classes to add in the table tag
- opts_word
Word options as a list. Supported elements are:
'split': Word option 'Allow row to break across pages' can be activated when TRUE.
'keep_with_next': Word option 'keep rows together' is activated when TRUE. It avoids page break within tables. This is handy for small tables, i.e. less than a page height.
- opts_pdf
PDF options as a list. Supported elements are:
'tabcolsep': space between the text and the left/right border of its containing cell.
'arraystretch': height of each row relative to its default height, the default value is 1.5.
'float': type of floating placement in the PDF document, one of:
'none' (the default value), table is placed after the preceding paragraph.
'float', table can float to a place in the text where it fits best
'wrap-r', wrap text around the table positioned to the right side of the text
'wrap-l', wrap text around the table positioned to the left side of the text
'wrap-i', wrap text around the table positioned inside edge-near the binding
'wrap-o', wrap text around the table positioned outside edge-far from the binding
'fonts_ignore': if TRUE, pdf-engine 'pdflatex' can be used instead of 'xelatex' or 'lualatex.' If pdflatex is used, fonts will be ignored because they are not supported by pdflatex, whereas with the xelatex and lualatex engines they are.
'caption_repeat': a boolean that indicates if the caption should be repeated along pages. Its default value is
TRUE.'footer_repeat': a boolean that indicates if the footer should be repeated along pages. Its default value is
TRUE.'default_line_color': default line color, restored globally after the flextable is produced.
- word_title
alternative text for Word table (used as title of the table)
- word_description
alternative text for Word table (used as description of the table)
See also
Other flextable dimensions:
autofit(),
dim.flextable(),
dim_pretty(),
fit_to_width(),
flextable_dim(),
height(),
hrule(),
ncol_keys(),
nrow_part(),
width()
Examples
library(flextable)
ft_1 <- flextable(head(cars))
ft_1 <- autofit(ft_1)
ft_2 <- set_table_properties(ft_1, width = .5, layout = "autofit")
ft_2
speed
dist
4
2
4
10
7
4
7
22
8
16
9
10
ft_3 <- set_table_properties(ft_1, width = 1, layout = "autofit")
# add scroll for HTML ----
set.seed(2)
dat <- lapply(1:14, function(x) rnorm(n = 20))
dat <- setNames(dat, paste0("colname", 1:14))
dat <- as.data.frame(dat)
ft_4 <- flextable(dat)
ft_4 <- colformat_double(ft_4)
ft_4 <- bg(ft_4, j = 1, bg = "#DDDDDD", part = "all")
ft_4 <- bg(ft_4, i = 1, bg = "#DDDDDD", part = "header")
ft_4 <- autofit(ft_4)
ft_4 <- set_table_properties(
x = ft_4,
opts_html = list(
scroll = list(
height = "500px",
freeze_first_column = TRUE
)
)
)
ft_4
colname1
colname2
colname3
colname4
colname5
colname6
colname7
colname8
colname9
colname10
colname11
colname12
colname13
colname14
-0.9
2.1
-0.4
-1.8
1.0
1.1
1.2
-0.6
0.4
-1.0
0.3
0.4
-0.1
1.3
0.2
-1.2
-2.0
2.0
-1.7
0.3
0.1
0.4
-0.6
-1.3
-1.0
0.7
2.9
-0.1
1.6
1.6
-0.8
-0.7
-0.5
-0.3
1.7
-0.8
-0.3
0.4
2.9
-0.8
1.2
-0.3
-1.1
2.0
1.9
0.2
-1.4
-0.7
-0.4
0.1
0.4
-1.1
0.2
1.9
0.5
-1.9
-0.1
0.0
0.6
0.5
-2.2
-0.9
-1.0
0.7
-1.3
0.5
-1.0
0.1
0.8
-0.6
0.1
-2.5
2.0
-0.8
1.8
2.0
0.5
-0.7
-0.9
1.2
0.4
0.5
-0.6
-1.4
0.7
0.5
-0.3
-2.0
-0.7
0.9
-0.7
0.7
2.1
0.0
-0.1
-0.1
0.1
1.9
-0.2
-0.6
-0.1
-0.5
-0.3
2.0
0.6
0.5
-2.1
0.5
-0.4
0.9
0.3
0.5
2.0
0.8
-0.2
0.1
-0.4
-0.4
-1.7
-0.8
-1.2
-0.7
0.6
-0.4
-0.5
0.5
-0.1
0.3
-1.2
-0.9
0.4
-0.4
-1.7
-1.0
1.0
0.5
0.2
2.3
-0.5
-0.0
0.4
0.7
-0.8
-0.9
1.6
-1.0
0.7
1.0
1.1
-1.3
1.0
1.6
0.5
-2.7
1.0
0.3
2.1
0.3
1.7
-0.3
0.3
-0.2
0.8
-0.1
-0.5
-2.0
-0.4
-0.0
-0.4
1.1
-0.6
-0.1
-1.2
0.5
0.9
0.7
0.1
-1.3
1.8
-0.6
-0.2
0.0
-1.0
-0.3
1.3
0.4
-1.4
1.4
-2.0
-0.8
0.3
-0.3
-1.4
-0.0
-0.3
-1.2
1.8
-0.8
-1.0
-0.1
-1.5
0.6
1.2
1.3
-0.9
1.1
0.1
-1.7
0.8
0.3
-2.3
-0.6
-2.0
-0.9
-1.3
0.5
1.2
-1.3
-0.7
0.7
0.5
-1.1
0.5
1.6
0.9
-1.7
-0.3
1.3
2.0
1.2
1.0
0.8
-0.3
-0.4
1.2
-0.6
-0.3
-0.0
0.0
-0.9
0.9
0.8
0.0
1.1
0.8
0.5
-0.9
-0.8
-1.3
0.5
-0.3
1.0
1.0
-0.6
1.1
1.1
-0.8
0.1
2.1
0.3
0.8
-0.9
-1.1
0.1
1.0
-0.4
0.4
-0.2
1.7
-1.4
-0.6
-0.8
-1.5
0.7
-1.6
-0.7
1.7
-0.6
-0.2
0.1