🎉 Release v0.14.0

[wpxp123456]

🎊 Univer@v0.14.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

• Document collaboration feature usage example in Node.js environment: https://docs.univer.ai/guides/sheets/features/collaboration#node-collaboration-example.

🐛 Bug Fixes and Optimizations

• Fix where IDialogProps properties mask, maskClosable, and keyboard were not effective. fix(design): fix the mask, maskClosable, and keyboard properties in IDialogProps #6311
• Fix where defined names and table names did not check for duplicates. fix: fix defined name can't be duplicate with table name #6312
• Fix where custom formulas in conditional formatting did not update after inserting/deleting rows or columns. feat(sheets-conditional-formatting): use other-formula-service on conditional-formatting #6322 feat(engine-formula): move register-other-formula-service to engine-formula #6328 refactor(sheets-conditional-formatting): ref-range #6335
• Fix style errors when pasting copied cells with conditional formatting, data validation, number formats, etc. fix(paste): fix the style error when copying cells with conditional formatting, data validation, number formatting, etc. #6326
• Fix where duplicate checks for defined names, table names, and worksheet names did not ignore case sensitivity. fix: fix case sensitivity was not ignored when checking for duplicate defined names, table names and sheet names #6330
• Fix where data stored in InsertSheetMutation could be modified by subsequent operations in collaborative environments. fix(sheets): ensure the sheet param of InsertSheetMutation are not modified by subsequent operations #6338
• Fix where some APIs like setGridLinesColor were ineffective when called on non-active worksheets. fix(sheets): fix some APIs, such as setGridLinesColor, were ineffective when setting for inactive worksheets #6348
• Fix error when Sankey chart data contains circular references.

Special thanks to community contributor @kenny-not-dead for contributions in this version:

• Optimize left-top corner defined name input box style. fix: defined name input style #6306
• Add interaction experience to show corresponding selection when clicking defined names in the defined name management panel. feat: set defined name in formula bar #6304
• Add quick jump feature by entering defined names in the top-left corner. feat: formula bar defined name input focus if has defined name #6315
• Optimize related logic of page setup panel in docs. feat: add page setup precision #6294

💔 Breaking Changes

• Move the IConfirmService interface definition from the @univerjs/ui package to the @univerjs/core package; please update if you are using it. refactor: move IConfirmService interface to core package and move merge-related command from sheets-ui to sheets package #6320
• Move merge cell related commands from the @univerjs/sheets-ui package to the @univerjs/sheets package; please update if you are using them. refactor: move IConfirmService interface to core package and move merge-related command from sheets-ui to sheets package #6320
• Change the COLORS color keyword constants in the @univerjs/core package to be case-insensitive; please update if you are using them. fix: fix colors keyword case ignorin #6359

🌐 Univer Server

• Fix style issues when importing certain Excel files with row styles set.

📦 Univer Presets

• SDK has been updated to version 0.14.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-12-20)

Bug Fixes

