Update handsontable by editing table and/or eventReactive

by

You could store the data in a reactiveValues and have two observers updating it; one if the button is clicked, one if the table is edited by hand.

In your output$table and output$result, you then just need to use the data that is in the reactiveValues. Here’s an example (same ui.R as you posted):

server <- function(input,output,session)({
  values <- reactiveValues(data=as.data.frame(runif(2)))

  observe({
    input$recalc
    values$data <- as.data.frame(runif(2))
  })

  observe({
    if(!is.null(input$table))
     values$data <- hot_to_r(input$table)
  })


  output$table <- renderRHandsontable({
    rhandsontable(values$data)
    })


  output$result <- renderText({ 
    sum(values$data)
  })
})

More Related Contents:

  1. Get selected rows of Rhandsontable
  2. Starting Shiny app after password input
  3. How to save plots that are made in a shiny app
  4. R shiny: display “loading…” message while function is running
  5. Make conditionalPanel depend on files uploaded with fileInput
  6. drop-down checkbox input in shiny
  7. ‘Reset inputs’ button in shiny app
  8. How to change ‘Maximum upload size exceeded’ restriction in Shiny and save user file inputs?
  9. Marker mouse click event in R leaflet for shiny
  10. Subset based on variable column name
  11. Favicon in Shiny
  12. Shiny: Dynamic Number of Output Elements/Plots
  13. Shiny: Merge cells in DT::datatable
  14. RStudio Shiny ERROR: there is no package called “shinydashboard”
  15. R Shiny set DataTable column width
  16. DT: Dynamically change column values based on selectinput from another column in R shiny app
  17. Get the event which is fired in Shiny?
  18. Remove ‘search’ option but leave ‘search columns’ option
  19. How to implement a cleanup routine in R Shiny?
  20. dplyr – groupby on multiple columns using variable names
  21. Add values to a reactive table in shiny
  22. r shiny table not rendering html
  23. How to add Rtools\bin to the system path in R
  24. Reading in a file in R Shiny
  25. Scale and size of plot in RStudio shiny
  26. Add data to ggvis tooltip that’s contained in the input dataset but not directly in the vis
  27. displaying TRUE when shiny files are split into different folders
  28. R shiny sliderInput with restricted range
  29. Display HTML file in Shiny App
  30. Possible to show console messages (written with `message`) in a shiny ui?

Leave a Comment