SheetXL - v1.0.2
    Preparing search index...

    Function renderDataValidation

    • Renders one data validation's report — where it applies, what it permits, and what a reader is told when it does not.

      Parameters

      • validation: IDataValidation

      Returns string

      A validation is a precondition on writing, which is why an agent reads one: it is the difference between a value that will be accepted and one that will be refused, and the list of allowed values is very often the only place a sheet states its own vocabulary.

      The prompt and alert text are on this report and not in any listing, because they are prose — and because the alert text is frequently where the author explained the rule in words.