v0.15.5

dream-num/univerv0.15.5Feb 11, 2026by wpxp123456

AI Summary

This release focuses on bug fixes and optimizations for Univer Sheets, including fixes for merged cell borders, data validation, formula issues, and introduces breaking changes to the SheetsNoteMode data structure and auto-fill feature relocation.

Key Highlights

  • Fix issues related to missing borders in merged cells (#6557, #6558)
  • Fix time zone issues in date-related formulas (#6578)
  • Optimize data validation dropdown list for cross-worksheet data referencing (#6572)
  • Fix undo/redo issues with sheets-note feature (#6562)
  • Fix formula calculation errors for values like 1,5 (#6579)

Breaking Changes

  • Refactor SheetsNoteMode data structure and adapt old data to address comment loss when deleting/inserting rows and columns (#6561)
  • Move auto-fill feature from @univerjs/sheets-ui to @univerjs/sheets package (#6566)

New Features

  • Enhance note popup functionality with default trigger (#6554)

Full Release Notes

## 🎊 Univer@v0.15.5

### 🚧 Important Note

Your feedback is crucial! Please submit [issues](https://github.com/dream-num/univer/issues) and suggestions 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

#### 🐛 Bug Fixes and Optimizations

- Optimize the validity check for inserting row/column ranges to prevent inserting invalid ranges through the API. #6553
- Fix issues related to missing borders in merged cells. #6557 #6558
- Fix undo/redo issues with the sheets-note feature. #6562
- Optimize the data validation dropdown list "Options - From a range" to allow cross-worksheet data referencing. #6572
- Fix an issue where the `SheetValueChanged` event would throw an error in certain scenarios. #6575
- Fix time zone issues in date-related formulas. #6578
- Fix an issue where certain values could be calculated by formulas, such as `1,5`. #6579
- Fix an issue where creating a pivot table would throw an error due to the selected range not having a sheet name.

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

- Fix the issue where the error prompt dialog would automatically close when renaming a worksheet. #6577

#### 💔 Breaking Changes

- Refactor the data structure of `SheetsNoteMode` and adapt old data to address the issue of comment loss caused by data anomalies in the comment feature when deleting/inserting rows and columns. #6561
- Move the auto-fill feature from the `@univerjs/sheets-ui` package to the `@univerjs/sheets` package. Please note the update if you have related types or method imports. #6566

### 📦 Univer Presets

- SDK has been updated to version 0.15.5.

### 📢 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.15.4...v0.15.5) (2026-02-11)

### Bug Fixes

* add row/column manager insert method and optimze insertMatrixArray ([#6555](https://github.com/dream-num/univer/issues/6555)) ([be00938](https://github.com/dream-num/univer/commit/be00938dd8a85f2797d05fff06c045eb9f78c007))
* add validity range protection to the insert row/column command ([#6553](https://github.com/dream-num/univer/issues/6553)) ([5844930](https://github.com/dream-num/univer/commit/58449302f8b7526a398032811b3424b0226b8d7f))
* **condition:** history error ([#6565](https://github.com/dream-num/univer/issues/6565)) ([b24892b](https://github.com/dream-num/univer/commit/b24892b9d4c2f64eb0ee160c7f99230f020c72dd))
* **drawing:** add axisAlignSheetTransform for sheet drawing ([#6574](https://github.com/dream-num/univer/issues/6574)) ([8b0c70e](https://github.com/dream-num/univer/commit/8b0c70e257c68ea0a19bb83443eff01f33256049))
* fix an issue where border styles were lost when unmerging cells and then undo ([#6558](https://github.com/dream-num/univer/issues/6558)) ([ca913c9](https://github.com/dream-num/univer/commit/ca913c915f2daf27baba58e786155ce1e2737ab6))
* fix auto-fill date rule ([#6570](https://github.com/dream-num/univer/issues/6570)) ([5c13384](https://github.com/dream-num/univer/commit/5c13384824991a2984cf16c0afc009dc838174b5))
* fix the issue of border styles being lost after cell merging ([#6557](https://github.com/dream-num/univer/issues/6557)) ([797f587](https://github.com/dream-num/univer/commit/797f587a910c2d85d90fadfcf9dedba23e765ff6))
* fix worksheet max row and column count ([#6575](https://github.com/dream-num/univer/issues/6575)) ([7c87f0d](https://github.com/dream-num/univer/commit/7c87f0d7afe67b4171db864e75c307926fbba8f0))
* **formula:** fix calculation errors in formulas, such as 1,5 ([#6579](https://github.com/dream-num/univer/issues/6579)) ([a1048fb](https://github.com/dream-num/univer/commit/a1048fb232ae7a8e5f7369add2587f274233a1b8))
* **formula:** fix time zone issues in date-related formulas ([#6578](https://github.com/dream-num/univer/issues/6578)) ([0cc433e](https://github.com/dream-num/univer/commit/0cc433e357bba97bcff58450b09c66cf276138f3))
* **formula:** when empty with value is "" ([#6569](https://github.com/dream-num/univer/issues/6569)) ([7e59f3e](https://github.com/dream-num/univer/commit/7e59f3e1fc2570db5a6516402934096042e9c019))
* **group:** add sheet transfrom for drawing cmd ([#6549](https://github.com/dream-num/univer/issues/6549)) ([cc70157](https://github.com/dream-num/univer/commit/cc70157965f88e102002baa6e0a568e5190f6a80))
* **note:** fix sheets-note undo/redo ([#6562](https://github.com/dream-num/univer/issues/6562)) ([ff8a186](https://github.com/dream-num/univer/commit/ff8a18628bec256a5d450def10f39bfd9ed17725))
* optimize data validation dropdown list allows cross-worksheet data referencing ([#6572](https://github.com/dream-num/univer/issues/6572)) ([47a330a](https://github.com/dream-num/univer/commit/47a330ac2923efad4a3666141c95ae68135272c7))
* rename tab auto close dialog err ([#6577](https://github.com/dream-num/univer/issues/6577)) ([1f1bbe2](https://github.com/dream-num/univer/commit/1f1bbe23efbfd93e4055f39eb6ddfa8b5f8ede92))

### Features

* **sheets-note-ui:** enhance note popup functionality with default trigger ([#6554](https://github.com/dream-num/univer/issues/6554)) ([160e5e4](https://github.com/dream-num/univer/commit/160e5e4ec95b2ee733a0a27504ab179fb632bf00))