logo

Univer SDK
所有功能快速开始客户案例开源
Workspace
功能介绍在线使用
ClipSheet
功能介绍安装 ClipSheet使用教程

定价
Univer Go
联系我们

更新日志

我们始终倾听用户反馈，不断优化和更新，让 Univer 为您创造更大价值。

0.6.6 (2025-03-14)

Bug Fixes

Features

  • docs-drawing-ui: doc float dom influence on sheet float-dom (#4834) (40acdc2)
  • docs-drawing-ui: optimize float-dom on doc canvas (#4824) (e8332bc)
  • supplement facade example (#4825) (3760ee8)

🎊 Univer@v0.6.5

Univer Banner

🚧 Important Note

This project is still in heavy development, and major API changes are expected. 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

  • Fixed conditional formatting command only applying to active worksheet #4798
  • Fixed unclosed col tag issue in generateHTML #4803
  • Fixed tooltip warnings in React 18 #4794
  • Fixed set font and limited fillText out of view bounds #4800
  • Fixed occasional worker errors #4821

📝 Univer Docs

  • Added support for custom blocks in documents #4792

🌐 Univer Server

  • Fixed known issues

📦 Univer Presets

  • Added UniverSheetsCorePreset configuration options dream-num/univer-presets#48
  • SDK has been updated to version 0.6.5

💔 Breaking Changes

  • @univerjs/network is now exported from @univerjs/presets/preset-sheets-core entry point dream-num/univer-presets#46
-import { HTTPService } from '@univerjs/presets/preset-sheets-advanced'
+import { HTTPService } from '@univerjs/presets/preset-sheets-core'

🎢 Special Thanks

Special thanks to the following contributors who have made this release possible:

  • @maxsbelt #4798

📢 Join the Conversation

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

📝 Changelog

Full changelog (2025-03-12)

Bug Fixes

Features

  • docs-drawing-ui: support float-dom on doc-canvas (#4821) (fdc7f0e)
  • docs: custom block support custom type (#4792) (4497c4f)
  • sheets-drawing-ui: change cell-image resize to render phase (#4809) (a4aee93)
  • supplement facade example (#4799) (c43b0c9)

🎊 Univer@v0.6.4

Univer Banner

🚧 Important Note

This project is still in heavy development, and major API changes are expected. 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

🎉 Highlights

In this release, we are excited to introduce a new set of features and improvements to enhance your Univer experience. Here are the highlights:

  • Interaction optimization: Set the number of rows and columns to insert in the right-click menu #4579
  • Added getCustomMetadata method to support getting worksheet custom metadata #4759

🐞 Bug Fixes

  • Fixed reference range error when inserting rows or columns in data validation #4785
  • Fixed interaction error when using custom formula validation in data validation #4776
  • Fixed tooltip jitter issue in menu bar #4779
  • Adjusted permission initialization timing to fix permission-related bugs #4770
  • Fixed known issues

📝 Univer Docs

  • Fixed known issues

🌐 Univer Server

  • Fixed known issues

📦 Univer Presets

  • SDK has been updated to version 0.6.4

🎢 Special Thanks

Special thanks to the following contributors who have made this release possible:

  • @maxsbelt #4771
  • @okxiaoliang4 #4760

📢 Join the Conversation

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

📝 Changelog

Full changelog (2025-03-08)

Bug Fixes

  • dep detect only in event handler not before register event (#4781) (58a24b5)
  • design: resolve the issue of tooltip jitter during initialization (#4779) (3643ffe)
  • docs-ui: select all on empty doc (#4787) (d85a0db)
  • facade: showRangeSelectorDialog document (#4767) (323fe3f)
  • fix facade example (#4780) (ca2329e)
  • formula e2e (#4788) (f0df9ef)
  • formula: fix dispose register function bug (#4783) (be00bdd)
  • formula: formula update after hide row column (#4238) (4113714)
  • sheets-conditional-formatting: correct bottom percent rank calculation (#4771) (e5cff35)
  • sheets-data-validation: data validation ref-range error on insert row & column (#4785) (82545bf)
  • sheets-data-validation: data validation valid error on custom formula (#4776) (2f3c477)
  • update permission init timing (#4770) (5099acf)

Features

  • sheets-numfmt: add percentage as default option (#4772) (e3a9b59)
  • sheets-ui: check before undo-redo rollback (#4784) (f66f931)

Performance Improvements

  • remove unnecessary ctx.font = calls, and avoid drawing glyphs outside the viewBounds (#4775) (cd3decd)

Reverts

  • remove unnecessary ctx.font = calls, and avoid drawing out of bounds (#4793) (1aaad2a)

📝 Changelog

Full changelog (2025-03-04)

Bug Fixes

Features

🎊 Univer@v0.6.2

Univer Banner

🚧 Important Note

This project is still in heavy development, and major API changes are expected. 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

🎉 Highlights

In this release, we are excited to introduce a new set of features and improvements to enhance your Univer experience. Here are the highlights:

  • Pivot table supports value filtering, added setFieldsConfig and reset Facade APIs
  • Added new Facade APIs for:
    • Number formatting #4733
    • Auto-adjusting row/column dimensions #4733 #4737
    • Range selector #4703
    • Cell image insertion #4729
    • Clearing conditional formatting #4743
  • Enhanced UI optimizations #4704 #4715
  • Added hideStatusBarStatistic configuration in sheets-ui to support hiding statistical status bar #4694
  • Added maxAutoHeightCount configuration in sheets-ui to address performance issues with auto-height in large datasets (default: 1000 rows) #4700 #4705
  • Formula functions now support reading and writing cell custom properties #4658
  • Find and replace component now supports Esc shortcut key to exit #4746

🐞 Bug Fixes

  • Fixed clear operation in filter state #4589
  • Fixed status bar statistics error when selection contains dates #4723
  • Fixed white screen issue when calling createUnit after disposeUnit #4728
  • Fixed generateHTML error #4689
  • Fixed Facade event mechanism #4736 #4739
  • Fixed uniscript plugin editor error #4738

💔 Breaking Changes

  • No breaking changes in this release

📝 Univer Docs

  • Fixed known issues

🌐 Univer Server

  • Fixed known issues

📦 Univer Presets

  • SDK has been updated to version 0.6.2

🎢 Special Thanks

Special thanks to the following contributors who have made this release possible:

  • @okxiaoliang4 #4732
  • @btea #4702
  • @jcalem #4658

📢 Join the Conversation

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

📝 Changelog

Full changelog (2025-03-01)

Bug Fixes

Features

  • facade: add cell image facade & remove rich-text cell-image (#4729) (f0b2d48)
  • facade: move cf command from sheets-conditional-formatting-ui to sheets-conditional-formatting package (#4743) (fdbde5b)
  • facade: supplement f-workbook f-worksheet f-range facade (#4733) (edddb71)
  • find-replace: use esc to focus on selection (#4746) (f4b30ae)
  • formula: add custom data to value objects (#4658) (2e59a6c)
  • hide statistic opt (#4694) (95410d0)
  • improve styles in sheets-ui (#4704) (b752a7f)
  • scroll bar hover style (#4708) (04af678)
  • thread-comment: export sheet thread comment plugin constant (#4732) (83c0af9)

🎊 Univer@v0.6.1

Univer Banner

🚧 Important Note

This project is still in heavy development, and major API changes are expected. 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

🎉 Highlights

  • Optimized plugin loading mechanism #4662
  • Formula engine performance optimization #4675
  • Facade API documentation updated #4677 #4686 #4653

🐞 Bug Fixes

  • Fixed the issue where line breaks were not preserved when pasting data from external applications #4670
  • Fixed the issue where the find icon was displayed abnormally in 0.6.0 #4685
  • Fixed the issue where FRange.setBorder only took effect on the active range #4650
  • Fixed the number format @ display issue #4669
  • Fixed the issue that the formula editor selected multiple ranges and displayed abnormally #4673
  • Fixed the numerical calculation problem in the statistics bar #4684

📝 Univer Docs

  • Fixed known issues.

🌐 Univer Server

  • Fixed known issues.

📦 Univer Presets

  • SDK has been updated to version 0.6.1.

🎢 Special Thanks

Special thanks to the following community members for their outstanding contributions to this release:

  • @btea #4649

📢 Univer Go

Univer Go 0.0.10 has been released, integrating AI, logging, and the latest Univer SDK features. With numerous templates ready to use, share and define your collaborative spreadsheet applications, welcome to experience! Univer Go

📢 Join the Conversation

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

📝 Changelog

Full changelog (2025-02-21)

Bug Fixes

Features

  • sheets-ui: update FormulaBar to accept custom className prop (#4663) (f39baf5)
  • watermark: move watermark component to engine render (#4683) (95f6b9d)

🎊 Univer@v0.6.0

Univer Banner

🚧 Important Note

This project is still in heavy development, and major API changes are expected. 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

🎉 Highlights

  • Added external image paste functionality and optimized image processing logic #3617
  • Compatible with React 19, refactored rendering logic, optimized Input component implementation, and improved UI performance #4247
  • Added Facade API FRange.attachRangePopup to insert components into ranges #4489
  • Added support for loading multiple sheets and switching the sheet to be displayed, you can now use cross-sheet formulas, refer to Loading Multiple Files #4580
  • Optimized Facade event memory usage, introduced FEventRegistry to manage event listeners #4616
  • Added NUMBERSTRING formula for converting numbers to Chinese strings #4615
  • Univer now supports over 500 formulas and counting!

🐞 Bug Fixes

  • Fixed multi-instance input cursor error in sheets-ui #4643
  • Fixed univerAPI.Event.SheetEditChanging event not triggering #4642
  • Fixed univerAPI.Event.CellClicked event not triggering #4628
  • Removed React dependency from core package, reduced core package size, and improved project modularity #4617
  • Fixed selection error in formula editor and collaborative selection issues #4619
  • Improved undo/redo menu item disable logic #4609
  • Fixed data validation formula issues and ActiveSheetChanged event #4606
  • Fixed incorrect row height when adjusting height with all rows selected #4639

💔 Breaking Changes

  • React 16 users need additional steps to use Univer 0.6.0, please refer to the React 16 User Upgrade Guide

  • Package @univerjs/facade has been removed, please migrate to the new Facade usage.

  • Facade content previously exported from @univerjs/core has been moved to @univerjs/core/facade exports: FBase, FBaseInitialable, FUniver, FHooks, FBlob, IFBlobSource, FEventName, IEventBase, IEventParamConfig, FEnum, FUtil #4596

ESM Before:

import { FUniver } from '@univerjs/core';

After:

import { FUniver } from '@univerjs/core/facade';

UMD Before:

<script src="https://unpkg.com/@univerjs/core/lib/umd/index.js"></script>
<script>
var { FUniver } = UniverCore;
</script>

After:

<script src="https://unpkg.com/@univerjs/core/lib/umd/facade.js"></script>
<script>
var { FUniver } = UniverCoreFacade;
</script>

  • To use the official collaboration features, you now need to provide a socketService in UniverCollaborationClientPlugin's config object. If your client runs in browsers, please use BrowserCollaborationSocketService provided by the @univerjs-pro/collaboration-client-ui package, refer to Collaboration Guide

  • Plugin developers need to note that the Redi view-related APIs exported have been moved to the @univerjs/ui package #4617

Before:

import { useDependency, RediContext, useObservable } from '@univerjs/core'

After:

import { useDependency, RediContext, useObservable } from '@univerjs/ui'

📝 Univer Docs

  • Fixed known issues.

🌐 Univer Server

  • Fixed known issues.

📦 Univer Presets

  • SDK has been updated to version 0.6.0.

🎢 Special Thanks

Special thanks to the following community members for their outstanding contributions to this release:

  • @okxiaoliang4 #4609
  • @wubocao #4528 #4473

📢 Univer Go

Univer Go 0.0.10 has been released, integrating AI, logging, and the latest Univer SDK features. With numerous templates ready to use, share and define your collaborative spreadsheet applications, welcome to experience! Univer Go

📢 Join the Conversation

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

📝 Changelog

Full changelog (2025-02-15)

Bug Fixes

  • adjust height when select all (#4639) (c274fc8)
  • clear timers when controller disposed (#4528) (6a871b0)
  • conditional-formatting: aligning Excel Effects with 'No Interfer… (#4584) (ce0b939)
  • drawing: drawing permission memory leak (#4598) (a04486e)
  • facade: editing-event not trigger on edit (#4642) (4914a55)
  • facade: set default style (#4613) (4d1f5d1)
  • fix multi memory leak problems (#4591) (3dc94a9)
  • fix paste dropdown in workspace (#4593) (3efc99f)
  • float dom after freeze (#4587) (9b2274f)
  • formula: fix cut paste bug of formula (#4582) (d9043ef)
  • formula: get dirtyRanges when row column removed (#4588) (0e0d68b)
  • formula: skip processing tree when there is no formula (#4586) (303c0b2)
  • numfmt: reset cell value type when remove numfmt (#4585) (bb81076)
  • sheet: add remove func to serivce (#4625) (6254c68)
  • sheet: row height no ranges (#4629) (aee23ec)
  • sheets-data-validation: data-validation formula-error (#4606) (0d6c8b4)
  • sheets-formula-ui: editor add selection error (#4619) (b431629)
  • sheets-formula-ui: selecion error on formula-editor (#4632) (1f961b8)
  • sheets-ui/facade: fix cell event not triggering when listening through the facade API (#4628) (92398b2)
  • sheets-ui: formula-editor edit error (#4603) (1559708)
  • sheets-ui: multi-instance input error (#4643) (d742763)
  • sheet: scrolling reaching limit judgment (#4473) (4b3dd11)
  • statusbar: fix status bar can not read date type cell (#4573) (0a0aafe)
  • ui: improve undo/redo menu item disable logic (#4609) (1edf335)
  • ui: optimize resize observer and update toolbar item structure of Ribbon (#4644) (8e88ffd)
  • upload snapshot as artifacts when test failed, record hean snapshot in mem test (#4594) (fb3d10f)
  • add ignore comments for facade (#4559) (1780109)
  • add ignore comments for facade (#4568) (bac2965)
  • bind: fix bind mode loss text style (#4533) (d724ad9)
  • customize column header height (#4526) (5097444)
  • docs: fix comments error (#4564) (d4334c9)
  • facade: add doc for sheets-ui event (#4538) (bae758f)
  • facade: hidden mixin in ui & data-validation & thread-comment (#4554) (99127d7)
  • facade: hide constructor and ignore injector getter (#4571) (1a8981d)
  • filter: fix filter enum (#4543) (bd220e7)
  • fix some permission bugs (#4478) (2683655)
  • formula: fix insert function of range has number value (#4561) (22f7159)
  • formula: t formula should handle reference and array values (#4556) (5b7cc47)
  • revert set text style (#4544) (266dadc)
  • sheet: fix range theme cmd param error (#4542) (b55877b)
  • sheets-ui: style error when save text from cell-editor (#4541) (a16d79a)
  • sheets: before edit event can't cancel by formula-bar (#4569) (9fe3d2a)
  • sheets: make auto-width sync (#4532) (d7cfc52)
  • sheets: save text editor style (#4570) (3059f03)
  • ui: add return type for ComponentContainer function (#4547) (a2cf4bb)
  • update freeze handle in left top viewport size when column heade… (#4545) (39cd016)

Features

  • design: update color presets and add tests for ColorPicker (#4583) (a54ab30)
  • engine-formula: add global computing status service (#4602) (15a943c)
  • engine-formula: add whenComputingCompleteAsync facade (#4610) (7db5474)
  • facade: facade event memory usage optimize (#4616) (0cde43c)
  • formula: supplement NUMBERSTRING formula (#4615) (7755e26)
  • split skeleton into core and render-engine (#4330) (9732f7b)
  • ui: support switching render unit (#4580) (45a1c14)
  • better col header facade (#4549) (12b30ff)
  • cleanup jsdoc (#4553) (31a8aa8)
  • facade: add [@hideconstructor](https://github.com/hideconstructor) and [@ignore](https://github.com/ignore) annotations to various classes (#4530) (fe6999d)
  • float-image: support paste image from external (#3617) (ee66eac)
  • network: support array params (#4563) (043aedc)
  • paste image if no excel html (#4558) (adf4c39)
  • ui: add ui facade menu position (#4546) (9685cb3)
  • ui: support hiding footer and header (#4455) (54e4378)

🎊 Univer@v0.5.5

Univer Banner

🚧 Important Note

This project is still in heavy development, and major API changes are expected. 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

🎉 Highlights

In this release, we are excited to introduce a new set of features and improvements to enhance your Univer experience. Here are the highlights:

  • UniverSheetsPlugin added new configuration option autoHeightForMergedCells to enable automatic height calculation for merged cells #4488

  • Added Facade API: border settings, get styles, enums, etc. #4494

import '@univerjs/sheets/facade'

univerAPI.getActiveWorkbook()
    .getActiveSheet()
    .getActiveRange()
    .setBorder(univerAPI.Enum.BorderType.ALL, univerAPI.Enum.BorderStyleTypes.THIN, '#ff0000');

univerAPI.getActiveWorkbook()
    .getActiveSheet()
    .getActiveRange()
    .getCellStyle()
  • Added support for sheet-related events: ActiveSheetChanged, SheetDeleted, SheetHideChanged, SheetMoved, SheetNameChanged, SheetTabColorChanged, SheetValueChanged #4494
import '@univerjs/sheets/facade'

univerAPI.addEvent(univerAPI.Event.Scroll, console.log)
  • Added support for sheet UI-related events: Scroll, SelectionMoving, SelectionChanged, ColumnHeaderClick, ColumnHeaderHover, RowHeaderClick, RowHeaderHover, SelectionChanged, SelectionMoving, SheetSkeletonChanged, etc. #4491
import '@univerjs/sheets-ui/facade'

univerAPI.addEvent(univerAPI.Event.Scroll, console.log)
  • Added FRange.getValue parameter: when set to true, it will return rich text values
import '@univerjs/sheets/facade'

const richTextValues = univerAPI.getActiveWorkbook()
    .getActiveSheet()
    .getActiveRange()
    .getValues(true)
  • Added support for number format localization settings #4470

🐞 Bug Fixes

  • Refactored cell editor and formula editor in sheet UI module #4384
  • Drop fill or copy-paste will not carry custom property #4503
  • Fixed data validator issue #4477
  • Fixed Facade API incorrect async calls #4482
  • AlphaSlider style optimization #4486

📝 Univer Docs

  • Fixed known issues

🌐 Univer Server

  • Fixed known issues

📢 0.6.0 Preview

[!IMPORTANT] The development of version 0.6.0 is currently underway. Starting with this release, Univer will support integration with projects using React@19 . However, this update may introduce breaking changes for users relying on React@16 or Univer UMD builds. If you have any questions or concerns, please feel free to share your suggestions and feedback via GitHub Issues.

📢 Univer Go

Univer Go 0.0.8 has been released, integrating AI, logging, and the latest Univer SDK features. You don't need to configure complex development environments - just code and share your collaborative spreadsheet applications. Try it now! Univer Go

📢 Join the Conversation

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

📝 Changelog

Full changelog (2025-01-20)

Bug Fixes

Features

🎊 Univer@v0.5.4

Univer Banner

🚧 Important Note

This project is still in heavy development, and major API changes are expected. 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

🎉 Highlights

In this release, we are excited to introduce a new set of features and improvements to enhance your Univer experience. Here are the highlights:

  • New color picker with custom color support #4437
custom-pasting
  • New feature: When pasting, a selective paste context menu will be triggered. #4393
custom-pasting
  • Added FWorkbook.addEvent and FWorksheet.addEvent with related events #4456
univerAPI.getActiveWorkbook().addEvent('CellClicked', (p)=> console.log(p));
univerAPI.getActiveWorkbook().addEvent('CellHover', (p)=> console.log(p));
  • Formula registration in Facade API now supports lambda functions #4298
  • Added Zen mode editor-related Facade APIs #4423
  • Added comment-related events and Facade APIs #4423
  • Added image-related events and Facade APIs #4429
  • Added clipboard events #4420
  • Added FUniver.registerUIPart #4452
univerAPI.registerUIPart(BuiltInUIPart.CUSTOM_HEADER, () => React.createElement('h1', null, 'Custom Header'));
  • Added string search Facade API #4430
const textFinder = await univerAPI.createTextFinderAsync('hello');
 const ranges = textFinder.findAll();
 ranges.forEach((range) => {
    console.log(range.getA1Notation());
 });

🐞 Bug Fixes

  • Optimized tooltip display #4463
  • Improved handling of worksheet names with quotes #4198

🔄 API Updates

The following APIs will be gradually replaced in future versions. Please migrate at your convenience:

  • Workbook Related
// Create workbook
- FUniver.createUniverSheet()     // Will be deprecated
+ FUniver.createWorkbook()        // Recommended

// Get active workbook
- FUniver.getActiveUniverSheet() // Will be deprecated
+ FUniver.getActiveWorkbook()    // Recommended
  • Conditional Formatting
FWorksheet {
- createConditionalFormattingRule() // Will be deprecated
+ newConditionalFormattingRule()    // Recommended
}
  • Original hyperlink Facade APIs will have new alternatives in future versions

💔 Breaking Changes

  • FFormula import path change:
- import type { FFormula } from '@univerjs/engine-formula';
+ import type { FFormula } from '@univerjs/engine-formula/facade';
  • Image operations upgraded to async APIs:
FOverGridImage {
- setPosition(row: number, column: number): boolean;
- setPosition(row: number, column: number, rowOffset?: number, columnOffset?: number): boolean;
- setSize(width: number, height: number): boolean;
+ setPositionAsync(row: number, column: number): Promise<boolean>;
+ setPositionAsync(row: number, column: number, rowOffset?: number, columnOffset?: number): Promise<boolean>;
+ setSizeAsync(width: number, height: number): Promise<boolean>;
}

FOverGridImageBuilder {
- build(): Promise<ISheetImage>;
+ buildAsync(): Promise<ISheetImage>;
}

📝 Univer Docs

  • Fixed known issues

🌐 Univer Server

  • Fixed known issues

📦 Univer Presets

  • Updated to the latest version of Univer

  • Adjustment of UMD version variable introduction method

before:

const { createUniver, LocaleType, merge, defaultTheme } = UniverPresets;

after:

const { createUniver } = UniverPresets;
const { LocaleType, merge } = UniverCore;
const { defaultTheme } = UniverDesign;

📢 0.6.0 Preview

[!IMPORTANT] The development of version 0.6.0 is currently underway. Starting with this release, Univer will support integration with projects using React@19 . However, this update may introduce breaking changes for users relying on React@16 or Univer UMD builds. If you have any questions or concerns, please feel free to share your suggestions and feedback via GitHub Issues.

📢 Univer Go

Univer Go 0.0.7 has been released, integrating AI, logging, and the latest Univer SDK features. You don't need to configure complex development environments - just code and share your collaborative spreadsheet applications. Try it now! Univer Go

📢 Join the Conversation

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

📝 Changelog

Full changelog (2025-01-13)

Bug Fixes

Features

🎊 Univer@v0.5.3

Univer Banner

🚧 Important Note

This project is still in heavy development, and major API changes are expected. 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!

📊 Introducing Univer Go Beta!

[!IMPORTANT]
Univer Go Beta is now available! We are excited to announce the release of Univer Go, a new desktop application that enables you to build your own spreadsheet and seamlessly integrate with AI agents, databases, and applications.

✨ Fun Built-in Templates

  • AI Spreadsheet Translator: Utilize the Univer API in combination with AI to achieve instant multilingual translation of spreadsheet content
  • Work Calendar: Generate a work calendar with one click, demonstrating how to use the Univer API to load snapshot data, customize formulas, bind cell events, and utilize the permissions module
  • Gantt Chart: Insert any number of Gantt charts into a spreadsheet with a single click, showcasing how to use the Univer API to add formulas, adjust cell styles, merge cells, set conditional formatting, and add data validation
  • High-performance Pivot Tables: Quickly create pivot tables and discover how to use the pivot table API in Univer Go to enhance data analysis efficiency
  • Tic Tac Toe: Share a link to play Tic-Tac-Toe with friends, learn how to bind Canvas events and implement real-time multiplayer interactions

More templates are waiting for you to explore. Feel free to share your templates with us!

Beta version is now available for both Windows. We welcome community members to test it out and share their feedback to help us improve the platform!

📊 Univer Sheets

🎉 Highlights

In this release, we are excited to introduce a new set of features and improvements to enhance your Univer experience. Here are the highlights:

  • Optimized Facade API chaining, enabling more fluent API calls. This update may require adjustments to existing code, please refer to the Breaking Changes section #4329 #4403 #4412
import '@univerjs/sheets/facade'

univerAPI.getActiveWorkbook().insertSheet()
    // set basic properties
    .setName('Sales Report 2024')
    // set freeze pane
    .setFrozenRows(2)
    .setFrozenColumns(1)
    // set column width
    .setColumnWidths(0, 1, 180)  // product name column
    .setColumnWidths(1, 1, 120)  // price column
    .setColumnWidths(2, 1, 100)  // quantity column
    .setColumnWidths(3, 1, 120)  // total price column
    .setColumnWidths(4, 1, 150)  // note column
    // set row height
    .setRowHeight(0, 35)  // main header
    .setRowHeight(1, 30)  // sub header
    // set values
    .getRange("a1:e1")
    .setValues([
        ["product name", "price", "quantity", "total price", "note"],
    ])
  • Added range theme feature with 31 built-in themes, Documentation #4369
import '@univerjs/sheets/facade'
univerAPI.getActiveWorkbook().getActiveSheet().getRange("a1:c5").useThemeStyle('default')
univerAPI.getActiveWorkbook().getActiveSheet().getRange("a1:c5").useThemeStyle(null)

image

  • Added Facade API FRange.splitTextToColumns for splitting text into columns
import '@univerjs/sheets/facade'
univerAPI.getActiveWorkbook().getActiveSheet().getRange("a1").setValue("1;2;3").splitTextToColumns()
  • Added Facade API FFormula.registerFunction and FFormula.registerAsyncFunction for creating custom functions #4399
import '@univerjs/sheets/facade'
import '@univerjs/sheets/sheets-formula'
univerAPI.getFormula().registerFunction('HELLO', (name) => `Hello, ${name}!`, 'A simple greeting function');
// Use the function in a cell
univerAPI.getActiveWorkbook().getActiveSheet().getRange('A1').setValue('World');
univerAPI.getActiveWorkbook().getActiveSheet().getRange('A2').setValue({ f: '=HELLO(A1)' });
// A2 will display: "Hello, World!"

🐞 Bug Fixes

  • Fixed mouse scrollbar operation issues #4396
  • Fixed non-responsive dropdown menu clicks in the More menu #4416
  • Fixed known issues

💔 Breaking Changes

  • Tools.deepMerge is deprecated, please use merge instead

Before:

import { Tools } from '@univerjs/core'
Tools.deepMerge(obj1, obj2)

After:

import { merge } from '@univerjs/core'
merge(obj1, obj2)
  • Changed return type of chained Facade API calls from Promise<boolean> to FUniver or FWorkbook or FWorksheet or FRange or FDataValidation or FFilter #4329 #4403 #4412

Before:

await univerAPI.getActiveWorkbook().getActiveSheet().getRange('A1:A5').setValue('123');
await univerAPI.getActiveWorkbook().getActiveSheet().getRange('A1:A5').merge()

After:

univerAPI.getActiveWorkbook().getActiveSheet().getRange('A1:A5').setValue('123').merge();

FUniver{
...
-setCrosshairHighlightColor(color: string): void;
+setCrosshairHighlightColor(color: string): FUniver;
-setCrosshairHighlightEnabled(enabled: boolean): void;
+setCrosshairHighlightEnabled(enabled: boolean): FUniver;
-showMessage(options: IMessageProps): void;
+showMessage(options: IMessageProps): FUniver;
-addWatermark(type: IWatermarkTypeEnum.Text, config: ITextWatermarkConfig): void;
+addWatermark(type: IWatermarkTypeEnum.Text, config: ITextWatermarkConfig): FUniver;
-addWatermark(type: IWatermarkTypeEnum.Image, config: IImageWatermarkConfig): void;
+addWatermark(type: IWatermarkTypeEnum.Image, config: IImageWatermarkConfig): FUniver;
-deleteWatermark(): void;
+deleteWatermark(): FUniver;
...
}

FWorkbook{
...

-deleteActiveSheet(): Promise<boolean>;
+deleteActiveSheet(): FWorkbook;
-deleteSheet(sheet: FWorksheet): Promise<boolean>;
+deleteSheet(sheet: FWorksheet): FWorkbook;
-duplicateActiveSheet(): Promise<boolean>;
+duplicateActiveSheet(): FWorkbook;
-duplicateSheet(sheet: FWorksheet): Promise<boolean>;
+duplicateSheet(sheet: FWorksheet): FWorkbook;
-moveActiveSheet(index: number): Promise<boolean>;
+moveActiveSheet(index: number): FWorkbook;
-moveSheet(sheet: FWorksheet, index: number): Promise<boolean>;
+moveSheet(sheet: FWorksheet, index: number): FWorkbook;
-redo(): Promise<boolean>;
+redo(): FWorkbook;
-undo(): Promise<boolean>;
+undo(): FWorkbook;
...
}

FWorksheet {
...
-cancelFreeze(): boolean;
+cancelFreeze(): FWorksheet;
-clear(options?: IFacadeClearOptions): Promise<boolean>;
+clear(options?: IFacadeClearOptions): FWorksheet;
-clearContents(): Promise<boolean>;
+clearContents(): FWorksheet;
-clearFormats(): Promise<boolean>;
+clearFormats(): FWorksheet;
-deleteColumn(columnPosition: number): Promise<FWorksheet>;
+deleteColumn(columnPosition: number): FWorksheet;
-deleteColumns(columnPosition: number, howMany: number): Promise<FWorksheet>;
+deleteColumns(columnPosition: number, howMany: number): FWorksheet;
-deleteRow(rowPosition: number): Promise<FWorksheet>;
+deleteRow(rowPosition: number): FWorksheet;
-deleteRows(rowPosition: number, howMany: number): Promise<FWorksheet>;
+deleteRows(rowPosition: number, howMany: number): FWorksheet;
-hideColumn(column: FRange): Promise<FWorksheet>;
+hideColumn(column: FRange): FWorksheet;
-hideColumns(columnIndex: number, numColumns?: number): Promise<FWorksheet>;
+hideColumns(columnIndex: number, numColumns?: number): FWorksheet;
-hideRow(row: FRange): Promise<FWorksheet>;
+hideRow(row: FRange): FWorksheet;
-hideRows(rowIndex: number, numRows?: number): Promise<FWorksheet>;
+hideRows(rowIndex: number, numRows?: number): FWorksheet;
-hideSheet(): void;
+hideSheet(): FWorksheet;
-insertColumnAfter(afterPosition: number): Promise<FWorksheet>;
+insertColumnAfter(afterPosition: number): FWorksheet;
-insertColumnBefore(beforePosition: number): Promise<FWorksheet>;
+insertColumnBefore(beforePosition: number): FWorksheet;
-insertColumns(columnIndex: number, numColumns?: number): Promise<FWorksheet>;
+insertColumns(columnIndex: number, numColumns?: number): FWorksheet;
-insertColumnsAfter(afterPosition: number, howMany: number): Promise<FWorksheet>;
+insertColumnsAfter(afterPosition: number, howMany: number): FWorksheet;
-insertColumnsBefore(beforePosition: number, howMany: number): Promise<FWorksheet>;
+insertColumnsBefore(beforePosition: number, howMany: number): FWorksheet;
-insertRowAfter(afterPosition: number): Promise<FWorksheet>;
+insertRowAfter(afterPosition: number): FWorksheet;
-insertRowBefore(beforePosition: number): Promise<FWorksheet>;
+insertRowBefore(beforePosition: number): FWorksheet;
-insertRows(rowIndex: number, numRows?: number): Promise<FWorksheet>;
+insertRows(rowIndex: number, numRows?: number): FWorksheet;
-insertRowsAfter(afterPosition: number, howMany: number): Promise<FWorksheet>;
+insertRowsAfter(afterPosition: number, howMany: number): FWorksheet;
-insertRowsBefore(beforePosition: number, howMany: number): Promise<FWorksheet>;
+insertRowsBefore(beforePosition: number, howMany: number): FWorksheet;
-moveColumns(columnSpec: FRange, destinationIndex: number): Promise<FWorksheet>;
+moveColumns(columnSpec: FRange, destinationIndex: number): FWorksheet;
-moveRows(rowSpec: FRange, destinationIndex: number): Promise<FWorksheet>;
+moveRows(rowSpec: FRange, destinationIndex: number): FWorksheet;
-setColumnCustom(custom: IObjectArrayPrimitiveType<CustomData>): Promise<FWorksheet>;
+setColumnCustom(custom: IObjectArrayPrimitiveType<CustomData>): FWorksheet;
-setColumnDefaultStyle(index: number, style: string | Nullable<IStyleData>): Promise<FWorksheet>;
+setColumnDefaultStyle(index: number, style: string | Nullable<IStyleData>): FWorksheet;
-setColumnWidth(columnPosition: number, width: number): Promise<FWorksheet>;
+setColumnWidth(columnPosition: number, width: number): FWorksheet;
-setColumnWidths(startColumn: number, numColumns: number, width: number): Promise<FWorksheet>;
+setColumnWidths(startColumn: number, numColumns: number, width: number): FWorksheet;
-setDefaultStyle(style: string): Promise<FWorksheet>;
+setDefaultStyle(style: string): FWorksheet;
-setFreeze(freeze: IFreeze): boolean;
+setFreeze(freeze: IFreeze): FWorksheet;
-setFrozenColumns(startColumn: number, endColumn: number): void;
+setFrozenColumns(startColumn: number, endColumn: number): FWorksheet;
-setFrozenRows(startColumn: number, endColumn: number): void;
+setFrozenRows(startColumn: number, endColumn: number): FWorksheet;
-setGridLinesColor(color: string | undefined): Promise<boolean>;
+setGridLinesColor(color: string | undefined): FWorksheet;
-setHiddenGridlines(hidden: boolean): Promise<boolean>;
+setHiddenGridlines(hidden: boolean): FWorksheet;
-setName(name: string): Promise<boolean>;
+setName(name: string): FWorksheet;
-setRowCustom(custom: IObjectArrayPrimitiveType<CustomData>): Promise<FWorksheet>;
+setRowCustom(custom: IObjectArrayPrimitiveType<CustomData>): FWorksheet;
-setRowDefaultStyle(index: number, style: string | Nullable<IStyleData>): Promise<FWorksheet>;
+setRowDefaultStyle(index: number, style: string | Nullable<IStyleData>): FWorksheet;
-setRowHeight(rowPosition: number, height: number): Promise<FWorksheet>;
+setRowHeight(rowPosition: number, height: number): FWorksheet;
-setRowHeights(startRow: number, numRows: number, height: number): Promise<FWorksheet>;
+setRowHeights(startRow: number, numRows: number, height: number): FWorksheet;
-setRowHeightsForced(startRow: number, numRows: number, height: number): Promise<FWorksheet>;
+setRowHeightsForced(startRow: number, numRows: number, height: number): FWorksheet;
-setTabColor(color: string): Promise<boolean>;
+setTabColor(color: string): FWorksheet;
-showColumns(columnIndex: number, numColumns?: number): Promise<FWorksheet>;
+showColumns(columnIndex: number, numColumns?: number): FWorksheet;
-showRows(rowIndex: number, numRows?: number): Promise<FWorksheet>;
+showRows(rowIndex: number, numRows?: number): FWorksheet;
-showSheet(): Promise<boolean>;
+showSheet(): FWorksheet;
-unhideColumn(column: FRange): Promise<FWorksheet>;
+unhideColumn(column: FRange): FWorksheet;
-unhideRow(row: FRange): Promise<FWorksheet>;
+unhideRow(row: FRange): FWorksheet;


-addConditionalFormattingRule(rule: IConditionFormattingRule): Promise<boolean>;
+addConditionalFormattingRule(rule: IConditionFormattingRule): FWorksheet;
-deleteConditionalFormattingRule(cfId: string): Promise<boolean>;
+deleteConditionalFormattingRule(cfId: string): FWorksheet;
-moveConditionalFormattingRule(cfId: string, toCfId: string, type?: IAnchor['type']): Promise<boolean>;
+moveConditionalFormattingRule(cfId: string, toCfId: string, type?: IAnchor['type']): FWorksheet;
-setConditionalFormattingRule(cfId: string, rule: IConditionFormattingRule): Promise<boolean>;
+setConditionalFormattingRule(cfId: string, rule: IConditionFormattingRule): FWorksheet;
-zoom(zoomRatio: number): FWorksheet;
+zoom(zoomRatio: number): FWorksheet;
...
}

FRange {
...
-merge(defaultMerge?: boolean): Promise<FRange>;
+merge(defaultMerge?: boolean): FRange;
-mergeAcross(defaultMerge?: boolean): Promise<FRange>;
+mergeAcross(defaultMerge?: boolean): FRange;
-mergeVertically(defaultMerge?: boolean): Promise<FRange>;
+mergeVertically(defaultMerge?: boolean): FRange;
-setHorizontalAlignment(alignment: FHorizontalAlignment): Promise<boolean>;
+setHorizontalAlignment(alignment: FHorizontalAlignment): FRange;
-setValue(value: CellValue | ICellData): Promise<boolean>;
+setValue(value: CellValue | ICellData): FRange;
-setValues(value: CellValue[][] | IObjectMatrixPrimitiveType<CellValue> | ICellData[][] | IObjectMatrixPrimitiveType<ICellData>): Promise<boolean>;
+setValues(value: CellValue[][] | IObjectMatrixPrimitiveType<CellValue> | ICellData[][] | IObjectMatrixPrimitiveType<ICellData>): FRange;
-setVerticalAlignment(alignment: FVerticalAlignment): Promise<boolean>;
+setVerticalAlignment(alignment: FVerticalAlignment): FRange;
-setWrap(isWrapEnabled: boolean): Promise<boolean>;
+setWrap(isWrapEnabled: boolean): FRange;
-setWrapStrategy(strategy: WrapStrategy): Promise<boolean>;
+setWrapStrategy(strategy: WrapStrategy): FRange;

-addConditionalFormattingRule(rule: IConditionFormattingRule): Promise<boolean>;
+addConditionalFormattingRule(rule: IConditionFormattingRule): FRange;
-deleteConditionalFormattingRule(cfId: string): Promise<boolean>;
+deleteConditionalFormattingRule(cfId: string): FRange;
-moveConditionalFormattingRule(cfId: string, toCfId: string, type?: IAnchor['type']): Promise<boolean>;
+moveConditionalFormattingRule(cfId: string, toCfId: string, type?: IAnchor['type']): FRange;
-setConditionalFormattingRule(cfId: string, rule: IConditionFormattingRule): Promise<boolean>;
+setConditionalFormattingRule(cfId: string, rule: IConditionFormattingRule): FRange;
-setDataValidation(rule: Nullable<FDataValidation>): Promise<FRange>;
+setDataValidation(rule: Nullable<FDataValidation>): FRange;
-createFilter(): Promise<FFilter | null>;
+createFilter(): FRange;
-cancelHyperLink(id: string): Promise<boolean>;
+cancelHyperLink(id: string): boolean;
-setNumberFormat(pattern: string): Promise<boolean>;
+setNumberFormat(pattern: string): FRange;
-sort(column: SortColumnSpec | SortColumnSpec[]): Promise<FRange>;
+sort(column: SortColumnSpec | SortColumnSpec[]): FRange;
...
}

FDataValidation{
-setCriteria(type: DataValidationType, values: [DataValidationOperator, string, string]): boolean;
+setCriteria(type: DataValidationType, values: [DataValidationOperator, string, string]): FDataValidation;
-setOptions(options: Partial<IDataValidationRuleOptions>): boolean;
+setOptions(options: Partial<IDataValidationRuleOptions>): FDataValidation;
-setRanges(ranges: FRange[]): boolean;
+setRanges(ranges: FRange[]): FDataValidation;
}

FFilter{
-remove(): Promise<boolean>;
+remove(): FFilter;
-removeColumnFilterCriteria(col: number): Promise<boolean>;
+removeColumnFilterCriteria(col: number): FFilter;
-removeFilterCriteria(): Promise<boolean>;
+removeFilterCriteria(): FFilter;
-setColumnFilterCriteria(col: number, criteria: ISetSheetsFilterCriteriaCommandParams['criteria']): Promise<boolean>;
+setColumnFilterCriteria(col: number, criteria: ISetSheetsFilterCriteriaCommandParams['criteria']): FFilter;
}

📢 0.6.0 Preview

[!IMPORTANT] The development of version 0.6.0 is currently underway. Starting with this release, Univer will support integration with projects using React@19 . However, this update may introduce breaking changes for users relying on React@16 or Univer UMD builds. If you have any questions or concerns, please feel free to share your suggestions and feedback via GitHub Issues.

  • Future versions will continue to improve enums and events, optimizing the Facade API experience #4346 #4406
    • FUniver.Enum
    • FUniver.Event
    • FUniver.addEvent(FUniver.Event.xxx, ()=> { })

📝 Univer Docs

  • Fixed known issues

🌐 Univer Server

  • Fixed known issues

📦 Univer Presets

  • Updated to the latest version of Univer

📢 Join the Conversation

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

📝 Changelog

Full changelog (2025-01-04)

Bug Fixes

Features

Reverts

  • get fontExtension from cache, revert to worksheet.getCell (#4417) (5c03dff)