What's 'inconsistent' & 'mixedCriteria' ? about office-scripts-docs-reference

[AlexJerabek]

Hi @YeeJone,

Thanks for the question. I'm going to write up an example today and share it with you. Basically, neither of these values will never be explicitly set by a script. For both, they are the results of read operations on ranges with existing data validation rules.

The following script tells you DataValidationType of the selected range. If you select multiple cells with different validation rules (like one uses "Number" and the other uses "List"), you'll get "Inconsistent".

function main(workbook: ExcelScript.Workbook) {
  let range = workbook.getSelectedRange();
  console.log(range.getDataValidation().getType());
}

[AlexJerabek]

Also @YeeJone, is there a particular scenario you're trying to complete? Or are you just learning about the details of data validation?

[AlexJerabek]

I added a sample (#119) showing how to access this enum and added another phrasing to clear up the confusion between incosistent and mixedCriteria. Hopefully that helps, but please let me know if it doesn't.

However, I think that in looking into this, I may have found an issue in the JavaScript code. It seems like inconsistent is being returned when mixedCriteria should be instead. I've opened an internal work item to track this investigation and will report back here as I learn things.

[YeeJone]

@AlexJerabek
Thank you for your reply. I probably understand what circumstances these two types will appear...
From the above description, these two types will only be applied in the code? Will there be these two types in an Excel exported XML file?

[AlexJerabek]

Hi @YeeJone,

If I understand your question correctly, yes, these types are only in code. They are not a type of data validation, but rather the return value for multiple types of data validation are applied on the selected range.

Do you have any other questions, or should I close this issue?

[YeeJone]

Hi @YeeJone,

If I understand your question correctly, yes, these types are only in code. They are not a type of data validation, but rather the return value for multiple types of data validation are applied on the selected range.

Do you have any other questions, or should I close this issue?

Thanks～