custom= "Custom" 自定义数据验证类型。 [API 集:ExcelApi 1.8] date= "Date" 日期数据验证类型。 [API 集:ExcelApi 1.8] decimal= "Decimal" 十进制数据验证类型。 [API 集:ExcelApi 1.8] inconsistent= "Inconsistent" 不一致意味着区域的数据验证不一致,指示不同单元格上存在不同的规则。
awaitExcel.run(async(context) => {letsheet = context.workbook.worksheets.getActiveWorksheet();letcommentsRange = sheet.tables.getItem("AthletesTable").columns.getItem("Comments").getDataBodyRange(); commentsRange.dataValidation.rule = {custom: {formula:"=NOT(ISNUMBER(SEARCH(A2,B2)))"} };await...
CustomFilters DataBar DataBarAxisPositionValues DataBarDirectionValues DataField DatastoreItem DataValidation 概述 构造函数 属性 方法 DataValidationFormulaType DataValidationForumla1 DataValidationForumla2 DataValidations DdeValues DefinedName DefinedNames
Weitere Informationen finden Sie unterExcel.DataValidationTypeTyp der Datenüberprüfung. TypeScript readonlytype: Excel.DataValidationType |"None"|"WholeNumber"|"Decimal"|"List"|"Date"|"Time"|"TextLength"|"Custom"|"Inconsistent"|"MixedCriteria"; ...
Using data validation: Select the cells you want to apply the rule to. In the following, I will assume that A1 is the active cell in the selection. On the Data tab of the ribbon, click Data Validation. Select Custom from the Allow dropdown. Enter the formula =MOD(100*A1,1)=0 where...
Custom– for custom formula. UnderData, select a condition. Set the other required values based on what you chose forAllowandData. Select theInput Messagetab and customize a message users will see when entering data. Select theShow input message when cell is selectedcheckbox to display the mess...
In Excel 2007 it became possible to reference cells that are not on the same worksheet What can you use Data Validation for ? 1) For restricting the type of data that can be entered in a particular cell. 2) To provide a drop-down list of values that can be entered in a particular ...
custom = "Custom" The custom data validation type. [ API set: ExcelApi 1.8 ] date = "Date" The date data validation type. [ API set: ExcelApi 1.8 ] decimal = "Decimal" The decimal data validation type. [ API set: ExcelApi 1.8 ] inconsistent = "Inconsistent" Inconsistent ...
Here we have some formula in data validation tool and we need to custom or change error message whenever cell reject any value in ExcelNow when I enter the value as shown below. A default error generates.As you can see an error is generated "This value doesn't match the data validation...
CustomUI DocumentFormat.OpenXml.Office.CustomXsn DocumentFormat.OpenXml.Office.Drawing DocumentFormat.OpenXml.Office.Drawing.Y2021.OEmbed DocumentFormat.OpenXml.Office.Drawing.Y2021.ScriptLink DocumentFormat.OpenXml.Office.Drawing.Y2022.ImageFormula DocumentFormat.OpenXml.Office.Excel DocumentFormat.OpenXml....