🎉 Release v0.11.0

[wpxp123456]

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

• Protected Range Shadow: feat(sheets): add protectedRangeShadowStrategy for protection range #6102
  • Optimize the protectedRangeShadow configuration to support setting the strategy for protected range shadows.
    • true or 'always': Show shadows for all protected ranges (default behavior).
    • 'non-editable': Show shadows only for ranges that are not editable (edit permission is false).
    • 'non-viewable': Show shadows only for ranges that are not viewable (view permission is false).
    • false or 'none': Do not show shadows for protected ranges.
  • Added Facade API:
    • univerAPI.setProtectedRangeShadowStrategy: Set the global strategy for protected range shadows.
    • univerAPI.getProtectedRangeShadowStrategy: Get the global strategy for protected range shadows.
    • univerAPI.getProtectedRangeShadowStrategy$: Get an observable for the protected range shadow strategy.
• Added print layout preview feature, supporting previewing the display/hide of print page break auxiliary dividing lines.

🐛 Bug Fixes and Optimizations

• Fix issues related to the filter function:
  • Added compatibility handling for unsupported filter types. fix(sheet): adjust filter import error #6061
  • Fix the issue where rows hidden by filters were not hidden when importing Excel files. fix(filter): fix the issue when importing Excel files with hidden rows filtered #6076
  • Fix the issue of abnormal date grouping function in filters. fix(filter): fix the filter date group #6081
• Fix the issue where worksheets could not be edited after adding and then removing permissions. fix(sheet): fix the permission mutation works before init #6066
• Fix issues related to formulas:
  • Fix the issue where the DATE formula parameters did not support text type numbers. fix(formula): fix date formula calculation error #6070
  • Fix the issue where the TEXTJOIN formula did not ignore empty strings when the ignoreEmpty parameter was TRUE. fix(formula): fix TEXTJOIN formula calculation when the ignoreEmpty parameter is true #6096
  • Fix the issue of abnormal inverted index cache when there are empty cells in the selected range of some formulas. fix(formula): fix the issue of array inverted index cache #6091
  • Fix the issue where text comparison did not ignore case sensitivity when some formulas had condition parameters. fix(formula): fix not ignoring case sensitive when comparing formula condition values #6097
  • Fix the issue where nested defined names were not correctly resolved in formulas. fix(formula): support recursive resolution for nested defined names #6100
• Fix the issue where the background color was not correctly applied when pasting data with a black background color. fix(paste): fix the black background color not working #6090
• Fix the issue where two warning prompt boxes appeared simultaneously. fix: fix two alert pop-ups appearing simultaneously #6108

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

• Improved updates to the Russian (ru-RU) language pack. feat: add ru lang to comment-ui #6072
• Added a clear button to the input box of the defined name panel. feat: add clear icon on defined name comment; fix: overlaying a value on clear icon #6043
• Fix style issues in the comment management panel under certain language environments. fix(docs): comment title expanded width container #6083

Special thanks to community contributor @KennanChan for contributions in this version:

• Fix the issue where the RectPopup component position calculation was incorrect. fix: wrong popup direction for RectPopup #6071 fix: update the range endRow and endColumn #6085

🌐 Univer Server

• Fix several collaborative editing conflict issues.
• Fix import and export related issues:
  • Fix the issue where the first column width was abnormal after importing some files.
  • Optimize formula import by removing the v value to ensure that formulas are recalculated.
  • Fix the issue where merged cells were lost after importing some files.
  • Fix the issue where border colors were lost when exporting Excel files.
  • Fix the issue where data validation and Table module exports were not escaped in some scenarios.
• Fix history list permission issues.
• Added an interface in USIP to notify the latest modification time of the document.

📦 Univer Presets

• SDK has been updated to version 0.11.0.
• Fix the issue where import/export functions were not working in the UMD bundle.

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

Bug Fixes

