spreadsheetAddDataValidationRule

Adds a data validation rule that restricts what can be entered in a range of cells.

spreadsheetAddDataValidationRule(spreadsheetObj, validationRule) → returns void

This function requires Adobe ColdFusion 2025 and up.  Not supported on Lucee, etc.
  1. CFDocs
  2. Functions
  3. ColdFusion 2025 New Functions and Tags
  4. spreadsheetAddDataValidationRule
  5. CF2025+
  6. 0 Issue
  7. Edit
See Also:   spreadsheetadddatavalidation

Argument Reference

spreadsheetObj any
Required

The spreadsheet object.

validationRule struct
Required

Struct describing the rule. Keys: validationType (integer, double, list, date or text_length), regions (array of structs with startRow, startColumn, endRow, endColumn), value, operator (greater_than, less_than, greater_or_equal, less_or_equal, equal, not_equal, between, not_between), minValue, maxValue, alertTitle, alertText, cellSelectTitle, cellSelectText.

Examples
Sample code invoking the spreadsheetAddDataValidationRule function

Signup for cfbreak to stay updated on the latest news from the ColdFusion / CFML community. One email, every friday.

Fork me on GitHub