Questions tagged [rhandsontable]

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

305 questions
0
votes
0 answers

R Shiny call tables in dynamic tabs

I have data tables in dynamic tabs, which will require the user to input data. How to call those tables and process the user data from the dynamic tabs? library(shiny) library(rhandsontable) DF <- data.frame(sample=c(350292, 350293), test=c(2,…
Jian
  • 365
  • 1
  • 6
  • 19
0
votes
0 answers

R shiny matrix or table input

I want to create a matrix or table as input for user to interact with in Shiny. For example: sample name number of tests 350292 3 ... ... I want to automatically generate tabs in the mainPanel for…
Jian
  • 365
  • 1
  • 6
  • 19
0
votes
0 answers

How to save the 'rhandsontable' output in a data frame?

I want to display my existing dataframe in output. In addition to those columns, I need few columns where user input can be recorded. I am able to achieve this through rHandsontable. But, am not able to save the edited/modified table in a…
0
votes
0 answers

R Programming/ Shiny/ Reading values from table

I'm new to programming and I am trying to learn R Programming. I made a table in R using the rhandsontable library. I would like to know if it's possible to read values from a user in the table generated by rhandsontable and process the values…
0
votes
1 answer

Error using rhandsontable in Shiny

I've observed some strange behaviour of rhandsontable in a shiny app. In this simple example I am assigning a data.frame to a reactiveValues element if some event happens. The data is then shown in a rhandsontable. But when I change some entry of…
needRhelp
  • 2,948
  • 2
  • 24
  • 48
0
votes
1 answer

Numerical validation of a cell using rhandsontable R package

I'd like to create a validation scheme when a table based on "rhandsontable" is updated. I have two columns: Min and Max and I'd like that when a cell in the column Max is updated, only it's allowed updating with a value greater than the previous…
Uli
  • 3
  • 5
0
votes
1 answer

Shiny: How to reset rhandson table to default?

I have a small app like this: require(shiny) require(shinyjs) require(rhandsontable) shinyApp(ui = fluidPage(useShinyjs(), div(id = 'div1', titlePanel("RHOT - Form"), …
jackStinger
  • 2,035
  • 5
  • 23
  • 36
0
votes
0 answers

Rhandsontable non-consecutive cell selection in shiny app

I am trying to use Rhandsontable in a Shiny app to make a 8x12 table that will be used as input matched to a 97 column dataframe. Each cell in the table corresponds to 1 column in the dataframe (-1 for the x-axis). This is my current code for…
Lyk
  • 33
  • 10
0
votes
1 answer

How can i get a fixed plotOutput in Shiny

I am developing a Shiny app with a plot (plot1 in the code) that is reactive to a data table (rhandsontable) and it displays the item selected on the table. The table is very large so you have to scroll down to see everything. But I want the plot to…
Aida
  • 79
  • 1
  • 8
0
votes
1 answer

How do I handle an empty table with rhandsontable in Shiny?

When the last row in my rhandsondtable is deleted I get the following error: Warning: Error in matrix: 'data' must be of a vector type, was 'NULL' Stack trace (innermost first): 61: matrix 60: 59: do.call 58: hot_to_r …
dommer
  • 19,610
  • 14
  • 75
  • 137
0
votes
1 answer

shiny: use data generated in renderRHandsontable({}) in another renderRHandsontable({}) expression

below is a schemata of what I would like to achieve data <- read.csv("data.csv") output$table1 <- renderRHandsontable({ data <- data*2 data_table <- filter(data, "ID1") rhandsontable(data_table)}) output$table2 <-…
Walde
  • 45
  • 8
0
votes
0 answers

Turning off resizable rhandsontable

I am using rhandsontable to create a table for the user to edit. I noticed that if you drag the box on the bottom right past the last boxes, you can resize the dataframes. Is there an option or solution to be able to turn off that the resizable…
dchen71
  • 170
  • 1
  • 13
0
votes
1 answer

Two rhandsontables in one tabPanel in shiny app

When putting two rhandsontables in one tabPanel within a shiny app, the sparklines get mixed up. Either the sparklines of the first table are displayed correctly while the second table contains the same sparklines as the first table or vice versa…
Thomas
  • 1,392
  • 3
  • 22
  • 38
0
votes
1 answer

R package "rhandsontable" does not display the "NA" character sequence

The Bloomberg exchange code for Dutch equities is "NA", for example "RDA NA Equity". I need to display the exchange code on a separate column in a handsontable. The default rendering function interprets the 2 character string "NA" as an Not…
Nick Nassuphis
  • 257
  • 2
  • 6
0
votes
1 answer

Incorrect rendering of the updated output in rHandsontable object (hot_to_r)

I have found an issue concerning the updated data output. The script is as follwos: library(shiny) library(shinyapps) library(rhandsontable) ## CLIENT SIDE ui <- shinyUI(pageWithSidebar( headerPanel("Test of rHandsontable output - hot_to_r…
Dimon D.
  • 438
  • 5
  • 23
1 2 3
20
21