Can you change the R default table length when outputting with the DT package?

Question

In R DT you can define the table control elements with code such as:

# only display the table, and nothing else
library(DT)
datatable(mtcars, options = list(dom = 't'))

The t above is a DOM. The DOM element l controls the length changing input control, basically how long your table will be. It looks like this.

This length changing input control defaults to a value of 10. How can I change this default value to 25, 100, perhaps even "All"?

Answer 1

We can set iDisplayLength:

datatable(mtcars, options = list(iDisplayLength = 25))

Related post:

• Datatable only display 10 rows, when 50 asked

Answer 2

You can change it to 3 by datatable(mtcars, options = list(dom = 't', pageLength = 3)).

This will get you your desired results:

datatable(mtcars, options = list(dom = 't',
  lengthMenu = list(c(25, 100, -1), c('25', '100', 'All')),
  pageLength = 25
))

Answer 3

Oh my, poke and hope until you find the secret combo, setting pageLength does nothing until you set scrollY to TRUE.

options = list(pageLength = 10, scrollY = TRUE)