🎊 Univer@v0.2.9

🚧 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 #3132
• Added more Facade APIs related to filter #3103
• Added more Facade APIs related to pivot table
• Added internationalization support for currency shortcuts #3062
• Added rank/rank.avg/rank.eq sorting functions #3140
• 236 formula functions are supported, with a goal of 500+

🐞 Bug Fixes

• Fixed an issue with formula calculations #3114
• Fixed an issue where imports were not displayed completely #3114
• Fixed an issue with incorrect positioning of the floating DOM layer #3152
• Fixed a timing issue during the initialization of conditional formatting #3142
• Fixed an issue where custom menu items were hidden by default when hidden$ was not configured #3122
• Fixed a date validator error when errorStyle=STOP was set in sheets data validation #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. #3128

• Some useless properties on snapshots are removed: houldStartRenderingImmediately, container, selections #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:

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