dream-num/univer v0.11.0 on GitHub

🎊 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: #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. #6061
- Fix the issue where rows hidden by filters were not hidden when importing Excel files. #6076
- Fix the issue of abnormal date grouping function in filters. #6081
Fix the issue where worksheets could not be edited after adding and then removing permissions. #6066
Fix issues related to formulas:
- Fix the issue where the DATE formula parameters did not support text type numbers. #6070
- Fix the issue where the TEXTJOIN formula did not ignore empty strings when the ignoreEmpty parameter was TRUE. #6096
- Fix the issue of abnormal inverted index cache when there are empty cells in the selected range of some formulas. #6091
- Fix the issue where text comparison did not ignore case sensitivity when some formulas had condition parameters. #6097
- Fix the issue where nested defined names were not correctly resolved in formulas. #6100
Fix the issue where the background color was not correctly applied when pasting data with a black background color. #6090
Fix the issue where two warning prompt boxes appeared simultaneously. #6108

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

Improved updates to the Russian (ru-RU) language pack. #6072
Added a clear button to the input box of the defined name panel. #6043
Fix style issues in the comment management panel under certain language environments. #6083

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

Fix the issue where the RectPopup component position calculation was incorrect. #6071 #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)

dream-num/univer v0.11.0 🎉 Release v0.11.0 on GitHub