Stack Overflow
Stack Overflow

Questions tagged [rhandsontable]

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

305 questions
2
votes
1 answer

Saving user content in RShiny as specified named variables

I'm trying to build a simple data entry sheet for media data which a user can add data too and save in a desired location. At the moment whenever I save a scenario it saves the variable as data, which i assume is due to the argument in the save…
Harry Daniels
  • 510
  • 1
  • 5
  • 15
2
votes
2 answers

input from rhandsontable in shiny issues

library(shiny) library(rhandsontable) ui = shinyUI(fluidPage( fluidRow(wellPanel( rHandsontableOutput("hot"), actionButton(inputId="enter",label="enter") )) )) server=function(input,output){ …
kireinasora
  • 323
  • 1
  • 3
  • 10
2
votes
1 answer

reactive shiny objects from database in rhandsontable

I have a large amount of data in a database that I can call using reactive functions in shiny. I would like to present the selected data using rhandsontable, update as necessary and send the data back to the database. I am running into difficulty…
anniemaggs
  • 63
  • 7
2
votes
0 answers

Customize colors of R shiny table using shinysky

So, I know that with rhandsontable package, I could do something like this to color my table: library(rhandsontable) DF <- tail(iris,30) rhandsontable(DF, readOnly = TRUE) %>% hot_cols(renderer = " function (instance, td, row, col,…
thiagogps
  • 439
  • 4
  • 12
2
votes
1 answer

is there a way to hide a column in rhandsontable when passing a dataframe

I have a data frame that I am passing to a rhandsontable . Say the data frame has columns (A and B). In the display I want to format column B based on the values in column A , but I don't want to display column A. Is there a way to do that. I don't…
Lenny2015
  • 35
  • 4
1
vote
0 answers

How to arrange the flow of reactive values in R Shiny in a manner that avoids circular dependencies?

The R Shiny code posted at the bottom allows the user to add columns to a rhandsontable table, allows manual inputs into the first row of the table, and automatically populates the non-editable second row of the table with reactive values from the…
Curious Jorge - user9788072
  • 2,548
  • 1
  • 9
  • 22
1
vote
0 answers

rhandsontable: save changes to sqlite data base via shiny

I'd like to save the changes of rhandsontable via shiny in the sqlite database but it doesn't work. I create and save the data base: library(collapse) library(DBI) library(shiny) library(RSQLite) library(rhandsontable) # Create sqlite base and…
kokolet
  • 11
  • 1
1
vote
2 answers

shiny / rhandsontable / updating cells

In shiny, I have two tables displayed with rhandsontable, I have already implemented that whenever a cell value is changed the cell gets colored, however when switching between the tables all the changes disappear since naturally the table reloads…
galaxy--
  • 152
  • 1
  • 9
1
vote
0 answers

Is there a way to use rhandsontable to show rows as columns and columns as rows?

I am working on a Shiny app where I want to use rhandsontable to manage user input. There are a lot of columns and usually few rows. What I need is for the render to happen transposed: my columns as rows and my rows as columns: My data: Field…
Guillermo Reyes Carmenaty
  • 11
  • 2
1
vote
1 answer

How to set the focus to the first row first column cell in a rhandsontable in an RShiny app?

I need to set focus on the first-row first-column cell of a rhandsontable in an RShiny app. Looking for a solution similar to the solutions discussed in this forum: Set the focus to a specific datagrid cell, QML: Set focus TextInput in a table cell,…
RanonKahn
  • 853
  • 10
  • 34
1
vote
1 answer

Is there a way to not set rhandsontable height to a huge value in order to have the dropdown menu correctly render?

Running the code at the bottom of this post presents a rhandsontable with dropdown choices. The only way to get the dropdowns to appear is to set a very large table height, but that has the ugly effect of pushing the actionButton() far down. If you…
Village.Idyot
  • 1,359
  • 2
  • 8
1
vote
2 answers

How to add columns to table rendered with rhandsontable with dropdown menus using an action button?

I'm working on a table rendered with rhandsontable that uses dropdown menus for user inputs into the table. My dropdown approach is based on guidance provided in post Is there a way to have different dropdown options for different rows in an…
Village.Idyot
  • 1,359
  • 2
  • 8
1
vote
2 answers

How to sum all colums in rhandsontable when reactively updating the table in Shiny with user inputs?

I've been trying to apply the solution in post Shiny App: How to get total sum by column to my situation but am unable to get it to work. I simply want the "Total" row at the bottom of the table to recalculate every time the user changes one of the…
Village.Idyot
  • 1,359
  • 2
  • 8
1
vote
1 answer

How run a shiny app inside of a function?

I would like to run a function that has a shiny app inside, but I can't. Running this example separately, I first remove column one from my input data frame; then I run shiny to change whatever is necessary in the data frame and, when I close the…
Igor Cobelo
  • 419
  • 3
  • 12
1
vote
1 answer

How to insert reactive values into a table rendered using rhandsontable based on triggers in that table?

In running the code presented at the bottom of this post, a table ("hottable") is rendered on the bottom-right of the window using the rhandsontable package whereby row 2 of that table reflects the user input from the input$choices object in the…
Village.Idyot
  • 1,359
  • 2
  • 8
1 2 3
…
20 21