Your feedback is crucial! Please submit issues and suggestions to help us shape the future of Univer.

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!

• UniverSheetsDataValidationUIPlugin added showSearchOnDropdown configuration option to control whether to display a search box in the data validation dropdown list. The default value is true.#6403
• API
  • Fixed an issue where the FWorksheet.setTabColor API was not working when setting the color of inactive worksheet tabs. #6395
  • Added an optional parameter isForceMerge to merge cell-related APIs to control whether to force the merge operation when there are merged cells in the range. #6418
  • Optimized the FRange.setValue API to parse number format when the value is set to CellValue rather than ICellData. #6443
  • Added an optional parameter includeHeaders to the FRange.getScreenshot API in the printing feature to control whether to include row and column headers in the screenshot.

• Fix the issue of floating image delete shortcut not working. #6401
• Fix the issue of abnormal selection when using keyboard arrow keys to select ranges across worksheets in formulas. #6404
• Optimize the paste menu to support copy and paste within Univer in environments that do not support the Clipboard API. #6406
• Fix the issue where cell custom properties would trigger formula calculation. #6408
• Fix the issue where cell height did not restore after setting and then unsetting word wrap. #6410
• Optimize double border rendering in cells. #6414
• Fix the issue of incorrect position calculation after inserting rows and columns for floating images located outside the first screen. #6420
• Fix the issue of abnormal merged cell border copy-paste introduced in version 0.14.0. #6429
• Fix the issue of custom formula errors in conditional formatting introduced in version 0.12.3. #6431
• Optimize the issue of failure to render when there are too many cell images on the first screen. #6432
• Fix the issue of lost styles after cell editing. #6435
• Fix the issue of abnormal cell editing position after worksheet zooming. #6445
• Fix the issue of incorrect fill range after double-clicking the auto-fill handle. #6448
• Fix some issues with row height and column width during copy and paste. #6450
• Fix some scenarios where formulas could not be recalculated after being interrupted. #6454

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

• Fix font selector view value. #6453

• Optimized the performance of collaborative broadcasting.

• SDK has been updated to version 0.15.1.
• UniverSheetsDataValidationPreset added showSearchOnDropdown configuration option to control whether to display a search box in the data validation dropdown list. The default value is true.

We welcome your input and insights as we embark on this exciting journey. Connect with us on:

• GitHub Discussions
• 👾 Discord

Full changelog (2026-01-10)