• add UniverSheetsFormulaPlugin for SheetsConditionalFormatting & SheetsDataValidation (fix: add UniverSheetsFormulaPlugin for SheetsConditionalFormatting & SheetsDataValidation #6329) 21b2d38, closes fix: add UniverSheetsFormulaPlugin for SheetsConditionalFormatting & SheetsDataValidation #6329
• api: fix new sheet params ts type (fix(api): fix new sheet params ts type #6323) 120263f, closes fix(api): fix new sheet params ts type #6323
• defined name input style (fix: defined name input style #6306) a0825f0, closes fix: defined name input style #6306
• design: fix the mask, maskClosable, and keyboard properties in IDialogProps (fix(design): fix the mask, maskClosable, and keyboard properties in IDialogProps #6311) ebae000, closes fix(design): fix the mask, maskClosable, and keyboard properties in IDialogProps #6311
• fix case sensitivity was not ignored when checking for duplicate defined names, table names and sheet names (fix: fix case sensitivity was not ignored when checking for duplicate defined names, table names and sheet names #6330) d044bd9, closes fix: fix case sensitivity was not ignored when checking for duplicate defined names, table names and sheet names #6330
• fix colors keyword case ignorin (fix: fix colors keyword case ignorin #6359) 6286b6c, closes fix: fix colors keyword case ignorin #6359
• fix defined name can't be duplicate with table name (fix: fix defined name can't be duplicate with table name #6312) dd79f5f, closes fix: fix defined name can't be duplicate with table name #6312
• fix remove merge cells on node (fix: fix remove merge cells on node #6337) 3237b07, closes fix: fix remove merge cells on node #6337
• formula: add api and fix ref formula (fix(formula): add api and fix ref formula #6336) 32f8d45, closes fix(formula): add api and fix ref formula #6336
• formula: add graph api (fix(formula): add graph api #6313) b2a757b, closes fix(formula): add graph api #6313
• formula: add type to tree model (fix(formula): add type to tree model #6314) 6a1d638, closes fix(formula): add type to tree model #6314
• formula: lexer add index for ref (fix(formula): lexer add index for ref #6331) 64d075b, closes fix(formula): lexer add index for ref #6331
• formula: start calculation trigger (fix(formula): start calculation trigger #6321) e52201a, closes fix(formula): start calculation trigger #6321
• formula: update (fix(formula): update #6318) f257194, closes fix(formula): update #6318
• paste: fix the style error when copying cells with conditional formatting, data validation, number formatting, etc. (fix(paste): fix the style error when copying cells with conditional formatting, data validation, number formatting, etc. #6326) 1545674, closes fix(paste): fix the style error when copying cells with conditional formatting, data validation, number formatting, etc. #6326
• sheets: ensure the sheet param of InsertSheetMutation are not modified by subsequent operations (fix(sheets): ensure the sheet param of InsertSheetMutation are not modified by subsequent operations #6338) 1f77bf4, closes fix(sheets): ensure the sheet param of InsertSheetMutation are not modified by subsequent operations #6338
• sheets: fix some APIs, such as setGridLinesColor, were ineffective when setting for inactive worksheets (fix(sheets): fix some APIs, such as setGridLinesColor, were ineffective when setting for inactive worksheets #6348) a6cc5b5, closes fix(sheets): fix some APIs, such as setGridLinesColor, were ineffective when setting for inactive worksheets #6348

Features

• add page setup precision (feat: add page setup precision #6294) 24107e0, closes feat: add page setup precision #6294
• engine-formula: move register-other-formula-service to engine-formula (feat(engine-formula): move register-other-formula-service to engine-formula #6328) 6fd9e36, closes feat(engine-formula): move register-other-formula-service to engine-formula #6328
• formula bar defined name input focus if has defined name (feat: formula bar defined name input focus if has defined name #6315) 5eef953, closes feat: formula bar defined name input focus if has defined name #6315
• set defined name in formula bar (feat: set defined name in formula bar #6304) b485708, closes feat: set defined name in formula bar #6304
• sheets-conditional-formatting: use other-formula-service on conditional-formatting (feat(sheets-conditional-formatting): use other-formula-service on conditional-formatting #6322) a1b7d95, closes feat(sheets-conditional-formatting): use other-formula-service on conditional-formatting #6322
• sheets: add biz info on other formula (feat(sheets): add biz info on other formula #6296) 23f6ae2, closes feat(sheets): add biz info on other formula #6296

[wpxp123456]

🎊 Univer@v0.14.0

🚧 重要提示

您的反馈至关重要！请提交 issues 和建议，帮助我们塑造 Univer 的未来。

🚀 快速开始

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

📊 Univer Sheets

✨ 新功能亮点

• 文档协同编辑功能在 Node.js 环境下的使用示例：https://docs.univer.ai/guides/sheets/features/collaboration#node-collaboration-example。

🐛 改进与优化

• 修复 IDialogProps 中 mask，maskClosable 和 keyboard 属性未生效的问题。fix(design): fix the mask, maskClosable, and keyboard properties in IDialogProps #6311
• 修复定义名称和 table 名称未判断重名的问题。fix: fix defined name can't be duplicate with table name #6312
• 修复条件格式自定义公式在插入/删除行列后未更新的问题。feat(sheets-conditional-formatting): use other-formula-service on conditional-formatting #6322 feat(engine-formula): move register-other-formula-service to engine-formula #6328 refactor(sheets-conditional-formatting): ref-range #6335
• 修复复制有条件格式、数据验证、数字格式等单元格时粘贴会出现样式错误的问题。fix(paste): fix the style error when copying cells with conditional formatting, data validation, number formatting, etc. #6326
• 修复定义名称、table 名称、工作表名称重复判断时未忽略大小写的问题。fix: fix case sensitivity was not ignored when checking for duplicate defined names, table names and sheet names #6330
• 修复协同环境下 InsertSheetMutation 会被后续操作修改数据的问题。fix(sheets): ensure the sheet param of InsertSheetMutation are not modified by subsequent operations #6338
• 修复 setGridLinesColor 等一些 API 在非当前工作表调用无效的问题。fix(sheets): fix some APIs, such as setGridLinesColor, were ineffective when setting for inactive worksheets #6348
• 修复桑基图数据为循环数据时报错的问题。

感谢社区贡献者 @kenny-not-dead 对此次版本的贡献：

• 优化左上角定义名称输入框样式。fix: defined name input style #6306
• 新增定义名称管理面板点击定义名称展示对应选区的交互体验。feat: set defined name in formula bar #6304
• 新增左上角输入定义名称快捷跳转功能。feat: formula bar defined name input focus if has defined name #6315
• 优化 doc 中页面设置面板的相关逻辑。feat: add page setup precision #6294

💔 破坏性更新

• IConfirmService 接口定义从 @univerjs/ui 包迁移至 @univerjs/core 包，若有使用请注意更新。refactor: move IConfirmService interface to core package and move merge-related command from sheets-ui to sheets package #6320
• 合并单元格相关命令从 @univerjs/sheets-ui 包迁移至 @univerjs/sheets 包，若有使用请注意更新。refactor: move IConfirmService interface to core package and move merge-related command from sheets-ui to sheets package #6320
• @univerjs/core 包中 COLORS 颜色关键字常量改为忽略大小写，若有使用请注意更新。fix: fix colors keyword case ignorin #6359

🌐 Univer Server

• 修复有设置行样式的部分 Excel 文件导入后样式异常的问题。

📦 Univer Presets

• SDK 已同步更新到 0.14.0 版本。

📢 加入讨论

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

• GitHub Discussions
• 👾 Discord

📝 更新日志

完整的更新日志 (2025-12-20)