Stack Overflow
Stack Overflow

Questions tagged [rhandsontable]

RHandsontable is a data grid component with an Excel-like appearance

305 questions
2
votes
1 answer

Synchronizing column order between two rHandsontable outputs in a Shiny app

I am building a Shiny app that displays two tables side by side: a control table and a preview table. The control table displays the column names of the preview table, and the user can manipulate them by dragging and dropping columns to change their…
mat
  • 2,412
  • 5
  • 31
  • 69
2
votes
1 answer

Reset selected range in rhandsontable

How can I reset the selected cell range each time a new dataset is generated in the example below? library(shiny) library(data.table) library(rhandsontable) shinyApp( ui = fluidPage( actionButton('gendata', 'Generate data'), hr(), …
mat
  • 2,412
  • 5
  • 31
  • 69
2
votes
1 answer

How to save reactive dataframe from one R session to the next?

I've begun working with package shinyStorePlus to save user inputs from one R session to the next. I've come across a scenario where it doesn't work: a reactive dataframe rendered with package rhandsontable, per the example code below. Using…
Curious Jorge - user9788072
  • 2,548
  • 1
  • 9
  • 22
2
votes
1 answer

R Shiny/RHandsontable: Trying to read from and update the same RHandsontable in real time

I'm trying to create an RShiny page to help with some fuzzy matches, and allow the user to confirm the matches are correct. The table being displayed has a few columns, most important of which are the names from list A, potential matching names from…
TC95
  • 51
  • 3
2
votes
1 answer

Merging multiple cells in rhandsontable

I am trying to create a table using rhandsontable with several rows of merged cells (different cells in each row). I am trying to achieve merging of the indicated cells in the screenshot below ... I am able to successfully merge the first set of…
Peter
  • 118
  • 9
2
votes
1 answer

Search functionality for multiple rhandsontables in a shiny app

I have a shiny app with multiple tabs in which I am rendering rhandsontable and would like to provide a search capability. This is the module I have written for rendering such a table with search : # Module for rendering rhandsontable with…
Dhiraj
  • 1,650
  • 1
  • 18
  • 44
2
votes
2 answers

Rhandsontable collect values from logical == TRUE

I'm trying to collect the value of a column ('Type') in a rhandsontable based on the the selection of the adjacent logical column ('Tick'). I want to create a vector of all the Type's based on the which rows are ticked. I will use the vector to…
Thomas Worthington
  • 133
  • 5
2
votes
2 answers

R shiny DT checkboxes on top to tick/untick all the checkboxes below

I'm looking for a simple way to select data organised by row with some attributes (namely, year of collection of these data) by column. The columns would be '2016', '2017', '2018' and on each row below each of these columns there should be a…
Olivier7121
  • 151
  • 1
  • 11
2
votes
1 answer

Conditional Default value rhandsontable in Shiny

Problem: In below Shiny app, I want to change and insert new rows to the following data via rhandsontable: data.frame(car = c("Opel", "Nissan", "Opel", "VW"), location = c("Ruesselsheim", "Frankreich", "Ruesselsheim",…
rkraft
  • 495
  • 4
  • 16
2
votes
1 answer

How to remove columns using rhandsontable in Shiny

I'm building a R Shiny app to edit uploaded data and modify them by using rhandsontable package. I'd like to allow the user to remove columns. Despite I could introduce the possibility to add columns with different types of classes (integer,…
Eugenio Alladio
  • 103
  • 7
2
votes
1 answer

Why does this reactive value needs to be called first before it can be used?

While trying to come up with an overly complicated solution for this question, I stumbled across the following problem. I have 2 different modules, inputtable displays an rhandsontable and returns this table, and resulttable takes this table as the…
starja
  • 9,887
  • 1
  • 13
  • 28
2
votes
1 answer

rhandsontable using a dropdown to "hide" columns

I have a data frame that I am passing to a rhandsontable. Let's say it has 10 columns. I have a drop-down that has 3 choices: Show columns 1 through 5 Show columns 1, 5 and 10 Show columns 6 through 10 Be default, when the rhandsontable loads, it…
lumiukko
  • 249
  • 3
  • 13
2
votes
1 answer

Shiny App: How to get total sum by column

I have two problems: -First I cannot start the table showing only zeros or blank for that reason I've created a button that set's every thing to zero which kind of works but its not ideal. -Secondly, I'm trying to calculate column sum for each…
PatraoPedro
  • 197
  • 1
  • 16
2
votes
1 answer

r handsontable: Can a custom renderer negate column formatting commands?

This rendering of my rhandsontable in Shiny works just fine. Among other things, columns 'Pat. Owes' and 'Ins. Owes' show up formatted as US$ (see lines 4 and 5 from the bottom of the code section below): renderRHandsontable({ …
user3245256
  • 1,842
  • 4
  • 24
  • 51
2
votes
1 answer

How to reset to default a reactive rhandsontable?

I'm building an app where a 2-by-2 table contains some values that are used for further computation. These values can be updated by user, and user would be able to get back to the original values. I'm trying to achieve it with an action button that…
Denis
  • 23
  • 3
1 2
3
…
20 21