資料驗證

univer.registerPlugin(UniverSheetsDataValidationUIPlugin, {  /**   * 是否在下拉選單中顯示編輯按鈕   * @default true   */  showEditOnDropdown: true,  /**   * 是否在下拉選單中顯示搜尋框   * @default true   */  showSearchOnDropdown: true,})

UniverSheetsDataValidationPreset({  /**   * 是否在下拉選單中顯示編輯按鈕   * @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,})