dream-num/univer v0.12.0

🎉 Release v0.12.0

on GitHub

🎊 Univer@v0.12.0

🚧 Important Note

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

✨ New Features Highlights

• Toolbar Type - Added 'classic' mode to the ribbonType configuration option. #6105
• Added support for Table formulas. #6113
• Added Japanese (ja-JP) language pack. #6153
• Refactored the permission control API to support clearer hierarchy and more granular permission settings. #6127

🐛 Bug Fixes and Optimizations

• Fixed issues related to formulas:
  • Fix the issue where the MATCH formula returned incorrect results when handling empty cells. #6119
  • Fix the issue where the status bar displayed incorrectly when selecting the result range of an array formula. #6117
  • Fix memory leak issues in certain formula cases. #6133 #6136
  • Fix the issue where the TEXT formula returned incorrect results when the first parameter was text in number format. #6140
  • Fix the issue where SUBTOTAL and OFFSET formulas returned incorrect results in certain nested cases. #6149
  • Fix the issue where IRR, MIRR, NPV, and XNPV formulas returned incorrect results when parameters were empty strings. #6155
  • Fix the issue where date and time comparisons in formulas returned incorrect results in certain edge cases. #6158
• Fixed the issue where adding data validation failed due to permission errors. #6125
• Optimized hiding cell alert pop-ups when entering cell edit mode. #6146
• Fixed the issue where collaborators could not edit worksheets after a user created and then deleted worksheet protection during collaborative editing. #6150

🌐 Univer Server

• Fix the issue where new formulas introduced from Excel 2016 (Office 365) required prefixes like _xlfn. after export.

📦 Univer Presets

• SDK has been updated to version 0.12.0.

📢 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 (2025-11-15)

Bug Fixes

• array status bar (#6117) (3ff8ac0)
• clear array formula (#6159) (c3d52d2)
• fix some commands that did not pass the ranges to the permissionCheckWithRanges method (#6125) (6840b39)
• formula: add false store to inverted index cache (#6154) (d2b66a8)
• formula: add more single ref (#6126) (982a263)
• formula: change trigger (#6124) (96ab49b)
• formula: clear array formula cache (#6157) (36ece7d)
• formula: clear array formula cache (#6164) (9b63474)
• formula: fix inverted index cache (#6123) (7ecb88c)
• formula: fix MATCH formula calculation (#6119) (10fda4b)
• formula: reference copy attach info (#6160) (5add949)
• formula: support multi reference (#6149) (8ab9567)
• formula: update (#6151) (cd8983b)
• formula: update compare logic (#6158) (c884677)
• formula: update inverted index cache (#6145) (397ff97)
• formula: update npv (#6155) (5b582dd)
• formula: update sum product (#6152) (bf1d4d5)
• formula: wildcard compare not apply cache (#6162) (dcb99f8)
• formula: write snapshot error (#6118) (4bb32b4)
• permission: add checks for rule existence during async operations (#6150) (6f6d6b6)
• permission: use optional chaining for command params (#6161) (ebe1149)
• sheet protection not work (#6137) (d58a9d3)
• sheet: handle empty pages in getDocsSkeletonPageSize function (#6147) (4affcea)
• text: update (#6140) (693e9d2)
• xf: add to set range value (#6128) (944a6f4)

Features

• cell-popup: hide cell popup while editing (#6146) (4dbb8cd)
• formula: adapt formula format for SSC service compatibility (#6109) (708daa9)
• formula: table formula (#6113) (a5e51e4)
• i18n: support ja-JP (#6153) (9dad84f)
• object matrix add new fucntion (#6163) (15ae3e1)
• ui: add new ribbon type (#6105) (ba2ed35)
• ui: update ClassicMenu height and adjust layout in Ribbon component (#6116) (29c107c)

Performance Improvements

• formula: memory leak (#6133) (1a44a56)
• formula: update (#6136) (9e29ce2)