SheetXL - v1.0.2
    Preparing search index...

    Variable BuiltInSelectorNamesConst

    BuiltInSelectorNames: {
        Date: "date";
        DateTime: "dateTime";
        Display: "display";
        Logical: "logical";
        Number: "number";
        Text: "text";
        TextLength: "textLength";
        Time: "time";
        Whole: "wholeNumber";
    } = ...

    Selectors

    Type Declaration

    • ReadonlyDate: "date"
    • ReadonlyDateTime: "dateTime"
    • ReadonlyDisplay: "display"

      The text a cell SHOWS: under a filter the displayed text, so $1 is a cell holding 1 under $0; under a format or a validation, where nothing is shown at evaluation, the value's own text. Type text. Excel's filter equal and its values list compare this way; equalTo under no selector is value equality.

    • ReadonlyLogical: "logical"
    • ReadonlyNumber: "number"
    • ReadonlyText: "text"
    • ReadonlyTextLength: "textLength"
    • ReadonlyTime: "time"
    • ReadonlyWhole: "wholeNumber"

    A selector is how a condition reads a value: it gates (a value of another kind is not this kind) and projects (date is the day, textLength the count). No selector is "any value".

    Membership is not among them. A list is the BuiltInOperatorNames.InSet operator, which every selector offers; the name 'list' is still read, as no selector with inSet.