🎉 Release v0.10.5

🎊 Univer@v0.10.5

🚧 Important Note

Your feedback is crucial! Please submit 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.
Dive into the world of collaborative document, spreadsheet, and presentation editing powered by Univer!

📊 Univer Sheets

✨ New Features Highlights

• Added Facade API for dynamically adding/removing workbook style data: #5690
  • FWorkbook.addStyles
  • FWorkbook.removeStyles

🐛 Bug Fixes and Optimizations

• Fixed an issue where certain texts (e.g., '1 23', '5A') were being incorrectly converted to number formats upon input. #5709
• Fixed the logic of the text finder to ensure the search scope is limited to the current workbook. #5703
• Fixed issue with inserting rows/columns causing errors when moving rows/columns due to data inconsistencies. #5711
• Fixed an issue where using the createOrUpdateNote API to add comments in bulk would cause errors when selecting multiple cells with the mouse. #5716
• Fixed performance issues when setting cell styles after selecting all cells. #5727
• Fixed an issue where the built-in menu in the import/export feature was unresponsive when the collaborative editing plugin was not installed.

Special thanks to community contributor @remix9 for improving the Russian (ru-RU) language pack! #5722

🌐 Univer Server

• Adapted the import of XML where the v value is in scientific notation to restore it to a number.
• The sheets-table import/export compatibility for certain WPS scenarios.

📦 Univer Presets

• SDK has been updated to version 0.10.5.

📢 Join the Conversation

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

• GitHub Discussions
• 👾 Discord

📝 Changelog

Full changelog (2025-08-22)

Bug Fixes

