Skip to content

🎉 Release v0.5.2
Compare
Choose a tag to compare
@hexf00 hexf00 released this 28 Dec 10:41
· 231 commits to dev since this release
v0.5.2
f182455

🎊 Univer@v0.5.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!

📊 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:

  • Added Spark-line plugin, click here for details #4233
    sparkline

  • Added Univer.onDispose for cleanup work #4218

  • Refactored message box and optimized message box styles #4352

  • Added numerous Facade APIs covering: worksheets, selection, UI, name manager, scrollbar, shortcuts, sorting, network, images, conditional formatting, and more

  • Added Facade API for getting multiple selections #4264

import '@univerjs/sheets/facade';

// get active range list
const activeRangeList = univerAPI.getActiveWorkbook().getActiveRangeList();
import '@univerjs/sheets-ui/facade';

// hide selection
univerAPI.getActiveWorkbook().transparentSelection()
// show selection
univerAPI.getActiveWorkbook().showSelection()
  • Added Image Operations Facade API #4322
import '@univerjs/sheets-drawing-ui/facade';

const activeSpreadsheet = univerAPI.getActiveWorkbook();
const activeSheet = activeSpreadsheet.getActiveSheet();
// insert image on A1
activeSheet.insertImage('https://avatars.githubusercontent.com/u/61444807?s=48&v=4', 0, 0);
  • Added Network Operations Facade API #4294
import '@univerjs/network/facade';

univerAPI.getNetwork().get("/api.json")
  .then(res => console.log('data', res.body))
  .catch(e  => console.log('error', e))

univerAPI.getNetwork().post("/api.json", { headers: {}, body: {} })
  • Added Conditional Formatting Facade API #4300
import '@univerjs/sheets-conditional-format/facade';

const workbook  = univerAPI.getActiveWorkbook();
const worksheet = workbook.getActiveSheet();

// set style when cell not empty on A1:A100
const rule = worksheet.createConditionalFormattingRule()
        .whenCellNotEmpty()
        .setRanges([{ startRow: 0, endRow: 100, startColumn: 0, endColumn: 100 }])
        .setItalic(true)
        .setBackground('red')
        .setFontColor('green')
        .build();
worksheet.addConditionalFormattingRule(rule);
  • Added Sorting Operations Facade API #4312
import '@univerjs/sheets-sort/facade';

const workbook  = univerAPI.getActiveWorkbook();
const worksheet = workbook.getActiveSheet();

const range = worksheet.getRange("A1:B3");
// sort A1:B3 by column B in ascending order
range.sort({column: range.getColumn() + 1 ,ascending:true})
import '@univerjs/ui/facade';

// create a custom menu on ribbon
univerAPI.createMenu({
  id: 'custom-menu-id',
  title: 'Custom Text',
  tooltip:'This tip show on hover.',
  action: () => {
    console.log('Custom Text');
  },
}).appendTo('ribbon.start.others');

// show message
univerAPI.showMessage({ content:"Hello, Univer!" })
  • Added Name Manager Facade API #4282
import '@univerjs/sheets/facade';

const workbook = univerAPI.getActiveWorkbook();
workbook.insertDefinedName('MyDefinedName', 'Sheet1!A1');

const definedNames = workbook.getDefinedNames();
  • Added Scrollbar Facade API #4290
import '@univerjs/sheets-ui/facade';

// get scroll state
univerAPI.getActiveWorkbook().getActiveSheet().getScrollState();

// scroll Event
univerAPI.getActiveWorkbook().getActiveSheet().onScroll((state) => {
    console.log('scroll', state);
});
  • Added Range to A1 Notation Facade API #4325
import '@univerjs/sheets/facade';

const range = univerAPI.getActiveWorkbook().getActiveRange().getA1Notation();
// convert range to A1:B3
range.getA1Notation();

🐞 Bug Fixes

  • Fixed border display issues when merging cells #4276
  • Fixed memory leak issues #4212 #4213
  • Fixed color picker reset functionality #4234
  • Fixed hyperlink issues #4223 #4237
  • Fixed known formula engine issues #4224 #4245
  • Fixed known clipboard issues #4268 #4253
  • Fixed known formula auto-fill issues #227
  • Fixed XLOOKUP formula function #4277
  • Fixed SUMIFS formula function #4216
  • Fixed PRODUCT formula function #4273
  • Fixed performance issues with data validation for large datasets #4376

💔 Breaking Changes

  • Merge Facade API will now force merge without prompting #4246
  • @univerjs-pro/collaboration-client has been split into three packages:
    • @univerjs-pro/collaboration-client
    • @univerjs-pro/collaboration-client-node
    • @univerjs-pro/collaboration-client-ui
-pnpm i @univerjs-pro/collaboration @univerjs-pro/collaboration-client
+pnpm i @univerjs-pro/collaboration @univerjs-pro/collaboration-client @univerjs-pro/collaboration-client-ui
import { UniverCollaborationClientPlugin } from '@univerjs-pro/collaboration-client';
+import { UniverCollaborationClientUIPlugin } from '@univerjs-pro/collaboration-client-ui';

-import '@univerjs-pro/collaboration-client/lib/index.css';
+import '@univerjs-pro/collaboration-client-ui/lib/index.css';

univer.registerPlugin(UniverCollaborationClientPlugin, {
    ...
});
+univer.registerPlugin(UniverCollaborationClientUIPlugin);
  • Fixed incorrect export names
-import { CollabrationImageIoService } from '@univerjs-pro/collaboration-client'
+import { CollaborationImageIoService } from '@univerjs-pro/collaboration-client'
  • Print Facade API adjustments, removed unnecessary return values
interface FWorkSheet {
    ...
-    closePrintDialog(): boolean;
-    openPrintDialog(): boolean;
-    print(): boolean;
+    closePrintDialog(): void;
+    openPrintDialog(): void;
+    print(): void;
    ...
}

📢 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 Docs

Fixed known rendering issues #4219

🌐 Univer Server

Fixed known issues and improved service stability

📦 Univer Presets

🎉 Highlights

  • All new features and Facade APIs from 0.5.2 are now integrated into Presets by default, just import presets to use them

🐞 Bug Fixes

  • Fixed known issues in Node.js environment

💔 Breaking Changes

  • Dependencies imported through @univerjs/presets should now be imported through specific preset entries:
-import { HTTPService } from '@univerjs/presets'
+import { HTTPService } from '@univerjs/presets/preset-sheets-advanced'
  • @univerjs-pro/thread-comment-datasource has been removed from presets, requires separate registration if needed.

🎢 Special Thanks

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

📢 Join the Conversation

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

📝 Changelog

Full changelog (2024-12-28)

Bug Fixes

Features

Contributors

okxiaoliang4
Assets 2
Loading
1 Join discussion