SheetXL - v0.8.0-beta.9+sites.210.e2d420901
    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.