高阶公式 0.5.0+

Facade API	可付费升级	需要 Univer 服务端	Univer on Node.js	Preset
✅	✅	-	✅	UniverSheetsAdvancedPreset

Univer 高级版公式提供了新的计算引擎，在计算性能上进行了优化。

该功能包含以下插件包：

@univerjs-pro/engine-formula 高阶公式引擎插件

Presets 安装


import { createUniver, defaultTheme, LocaleType, merge } from '@univerjs/presets';
import { UniverSheetsCorePreset } from '@univerjs/presets/preset-sheets-core';
import UniverPresetSheetsCoreZhCN from '@univerjs/presets/preset-sheets-core/locales/zh-CN';
import { UniverSheetsAdvancedPreset } from '@univerjs/presets/preset-sheets-advanced';
import UniverPresetSheetsAdvancedZhCN from '@univerjs/presets/preset-sheets-advanced/locales/zh-CN';
import { UniverSheetsDrawingPreset } from '@univerjs/presets/preset-sheets-drawing'
import UniverPresetSheetsDrawingZhCN from '@univerjs/presets/preset-sheets-drawing/locales/zh-CN'
 
import '@univerjs/presets/lib/styles/preset-sheets-core.css'
import '@univerjs/presets/lib/styles/preset-sheets-drawing.css'
import '@univerjs/presets/lib/styles/preset-sheets-advanced.css'
 
const { univerAPI } = createUniver({
  locale: LocaleType.ZH_CN,
  locales: {
    [LocaleType.ZH_CN]: merge(
      {},
      UniverPresetSheetsCoreZhCN,
      UniverPresetSheetsDrawingZhCN,
      UniverPresetSheetsAdvancedZhCN,
    ),
  },
  theme: defaultTheme,
  presets: [
    UniverSheetsCorePreset(),
    UniverSheetsDrawingPreset(),
    UniverSheetsAdvancedPreset(),
  ],
});

手动组合安装


npm install @univerjs-pro/engine-formula


pnpm add @univerjs-pro/engine-formula


yarn add @univerjs-pro/engine-formula


bun add @univerjs-pro/engine-formula


import { LocaleType, merge } from '@univerjs/core';
- import { UniverFormulaEnginePlugin } from '@univerjs/engine-formula'
import { UniverProFormulaEnginePlugin } from '@univerjs-pro/engine-formula'
 
- univer.registerPlugin(UniverFormulaEnginePlugin);
+ univer.registerPlugin(UniverProFormulaEnginePlugin);

Facade API

参考公式 Facade API 章节。