Hello,
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
Selected
to be editeable while the min and max cannot be changed. - Values inserted into the Selected need to adhere to the corresponding
Min
andMax
vectors, 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)