# 高階公式引擎

- Human documentation: [https://docs.univer.ai/zh-TW/guides/sheets/features/advanced-formula](https://docs.univer.ai/zh-TW/guides/sheets/features/advanced-formula)

- Agent Markdown: [https://docs.univer.ai/zh-TW/guides/sheets/features/advanced-formula.md](https://docs.univer.ai/zh-TW/guides/sheets/features/advanced-formula.md)

- Requested language: `zh-TW`

- Content language: `zh-TW`

- Documentation version: `1.2.0`

- Source: [sheets/features/advanced-formula.zh-TW.mdx](https://github.com/dream-num/documentation/blob/dev/content/guides/sheets/features/advanced-formula.zh-TW.mdx)

---

#### Package metadata

```json
{
  "preset": [
    {
      "client": "@univerjs/preset-sheets-advanced",
      "locale": "@univerjs/preset-sheets-advanced/locales/zh-TW",
      "style": "@univerjs/preset-sheets-advanced/lib/index.css"
    }
  ],
  "plugins": [
    {
      "client": "@univerjs-pro/engine-formula",
      "facade": "@univerjs-pro/engine-formula/facade"
    }
  ],
  "license": true,
  "server": false
}
```

高階公式引擎最佳化了原有的公式引擎，提供了更高效的計算效能和更豐富的功能。它支援多種複雜的公式計算，能夠處理大規模資料集，並且提供了更好的錯誤處理和除錯功能。

## 外掛模式

### 安裝

#### npm

```bash
npm install @univerjs-pro/engine-formula
```

#### pnpm

```bash
pnpm add @univerjs-pro/engine-formula
```

#### yarn

```bash
yarn add @univerjs-pro/engine-formula
```

#### bun

```bash
bun add @univerjs-pro/engine-formula
```

### 使用

使用高階公式引擎需要將原有的 `UniverFormulaEnginePlugin` 替換為 `UniverProFormulaEnginePlugin`。

```typescript
import { UniverProFormulaEnginePlugin } from '@univerjs-pro/engine-formula' // [!code ++]
import { UniverFormulaEnginePlugin } from '@univerjs/engine-formula' // [!code --]

univer.registerPlugin(UniverFormulaEnginePlugin) // [!code --]
univer.registerPlugin(UniverProFormulaEnginePlugin) // [!code ++]
```

如果你擁有 Univer 的商業許可證，請參考[在客戶端使用許可證](https://docs.univer.ai/zh-TW/server/license.md#in-plugin-mode)進行配置。

## 預設模式

高階公式引擎被包含在 `@univerjs/preset-sheets-advanced` 預設中。

### 安裝

> [!NOTE]
> @univerjs/preset-sheets-advanced 的 `UniverSheetsAdvancedPreset` 預設在執行時依賴 `UniverSheetsDrawingPreset` 預設，請先安裝 @univerjs/preset-sheets-drawing。

#### npm

```bash
npm install @univerjs/preset-sheets-drawing @univerjs/preset-sheets-advanced
```

#### pnpm

```bash
pnpm add @univerjs/preset-sheets-drawing @univerjs/preset-sheets-advanced
```

#### yarn

```bash
yarn add @univerjs/preset-sheets-drawing @univerjs/preset-sheets-advanced
```

#### bun

```bash
bun add @univerjs/preset-sheets-drawing @univerjs/preset-sheets-advanced
```

### 使用

```typescript
import { UniverSheetsAdvancedPreset } from '@univerjs/preset-sheets-advanced' // [!code ++]
import UniverPresetSheetsAdvancedZhTW from '@univerjs/preset-sheets-advanced/locales/zh-TW' // [!code ++]
import { UniverSheetsCorePreset } from '@univerjs/preset-sheets-core'
import UniverPresetSheetsCoreZhTW from '@univerjs/preset-sheets-core/locales/zh-TW'
import { UniverSheetsDrawingPreset } from '@univerjs/preset-sheets-drawing' // [!code ++]
import UniverPresetSheetsDrawingZhTW from '@univerjs/preset-sheets-drawing/locales/zh-TW' // [!code ++]
import { createUniver, LocaleType, mergeLocales } from '@univerjs/presets'

import '@univerjs/preset-sheets-core/lib/index.css'
import '@univerjs/preset-sheets-drawing/lib/index.css' // [!code ++]
import '@univerjs/preset-sheets-advanced/lib/index.css' // [!code ++]

const { univerAPI } = createUniver({
  locale: LocaleType.ZH_TW,
  locales: {
    [LocaleType.ZH_TW]: mergeLocales(
      UniverPresetSheetsCoreZhTW,
      UniverPresetSheetsDrawingZhTW, // [!code ++]
      UniverPresetSheetsAdvancedZhTW, // [!code ++]
    ),
  },
  presets: [
    UniverSheetsCorePreset(),
    UniverSheetsDrawingPreset(), // [!code ++]
    UniverSheetsAdvancedPreset(), // [!code ++]
  ],
})
```

如果你擁有 Univer 的商業許可證，請參考[在客戶端使用許可證](https://docs.univer.ai/zh-TW/server/license.md#in-preset-mode)進行配置。