数据验证

UniverSheetsDataValidationPreset({  /**   * 是否在下拉菜单中显示编辑按钮   * @default true   */  showEditOnDropdown: true,  /**   * 是否在下拉菜单中显示搜索框   * @default true   */  showSearchOnDropdown: true,})

univer.registerPlugin(UniverSheetsDataValidationUIPlugin, {  /**   * 是否在下拉菜单中显示编辑按钮   * @default true   */  showEditOnDropdown: true,  /**   * 是否在下拉菜单中显示搜索框   * @default true   */  showSearchOnDropdown: true,})

import '@univerjs/sheets-data-validation/facade'

const fWorkbook = univerAPI.getActiveWorkbook()const fWorksheet = fWorkbook.getActiveSheet()// 创建一个新的数据验证规则，要求 A1:B10 范围内的数字在 1 到 10 之间const fRange = fWorksheet.getRange('A1:B10')const rule = univerAPI.newDataValidation()  .requireNumberBetween(1, 10)  .setOptions({    allowBlank: true,    showErrorMessage: true,    error: 'Please enter a number between 1 and 10',  })  .build()fRange.setDataValidation(rule)

const fWorkbook = univerAPI.getActiveWorkbook()const fWorksheet = fWorkbook.getActiveSheet()// 清除 A1:B10 范围内的数据验证规则const fRange = fWorksheet.getRange('A1:B10')fRange.setDataValidation(null)

const fWorkbook = univerAPI.getActiveWorkbook()const fWorksheet = fWorkbook.getActiveSheet()// 获取当前工作表的所有数据验证规则const rulesOfSheet = fWorksheet.getDataValidations()// 通过规则 ID 获取数据验证规则const ruleById = fWorksheet.getDataValidation(rulesOfSheet[0]?.rule?.uid)const fRange = fWorksheet.getRange('A1:B10')// 获取当前范围的第一个数据验证规则const ruleOfRange = fRange.getDataValidation()ruleOfRange?.getCriteriaValues()// 获取当前范围的所有数据验证规则const rulesOfRange = fRange.getDataValidations()

const fWorkbook = univerAPI.getActiveWorkbook()const fWorksheet = fWorkbook.getActiveSheet()// 获取当前工作簿的所有数据验证错误const workbookErrors = await fWorkbook.getAllDataValidationErrorAsync()console.log('workbookErrors:', workbookErrors)// 获取当前工作表的所有数据验证错误const worksheetErrors = await fWorksheet.getAllDataValidationErrorAsync()console.log('worksheetErrors:', worksheetErrors)// 获取当前范围的数据验证错误const fRange = fWorksheet.getRange('A1:B10')const rangeErrors = await fRange.getDataValidationErrorAsync()console.log('rangeErrors:', rangeErrors)

const fWorkbook = univerAPI.getActiveWorkbook()const fWorksheet = fWorkbook.getActiveSheet()// 获取当前工作簿的数据验证校验状态fWorkbook.getValidatorStatus().then((status) => {})// 获取当前工作表的数据验证校验状态fWorksheet.getValidatorStatusAsync().then((status) => {})// 获取当前范围的数据验证校验状态const fRange = fWorksheet.getRange('A1:B10')fRange.getValidatorStatus().then((status) => {})

const disposable = univerAPI.addEvent(univerAPI.Event.SheetDataValidationChanged, (params) => {  const { origin, worksheet, workbook, changeType, oldRule, rule } = params})// 移除事件监听器，使用 `disposable.dispose()`

const disposable = univerAPI.addEvent(univerAPI.Event.BeforeSheetDataValidationAdd, (params) => {  const { worksheet, workbook, rule } = params  // 取消添加验证规则操作  params.cancel = true})// 移除事件监听器，使用 `disposable.dispose()`

const disposable = univerAPI.addEvent(univerAPI.Event.BeforeSheetDataValidationDelete, (params) => {  const { worksheet, workbook, ruleId, rule } = params  // 取消删除验证规则操作  params.cancel = true})// 移除事件监听器，使用 `disposable.dispose()`

const disposable = univerAPI.addEvent(univerAPI.Event.BeforeSheetDataValidationDeleteAll, (params) => {  const { worksheet, workbook, rules } = params  // 取消删除所有验证规则操作  params.cancel = true})// 移除事件监听器，使用 `disposable.dispose()`

const disposable = univerAPI.addEvent(univerAPI.Event.BeforeSheetDataValidationCriteriaUpdate, (params) => {  const { worksheet, workbook, ruleId, rule, newCriteria } = params  // 取消更新验证规则条件操作  params.cancel = true})// 移除事件监听器，使用 `disposable.dispose()`

const disposable = univerAPI.addEvent(univerAPI.Event.BeforeSheetDataValidationRangeUpdate, (params) => {  const { worksheet, workbook, ruleId, rule, newRanges } = params  // 取消更新验证规则范围操作  params.cancel = true})// 移除事件监听器，使用 `disposable.dispose()`

const disposable = univerAPI.addEvent(univerAPI.Event.BeforeSheetDataValidationOptionsUpdate, (params) => {  const { worksheet, workbook, ruleId, rule, newOptions } = params  // 取消更新验证规则选项操作  params.cancel = true})// 移除事件监听器，使用 `disposable.dispose()`

const disposable = univerAPI.addEvent(univerAPI.Event.SheetDataValidatorStatusChanged, (params) => {  const { worksheet, workbook, row, column, status, rule } = params})// 移除事件监听器，使用 `disposable.dispose()`

const fWorkbook = univerAPI.getActiveWorkbook()const fWorksheet = fWorkbook.getActiveSheet()const fRange = fWorksheet.getRange('A1:B10')const rule = univerAPI.newDataValidation()  .requireNumberBetween(1, 10)  .setOptions({    allowBlank: true,    showErrorMessage: true,    error: '请输入 1 到 10 之间的数字',    errorStyle: univerAPI.Enum.DataValidationErrorStyle.STOP,  })  .build()fRange.setDataValidation(rule)

const fWorkbook = univerAPI.getActiveWorkbook()const fWorksheet = fWorkbook.getActiveSheet()const fRange = fWorksheet.getRange('A1:B10')fRange.getDataValidation()?.setOptions({  // support TEXT, ARROW, CUSTOM  // default is `CUSTOM`  renderMode: univerAPI.Enum.DataValidationRenderMode.TEXT,})