• api: fix setTabColor API was not working when setting inactive worksheets (#6395) (57c51ee)
• api: optimize FRange.setValue api will parse number format when setting the value is CellValue rather than ICellData (#6443) (a34077f)
• border: optimize double border rendering (#6414) (1626efb)
• debugger: add data attribute to Fab component for debugging (#6424) (8020985)
• drawing: fix drawing position calculation error (#6420) (5e88023)
• editor: fix the issue of incorrect cell styles after editing (#6435) (84dbabb)
• engine-render: auto-height calc error (#6410) (a915ea3)
• engine-render: image render error if too much (#6432) (8e4165d)
• fix font selector view value (#6453) (7fb8ab1)
• fix the issue with custom formulas in conditional formatting introduced in version 0.12.3 (#6431) (239bba0)
• formula: fix cell custom properties would trigger formula calculation (#6408) (34711d9)
• formula: fix compare calculation error (#6444) (eb57767)
• formula: fix where keyboard shortcuts incorrect when selecting formula range across worksheets (#6404) (522cb09)
• formula: fix where the formula calculation could not be recalculated after it was interrupted in certain situations (#6454) (a20f30c)
• handle disposed state in DocResizeRenderController and improve null checks in Editor (#6440) (f294680)
• improve layout in IconGroupList (#6449) (d875547)
• paste: fix copy-paste issue with merged cell borders introduced in version 0.14.0 (#6429) (e6dac10)
• paste: fix some issues with row height and column width during copy and paste (#6450) (c5d22f3)
• paste: optimize the paste menu to support copy and paste within Univer in environments that do not support the Clipboard API (#6406) (b6222ce)
• sheets-drawing-ui: add URL image downloader registration method in IFUniverDrawingMixin (#6441) (505252b)
• sheets-ui: editor position calc error on scale (#6445) (0ffbe35)
• sheets-ui: improve overflow handling and truncate long labels in sheet bar (#6437) (d15bc08)
• sheets: fix the issue of double-clicking automatically filling boundaries (#6448) (21e2e3a)
• shortcut: fix delete drawing shortcut (#6401) (203f7cb)

• add resolveWithBasePath function (#6421) (df2de99)
• api: add the optional isForceMerge parameter to the merge-related APIs (#6418) (883eab6)
• design: add gradient-color-picker (#6411) (4d40f9b)
• design: add RGBA support to ColorPicker (#6412) (d46cd6d)
• optimize the data validation dropdown list by adding a search box (#6403) (42d62a1)
• shape: custom shape popup position (#6451) (0b3c40e)
• sheets-drawing-ui: add API to register custom URL image downloader (#6430) (5bc20d9)
• sheets-drawing: introduce URL image service to centralize URL image (#6434) (fc5ae91)
• ui: add DesktopRibbonService and integrate with Ribbon componenta (#6428) (f67b413)

Your feedback is crucial! Please submit issues and suggestions to help us shape the future of Univer.

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!

• Optimize customFontFamily configuration to allow adding new fonts or overriding existing ones via the override property; see https://docs.univer.ai/guides/sheets/ui/fonts for usage. #6375
• Optimize the freeze menu and add options to freeze the first row/first column. #6388
• API
  • Add getVisibleRangesOfAllViewports API to retrieve visible ranges of all viewports. #6368
  • Fix getVisibleRange API returning incorrect ranges when there are frozen panes. #6368

• Fix where any cell value change would trigger a full recalculation of all formulas. #6364
• Fix where insert/delete row/column permission points were ineffective. #6357
• Fix where errors occurred when using collaboration features in the deno environment. #6370
• Fix where styles would be lost after clearing cell formulas. #6371
• Fix abnormal undo operations after copying and pasting merged cells. #6374
• Fix where adjusting row height after cell wrapping did not trigger updates to floating image positions. #6378
• Fix dark mode style issues in the font family component. #6381
• Optimize behavior when selecting merged cells using keyboard arrows during formula editing. #6377
• Fix where worksheet name tab background color displayed abnormally in dark mode. #6383
• Fix REGEXMATCH formula calculation errors. #6384
• Fix errors when using the importXLSXToSnapshotAsync API in versions after v0.12.4.

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

• Fix where pop-up position was incorrect after clicking the toolbar more button. #6343
• Add support for mouse wheel zooming in floating image previews. #6333
• Optimize the interaction experience of applying fonts by typing when the font size is the same. #6356
• Optimize the style of the comment management panel. #6074
• Add filtering of defined names when typing in the top-left corner input box. #6332
• Fix validation issues when entering invalid selections in the top-left corner input box. #6390

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

• Fix error in the removeStyles API. #6339

• A layered scheduling for collaborative editing has been introduced to route operations of different file sizes to different collaboration service clusters, minimizing the impact of large file editing on normal-sized files.

• SDK has been updated to version 0.15.0.

We welcome your input and insights as we embark on this exciting journey. Connect with us on:

• GitHub Discussions
• 👾 Discord

Full changelog (2025-12-27)

• api: fix getVisibleRange api and add getVisibleRangesOfAllViewports api (#6368) (1c63bc0)
• drawing: export the ui component for shape (#6387) (94afc13)
• fix auto row height not trigger the update of floating image positions (#6378) (e8e4366)
• formula: fix REGEXMATCH formula calculation errors (#6384) (964a522)
• formula: fix styles were lost after the cell formula was cleared (#6371) (5926560)
• formula: fix the issue where all formulas would be recalculated (#6364) (07485a2)
• formula: optimize the behavior when selecting merged cells by keyboard during formula editing (#6377) (1fe5701)
• formula: remove throw new error (#6365) (6655dd2)
• formula: update (#6363) (7be3f62)
• paste: fix undo after copying and pasting merged cells (#6374) (45dc3f7)
• permission: enhance permission checks for insert and remove row/column commands (#6357) (f836fc8)
• pop up wrong position after click on toolbar-more icon (#6343) (d786807)
• popup: range popup position calc log (#6351) (7f18fce)
• remove style in cache map (#6339) (780d801)
• setSelections by top-left input if refString col more 16384 (#6390) (1575b26)
• sheet: export some types for shape (#6362) (bd00bea)
• sheets-ui: update background color for selected state in dark mode (#6383) (62b5786)
• thread-comment-ui panel width (#6074) (ebd94e2)
• ui: fix dark mode styles for font family components (#6381) (4e9e381)
• util: handle null document input and optimize paragraph processing (#6385) (4195d43)

• change img zoom in gallery on wheel Event (#6333) (b997301)
• enhance collaborator management by filtering allowed users with… (#6380) (41164d7)
• filter defined name list if input event (#6332) (cd2bcb2)
• optimize the frozen menu (#6388) (98f93f4)
• set font family via text input (#6356) (c55f25d)
• shape: add option handle in interface (#6369) (603da2d)
• ui: allow overriding custom fonts in configuration (#6375) (c3d75e3)

Your feedback is crucial! Please submit issues and suggestions to help us shape the future of Univer.

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!

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

• Fix where IDialogProps properties mask, maskClosable, and keyboard were not effective. #6311
• Fix where defined names and table names did not check for duplicates. #6312
• Fix where custom formulas in conditional formatting did not update after inserting/deleting rows or columns. #6322 #6328 #6335
• Fix style errors when pasting copied cells with conditional formatting, data validation, number formats, etc. #6326
• Fix where duplicate checks for defined names, table names, and worksheet names did not ignore case sensitivity. #6330
• Fix where data stored in InsertSheetMutation could be modified by subsequent operations in collaborative environments. #6338
• Fix where some APIs like setGridLinesColor were ineffective when called on non-active 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. #6306
• Add interaction experience to show corresponding selection when clicking defined names in the defined name management panel. #6304
• Add quick jump feature by entering defined names in the top-left corner. #6315
• Optimize related logic of page setup panel in docs. #6294

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

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

• SDK has been updated to version 0.14.0.

We welcome your input and insights as we embark on this exciting journey. Connect with us on:

• GitHub Discussions
• 👾 Discord

Full changelog (2025-12-20)

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

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

Your feedback is crucial! Please submit issues and suggestions to help us shape the future of Univer.

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!

• Right-click menu now includes a "Copy Formula Only" menu item, allowing you to copy only the formula string from a cell. #6287

• Fix the issue where copied data would convert number formats in some error cases. #6257
• Optimize the data range expansion logic when creating filter selections for single cells or single rows. #6264
• Fix the issue where the get data validation status API returned incorrect results when retrieving merged cells. #6266
• Fix the maximum width of the data validation drop-down menu to be the cell width. #6268
• Fix the issue where holding the Ctrl key while selecting cells during formula editing did not correctly insert references. #6272
• Optimize the behavior when selecting merged cells during formula editing. #6270
• Optimize the behavior when pressing Tab/Enter keys while editing cells in the last row/column of the worksheet. #6278
• Fix the "Cut" menu item in the right-click menu. #6280
• Refactor the implementation logic of AuthzIoLocalService to allow controlling the edit/view functionality of protected areas by modifying permission points after adding protection ranges. #6293

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

• Fix the issue where increasing/decreasing font size did not apply correctly in rich text. #6274
• Added a quick jump feature by pressing the Enter key after inputting a selection in the top-left corner. #6138
• Fix the issue where the examples/sheets-uniscript example failed to load. #6288

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

• Fix the abnormal behavior of the comment feature when editing is disabled in the workbook. #6251

• Optimize large file collaborative editing performance to enhance user experience.
• Fix collaborative conflict issues related to renaming sheets.

• SDK has been updated to version 0.13.0.

We welcome your input and insights as we embark on this exciting journey. Connect with us on:

• GitHub Discussions
• 👾 Discord

Full changelog (2025-12-13)

• authz: refactor permission data structure and update logic for permissions (#6293) 37a6b83, closes #6293
• clipboard: fix pasted data with number format error case (#6257) 300e60b, closes #6257
• dataValidation: fix get validator status api in merge cell (#6266) 710faf9, closes #6266
• ensure sheet order unique (#6295) 59f32ce, closes #6295
• filter: optimize the data range expand logic when creating filters (#6264) 8ffeac5, closes #6264
• fix comment editor behavior (#6251) 098dbf6, closes #6251
• fix copy default (#6290) b6f3f97, closes #6290
• fix drop down list max width (#6268) fc254b9, closes #6268
• fix the cut menu item in the context menu (#6280) 40d5d24, closes #6280
• formula: api to promise (#6279) fcabac9, closes #6279
• formula: optimize the behavior when selecting merged cells during formula editing (#6270) fa5bb4a, closes #6270
• increase/decrease font size with cell.P (#6274) 4cd65e6, closes #6274
• instance: ensure proper disposal of current unit (#6254) c407cdf, closes #6254
• optimize the behavior of editing cells in the last row/column of the worksheet (#6278) b446ecd, closes #6278
• revive sheet uniscript (#6288) c82698e, closes #6288
• selection: support ctrl key for adding selections without altering order (#6272) cfdd740, closes #6272
• sheet: fix code error, the style always is a object (#6289) 979d638, closes #6289
• sheet: fix row、col style not effect when the cell is null (#6286) 44c935f, closes #6286
• workbook: sheet removal process (#6284) 9583542, closes #6284

• add a Copy Formula Only menu item to the right-click menu (#6287) e9fc086, closes #6287
• export PLUGIN_CONFIG_KEY_MAIN_THREAD from rpc package (#6283) c3f59cf, closes #6283
• export PLUGIN_CONFIG_KEY_WORKER_THREAD from rpc package (#6281) 1e4954d, closes #6281
• formula: add formula dependency api 2 (#6277) 128f2ff, closes #6277
• formula: dependency tree and calculation api (#6258) e67908f, closes #6258
• set active selections by defined name input (#6138) 972097c, closes #6138

Your feedback is crucial! Please submit issues and suggestions to help us shape the future of Univer.

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!

• Added fonts: #6237
  • UniverUIPlugin introduced a new configuration option customFontFamily to add fonts to the font list.
  • Added univerAPI.addFonts API to dynamically add fonts to the font list.
• Save cell images:
  • A new "Save Cell Images" menu item has been added to the right-click menu to save cell images within a range to the local device. #6250
  • Added FWorksheet.saveCellImagesAsync and FRange.saveCellImagesAsync APIs to save cell images to the local device. #6252

• Optimized performance issues with data validation. #6219
• Optimized mutation size issues when splitting and copying large data worksheets. #6214
• Fixed the issue where the corresponding menu input box was not disabled after adding permission control. #6242
• Fixed some translation errors in the Traditional Chinese (zh-TW) language pack. #6244
• Fixed the issue where cell images generated by the IMAGE formula could not apply alignment. #6249
• Charts:
  • Fixed the issue of abnormal display in chart history.
  • Fixed issues with copying and pasting charts.
  • Fixed the issue where charts were not copied/deleted when copying/deleting worksheets.
  • Fixed the issue where the FChart.addRange API threw an exception when setting the data source to a range outside the current worksheet.
• Fixed the issue where sparklines were not copied/deleted when copying/deleting worksheets.
• Optimized the time display in the version list of the history to the second level.

• Added export support for the sheets-note feature.

• SDK has been updated to version 0.12.4.
• UniverSheetsCorePreset introduced a new configuration option customFontFamily to add fonts to the font list.

We welcome your input and insights as we embark on this exciting journey. Connect with us on:

• GitHub Discussions
• 👾 Discord

Full changelog (2025-12-06)

• drawing: ensure unique id for float dom element at runtime (#6235) 3c5d384, closes #6235
• formula: fix the issue where images generated by the IMAGE formula could not be aligned (#6249) 53b6c13, closes #6249
• i18n: update zh-TW for clarity and consistency (#6244) f595b78, closes #6244
• sheets-ui: popup not update corretly on selection changes (#6236) 2feee7e, closes #6236

• data-validation: add 'set' property to IListCacheItem for improved caching (#6229) a4c88b8, closes #6229
• sheets-data-validation: add DataValidationListCacheService for caching list validation results (#6219) 2bc2929, closes #6219
• sheets-drawing-ui: add batch save images functionality with customizable file naming options (#6252) 2fce949, closes #6252
• sheets-drawing-ui: implement batch save images functionality (#6250) 1731680, closes #6250
• sheets-ui: add disabled state support via observable for MenuItemInput (#6242) 58be4bd, closes #6242
• sheets: split insert sheet command on large data (#6214) 09cc69a, closes #6214
• ui: add font management service & support appending custom font family (#6237) 7c1c2c9, closes #6237

Your feedback is crucial! Please submit issues and suggestions to help us shape the future of Univer.

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!

• Added some point enumeration values to the permission API. #6199
• Added auto-fill API: FRange.autoFill. #6204

• Fix the issue where incorrect number formats would cause the entire sheet to crash. #6201
• Optimize formula and selection performance issues. #6197
• Fix the issue of cut and delete float image. #6215
• Fix the issue of copy and paste chart.

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

• Using adaptive damping and fast-path to stabilize the calculation of the RATE function. #6055

• SDK has been updated to version 0.12.3.

We welcome your input and insights as we embark on this exciting journey. Connect with us on:

• GitHub Discussions
• 👾 Discord

Full changelog (2025-11-29)

• API: fix premission api example (#6199) 8da3fe9, closes #6199
• drawing: fix the issue of cut and delete float image (#6215) cc3be15, closes #6215
• engine-formula: stabilize RATE function with fast-path and adaptive damping (#6055) 8fbbb2d, closes #6055
• fix auto-fill api opreate in non-active sheet (#6205) 9259343, closes #6205
• handle empty sections in parseDataStreamToTree by ensuring an … (#6188) 0cbc370, closes #6188
• permission: update default permission values to false (#6206) 93ce16e, closes #6206
• selection: clean up empty cell styles in copyRangeStyles function (#6184) 16fa81a, closes #6184
• sheet: ensure numfmt crash not effect all (#6201) 57c1d68, closes #6201
• sheets: permission api (#6202) c4d7fe7, closes #6202

• add dispose for close univer worker (#6216) b8d3a2c, closes #6216
• facade: add auto-fill api (#6204) 6127c4b, closes #6204
• sheets: split large set-range-values mutation (#6191) e161f5e, closes #6191
• update Japanese localization for various packages (#6207) 1551b81, closes #6207

• selection: formula and selection (#6197) 344f773, closes #6197

Your feedback is crucial! Please submit issues and suggestions to help us shape the future of Univer.

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!

• Formulas:
  • Added support for the AGGREGATE formula. #6177
  • Added support for the IMAGE formula. #6189

• Fix formula-related issues:
  • Fix the issue where defined names belonging to a specific worksheet were not correctly recognized during parsing. #6174
  • Fix the issue where arrays of different dimensions were not correctly calculated during formula computation. #6174
  • Fix the issue where the SORT formula did not compute correctly when the sortIndex parameter was empty. #6179
• Fix the issue where the FWorksheet.getDataRange API did not return the correct starting row and column indices of the data range.
• Fix the issue where selecting an invalid range for pivot tables caused a white screen.

• Added support for importing note features.
• Optimized the size of collaborative editing mutation data to improve transmission efficiency.

• SDK has been updated to version 0.12.2.

We welcome your input and insights as we embark on this exciting journey. Connect with us on:

• GitHub Discussions
• 👾 Discord

Full changelog (2025-11-22)

• formula: defined name nest and lexer (#6174) (b54d9cb)
• formula: sort function error (#6179) (2cafca1)
• formula: update node (#6165) (aa959d4)
• fix objectMatrix getRealRange function (#6193) (711c9ae)

• formula: add support for AGGREGATE formula (#6177) (d0e1838)
• formula: add support for IMAGE formula (#6189) (b788105)
• ui: improve accessibility attributes (#6190) (733b238)

Your feedback is crucial! Please submit issues and suggestions to help us shape the future of Univer.

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!

• 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

• 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

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

• SDK has been updated to version 0.12.0.

We welcome your input and insights as we embark on this exciting journey. Connect with us on:

• GitHub Discussions
• 👾 Discord

Full changelog (2025-11-15)

• 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)

• 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)

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

Your feedback is crucial! Please submit issues and suggestions to help us shape the future of Univer.

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!

• 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.

• 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

• 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.

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

We welcome your input and insights as we embark on this exciting journey. Connect with us on:

• GitHub Discussions
• 👾 Discord

Full changelog (2025-11-08)

• 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)

• 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)

Your feedback is crucial! Please submit issues and suggestions to help us shape the future of Univer.

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!

• Fix the error of filtering multiple conditions. #6059

• Fix the issue of document error caused by serialization when the mutations passed to the server after transform are an empty array during multi-user collaborative editing conflicts.

• SDK has been updated to version 0.10.14.

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

• Fix the white screen error when clicking the edit button on the slide text node. #6053

We welcome your input and insights as we embark on this exciting journey. Connect with us on:

• GitHub Discussions
• 👾 Discord

Full changelog (2025-10-29)

• filter: fix the error of filtering multiple conditions (#6059) (e95e64e)
• permission: remove throw error (#6049) (5e0a9db)
• slides: params in getRenderUnitByPageId (#6053) (38b7063)