suppressing sorting in dataTables in Shiny

r datatable shiny
mike picture mike · Jun 16, 2016 · Viewed 8.7k times · Source

I have a dataTable in Shiny but I want to disable sorting and get rid of the arrows next to the column headings as exemplified in the following image.

enter image description here

I have used the following code to attempt to disble it with no luck.

output$ex <-
  renderDataTable({inData},
                  options = list(
                      bLengthChange = 0,
                      bFilter       = 0,
                      bInfo         = 0,
                      bPaginate     = 0,
                      bSortable     = 0,
                      bOrderable    = 0),
                  rownames=FALSE)

I thought bSortable=0, bOrderable=0 would do the trick but doesn't make it work.

Answer

Batanichek picture Batanichek · Jun 16, 2016

Try 

datatable(iris,options = list(ordering=F))

to remove sorting

And 

datatable(iris,options = list(dom='t',ordering=F))

to show only table

Related questions

datatable does not render in Shiny Dashboard

The datatable does not render in a Shinydashboard. It just renders a thin white strip for the box. Running only the datatable function in RStudio renders the datatable in the RStudio viewer. So what the correct way to render a …

Read More
Remove rows with all or some NAs (missing values) in data.frame

I'd like to remove the lines in this data frame that: a) contain NAs across all columns. Below is my example data frame. gene hsap mmul mmus rnor cfam 1 ENSG00000208234 0 NA NA NA NA 2 ENSG00000199674 0 2 2 2 2 3 ENSG00000221622 0 NA NA NA NA 4 …

Read More
Drop data frame columns by name

I have a number of columns that I would like to remove from a data frame. I know that we can delete them individually using something like: df$x <- NULL But I was hoping to do this with …

Read More