Advanced Formula Engine
The Advanced Formula Engine replaces the built-in formula engine. It calculates faster, handles large datasets, and supports more complex formula calculations. Error handling and debugging are better than in the default engine.
Plugin Mode
Installation
pnpm add @univerjs-pro/engine-formulanpm install @univerjs-pro/engine-formulayarn add @univerjs-pro/engine-formulabun add @univerjs-pro/engine-formulaUsage
To use the Advanced Formula Engine, replace UniverFormulaEnginePlugin with UniverProFormulaEnginePlugin.
import { UniverProFormulaEnginePlugin } from '@univerjs-pro/engine-formula'import { UniverFormulaEnginePlugin } from '@univerjs/engine-formula'univer.registerPlugin(UniverFormulaEnginePlugin)univer.registerPlugin(UniverProFormulaEnginePlugin)If you have a commercial license for Univer, see Using License in Client for setup instructions.
Preset Mode
The Advanced Formula Engine is included in the @univerjs/preset-sheets-advanced preset.
Installation
UniverSheetsAdvancedPreset from @univerjs/preset-sheets-advanced depends on UniverSheetsDrawingPreset at runtime. Install @univerjs/preset-sheets-drawing first.
pnpm add @univerjs/preset-sheets-drawing @univerjs/preset-sheets-advancednpm install @univerjs/preset-sheets-drawing @univerjs/preset-sheets-advancedyarn add @univerjs/preset-sheets-drawing @univerjs/preset-sheets-advancedbun add @univerjs/preset-sheets-drawing @univerjs/preset-sheets-advancedUsage
import { UniverSheetsAdvancedPreset } from '@univerjs/preset-sheets-advanced'import UniverPresetSheetsAdvancedEnUS from '@univerjs/preset-sheets-advanced/locales/en-US'import { UniverSheetsCorePreset } from '@univerjs/preset-sheets-core'import UniverPresetSheetsCoreEnUS from '@univerjs/preset-sheets-core/locales/en-US'import { UniverSheetsDrawingPreset } from '@univerjs/preset-sheets-drawing'import UniverPresetSheetsDrawingEnUS from '@univerjs/preset-sheets-drawing/locales/en-US'import { createUniver, LocaleType, mergeLocales } from '@univerjs/presets'import '@univerjs/preset-sheets-core/lib/index.css'import '@univerjs/preset-sheets-drawing/lib/index.css'import '@univerjs/preset-sheets-advanced/lib/index.css'const { univerAPI } = createUniver({ locale: LocaleType.EN_US, locales: { [LocaleType.EN_US]: mergeLocales( UniverPresetSheetsCoreEnUS, UniverPresetSheetsDrawingEnUS, UniverPresetSheetsAdvancedEnUS, ), }, presets: [ UniverSheetsCorePreset(), UniverSheetsDrawingPreset(), UniverSheetsAdvancedPreset(), ],})If you have a commercial license for Univer, see Using License in Client for setup instructions.
How is this guide?