🎊 Univer@v0.2.15

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

• Optimized merged cell implementation, significantly improving performance with large datasets #3403
• Added new formula functions: MID and LEFTB #3417 #3418
• FWorksheet.getRange now supports A1 notation input #3504
• Now supporting 321 formula functions, with a goal of 500+

🐞 Bug Fixes

• Fixed an issue where column widths were not preserved when pasting from Excel #3450
• Resolved a problem where clicking the scrollbar didn't trigger scroll commands #3429
• Improved permissions, allowing cell size adjustment when setEditable(false) #3464
• Fixed the "permissionPoint does not exist!" error when recreating units #3392
• Column header arrows are now hidden when contextMenu is set to false #3444
• Addressed incomplete display issues in hyperlink editing #3462

📝 Univer Docs

• Stability improvements

🌐 Univer Server

• Table insertion is supported after importing the Docx file

📢 Join the Conversation

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

• :octocat: GitHub Discussions
• 👾 Discord

📝 Changelog

Full changelog (2024-09-21)

Bug Fixes

• add filter with one cell should adjust expend range permission (#3469) (b4b0763)
• clipboard: fix paste col width (#3450) (2175c49)
• design: prevent suffix showing with allowClear is false (#3449) (32b2cac)
• docs-ui: doc list can't toggle (#3473) (3dc6d95)
• docs: scroll to selection (#3458) (3cf7b46)
• docs: wrong ime position after scroll (#3457) (6e6b0b2)
• fix edit cell with remove sheet (#3474) (38b03fb)
• fix pasting twice in formula editor (#3481) (13cf373)
• formula: binary search supports match type (#3402) (6db4cf8)
• formula: fix some bugs (#3470) (7c66482)
• hide sheet should operation right sheet (#3468) (a4bfe0d)
• menu: sort menu should be hide (#3505) (9530fe4)
• numfmt: do not block when syntax is not supported (#3491) (b8c9256)
• scroll cmd for pointer down at scrolltrack (#3429) (8e9f513)
• sheet: getDiscreteRanges filter empty cell (#3437) (92a063a)
• sheets-data-validation: data validation event trigger before data applied (#3498) (c4601a0)
• sheets-data-validation: data-validation oom on extreme-big-range (#3494) (86c2dd9)
• sheets-data-validation: large data validation oom (#3492) (42ce257)
• sheets-hyper-link-ui: input link error (#3513) (b4fcb4a)
• sheets-hyper-link-ui: link redo undo (#3465) (9ddcaf5)
• sheets-hyper-link: build url (#3503) (25b7b66)
• sheets-thread-comment-ui: delete comment error (#3476) (01a78da)
• sheets-thread-comment: comment ui issues (#3510) (05616d4)
• sheet: set selection should ensure the selection is not null (#3497) (7b89f27)
• span: fix editor position not right issue (#3443) (4b86a65)
• type errors (20d35a3)
• ui: hide column header arrow when contextMenu is false (#3444) (1355807)

Features

• core: unify the handler of get plain text from rich-text model (#3421) (e9395d2)
• demo: add support for dynamic imports (#3433) (33571b6)
• facade: add FWorksheet.getRange(a1Notation) (#3504) (a697a49)
• formula: add function leftb (#3418) (b66e8ce)
• formula: add function mid (#3417) (32fb95e)
• sheets-data-validation: data validation optimize (#3422) (93c3659)
• sheets-ui: undo set cols visible should scroll to cols (#3355) (ed6d783)

Performance Improvements

• refactor local file service (#3479) (23e47c2)
• sheet: add span model (#3403) (c357724)