🎊 Univer@v0.2.14

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

• Support for hyperlinks in rich text within cells #3322
• Format painter now supports conditional formatting #3420
• Added 7 new lookup and reference formula functions #3352
• Introduced new formula functions: bycol, byrow, map, reduce, and scan #3320
• Added 16 new mathematical formula functions #3381
• Now supporting 319 formula functions, with a goal of 500+

🐞 Bug Fixes

• Optimized scrolling performance when using filters with large datasets #3396
• Permission errors no longer output to console #3363
• Optimized behavior related to formula IDs #3339
• Fixed issue where custom property was being overwritten as { __link_url: "" } #3434

💔 Breaking Changes

• Refactored data-validation model #3383

📝 Univer Docs

💔 Breaking Changes

• refactor of doc selections #3299
  • The TextSelectionManagerService service was renamed to DocSelectionManagerService.
  • Some of the APIs in the docs package were moved to the docs-ui package.
  • TextSelectionRenderManagerService is migrated to the docs-ui package, renamed to DocSelectionRenderService, and the IRenderModule interface is implemented.

📢 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-13)

Bug Fixes

• border auxiliary is unexpectedly cleared after the merge cell is hidden (#3358) (c11c324)
• cell margin top is not right (#3382) (8b4027e)
• cell value should adjust rich text & function (#3385) (ca628e1)
• docs-drawing: drawing resource (#3410) (4f2b148)
• docs-ui: editor focusing conflict when update content (#3423) (f2deabc)
• formular: fix sheet maximum (#3384) (41affb7)
• formula: update formula id (#3339) (1434966)
• incorrectly quit autofill mode (#3390) (f0fc942)
• render: fix the issue loop span many times (#3394) (f3d55f7)
• sheet getRowVisible lags after filter (#3396) (cb2cf7e)
• sheet: adjust move range old mutation not has fromRange property (#3361) (11748a5)
• sheet: fix type error (#3401) (7ce40a5)
• sheet: merge cell custom property (#3365) (880ef44)
• sheets-ui: recover float-dom delete menu & focusing when zen-editor mount (#3426) (2bf1177)
• sheet: the first style of span is not set is merge to true (#3398) (6def773)
• sort: i18n error in sheet sort (#3419) (771eeb6)
• the viewport size is too big after cancel filter rule, then viewport main is blank because graphic mem is full. (#3415) (f31cefd)
• ui: prevent dropdown usage when menu bar is disabled (#3400) (5f2e9fa)
• sheet: custom will overwrite the original value (#3431) (e1042d4)
• sheets-ui: formula error when cross sub-sheet (#3436) (97ae314)

Features

• action-recorder: add experimental action recorder plugin (#3386) (83238fa)
• conditional-formatting: support formatting painter (#3420) (2b121d7)
• doc-hyper-link: polyfill history data for doc hyper link (#3406) (5f2c2fe)
• formula: add some lookup formulas (#3352) (5ab9c7d)
• formula: add some math formulas (#3381) (e736b8a)
• formula: bycol/byrow/map/reduce/scan (#3320) (85b9d90)
• sheets-hyper-link-ui: sheet link support rich-text mode (#3322) (d19d224)
• sheets-ui: optimize shortcut for comment & hyperlink editor (#3434) (9604020)