RHandsontable is a data grid component with an Excel-like appearance
Questions tagged [rhandsontable]
305 questions
2
votes
1 answer
Dynamic coloring of cell background in rhandsontable
My question is a bit more advanced than the question here. Let's assume that I want to develop the following game as a Shiny app.
I have 3 x 3 data frame containing the numbers from 1 to 9 in a random order.
set.seed(123)
df_correct <-…
SavedByJESUS
- 3,262
- 4
- 32
- 47
2
votes
2 answers
Centering rHandsontableOutput - Shiny
I'm trying to center two tables created using rhandsontable in column and get two weirdly split tables:
When I do not try to center, everything is fine.
Does anyone know what is going wrong and how to center my tables?
Here is my…
Suzanne
- 83
- 9
2
votes
1 answer
Hiding Columns in rhandsontable using css
I am trying to hide columns in a rhandsontable rendered in a Shiny app. I believe that in the current version it can't be done as explained here. However Handsontable does have a Hidden Columns plugin. I am not conversant with how to add plugins. If…
Dhiraj
- 1,650
- 1
- 18
- 44
2
votes
1 answer
Shiny rhandsontable that is reactive to itself
I am trying to create a shiny app that has a rhandsontable in it. I want rhandsontable to be able to update its values in one of its columns if the corresponding values in another column is selected/ checked. So far, I have been able to use reactive…
Fahadakbar
- 488
- 1
- 8
- 26
2
votes
0 answers
Ways to make shiny faster when using rhandsontable and reactiveValues
My shiny code has an rhandstontable that the user can edit. This leads to an update of the rightmost columns, based on a custom function. the code also plots values from the table on two ggplots, which also get updated when the table values change.…
val
- 1,629
- 1
- 30
- 56
2
votes
0 answers
prioritise rendering in shiny with handsontable
Thanks to rhandonstable, I am asking the user of my shinyApp to fill in a table from which computations are done and plots displayed in real time. This is great! However, because of computation time (simulated by a little Sys.sleep() in the MRE…
Yollanda Beetroot
- 323
- 6
- 15
2
votes
0 answers
R Shiny number formatting issues in rhandsontable
I created a simple table using rhandsotable library and no matter how I format it, number always gets rounded down or up to closest integer. For example, if I type in 1.02, the result shown is 1. For 0.46, result shown is 0. I tried getting numbers…
Martin
- 133
- 13
2
votes
1 answer
rhandsontable with row highlighting and checkbox columns
I'm trying to use the rhandsontable library to generate a table in which I combine two of the package's nifty features: (1) row highlighting using a customer renderer argument, and (2) checkbox column type for a boolean field.
On their own, both…
joebrew
- 55
- 7
2
votes
1 answer
select number of rows to preview in rhandsontable
When working with datatables everything is clear - I can choose 5, 10, 25, 50 or 100 entries.
shinyApp(
ui = fluidPage(
fluidRow(
column(12,
dataTableOutput('table')
)
)
),
server = function(input, output) {
…
Adamek
- 95
- 8
2
votes
1 answer
Store edits of RHandsontable in a Shiny application
I have a Shiny application that produces reads in a .csv file and produces an editable table.
library(dplyr)
library(rhandsontable)
options(shiny.maxRequestSize = 9*1024^2)
function(input, output) {
values <- reactiveValues()
Post <-…
Henk Straten
- 1,365
- 18
- 39
2
votes
1 answer
Change font color of a column in rhandsontable
I have a table rendered using rhandsontable in R. I want to change the font color to red of a specific column. How can I do it ? I tried the following code, but it does not work
output$hot=renderRHandsontable({
rhandontable…
Malinda Samaratunga
- 37
- 1
- 7
2
votes
2 answers
rhandsontable how to restrict max. rows count
I have a rhandsontable in a shiny app, that has 2 rows. It uses reactiveValues() to load values inside of it. Creating additional rows by dragging a cell is prohibited with
fillHandle = list(direction='vertical', autoInsertRow=FALSE))
The user…
vladli
- 1,454
- 2
- 16
- 40
2
votes
1 answer
Rhandsontable conditional formatting- How to highlight rows based on specific attribute value?
I'd like to apply color highlighting for a entire row depending on a value and retain check boxes functionality of rhandsontable. In the simple example below, I'd like row 3 to be pink and row 4 to be green.
library(rhandsontable)
DF = data.frame(…
Shiny_n00B
- 21
- 4
2
votes
1 answer
r shiny: updating rhandsontable from another rhandsontable
I hope you're well. I am trying to create a shiny dashboard whereby a user is able to update one rhandsontable from another. My code is as follows:
library(shiny)
library(rhandsontable)
channel <- c("TV","Radio","Digital")
start.date <-…
Harry Daniels
- 510
- 1
- 5
- 15
2
votes
1 answer
how to add new/separate datatables after clicking actionbutton
I need help writing a shiny app that will spit out a separate datatable after entering into each respective input and clicking the actionbutton. I got the app to simply output to the datatable, but it will overwrite upon a new entry. I checked the…
Spencer Trinh
- 743
- 12
- 31