v0.22.0

## 🎊 Univer@v0.22.0

### 🚧 Important Note

Univer Sheets features are becoming more stable, and we are planning for the release of version 1.0.
If you have any suggestions, please submit them in our [issues](https://github.com/dream-num/univer/issues) to help us shape the future of Univer.

### 🚀 Getting Started

If you're eager to explore Univer, check out our [getting started documentation](https://docs.univer.ai/guides/sheets/getting-started/installation).
Dive into the world of collaborative document, spreadsheet, and presentation editing powered by Univer!

### 📊 Univer Sheets

#### ✨ New Features Highlights

- `UniverDrawingPlugin` added a new configuration item `allowImageSize` to support limiting the maximum size of uploaded images. #6865
- `UniverSheetsUIPlugin` added a new configuration item `footer.addSheetButtonConfig` to customize the behavior of the "Add Sheet" button: #6866
  - `show`: Whether to show the add sheet button, default is `true`.
  - `defaultRowCount`: The default number of rows for a new sheet, default is `1000`.
  - `defaultColumnCount`: The default number of columns for a new sheet, default is `20`.

#### 🐛 Bug Fixes and Optimizations

- **Image Related**
  - Fix the issue of floating images not updating their position correctly after hiding rows/columns. #6842
  - Fix the issue of incorrect hot zone calculation for the zoom button in cell image preview. #6845
- **Copy and Paste**
  - Fix the issue of some number formatted text copied from Excel not being parsed correctly. #6844
  - Fix the issue of character loss when copying text containing `<>` from Univer to Excel. #6850
- **Permission Control**
  - Fix the issue of toolbar disabled status not refreshing in time after updating the current range permission point. #6853
  - Fix the issue of being able to modify styles within a full selection (`Ctrl + A`) that contains non-editable areas. #6853
  - Fix the issue of the API for setting borders not being subject to permission control. #6853
  - Fix the issue of defined name related operations not being subject to permission control. #6857
  - Fix the issue of the disabled status listener for the context menu in the sheet bar not being triggered. #6877
- **Others**
  - Fix the issue of the submenu in the context menu not disappearing when clicking it. #6858
  - Fix the issue of text containing `\n` not wrapping correctly in the cell when word wrap is enabled. #6859
  - Fix the issue of row height not updating correctly after clearing cell content or styles. #6870
  - Optimize the performance of `Lexer.treeBuilder` in scenarios with a large number of defined names. #6873
  - Optimize the boundary cases where the width and height of the last row/column cannot be changed via UI. #6876
  - Fix the issue of chart styles being reset after copy/paste/delete/undo in scenarios where the chart style is a non-default style.
  - Optimize the display style of history records when there are many operators.
  - Fix the issue of triangle shape adjustment nodes not being able to be dragged to the right.

Special thanks to community contributor @kenny-not-dead for contributions in this version:

- Fix the issue of page margins in doc page settings supporting negative values. #6838
- Fix the issue of paragraph alignment in doc not being highlighted. #6854
- Fix the issue of unordered lists in doc not being highlighted. #6856

Special thanks to community contributor @IMSupperkaka for contributions in this version:

- Fix the issue of shortcuts (bold/italic/underline/strikethrough) not working in cell editing state. #6851

Special thanks to community contributor @getmateri for contributions in this version:

- Fix the issue of styles not being cleared in target cells when copy filling blank cells in some scenarios. #6869

### 🌐 Univer Server

- Fix the issue of string condition values being lost after importing when the conditional format is "equal to a certain string".
- Fix the issue of content loss when importing certain charts.

### 📦 Univer Presets

- SDK has been updated to version 0.22.0.
- `UniverSheetsCorePreset` has been updated to support the `footer.addSheetButtonConfig` configuration item.
- `UniverSheetsDrawingPreset` has been updated to support the `allowImageSize` configuration item.

### 📢 Join the Conversation

We welcome your input and insights as we embark on this exciting journey. Connect with us on:

- :octocat: [GitHub Discussions](https://github.com/dream-num/univer/discussions)
- 👾 [Discord](https://discord.gg/z3NKNT6D2f)

### 📝 Changelog

[Full changelog](https://github.com/dream-num/univer/compare/v0.21.1...v0.22.0) (2026-05-09)

### Bug Fixes

* active alignment style ([#6854](https://github.com/dream-num/univer/issues/6854)) ([15cdf62](https://github.com/dream-num/univer/commit/15cdf62020d514d23fb70694819bb44ade3983e1))
* active list value ([#6856](https://github.com/dream-num/univer/issues/6856)) ([0ac415c](https://github.com/dream-num/univer/commit/0ac415cbf04c034e724bae31be0b37cfe67e3849))
* **cellImage:** fix defects in image enlargement hot zone calculation ([#6845](https://github.com/dream-num/univer/issues/6845)) ([0e30fea](https://github.com/dream-num/univer/commit/0e30feaff54c643206412a06cce5428dd8cb66c5))
* **copy:** fix unescaped special characters such as `<>` in copied HTML ([#6850](https://github.com/dream-num/univer/issues/6850)) ([7ba9b6a](https://github.com/dream-num/univer/commit/7ba9b6aafa63f5394bc2a98daf4d826a2583944c))
* **definedName:** add defined name permission controller ([#6857](https://github.com/dream-num/univer/issues/6857)) ([44dbe3b](https://github.com/dream-num/univer/commit/44dbe3ba4d296478866e12cadb92a3b267ea0ce1))
* **definedName:** fix lexer.treeBuilder performance ([#6873](https://github.com/dream-num/univer/issues/6873)) ([ed89f1f](https://github.com/dream-num/univer/commit/ed89f1fc9cf230027c4996b4047dba0e16268b34))
* **drawing:** fix floating images did not update their position along with hidden rows and columns ([#6842](https://github.com/dream-num/univer/issues/6842)) ([a46d82b](https://github.com/dream-num/univer/commit/a46d82b9e7716a8a555c89baa735cfd0015aeb9c))
* fix copy html error ([#6861](https://github.com/dream-num/univer/issues/6861)) ([eca1af9](https://github.com/dream-num/univer/commit/eca1af9ee6a90c9f6da9f3c135edb2867d1921ea))
* fix when cell wrapping is enabled, cell text must wrap to the next line after `\n` ([#6859](https://github.com/dream-num/univer/issues/6859)) ([c4f3ce5](https://github.com/dream-num/univer/commit/c4f3ce5f8b944dc66b4cb9a87c78bbefd0a90660))
* optimize auto row height recalculation when clearing cell content or styles ([#6870](https://github.com/dream-num/univer/issues/6870)) ([ef63690](https://github.com/dream-num/univer/commit/ef636900b6cf401bced1b0d981e63d67f90a8604))
* optimize boundary cases where the width and height of the last row/column cannot be changed via UI ([#6876](https://github.com/dream-num/univer/issues/6876)) ([bbd5294](https://github.com/dream-num/univer/commit/bbd52941255129655ddf243e0828a3102646292c))
* **paste:** fix some number formatted text copied from Excel was not parsed correctly ([#6844](https://github.com/dream-num/univer/issues/6844)) ([f171450](https://github.com/dream-num/univer/commit/f1714504ab0f02b1c5fa43c24320a46f5f464606))
* **permission:** fix some issues with permission control ([#6853](https://github.com/dream-num/univer/issues/6853)) ([5af6a73](https://github.com/dream-num/univer/commit/5af6a73c98c0e16b9751332165ee2eff2097d406))
* **permission:** fix the disabled status listener for the context menu in the sheet bar ([#6877](https://github.com/dream-num/univer/issues/6877)) ([67371e8](https://github.com/dream-num/univer/commit/67371e8ffb80a14eab18ef2810289738d0748bed))
* set min value in page settings ([#6852](https://github.com/dream-num/univer/issues/6852)) ([4990505](https://github.com/dream-num/univer/commit/4990505479745be6e4063611ba766dcca1497c72))
* **sheets-ui:** allow inline format shortcuts to fire inside cell editor ([#6851](https://github.com/dream-num/univer/issues/6851)) ([4b98f87](https://github.com/dream-num/univer/commit/4b98f87b66db2093b77d7cb8d351b309a875e3d5))
* **sheets:** clear styles when copy filling blank cells ([#6869](https://github.com/dream-num/univer/issues/6869)) ([32a2c98](https://github.com/dream-num/univer/commit/32a2c98f41f5533796ac985eaed35e4b27a6cf64))
* **ui:** fix the submenu in the context menu did not disappear when click it ([#6858](https://github.com/dream-num/univer/issues/6858)) ([0def2e2](https://github.com/dream-num/univer/commit/0def2e21a3c32d87185967209c0dd0e1fc524913))

### Features

* add `footer.addSheetButtonConfig` config ([#6866](https://github.com/dream-num/univer/issues/6866)) ([4055e42](https://github.com/dream-num/univer/commit/4055e42530b0aac1df690e7a3fe47d55efbe6c05))
* add maximum allowed size config of uploaded images ([#6865](https://github.com/dream-num/univer/issues/6865)) ([46e1309](https://github.com/dream-num/univer/commit/46e13092c0a9348a0928d8b2a73418fecda23372))