• fix issue with inserting rows and columns (#5711) (15917b3)
• locale: uppcase for text panel ui (#5722) (e3477d7)
• numfmt: filter some erroneous numfmt pattern conversions (#5709) (6c33280)
• numfmt: fix numfmt parse error (#5697) (d466311)
• sheets-data-validation: performance issues when edit whole cells on large scale (#5727) (128cdc8)
• sheets-ui: make disposable property optional and handle undefined case (#5716) (e936715)

Features

• add facade api addStyles and removeStyles (#5690) (0f80221)

🎉 Release v0.10.4

🎊 Univer@v0.10.4

🚧 Important Note

Your feedback is crucial! Please submit 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.
Dive into the world of collaborative document, spreadsheet, and presentation editing powered by Univer!

📊 Univer Sheets

🐛 Bug Fixes and Optimizations

• Fixed an issue where the automatic row height calculation was incorrect when cell styles had text wrapping enabled. #5663
• Optimized the default alignment for number rendering to left when the cell width is less than the content width. #5665
• Optimized the rendering of odd/even row theme colors when the table range has hidden rows. #5651
• Fixed an issue where the cell content could not enter edit mode when deleting cell content with the Backspace key or copying empty Excel cells to Univer. #5682
• Optimized the built-in menu currency format to match the currency symbol in the language pack. #5688

Special thanks to community contributor @kenny-not-dead for improving the Russian (ru-RU) language pack! #5672

🌐 Univer Server

• Fixed issues with cell images being misaligned or lost after importing and then exporting.
• Adapted the export functionality for cases where the table range consists of a single cell.

📦 Univer Presets

• SDK has been updated to version 0.10.4.

📢 Join the Conversation

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

• GitHub Discussions
• 👾 Discord

📝 Changelog

Full changelog (2025-08-15)

Bug Fixes

• editor: fix after delete cell content using backspace, the cell does not enter edit mode (#5682) (f4e3b4e)
• engine-render: disable cache clearing for visible range in sprea… (#5673) (ccc5d5b)
• filterAndTable: filter vertical align and table custom style (#5677) (cd10f07)
• filter: fix filter button style not effect range theme (#5695) (2336c6d)
• fix number render when cell type is undefined or null (#5666) (10a09aa)
• render: fix auto height calculate (#5663) (4eb3456)

Features

• localization logical&lookup func; fix: replace   in some functions (#5672) (6354f0b)
• optimize the currency format in the built-in menu to the one corresponding to the language pack. (#5688) (0cda1d1)
• optimized number rendering when cell width less than text width (#5665) (a2465e9)
• rangetheme: support a performance cache for consider hide row (#5651) (25674c2)

🎉 Release v0.10.3

🎊 Univer@v0.10.3

🚧 Important Note

Your feedback is crucial! Please submit 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.
Dive into the world of collaborative document, spreadsheet, and presentation editing powered by Univer!

📊 Univer Sheets

🐛 Bug Fixes and Optimizations

• Fixed the issue where empty values in the sheets-table filter did not display internationalization correctly. #5649
• Fixed the issue where the list panel and single formula info panel appeared simultaneously when entering a formula. #5655
• Fixed some issues related to 0 value judgment. #5655
• Fixed the issue where the Enter key shortcut in the find and replace feature was not working. #5657

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

• Improved updates to the Russian (ru-RU) language pack. #5645
• Fixed the z-index issue in the Dialog component. #5654

🌐 Univer Server

• Added fallback logic to ensure compatibility when importing Excel XML files that lack row and column attributes.
• Added support for exporting tables.

📦 Univer Presets

• SDK has been updated to version 0.10.3.
• UniverSheetsCorePreset has removed the statusBarStatistic configuration item, please use the footer.statisticBar configuration instead.

📢 Join the Conversation

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

• GitHub Discussions
• 👾 Discord

📝 Changelog

Full changelog (2025-08-08)

Bug Fixes

• color picker is partially blocked (#5654) (8daabe5)
• find-replace: fix enter shortcut (#5657) (ae1dc2a)
• fixed some formula and 0 value judgment issues (#5655) (6d18c8b)
• formula: fix numbervalue/datevalue/timevalue calculate (#5637) (60c59f9)
• sheets-table: return undefined for empty cell values & fix i18n (#5649) (48aea11)
• sheets-ui: fix context menu insert control (#5639) (e018864)

Features

• add Ru localization engineering&information func; fix: description IMPRODUCT (#5645) (2b79e82)

🎉 Release v0.10.2

🎊 Univer@v0.10.2

🚧 Important Note

Your feedback is crucial! Please submit 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.
Dive into the world of collaborative document, spreadsheet, and presentation editing powered by Univer!

📊 Univer Sheets

✨ New Features Highlights

• Refactored the date components, including DatePicker and DateRangePicker, to unify their UI style and fix issues with locale loading in preset mode. #5622
• Added new permission points: WorkbookInsertColumnPermission, WorkbookInsertRowPermission, WorkbookDeleteColumnPermission, and WorkbookDeleteRowPermission, allowing control over adding and deleting columns and rows in workbooks. #5615

🐛 Bug Fixes and Optimizations

• Developers are now allowed to create dialogs that exceed the width limit. #5612
• Fixed the issue where the global theme was not synchronized in the history record.
• Fixed some style issues with pivot tables.
• Improved the style of the permissions panel. #5619
• Illegal table names are now prohibited. #5601
• Refactored the scrollbar in the rendering area. #4957
• Fixed incorrect horizontal alignment when the cell type is Boolean. #5626
• Fixed some style issues in the filter panel. #5628
• Fixed the excessive memory usage issue when integrating Univer in Electron. #5629
• Fixed incorrect calculation for formulas like COUNTIFS when using the <> operator. #5625
• Fixed the issue where the cell editor's zoom ratio was not synchronized when the zoom ratio was not 100%. #5620

📦 Univer Presets

• SDK has been updated to version 0.10.2

📢 Join the Conversation

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

• GitHub Discussions
• 👾 Discord

📝 Changelog

Full changelog (2025-08-02)

Bug Fixes

• design: fix DayButton styles for Calendar (#5630) (f859a58)
• docs-ui: adjust zoom behavior for sheet editor compatibility (#5620) (eed7b23)
• engine-render: disable queryLocalFonts in Electron to prevent memory overflow (#5629) (dd32c66)
• formula: fixed the issue that formulas such as COUNTIFS would calculate incorrectly with <> operator (#5625) (abe0e1c)
• render: fix true and false render (#5626) (e5b2181)
• sheets-formula-ui: handle undefined unitId in formula selection (#5627) (65a87a7)
• sheets-ui: fix permssion panel styles for better readability (#5619) (53de7bf)
• table: table name should not include space (#5601) (ef87537)
• update default workbook point (#5624) (06b4518)

Features

• sheets: update workbook permission point (#5615) (3a59614)

🔥 Release v0.10.1

Changelog

Full changelog (2025-07-31)

Bug Fixes

• core: fix user part handling in SheetPermissionPanelDetail (#5611) (3214050)

Features

• design: allow customizing the Dialog component's width beyond predefined limits (#5612) (1f9c781)
• locale compatibility & date formula; fix duplicate 'required' (#5608) (efe1a5e)

🎉 Release v0.10.0

🎊 Univer@v0.10.0

🚧 Important Note

Your feedback is crucial! Please submit 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.
Dive into the world of collaborative document, spreadsheet, and presentation editing powered by Univer!

💔 Breaking Changes: Custom Permission Background and User Component Configuration Changes

In the past, developers used the customComponents property of UniverSheetsUIPlugin to implement custom permission backgrounds and user components. This approach was cumbersome and had a high learning curve. In version 0.10.0, we made a breaking change by removing customComponents and replacing it with more intuitive protectedRangeUserSelector and protectedRangeShadow. If you previously used the customComponents property for custom permission backgrounds and user components, please refer to the documentation for migration guidance.

📊 Univer Sheets

✨ New Features Highlights

• Added mergeLocales method: Simplifies merging of locale packages. #5598
• Enhanced univer.registerPlugin method: Supports batch registration of plugins. #5604

🐛 Bug Fixes and Optimizations

• Optimized the default popup position of the custom sorting dialog to enhance user experience. #5600
• The find and replace feature has been upgraded to allow jumping to the next match directly by pressing the Enter key in the input box. #5589
• Fixed some issues related to table filters. #5584

📦 Univer Presets

• SDK has been updated to version 0.10.0

🎢 Special Thanks

Univer Slides now supports inserting circles. Thanks to community contributor @kenny-not-dead for this feature contribution. #5602

📢 Join the Conversation

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

• GitHub Discussions
• 👾 Discord

📝 Changelog

Full changelog (2025-07-29)

Bug Fixes

• sheets-sort-ui: update default position calculation for custom sort dialog (#5600) (6f545c3)
• tablefilter: fix table filter fromjson condition error (#5584) (6595c02)

Features

• core: add mergeLocales function to combine locale objects (#5598) (9538bdf)
• core: add register multi plugins API (#5604) (3fd10c0)
• find-replace: enhance SearchInput component with keyboard navigation (#5589) (1d5df3d)
• slides: add insert ellipse in Slides (#5602) (6b4f664)

🎉 Release v0.9.4

🎊 Univer@v0.9.4

🚧 Important Note

Your feedback is crucial! Please submit 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.
Dive into the world of collaborative document, spreadsheet, and presentation editing powered by Univer!

📊 Univer Sheets

✨ New Features Highlights

• Added Facade API: FPermission.getPermissionInfoWithCell to retrieve cell permission information.
• The improved updates to the Russian (ru-RU) language pack.

🐛 Bug Fixes and Optimizations

• Fixed the issue of the data validation dropdown not having a default background color, improving visual consistency. #5566
• After copying, you can quickly exit the activation state by pressing ESC, making operations more convenient. #5569
• Optimized chart dragging logic to resolve potential freezing issues in extreme cases. #5570
• Fixed abnormal input box size when creating annotations, ensuring a consistent user experience. #5563

📦 Univer Presets

• SDK has been updated to version 0.9.4

🎢 Special Thanks

Special thanks to community contributor @kenny-not-dead for the improved updates to the Russian (ru-RU) language pack! #5561

📢 Join the Conversation

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

• GitHub Discussions
• 👾 Discord

📝 Changelog

Full changelog (2025-07-25)

Bug Fixes

• drawing: fix drawing op send cycle (#5570) (86d19c5)
• sheets-data-validation-ui: set default color for dropdown options when color is not provided (#5566) (095759b)
• sheets-note-ui: improve note handling and update textarea value management (#5563) (9592d3c)
• sheets-ui: improve layout and styling of SelectList component (#5554) (2bc5246)
• sheets-ui: update default style settings based on active sheet styles (#5556) (7f32f90)

Features

• add ru localization in math sheets formula UI (#5577) (33574f3)
• add ru localization in sheets formula UI (#5561) (8aecfe6)
• design: add Textarea component (#5567) (8e77b43)

🎉 Release v0.9.3

🎊 Univer@v0.9.3

🚧 Important Note

Your feedback is crucial! Please submit 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.
Dive into the world of collaborative document, spreadsheet, and presentation editing powered by Univer!

💔 Breaking Changes

In this release, the core logic of numfmt has been migrated to @univerjs/core, and as a result, we've officially removed the @univerjs/engine-numfmt package. For most users, this change will not impact your existing projects, as the package was only a secondary dependency. If you haven't installed it manually, no further action is required after upgrading. This adjustment helps reduce redundant dependencies and streamlines Univer's architecture for greater efficiency.

If you have previously installed this package, you can safely remove it with the relevant command.

📊 Univer Sheets

✨ New Features Highlights

• Basic editing support has been added for mobile plugins, further enhancing usability and interaction on mobile devices. #5535

🐛 Bug Fixes and Optimizations

• Fixed an issue where the data validation dropdown text was invisible in dark mode, improving usability for night/dark themes. #5538
• The layout of the conditional formatting panel has been optimized for better appearance and consistency across different scenarios. #5539
• Resolved a problem where the univerAPI.Event.SheetEditEnded event was triggered before data changes when validating cell data through a popup, ensuring correct data flow. #5541
• Fixed an issue where charts could not display correctly when the cell t value was not specified, ensuring the stability of chart components.
• Fixed an issue with the history panel style in dark mode, ensuring a consistent appearance.

🌐 Univer Server

• Univer Server has fixed the issue of worksheet order confusion when exporting to XLSX, ensuring the accuracy of the exported data.

📦 Univer Presets

• SDK has been updated to version 0.9.3

🎢 Special Thanks

Special thanks to community contributor @guillempuche for adding Spanish (es-ES) and Catalan (ca-ES) language packs to Univer. #5536

📢 Join the Conversation

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

• GitHub Discussions
• 👾 Discord

📝 Changelog

Full changelog (2025-07-19)

Bug Fixes

• sheets-conditional-formatting-ui: improve layout and styling (#5539) (ddea707)
• sheets-data-validation-ui: reorder SetCellEditVisibleOperation command execution (#5541) (bbef155)
• sheets-filter-ui: add dark mode text color for filter panel (#5521) (6e3ee63)
• sheets-ui: optimize the style of SelectList in dark mode (#5538) (95d6394)
• ui: add dark mode support for custom header (#5547) (8bf16aa)

Features

• add locales Spanish (es-ES) and Catalan (ca-ES) (#5536) (761dfb7)
• enhance mobile UI by adding new plugins and improving component registration (#5535) (86285a6)

🎉 Release v0.9.2

🎊 Univer@v0.9.2

🚧 Important Note

Your feedback is crucial! Please submit 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.
Dive into the world of collaborative document, spreadsheet, and presentation editing powered by Univer!

📊 Univer Sheets

✨ New Features Highlights

• Univer Sheets Filter now supports filter by colors #5501
• Facade API supplemented methods and events related to float-dom #5515

🐛 Bug Fixes and Optimizations

• Removed specific Vue version dependencies from the @univerjs/ui-adapter-vue3 package #5495
• Fixed an issue where the SUBTOTAL formula did not ignore results from other SUBTOTAL formulas #5506
• Fixed layout issues in the custom sorting panel for Spanish language settings #5507
• Fixed rendering errors for TRUE and FALSE #5504
• Fixed an issue where formula selection areas could not be dragged while in formula edit mode #5512

🌐 Univer Server

• Fixed issues related to broken hyperlinks during export

📦 Univer Presets

• SDK has been updated to version 0.9.2

📢 Join the Conversation

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

• GitHub Discussions
• 👾 Discord

📝 Changelog

Full changelog (2025-07-11)

Bug Fixes

• doc: fix some code error (#5489) (674fd6e)
• dts: simplify interface declarations and improve method overrides in event and range modules (#5516) (edea4eb)
• fix render of true and false, and TEXT formula error (#5504) (ec740ba)
• fix SUBTOTAL formula need ignore other SUBTOTAL formula results (#5506) (732bcec)
• sheets-filter-ui: adjust width of filter panel component (#5518) (bb719f2)
• sheets-formula-ui: can't drag selections when edit formula (#5512) (cd39795)
• sheets-sort-ui: improve layout and styling of CustomSortPanel (#5507) (16d234d)
• ui-adapter-vue3: update peerDependencies to require Vue 3.0.0 or higher (#5495) (b72b49a)

Features

• add float-dom update & delete & event api (#5515) (a4e177a)
• add support for filter by colors (#5501) (45f389b)
• sheets-drawing-ui: add updateFloatDomProps (#5517) (bb051e2)

Release v0.9.1

🎊 Univer@v0.9.1

🚧 Important Note

Your feedback is crucial! Please submit 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.
Dive into the world of collaborative document, spreadsheet, and presentation editing powered by Univer!

💔 Breaking Changes

From version 0.9.1, @univerjs/ui will no longer include built-in support for vue@3.x components. You will need to install @univerjs/ui-adapter-vue3 and register the UniverVue3AdapterPlugin it provides to register components developed with vue@3.x.

univer.registerPlugin(UniverUIPlugin)
// UI Adapter plugin must be registered after UniverUIPlugin and before registering custom components
univer.registerPlugin(UniverVue3AdapterPlugin)

📊 Univer Sheets

✨ New Features Highlights

• Added @univerjs/ui-adapter-vue3, which can be used to integrate custom components developed with vue@3.x
• Added @univerjs/ui-adapter-web-component, which can be used to integrate Web Components

🐛 Bug Fixes and Optimizations

• Optimized the implementation of the Facade API for customizing row and column headers #5460
  • Added support for customizing row and column headers at the workbook level: FWorkbook.customizeRowHeader and FWorkbook.customizeColumnHeader
  • Fixed the issue with the worksheet-level API methods: FWorksheet.customizeRowHeader and FWorksheet.customizeColumnHeader
• Fixed the issue of errors occurring when using UniverSheetsAdvancedPreset in webpack@5 environment #5469
• Fixed global CSS conflicts when integrating with Tailwind CSS v4 #5472
• Fixed the issue of warnings when integrating non-React custom components #5470
• Fixed the issue where the auto-fill handle button would disappear abnormally when formula calculation were performed without using Web Worker #5478
• Fixed the issue where the formula editor does not allow using the BackSpace key to delete formulas when triggered by the fx button #5477
• Fixed the issue where focused on the formula name and selection when the formula cell re-entering edit mode, and the formula introduction popup does not display #5481

📦 Univer Presets

• SDK has been updated to version 0.9.1
• Added @univerjs/preset-docs-node-core package to support quick integration of Headless Univer Docs

📢 Join the Conversation

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

• GitHub Discussions
• 👾 Discord

📝 Changelog

Full changelog (2025-07-04)

Bug Fixes

• design: remove unused @tailwind base directive from global.css (#5472) (d1c481e)
• docs-ui: add return type to useResize function (#5473) (a57a58d)
• engine-render: handle broken image state in font rendering (#5459) (054ec77)
• engine-render: render fallback image when cell image renderer-error (#5449) (cca2971)
• facade: fix customizeColumnHeader and customizeRowHeader api (#5460) (58de0a4)
• fix BackSpace cannot fallback and delete after triggering formula through fx (#5477) (26953b1)
• fix the issue where formula helpfunction does not display (#5481) (ef5409b)
• fixed the auto-fill handle button cannot appear (#5478) (eac4483)
• plugin: prevent passing undefined or null props to Vue component (#5470) (ed67b48)
• sheets-hyper-link-ui: hyper-link tooltip display far away of the cell bound (#5456) (12974da)
• ui-adapter: remove react dependency from ui adapter packages (#5474) (0b7cab6)
• add postcss-replace plugin and update global styles (#5488) (e7facd8)
• fix thread-comment-ui add comment i18n (#5487) (2cba0f9)

Features

• ui: support the registration of custom components built with vue3 / web component (#5440) (649385c)
• use portal to show filter panel (#5446) (5156a42)