# @univerjs/preset-sheets-advanced

> Language fallback: requested `ko-KR`; content is `en-US`.

- Human documentation: [https://docs.univer.ai/ko-KR/reference/packages/presets/univerjs/preset-sheets-advanced](https://docs.univer.ai/ko-KR/reference/packages/presets/univerjs/preset-sheets-advanced)

- Agent Markdown: [https://docs.univer.ai/ko-KR/reference/packages/presets/univerjs/preset-sheets-advanced.md](https://docs.univer.ai/ko-KR/reference/packages/presets/univerjs/preset-sheets-advanced.md)

- Requested language: `ko-KR`

- Content language: `en-US`

- Documentation version: `1.0.4`

- Source: [packages/presets/univerjs/preset-sheets-advanced.mdx](https://github.com/dream-num/documentation/blob/dev/content/reference/packages/presets/univerjs/preset-sheets-advanced.mdx)

---

```typescript
import { UniverSheetsAdvancedPreset } from '@univerjs/preset-sheets-advanced'

const preset = UniverSheetsAdvancedPreset()
```

The preset includes the Sheets PivotTable, chart, and PivotChart model/UI plugins. Use it with the Sheets core and drawing presets. For PivotChart APIs, also import `@univerjs-pro/sheets-pivot-chart/facade`; see the [PivotChart guide](https://docs.univer.ai/ko-KR/guides/sheets/features/pivot-chart.md).

With Worker calculation, pair `UniverSheetsAdvancedPreset({ useWorker: true })` on the main thread with `UniverSheetsAdvancedWorkerPreset()` from `@univerjs/preset-sheets-advanced/worker`. The Worker preset registers `UniverSheetsPivotChartWorkerPlugin`; drawing and chart bindings remain on the main thread.

## IUniverSheetsAdvancedPresetConfig

| Option                    | Type                                         | Behavior                                                                                                                                          |
| ------------------------- | -------------------------------------------- | ------------------------------------------------------------------------------------------------------------------------------------------------- |
| `license`                 | `string`                                     | License passed to `UniverLicensePlugin`.                                                                                                          |
| `universerEndpoint`       | `string`                                     | Base URL for exchange upload, task, signed URL, import, export, and download endpoints.                                                           |
| `useWorker`               | `boolean`                                    | Disables main-thread calculation in the Pro formula, PivotTable, and PivotChart plugins. Configure the Worker and its advanced preset separately. |
| `formula.function`        | `custom function configuration`              | Custom functions passed to the Pro formula engine.                                                                                                |
| `exchangeClientOptions`   | `Partial<IUniverSheetsExchangeClientConfig>` | Spreadsheet import/export options; see [exchange configuration](https://docs.univer.ai/ko-KR/reference/packages/plugins/univerjs-pro/sheets-exchange-client.md).                 |
| `print.enforceWatermark`  | `boolean`                                    | Controls print watermark enforcement.                                                                                                             |
| `pivot.maxLimitItemCount` | `number`                                     | Maximum pivot item limit.                                                                                                                         |