🎉 Release v0.2.15

[hexf00]

🎊 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 feat(sheet): span mode #3403
• Added new formula functions: MID and LEFTB feat(formula): add function mid #3417 feat(formula): add function leftb #3418
• FWorksheet.getRange now supports A1 notation input feat(facade): add FWorksheet.getRange(a1Notation) #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 fix(clipboard): fix paste col width #3450
• Resolved a problem where clicking the scrollbar didn't trigger scroll commands fix: scroll cmd for pointer down at scrolltrack #3429
• Improved permissions, allowing cell size adjustment when setEditable(false) chore: change permission check row #3464
• Fixed the "permissionPoint does not exist!" error when recreating units chore: change rx subscribe when mult unit #3392
• Column header arrows are now hidden when contextMenu is set to false fix(ui): hide column header arrow when contextMenu is false #3444
• Addressed incomplete display issues in hyperlink editing chore: add permission facade returns #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:

• 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)

---

This discussion was created from the release 🎉 Release v0.2.15.

[hexf00]

🎊 Univer@v0.2.15

🚧 重要提示

该项目仍在积极开发中，预计会有重大 API 更改。您的反馈至关重要！请提交 issues 和建议，帮助我们塑造 Univer 的未来。

🚀 快速开始

如果您希望了解 Univer，请查看我们的入门文档。
深入探索由 Univer 提供支持的协作文档、电子表格和演示文稿编辑的世界！

📊 Univer Sheets

🎉 新功能

• 优化合并单元格实现，大幅提升大数据量下的性能 feat(sheet): span mode #3403
• 新增 mid、leftb 公式函数 feat(formula): add function mid #3417 feat(formula): add function leftb #3418
• FWorksheet.getRange支持传入A1表示法 feat(facade): add FWorksheet.getRange(a1Notation) #3504
• 公式函数数量现已达到 321 个，目标是超过 500 个

🐞 Bug 修复

• 修复从 Excel 粘贴时未保留行列宽度 fix(clipboard): fix paste col width #3450
• 修复点击滚动条不会触发滚动命令 fix: scroll cmd for pointer down at scrolltrack #3429
• 权限优化，setEditable(false) 后允许调整单元格大小 chore: change permission check row #3464
• 修复重新创建 unit 会出现 permissionPoint does not exist! 错误 chore: change rx subscribe when mult unit #3392
• 当 contextMenu 为 false 时会隐藏列箭头 fix(ui): hide column header arrow when contextMenu is false #3444
• 修复超链接编辑显示不完整 chore: add permission facade returns #3462

📝 Univer Docs

• 稳定性改进

🌐 Univer Server

• 导入 Docx 后支持插入表格

📢 加入讨论

我们欢迎您的参与和见解，一起踏上这个激动人心的旅程。请通过以下方式与我们联系：

• GitHub Discussions
• 👾 Discord

📝 更新日志

完整的更新日志 (2024-09-21)