R shiny DT table with pagination and drop down list inside table and being able to save the entire updated table as csv file about dt HOT 5 CLOSED

Search "cellEdit" in my StackOverflow answers within the [dt] tag, e.g. this answer.

from dt.

I checked your stackoverflow page. Actually this is not quite what I want. What I want is drop down list inside data table with fixed choices, not simply editting cells. I actually have some testing R shiny code here, but there's problem with it. The issue is when I click into other pages other than first page and select a choice from drop down list, it always goes back to first page. The code and the base csv file are in attached files, could you pls help to fix this? Many thanks!

from dt.

saved_data.csv
app_dropdown.txt
Please use above two files to run my testing r shiny app!

from dt.

Make sure you use server = FALSE in RenderDataTable. DT only loads the current page to the browser when using server = TRUE.

from dt.

I resolved this issue by adding isolate function around rv$data in datatable function call.

from dt.