Stack Overflow
Stack Overflow

Questions tagged [rhandsontable]

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

305 questions
15
votes
1 answer

Inserting control inputs and HTML widgets inside rhandsontable cells in shiny

I'd like to put a colour picker as a column type inside a rhandsontable in a shiny app. Using colourInput() from the colourpicker package, I can add colour pickers as stand-alone inputs, create them from HTML tags, or put them in HTML tables (see…
oshun
  • 2,319
  • 18
  • 32
8
votes
1 answer

Is there a way to have different dropdown options for different rows in an rhandsontable?

I am making a shiny app where the user needs to select dropdown options in a table. I am using rhandsontable, however it seems like I am only able to have one set of dropdown options for a single column. So row 1 has the same options as row 800. I…
Joe Z
  • 101
  • 6
8
votes
5 answers

Retrieving values from an rhandsontable object (R, R shiny)

I use the (awesome) package rhandsontable that will later be included in an R shiny webpage. The user can click at some places, and I want to know how to retrieve the info on which rows was clicked. Here is an example, (to be copy&paste in an R…
Xavier Prudent
  • 1,570
  • 3
  • 25
  • 54
6
votes
1 answer

Switching between reactive data sets of different formats with rhandsontable

In this excellent question: Shiny: Switching reactive datasets with Rhandsontable and external parameters the data frames and the rhandsontable output have identical structures. I am trying to solve a similar problem, but with datasets that do not…
fifthace
  • 506
  • 1
  • 10
  • 33
6
votes
2 answers

Correct way to customize color of rhandsontable inside a Shiny app

So, I'm creating a shiny app and I'd like to color some rows in a table generated with rhandsontable. I'm following this very good tutorial: https://jrowen.github.io/rhandsontable/ Specifically, I'm interested in this part: library(rhandsontable) DF…
thiagogps
  • 439
  • 4
  • 12
6
votes
1 answer

Disable column editing in rhandsontable?

Suppose I have the following shiny app: library(shiny) library(rhandsontable) ui <- shinyUI(fluidPage( titlePanel("Handsontable"), sidebarLayout( sidebarPanel( helpText("Handsontable demo output. Column add/delete does work ", …
Ignacio
  • 7,646
  • 16
  • 60
  • 113
5
votes
1 answer

rhandsontable, wrap text in cells of column (and auto row height)

Data... DF <- data.frame(a = c("hi", rep(NA, 4)), b = letters[1:5], c = LETTERS[1:5], stringsAsFactors = FALSE) When I fix the column widths and the row heights, how can i force the text to wrap…
bikeactuary
  • 447
  • 4
  • 18
5
votes
0 answers

Passing parameter to custom renderer in rhandsontable does not work inside a Shiny App

I need to pass some parameters into a custom rhandsontable renderer. It works fine when executed inside RStudio, but does not render anything when used inside a Shiny App. Here is the code for the custom renderer that sets bold font: renderSheet <-…
Endre
  • 690
  • 8
  • 15
5
votes
0 answers

shiny RHandsontable is not properly displayed in shiny modalDialog

I have researched a lot on the issue already, but so far no solution has been provided when using shiny's showModal() instead of bsModal(). When I show a rhandsontable in a modal Dialog for the second time, the display is buggy, i.e. not all columns…
Tobias Krabel
  • 656
  • 4
  • 8
5
votes
1 answer

rhandsontable drop-down menus cut short in Shiny app

When I try to edit the entries of an rhandsontable inside a Shiny app, the drop-down menus are cut short. Is there a way to make them fully expand like the date selectors in the rhandsontable tutorial? Here is the…
landau
  • 5,636
  • 1
  • 22
  • 50
4
votes
1 answer

R rhandsontable renderer does not follow column sorting despite being reactive

I am working in a shiny app that displays a rhandsontable. I use a "renderer" to customize cell color and border. In addition, I would like to allow the user to perform column sorting. Here is my problem: when columns are sorted, the borders and the…
mazu
  • 147
  • 6
4
votes
1 answer

Shiny: overwriting rhandsontable, invalid (NULL) left side of assignment

In Shiny App, I want to read a table from my local, display it as an rhandsontable, and overwrite one of the columns with Sys.Date(), and display the updated table as rhandsontable. the table function_table looks like this. client fun …
Makoto Miyazaki
  • 1,743
  • 2
  • 23
  • 39
4
votes
1 answer

dynamically add rows to rhandsontable in shiny and R

I'm trying to create an app which ultimately needs the mean and sd of a protein's concentration on the log scale. Since the log-scale values are almost never reported, I've found references which allow me to approximate log-scale using commonly…
Melissa Key
  • 4,476
  • 12
  • 21
4
votes
2 answers

Change cell background of rHandsontable with afterChange event on client side

I'd like to change the background color of a handsontable cell after it's been edited by the user on the client side. The handsontable is defined through a Shiny application; so this is really a question about how to define event hooks in…
Soren
  • 1,792
  • 1
  • 13
  • 16
4
votes
1 answer

color row based on cell value in rhandsontable

I am struggling to color full row of rhandsontable in my shiny app based on a cell value. In the following example, I would like to format full row instead of one cell. library(rhandsontable) DF = data.frame(val = 1:10, bool = TRUE, big =…
M.Qasim
  • 1,827
  • 4
  • 33
  • 58
1
2 3
…
20 21