title: Filter rows in rhandsontable in R Shiny
body: <p>I want to display and edit an <code>rhandsontable</code> within a Shiny app. Since my data frame is fairly large, I want the user to be able to filter a specific row instead of displaying the whole 1000 rows (see example below). I can create a reactive value to subset <code>hot</code> based on <code>input$row</code>, but then only <code>DF[input$row,]</code> is assigned to <code>input$hot</code> and, thus, next time I get the value of <code>input$hot</code> it returns a data frame with only one row. </p>
  
  <pre><code>library(shiny)
  library(rhandsontable)
  
  ui &lt;- shinyUI(fluidPage(
    numericInput("rows","row to filter",value = 1),
    rHandsontableOutput("hot")
  ))
  
  server &lt;- shinyServer(function(input, output, session) {
  
    # render handsontable output
    output$hot &lt;- renderRHandsontable({
      if (!is.null(input$hot)) {
        DF &lt;- hot_to_r(input$hot)
      } else {
        set.seed(42)
        DF &lt;- data.frame(a=1:1000, b= rnorm(1000))
      }
      rhandsontable(DF) 
    })
  
  })
  
  runApp(list(ui=ui, server=server))
  </code></pre>
  
  <p>Is there a filtering paramenter that I can apply to <code>rhandsontable()</code> that would allow me to render a filtered version of my data frame without actually subsetting it, so that the linked <code>input$hot</code> wouldn't be affected (except, of course, for any edits made by the user)? </p>
  
  <p>I want the user to write the row to filter in the textInput box <code>row</code> and then the table to be filtered accordingly. It is imperative that <code>nrow(hot_to_r(input$hot)) == 1000</code> continues to be TRUE:</p>
  
  <p><a href="https://i.stack.imgur.com/SRFK8.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/SRFK8.png" alt="render"></a></p>