hot_validate_numeric: Handsontable widget

In rhandsontable: Interface to the 'Handsontable.js' Library

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))

Example output

rhandsontable documentation built on May 27, 2021, 5:07 p.m.