GuidesUniver SheetsFeaturesCoreAdvanced FormulaPro

Advanced Formula 0.5.0+

Facade APIPaid VersionUniver ServerUniver on Node.jsPreset
--UniverSheetsAdvancedPreset

Univer advanced formula provides a new calculation engine that optimizes calculation performance.

This feature includes the following plugin packages:

Presets Installation

import { createUniver, defaultTheme, LocaleType, Tools } from '@univerjs/presets';
import { UniverSheetsCorePreset } from '@univerjs/presets/preset-sheets-core';
import UniverPresetSheetsCoreEnUS from '@univerjs/presets/preset-sheets-core/locales/en-US';
import { UniverSheetsAdvancedPreset } from '@univerjs/presets/preset-sheets-advanced';
import UniverPresetSheetsAdvancedEnUS from '@univerjs/presets/preset-sheets-advanced/locales/en-US';
 
const { univerAPI } = createUniver({
  locale: LocaleType.EN_US,
  locales: {
    enUS: Tools.deepMerge(
      {},
      UniverPresetSheetsCoreEnUS,
      UniverPresetSheetsAdvancedEnUS,
    ),
  },
  theme: defaultTheme,
  presets: [
    UniverSheetsCorePreset(),
    UniverSheetsAdvancedPreset(),
  ],
});

Advanced Installation

npm install @univerjs-pro/engine-formula
import { LocaleType, Tools } from '@univerjs/core';
- import { UniverFormulaEnginePlugin } from '@univerjs/engine-formula'
import { UniverProEngineFormulaPlugin } from '@univerjs-pro/engine-formula'
 
- univer.registerPlugin(UniverFormulaEnginePlugin);
+ univer.registerPlugin(UniverProEngineFormulaPlugin);