dream-num/univer v0.5.4

🎉 Release v0.5.4

on GitHub

🎊 Univer@v0.5.4

🚧 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

• New feature: When pasting, a selective paste context menu will be triggered. #4393

• 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

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

• GitHub Discussions
• 👾 Discord

📝 Changelog

Full changelog (2025-01-13)

Bug Fixes

• better facade comment (#4402) (59a1774)
• design: ensure colorpicker trigger onChanged callback on mouseup event (#4443) (32f1d30)
• design: ensure colorpicker triggers value change after color selection (#4441) (c4d8a1b)
• design: improve styling of Tooltip (#4463) (fcf5bbf)
• facade: insert empty text error (#4465) (88a0c86)
• font interceptor (#4453) (48080f6)
• formula: clear ast cache (#4439) (c504fcb)
• formula: fix formula facade import (#4438) (b1e4ae8)
• formula: node maker handle blank (#4347) (2fbe824)
• paste border should cover origin border (#4321) (7cdd2e6)
• pointer event (#4456) (58d8551)
• ref selection clear (#4387) (c2d126e)
• sheet: sheet name quote (#4198) (f42c01a)
• sidebar visible shoule be false when close (#4343) (c8f2171)
• ui: improve the style of Ribbon (#4448) (4be0fb9)

Features

• add find replace facade api (#4430) (e34c664)
• add paste options (#4393) (d758b21)
• facade: add comment & rich-text & data-validation & edit API (#4423) (cff224f)
• facade: add formula facade (#4348) (de097d8)
• facade: add lexer-tree-builder (#4444) (a36c4f3)
• facade: add ui facade (#4452) (6b723c9)
• facade: univer-sheet change to workbook (#4460) (c4e9c3a)
• formula: support lambda in function register (#4298) (a1b7a16)
• image: add event and enum (#4429) (b413d68)