hot_validate_numeric {rhandsontable}

Handsontable widget

Description

Add numeric validation to a column

Usage

hot_validate_numeric(
  hot,
  cols,
  min = NULL,
  max = NULL,
  choices = NULL,
  exclude = NULL,
  allowInvalid = FALSE
)

Arguments

hot

rhandsontable object

cols

vector of column names or indices

min

minimum value to accept

max

maximum value to accept

choices

a vector of acceptable numeric choices. It will be evaluated after min and max if specified.

exclude

a vector of unacceptable numeric values

allowInvalid

logical specifying whether invalid data will be accepted. Invalid data cells will be color red.

See Also

hot_validate_character

Examples

library(rhandsontable)
MAT = matrix(rnorm(50), nrow = 10, dimnames = list(LETTERS[1:10],
             letters[1:5]))

rhandsontable(MAT * 10) %>%
  hot_validate_numeric(col = 1, min = -50, max = 50, exclude = 40)

rhandsontable(MAT * 10) %>%
  hot_validate_numeric(col = 1, choices = c(10, 20, 40))