• filter chart type of drawing in sheet change intercept (#6084) (b90933f)
• filter: fix the filter date group (#6081) (f2cc73d)
• filter: fix the issue when importing Excel files with hidden rows filtered (#6076) (3efa1fe)
• fix two alert pop-ups appearing simultaneously (#6108) (8d4f326)
• formula: fix date formula calculation error (#6070) (a4a08cd)
• formula: fix not ignoring case sensitive when comparing formula condition values (#6097) (2c78161)
• formula: fix text formula calculation (#6101) (06693ca)
• formula: fix TEXTJOIN formula calculation when the ignoreEmpty parameter is true (#6096) (10b7cbf)
• formula: fix the issue of array inverted index cache (#6091) (dd78623)
• formula: support recursive resolution for nested defined names (#6100) (b5f948f)
• intercept unnecessary mutations (#6104) (8e74b7d)
• remove table not found throw error (#6068) (127f9ef)
• sheet-ui: comment out offsetLeft calculation for center alignment (#6039) (b77acb0)
• sheet: adjust filter import error (#6061) (c5c1d96)
• sheet: fix sheet add permission fail (#6069) (c04e338)
• sheet: fix the permission mutation works before init (#6066) (e0b74f0)
• sheets-print: print-range not include cell by value 0 (#6099) (e810972)
• sheets-ui: fix the pasted black background does not take effect (#6090) (8bda175)
• sheets: 2 errors with the same text (#6056) (1b1dc16)
• sheets: fix sheet interceptor service dispose (#6078) (1f69a49)
• thread-comment-ui: comment title expanded width container (#6083) (2c591c4)
• ui: wrong popup direction for RectPopup (#6071) (5d6c3b5)
• update the range endRow and endColumn (#6085) (815c557)

Features

• design: add clear icon on defined name comment; fix: overlaying a value on clear icon (#6043) (1748f5f)
• design: add closable prop to Confirm (#6073) (36a5142)
• docs-hyper-link-ui: add ru lang to comment-ui (#6072) (6547330)
• engine-formula: export IAstNodeNodeJson interface and update index exports (#6082) (30890ad)
• sheets: add protectedRangeShadowStrategy for protection range (#6102) (df08fc0)

[wpxp123456]

🎊 Univer@v0.11.0

🚧 重要提示

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

🚀 快速开始

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

📊 Univer Sheets

✨ 新功能亮点

• 权限保护范围阴影：feat(sheets): add protectedRangeShadowStrategy for protection range #6102
  • 优化 protectedRangeShadow 配置项，支持配置权限保护范围阴影的策略。
    • true or 'always'：显示所有受保护范围的阴影（默认行为）。
    • 'non-editable'：仅显示无法编辑的范围的阴影（编辑权限为 false）。
    • 'non-viewable'：仅显示无法查看的范围的阴影（查看权限为 false）。
    • false or 'none'：不显示受保护范围的阴影。
  • 添加 Facade API：
    • univerAPI.setProtectedRangeShadowStrategy：设置受保护范围阴影的全局策略。
    • univerAPI.getProtectedRangeShadowStrategy：获取受保护范围阴影的全局策略。
    • univerAPI.getProtectedRangeShadowStrategy$：获取受保护范围阴影策略的可观察对象。
• 新增打印布局预览功能，并支持预览显示/隐藏打印分页辅助分割线。

🐛 改进与优化

• 修复筛选功能相关问题：
  • 添加不支持的筛选类型的兼容性处理。fix(sheet): adjust filter import error #6061
  • 修复导入的 Excel 文件有筛选隐藏行时未隐藏行的问题。fix(filter): fix the issue when importing Excel files with hidden rows filtered #6076
  • 修复筛选的日期分组功能异常的问题。fix(filter): fix the filter date group #6081
• 修复工作表权限添加再移除后无法编辑的问题。fix(sheet): fix the permission mutation works before init #6066
• 修复公式相关问题：
  • 修复 DATE 公式参数未支持文本类型数字的问题。fix(formula): fix date formula calculation error #6070
  • 修复 TEXTJOIN 公式在 ignoreEmpty 参数为 TRUE 时未忽略空字符串的问题。fix(formula): fix TEXTJOIN formula calculation when the ignoreEmpty parameter is true #6096
  • 修复部分公式选区范围有空单元格时倒排索引缓存异常的问题。fix(formula): fix the issue of array inverted index cache #6091
  • 修复部分公式有条件参数时文本比较未忽略大小写的问题。fix(formula): fix not ignoring case sensitive when comparing formula condition values #6097
  • 修复公式中使用嵌套定义名称时未正确解析的问题。fix(formula): support recursive resolution for nested defined names #6100
• 修复粘贴的数据有黑色背景色时背景色未正确应用的问题。fix(paste): fix the black background color not working #6090
• 修复会同时出现两个警告提示框的问题。fix: fix two alert pop-ups appearing simultaneously #6108

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

• 俄语（ru-RU）语言包的完善更新。feat: add ru lang to comment-ui #6072
• 添加定义名称面板输入框清除按钮。feat: add clear icon on defined name comment; fix: overlaying a value on clear icon #6043
• 修复评论管理面板在某些语言环境下的样式问题。fix(docs): comment title expanded width container #6083

感谢社区贡献者 @KennanChan 对此次版本的贡献：

• 修复 RectPopup 组件位置计算错误的问题。fix: wrong popup direction for RectPopup #6071 fix: update the range endRow and endColumn #6085

🌐 Univer Server

• 修复几个协同编辑冲突问题。
• 修复导入导出相关问题：
  • 修复部分文件导入后首列列宽异常的问题。
  • 优化公式导入去除 v 值以保证公式会重新计算。
  • 修复部分文件导入后合并单元格丢失的问题。
  • 修复导出 Excel 边框颜色丢失的问题。
  • 修复部分场景数据验证、Table 模块导出未转义的问题。
• 修复历史记录列表权限问题。
• USIP 添加通知文档最新修改时间接口。

📦 Univer Presets

• SDK 已同步更新到 0.11.0 版本。
• 修复 UMD 捆绑包中导入/导出功能失效的问题。

📢 加入讨论

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

• GitHub Discussions
• 👾 Discord

📝 更新日志

完整的更新日志 (2025-11-08)