DataValidationComparison | @sheetwrite/core

@sheetwrite/coretype

Native comparison semantics for numeric, date-serial, and text-length validation. Interval operands are inclusive; notBetween accepts values outside that interval.

Package: @sheetwrite/core
Source: packages/core/src/types/document.ts#L105

Variants 2

{
  operator: "between" | "notBetween";
  min: number;
  max: number;
}

{
  operator:
    | "equal"
    | "notEqual"
    | "greaterThan"
    | "lessThan"
    | "greaterThanOrEqual"
    | "lessThanOrEqual";
  value: number;
}

Declaration

View full TypeScript declaration

export type DataValidationComparison =
  | {
      operator: "between" | "notBetween";
      min: number;
      max: number;
    }
  | {
      operator:
        | "equal"
        | "notEqual"
        | "greaterThan"
        | "lessThan"
        | "greaterThanOrEqual"
        | "lessThanOrEqual";
      value: number;
    };