🎉 Release v0.2.9

[hexf00]

🎊 [email protected]

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

• Added more Facade APIs related to permission protection feat(permission): add facade api #3132
• Added more Facade APIs related to filter feat(filter): add facade API and docs #3103
• Added more Facade APIs related to pivot table
• Added internationalization support for currency shortcuts feat(numfmt): currency shortcuts support internationalization #3062
• Added rank/rank.avg/rank.eq sorting functions feat(formula): add rank/rank.avg/rank.eq function #3140
• 236 formula functions are supported, with a goal of 500+

🐞 Bug Fixes

• Fixed an issue with formula calculations fix(formula): skip tree after add to formula run list #3114
• Fixed an issue where imports were not displayed completely fix(formula): skip tree after add to formula run list #3114
• Fixed an issue with incorrect positioning of the floating DOM layer fix(sheets-drawing-ui): float-dom-layer position not correct on sheets and uni mode #3152
• Fixed a timing issue during the initialization of conditional formatting fix(conditional-formatting): initialization timing problem #3142
• Fixed an issue where custom menu items were hidden by default when hidden$ was not configured fix: fix issue where custom menu items are hidden by default when hidden$ is not configured #3122
• Fixed a date validator error when errorStyle=STOP was set in sheets data validation fix(sheets-data-validation): date validator error when errorStyle=STOP was set #3102

💔 Breaking Changes

• The method to get workbook data has been updated. Also, FWorkbook.getSnapshot will be removed in the future, so please switch to the FWorkbook.save method. refactor(resources)!: remove workbook.save and add resourceloader.saveunit #3128

• Some useless properties on snapshots are removed: houldStartRenderingImmediately, container, selections refactor(core)!: remove redundant files in core package #3154

• The package name for the pivot table plugin has been updated from @univerjs-pro/pivot-engine to @univerjs-pro/engine-pivot. Additionally, the default configuration options required by the plugin have been removed.

install the new package:

pnpm add @univerjs-pro/sheets-pivot @univerjs-pro/sheets-pivot-ui
- pnpm add @univerjs-pro/pivot-engine
+ pnpm add @univerjs-pro/engine-pivot

plugin registration:

-univer.registerPlugin(UniverSheetsPivotTablePlugin, {
-  notExecuteFormula: true,
-  registerInOneThread: true,
-})
+univer.registerPlugin(UniverSheetsPivotTablePlugin)
univer.registerPlugin(UniverSheetsPivotTableUIPlugin)

📝 Univer Docs

🐞 Bug Fixes

• Fixed bugs in docs-ui / docs / docs-drawing-ui

📢 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-08-23)

Bug Fixes

