Stack Overflow
Stack Overflow

Questions tagged [rhandsontable]

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

305 questions
4
votes
1 answer

rhandsontable hide columns for a shiny app

I use output$hot <- renderRHandsontable(rhandsontable(DF)) to get a table. All works fine but I would like to allow the user to select certain columns only (implemented with shiny::updateSelectizeInput()). the data should then be updated in the…
Walde
  • 45
  • 8
3
votes
2 answers

How to format numbers in a specific row using js in a table rendered with rhandsontable?

In the simplified code at the bottom of this post, I believe it is js that is used for formatting outputs of the table rendered using rhandsontable. I play around with row/column formatting with some success in the js section of the code. However,…
Village.Idyot
  • 1,359
  • 2
  • 8
3
votes
0 answers

How to restore the rhandsontable package's disabled 'Undo' from the context menu in R shiny

For one of my Rshiny app, I am referring to this R shiny code from StackOverflow: In R Shiny, how do you reset data (reversing all manual inputs) in rhandsontable using an actionButton? When we use the package "rhandsontable," the following code…
Kevin Tracey
  • 154
  • 1
  • 16
3
votes
1 answer

highlight the row if a cell is edited in Rhandsontable and keep track of all changes

I'm developing a shiny app which is reading data from SQL database and present it in a rhandsontable and allows user to edit the data. I would like to add some functionality before I submit the changes back to the database : How could I highlight a…
Haribo
  • 2,071
  • 17
  • 37
3
votes
1 answer

Adding multiple rows in rhandsontable via context menu

I'm using the rhandsontablepackage and would like to add a context menu option for adding multiple rows to the handsontable produced. I've tried to adapt this example into my R equivalent with no luck. I believe my javascript is the issue but don't…
Michael Bird
  • 771
  • 8
  • 21
3
votes
1 answer

Date formating in handson table

I am using handson table lib in my angular project. have a date column and i want the dates to be formatted like that DD/MM/YYYY at the init of the table but unfortunately nothing is happened and even when i call afterRender() in angular's…
fbm fatma
  • 430
  • 6
  • 22
3
votes
1 answer

R Shiny module not updating reactively within same event

I'm having an issue with reactivity when using modules in R. If I update a module and then try to update another module with those updated values, I instead get the values prior to the update. I've written up some basic code to show what I mean…
Sooji
  • 169
  • 3
  • 18
3
votes
0 answers

increase rhandsontable checkbox size

Does any one have an idea how to increase the size of the checkbox itself in a cell ? I have been able to increase the size of the row and of the columns, but it turns out that increasing the row and column size does not increase the size of the…
Fahadakbar
  • 488
  • 1
  • 8
  • 26
3
votes
1 answer

r shiny rhandsontable: create empty table for copy & paste of data

I try to use rhandsontable to build a shiny app. When running the app at first an empty table should be rendered which then could be filled with data by copy & paste. After pasting the data a plot of the values should be rendered. My code is as…
MacFlo
  • 31
  • 3
3
votes
1 answer

To allow multi select in Rhandsontable column dropdown

I am trying to build a application in R shiny, where I am using a handsontable to take inputs from users. One column in my handsontable is having dropdowns where I need multiple selection from the user. For example in my below sample code, I want…
kawsleo
  • 560
  • 4
  • 23
3
votes
0 answers

hot_to_r: glitching/ values stuck in a loop

I've written some Shiny code which connects three rhandsontables with different date aggregations. There are three tables: day, week and month. If you add/edit values into the day table, the values are aggregated and pushed into the other two…
Harry Daniels
  • 510
  • 1
  • 5
  • 15
3
votes
1 answer

R change columns types using shiny, rhandson and DT

I have a shiny app, where a user can upload his csv into user_table() reactive expression, which is then shown to a user using DT renderDataTable(); There is also RHandsontable with the types of columns from user_table(). User should be able to…
vladli
  • 1,454
  • 2
  • 16
  • 40
3
votes
1 answer

Fill up missing values of rhandsontable object using an action button in shiny R studio

I have the following code. I want to fill the missing value of the rhandsontable object with a bolded number (or may be with red color) once the "go" button is clicked, given the relationship of calculating the value as datacopy[16, "wt"]=…
Sumeda
  • 115
  • 8
3
votes
2 answers

Filter rows in rhandsontable in R Shiny

I want to display and edit an rhandsontable 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…
InspectorSands
  • 2,859
  • 1
  • 18
  • 33
3
votes
3 answers

Convert data from rhandsontable object into dataframe in Shiny

I have a rHandsontable table (rhandsontable package) and now I am searching a way how to transfer data from the table into a dataframe. So far I have not found a clear clue how to perfrom this action. I would be very grateful for the plain and clear…
Dimon D.
  • 438
  • 5
  • 23
1
2
3
…
20 21