For a Shiny Application I need to make use of the
rhandsontable package and for my needs want some row wise checks to be done instead of columwise as you can do with
hot_validate_numeric. I know this is not shiny code but it seemed simpler to solve it here first before taking it there.
What I want to achieve:
- I only want the final column
Selectedto be editeable while the min and max cannot be changed.
- Values inserted into the Selected need to adhere to the corresponding
Maxvectors, i.e. If I put 15 into the first row it will be successful as the min is 10 and max 20 while putting 22 I am not able to.
df <- data.frame(Min=c(10,20,30),Max=c(20,30,40),Selected=c(0,0,0)) rhandsontable(df, width = 550, height = 300) # %>% # hot_validate_numeric(cols = 1, min = -50, max = 50, exclude = 40)