/** * Copyright 2023-present DreamNum Co., Ltd. * * Licensed under the Apache License, Version 2.0 (the "License"); * you may not use this file except in compliance with the License. * You may obtain a copy of the License at * * http://www.apache.org/licenses/LICENSE-2.0 * * Unless required by applicable law or agreed to in writing, software * distributed under the License is distributed on an "AS IS" BASIS, * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. * See the License for the specific language governing permissions and * limitations under the License. */ import type { ICellData, ISheetDataValidationRule, IUnitRangeName, IUniverInstanceService, Nullable, Workbook } from '@univerjs/core'; import type { LexerTreeBuilder } from '@univerjs/engine-formula'; import type { ISheetLocationBase } from '@univerjs/sheets'; import { isFormulaString, Range, UniverInstanceType } from '@univerjs/core'; import { deserializeListOptions } from '@univerjs/sheets'; import { getCellValueOrigin } from '../utils/get-cell-data-origin'; import { getRangeInWorksheet } from '../utils/range'; export function getSheetRangeValueSet(grid: IUnitRangeName, univerInstanceService: IUniverInstanceService, currUnitId: string, currSubUnitId: string) { const set = new Set(); const unitId = grid.unitId || currUnitId; const workbook = univerInstanceService.getUnit(unitId, UniverInstanceType.UNIVER_SHEET) ?? univerInstanceService.getCurrentUnitOfType(UniverInstanceType.UNIVER_SHEET); if (!workbook) { return []; } const worksheet = workbook.getSheetBySheetName(grid.sheetName) ?? workbook.getSheetBySheetId(currSubUnitId) ?? workbook.getActiveSheet(); if (!worksheet) { return []; } const range = getRangeInWorksheet(grid.range, worksheet); if (!range) { return []; } Range.foreach(range, (row, col) => { const data = worksheet.getCellRaw(row, col); if (!data) { return; } const cellValue = getCellValueOrigin(data); if (cellValue === undefined || cellValue === null || cellValue === '') { return; } const list = deserializeListOptions(`${cellValue}`); list.forEach((item) => { if (item) { set.add(`${cellValue}`); } }); }); return Array.from(set); } export function getDataValidationCellValue(cellData: Nullable) { const cellValue = getCellValueOrigin(cellData); if (cellValue === undefined || cellValue === null) { return ''; } return cellValue.toString(); } export function getTransformedFormula(lexerTreeBuilder: LexerTreeBuilder, rule: ISheetDataValidationRule, position: ISheetLocationBase) { const { formula1, formula2 } = rule; const originStartRow = rule.ranges[0].startRow; const originStartColumn = rule.ranges[0].startColumn; const offsetRow = position.row - originStartRow; const offsetColumn = position.col - originStartColumn; const transformedFormula1 = isFormulaString(formula1) ? lexerTreeBuilder.moveFormulaRefOffset(formula1!, offsetColumn, offsetRow, true) : formula1; const transformedFormula2 = isFormulaString(formula2) ? lexerTreeBuilder.moveFormulaRefOffset(formula2!, offsetColumn, offsetRow, true) : formula2; return { transformedFormula1, transformedFormula2, }; }