title: Update rhandsontable by changing one cell value
body: <p>I have the dataframe below:</p>
  
  <pre><code>DF2 = data.frame(agency_postcode = factor(rep(c(12345,45678,24124,32525,32325),2)),
                   car_group=factor(rep(c("Microcar","City car","Supermini","Compact","SUV"),2)),
                   transmission=factor(rep(c("automatic","manual"),5)))
  </code></pre>
  
  <p>and after subseting it by one of the values of the 1st column</p>
  
  <pre><code>newdata &lt;- DF2[ which(DF2$agency_postcode =='12345'), ]
  </code></pre>
  
  <p>and re-factoring in order to set accordingly the dropdown values of the second and third column to only available values after the subset</p>
  
  <pre><code>for(i in 2:ncol(newdata)){
    newdata[,i] &lt;- factor(newdata[,i])
  }
  </code></pre>
  
  <p>I display it with:</p>
  
  <pre><code>library(rhandsontable)
  rhandsontable(newdata[1,], rowHeaders = NULL, width = 550, height = 300)%&gt;%
    hot_col(colnames(newdata))   
  </code></pre>
  
  <p>What I want to do is when I select a different value from the available ones of (only) the 1st column the whole table should be updated accordingly if of course this row exists.</p>