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

Shell
pnpm add @univerjs-pro/engine-formula

Usage

To use the Advanced Formula Engine, replace UniverFormulaEnginePlugin with UniverProFormulaEnginePlugin.

TypeScript
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.

Shell
pnpm add @univerjs/preset-sheets-drawing @univerjs/preset-sheets-advanced

Usage

TypeScript
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?

© 2026 DreamNum Co., Ltd.