Clarity on Any Validation in Data Validation

Clarity on Any Validation in Data Validation

Posted by: sbhadane on 4 October 2025, 1:02 am EST

• 

  sbhadane

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 4 October 2025, 1:02 am EST

  Hi ,

  I am trying to understand how does any validation work and what are the invalid cases for it .
  
  Also can we highlight the cell in any validation for blank cell like in case of number validation or other.

  Thanks & Regards,
  
  Saurabh R. Bhadane

• 

  priyam.kushwaha

  

  • Post Options:
  • Link
    Copy

  Posted 6 October 2025, 4:58 am EST - Updated 6 October 2025, 5:03 am EST

  Hi Saurabh,

  As per my understanding, when you refer to “any validation,” you mean a validation type similar to other types like number, date, or list (as shown in the attached image).

  

  704×533 6.4 KB

  The “Any” validation type essentially means that no restrictions are applied to the cell input. When this validation type is used, all kinds of input—text, numbers, dates, formulas, and even blanks—are considered valid. Hence, there are no invalid cases for this type of validation.

  If you wish to highlight blank cells while using “Any” validation, it won’t happen automatically since blanks are treated as valid. However, you can use Text Length validation instead, with a minimum length of 1. This ensures that at least one character is required, making empty cells invalid and therefore highlighted—functioning similarly to “Any” validation, but excluding empty cells.

  You can refer to the documentation for more details https://developer.mescius.com/spreadjs/docs/features/datavalidate#text-length-validation

  Regards,
  
  Priyam