• conditional-formatting: initialization timing problem (#3142) (7d1c9d6)
• crosshair: fix rendering controller (f697951)
• debug currentSkeleton$ if param is null (#3164) (3283d61)
• docs-ui: limit list maxLevel to 3 when in table & set line-through style on checklist (#3096) (9a62d77)
• docs-ui: link & checklist can't work on header-footer (#3107) (106e7c4)
• docs: disable some menu items when no selections (#3094) (07a24cb)
• docs: find cursor by coods (#3143) (9998feb)
• docs: line space between image and line (#3101) (32915ff)
• docs: no need to scroll to selection when resize page (#3092) (9697d87)
• fix issue where custom menu items are hidden by default when hidden$ is not configured (#3122) (701131d)
• fix some permission bugs (#3037) (eb30bdc)
• fix type error (983a323)
• formula: array input (#3097) (774d09c)
• formula: skip tree after add to formula run list (#3114) (a238ea9)
• hyper-link ref-range error on filter (#3135) (014dd67)
• permission: optimize permission calculation logic in dv (#2811) (d127e02)
• ref selection expand after bottom line is over top line, and ref selection fill area(primary cell) and formula editor should clear when change sheet. (#3104) (e73fc3c)
• selection render and insert char (#2982) (411d328)
• sheet: defined name panel style (#2797) (23a581b)
• sheet: mixin should not use class self (#3130) (1d7c3ab)
• sheet: move function to a file and export (#3125) (8483725)
• sheets-data-validation: data-validation absolute offset (#3091) (135e5c0)
• sheets-data-validation: date validator error when errorStyle=STOP was set (#3102) (a5015c8)
• sheets-drawing-ui: float-dom-layer position not correct on sheets and uni mode (#3152) (4e434b0)
• sheets-ui: data-validation dropdown hidden when selection change (#3119) (b8bf3b1)

Features

• add crosshair highlight plugin for Univer Sheet (#3118) (3e9c34c)
• docs: tab in table (#3064) (39ce155)
• facade: add FFormula api (#3144) (610be1f)
• filter: add facade API and docs (#3103) (dc37071)
• formula: add rank/rank.avg/rank.eq function (#3140) (d2a3ec2)
• numfmt: currency shortcuts support internationalization (#3062) (736cb9b)
• permission: add facade api (#3132) (ca21fb8)
• pivot: add mixin to util (#3124) (53f6610)

---

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

[hexf00]

🎊 [email protected]

🚧 重要提示

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

🚀 快速开始

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

📊 Univer Sheets

🎉 新功能

• 新增权限保护相关的Facade API feat(permission): add facade api #3132
• 新增过滤器相关的Facade API feat(filter): add facade API and docs #3103
• 新增透视表相关的Facade API
• 货币单位添加国际化支持 feat(numfmt): currency shortcuts support internationalization #3062
• 添加 rank/rank.avg/rank.eq 公式函数 feat(formula): add rank/rank.avg/rank.eq function #3140
• 已经支持 236 个公式函数，目标是500+

🐞 Bug 修复

• 修复公式计算问题 fix(formula): skip tree after add to formula run list #3114
• 修复导入时未完全显示的问题 fix(formula): skip tree after add to formula run list #3114
• 修复悬浮 DOM 层定位不正确的问题 fix(sheets-drawing-ui): float-dom-layer position not correct on sheets and uni mode #3152
• 修复条件格式化初始化时的时序问题 fix(conditional-formatting): initialization timing problem #3142
• 修复未配置 hidden$ 时自定义菜单项默认隐藏的问题 fix: fix issue where custom menu items are hidden by default when hidden$ is not configured #3122
• 修复数据验证中设置 errorStyle=STOP 时日期验证器错误的问题 fix(sheets-data-validation): date validator error when errorStyle=STOP was set #3102

💔 破坏性变更

• 获取工作簿数据的方法已更新。此外，FWorkbook.getSnapshot 将在未来被移除，请切换到 FWorkbook.save 方法。refactor(resources)!: remove workbook.save and add resourceloader.saveunit #3128
• 快照中一些无用的属性已被移除：houldStartRenderingImmediately、container、selections refactor(core)!: remove redundant files in core package #3154
• 透视表插件的包名已从 @univerjs-pro/pivot-engine 更新为 @univerjs-pro/engine-pivot。此外，插件所需的默认配置选项已被移除。

安装新包：

pnpm add @univerjs-pro/sheets-pivot @univerjs-pro/sheets-pivot-ui
- pnpm add @univerjs-pro/pivot-engine
+ pnpm add @univerjs-pro/engine-pivot

插件注册：

-univer.registerPlugin(UniverSheetsPivotTablePlugin, {
-  notExecuteFormula: true,
-  registerInOneThread: true,
-})
+univer.registerPlugin(UniverSheetsPivotTablePlugin)
univer.registerPlugin(UniverSheetsPivotTableUIPlugin)

📝 Univer Docs

🐞 Bug 修复

• 修复 docs-ui / docs / docs-drawing-ui 中的一些问题

📢 加入讨论

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

• GitHub Discussions
• 👾 Discord

📝 更新日志

完整的更新日志 (2024-08-23)

[JeffreyZhu983]

Amazon job