🎉 Release v0.15.5
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 the validity check for inserting row/column ranges to prevent inserting invalid ranges through the API. #6553
- Fix issues related to missing borders in merged cells. #6557 #6558
- Fix undo/redo issues with the sheets-note feature. #6562
- Optimize the data validation dropdown list "Options - From a range" to allow cross-worksheet data referencing. #6572
- Fix an issue where the
SheetValueChangedevent would throw an error in certain scenarios. #6575 - Fix time zone issues in date-related formulas. #6578
- Fix an issue where certain values could be calculated by formulas, such as
1,5. #6579 - Fix an issue where creating a pivot table would throw an error due to the selected range not having a sheet name.
Special thanks to community contributor @kenny-not-dead for contributions in this version:
- Fix the issue where the error prompt dialog would automatically close when renaming a worksheet. #6577
- Refactor the data structure of
SheetsNoteModeand adapt old data to address the issue of comment loss caused by data anomalies in the comment feature when deleting/inserting rows and columns. #6561 - Move the auto-fill feature from the
@univerjs/sheets-uipackage to the@univerjs/sheetspackage. Please note the update if you have related types or method imports. #6566
- SDK has been updated to version 0.15.5.
We welcome your input and insights as we embark on this exciting journey. Connect with us on:
Full changelog (2026-02-11)
- add row/column manager insert method and optimze insertMatrixArray (#6555) (be00938)
- add validity range protection to the insert row/column command (#6553) (5844930)
- condition: history error (#6565) (b24892b)
- drawing: add axisAlignSheetTransform for sheet drawing (#6574) (8b0c70e)
- fix an issue where border styles were lost when unmerging cells and then undo (#6558) (ca913c9)
- fix auto-fill date rule (#6570) (5c13384)
- fix the issue of border styles being lost after cell merging (#6557) (797f587)
- fix worksheet max row and column count (#6575) (7c87f0d)
- formula: fix calculation errors in formulas, such as 1,5 (#6579) (a1048fb)
- formula: fix time zone issues in date-related formulas (#6578) (0cc433e)
- formula: when empty with value is "" (#6569) (7e59f3e)
- group: add sheet transfrom for drawing cmd (#6549) (cc70157)
- note: fix sheets-note undo/redo (#6562) (ff8a186)
- optimize data validation dropdown list allows cross-worksheet data referencing (#6572) (47a330a)
- rename tab auto close dialog err (#6577) (1f1bbe2)
🎉 Release v0.15.4
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!
- Add Slovak (sk-SK) language pack. #6544
- Fix an issue where formulas referencing a changed array formula range would result in abnormal updates. #6527
- Optimize the header selection and resize experience on mobile devices. #6529
- Optimize the statistics bar is also updated when setting the selection range via API. #6533
- Fix extra spaces after pasting text copied from Excel. #6538
- Fix column-like selections being parsed as formula names during formula parsing, e.g.,
N:N. #6540 #6542 - Fix incorrect positioning of floating images after changing row height and then inserting rows. #6541
- Optimize the sidebar to hide function types with zero formulas. #6545
- Fix an issue where using Univer in React Portals components (modals, dialogs, etc.) would cause the page to crash. #6546
- Fix an issue where using Backspace to delete cell content would incorrectly identify duplicate values in conditional formatting - duplicate values rule. #6547
- API fixes:
- Fix an issue where
univerAPI.disposeUnitwould clear all event listeners. #6508 - Fix an issue where, after calling
univerAPI.disposeUnitand recreating the workbook, floating images would lack action buttons when focused, and toolbar menus would be unusable after the floating image lost focus. #6543 - Fix an issue where the triggering timing of
FFormula.calculationResultAppliedandFFormula.onCalculationResultAppliedwas incorrect. #6522
- Fix an issue where
Special thanks to community contributor @kenny-not-dead for contributions in this version:
- Fix the issue where the toolbar "more" icon would disappear when changing screen size in some scenarios. #6535
- Optimize the sidebar content area to use the default cursor type. #6518
- Fix styling issues when importing Excel files with some columns having default styles.
- Add experimental USIP APIKEY feature, details at: https://docs.univer.ai/guides/pro/usip#usip-configuration.
- SDK has been updated to version 0.15.4.
We welcome your input and insights as we embark on this exciting journey. Connect with us on:
Full changelog (2026-01-31)
- api: fix api FFormula.calculationResultApplied and FFormula.onCalculationResultApplied (#6522) (39c9244)
- cf: fix the issue of duplicate values in conditional formatting (#6547) (8308b35)
- disposeUnit: fix the issue of drawing disposeUnit (#6543) (bd159b0)
- docs-ui: improve focus-trap handling by ensuring container stays within the modal subtree (#6546) (be2d617)
- fix an issue where disposeUnit would clear all event listeners (#6508) (e0b514c)
- fix where floating images were not positioned correctly after inserting rows in some scenarios (#6541) (88cb6fc)
- fix where formulas reference a changed array formula range would result in abnormal updates (#6527) (9817568)
- formula: column like functions error (#6540) (583c195)
- formula: update column like list (#6542) (6802917)
- icon more will disappear when change screen in some cases (#6535) (b9a3b82)
- image: image switched double (#6536) (6e62e29)
- image: load multiple (#6537) (ab669e4)
- mobile: header selection and resize (#6529) (71f21cd)
- optimize the API so that the statistics bar is also updated when setting the selection range (#6533) (4b3baeb)
- paste: fix extra spaces after pasting text copied from Excel (#6538) (2453581)
- shape: the editor should not get focus when shap editor is focus (#6516) (9f9855c)
- sheets-formula-ui: hide empty function list of SelectFunction (#6545) (9a96853)
🎉 Release v0.15.3
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 "Text to Number" function menu, which supports converting numeric text in selected cells to numbers. The menu is located in "Top Toolbar > Data > Text to Number" and in the right-click menu. #6514
- API:
- Added
FWorksheet.deleteRowsByPoints(rowPoints: Array<number | [number, number]>)API, which supports deleting multiple non-contiguous rows at once. #6493 - Added
FWorksheet.deleteColumnsByPoints(columnPoints: Array<number | [number, number]>)API, which supports deleting multiple non-contiguous columns at once. #6493
- Added
- Optimize performance issues when performing high-frequency row and column deletion operations via API. #6493
- Fix the issue where content being edited in a cell would be reset in certain scenarios. #6495
- Fix a stack overflow issue when deleting a large number of rows. #6497
- Fix the incorrect position of floating images. #6498
- Fix performance issues when the worksheet has a large number of merged cells. #6504
- Fix the issue of incorrect background color rendering after cell rotation. #6513
- Fix the issue where only one chart would follow the zoom when zooming the worksheet with multiple charts.
Special thanks to community contributor @kenny-not-dead for contributions in this version:
- Using ComponentManager in the Slider component to obtain registered icons, supporting customizable icon replacement. #6468
- Fix the cursor type issue in the number format dropdown list. #6511
- Added support for redis TLS connections. Usage can be found at: https://docs.univer.ai/guides/pro/deploy#redis-1.
- SDK has been updated to version 0.15.3.
- Fix the issue where the date-time control in data validation could not change the time in Preset installation mode. #6494
We welcome your input and insights as we embark on this exciting journey. Connect with us on:
Full changelog (2026-01-24)
- design: fix time parsing logic for TimeInput (#6494) (044add7)
- drawing: fix the incorrect position of floating images (#6498) (af68ca8)
- editor: config (#6510) (9263cad)
- editor: fix the issue where content being edited in a cell would be reset (#6495) (dc5cf3c)
- fix debugger plugin (#6506) (1444b46)
- fix the issue of incorrect background color after cell rotation (#6513) (5944c7b)
- optimize the performance of frequent row and column deletion operations (#6493) (00fe317)
- sheets: fix a stack overflow issue when deleting a large number of rows (#6497) (27d08f5)
- sheets: fix performance issues when the worksheet has a large number of merged cells (#6504) (075a46c)
- add a text-to-number function menu (#6514) (fe296bc)
- drawing: add interceptor for drawing update (#6490) (1d52ebb)
- more numfmt type cursor to default (#6511) (ea81ae8)
- sheets-ui: introduce
disableEditconfiguration (#6489) (aa95e93) - sheets-ui: support shape text editing (#6479) (ff5fef2)
- use component manager in slider component (#6468) (3735670)
🎉 Release v0.15.2
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 issue where renaming a worksheet name without changes would still trigger related events. #6459
- Fix some error issues with
disposeUnit. #6460 #6476 - Optimize the interaction experience of scrolling, zooming, and selection on mobile devices. #6483
- Fix the error that occurs when registering
UniverLicensePluginin a Node environment. - Fix the issue where the more operation button of fields in pivot tables is unresponsive under React 18.3.1.
Special thanks to community contributor @kenny-not-dead for contributions in this version:
- Optimize the formula list panel so that user-defined categories do not display when no custom formulas are registered. #6475
- Optimize the formula list panel to disable the confirm button when no results are found during a search. #6477
- Optimize the formula introduction popup to collapse formula details by default when editing formulas. #6485
- Fix the issue where only 10 collaborative documents can be opened on the same ws.
- Support configuring cross-origin headers.
- SDK has been updated to version 0.15.2.
We welcome your input and insights as we embark on this exciting journey. Connect with us on:
Full changelog (2026-01-17)
- add univer-wrap-anywhere class (#6482) (55a7edc)
- copy: fix copy id (#6469) (bf75a44)
- disposeUnit: fix some issues with disposeUnit (#6460) (427aeed)
- disposeUnit: fix the component reported an error after disposeUnit (#6476) (f4d7d03)
- formula: fix where the formula calculation could not be recalculated after it was interrupted in certain situations (#6465) (03342cf)
- mobile: scroll zoom and selection (#6483) (6cf25a2)
- paste: optimize copy and paste mutations (#6472) (b463fef)
- sheets-ui: enhance paste handling and cleanup event listeners for SheetBar (#6486) (938a347)
- sheets: fix the worksheet rename event will triggered even if the name unchanged (#6459) (ca8866e)
- ui: remove unused renderedTimeout and simplify lifecycle stage handling (#6463) (9f8d8ee)
🎉 Release v0.15.1
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!
UniverSheetsDataValidationUIPluginaddedshowSearchOnDropdownconfiguration option to control whether to display a search box in the data validation dropdown list. The default value istrue.#6403- API
- Fixed an issue where the
FWorksheet.setTabColorAPI was not working when setting the color of inactive worksheet tabs. #6395 - Added an optional parameter
isForceMergeto merge cell-related APIs to control whether to force the merge operation when there are merged cells in the range. #6418 - Optimized the
FRange.setValueAPI to parse number format when the value is set toCellValuerather thanICellData. #6443 - Added an optional parameter
includeHeadersto theFRange.getScreenshotAPI in the printing feature to control whether to include row and column headers in the screenshot.
- Fixed an issue where the
- 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.
UniverSheetsDataValidationPresetaddedshowSearchOnDropdownconfiguration option to control whether to display a search box in the data validation dropdown list. The default value istrue.
We welcome your input and insights as we embark on this exciting journey. Connect with us on:
Full changelog (2026-01-10)
- api: fix setTabColor API was not working when setting inactive worksheets (#6395) (57c51ee)
- api: optimize
FRange.setValueapi will parse number format when setting the value isCellValuerather thanICellData(#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)
🎉 Release v0.15.0
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
customFontFamilyconfiguration to allow adding new fonts or overriding existing ones via theoverrideproperty; 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
getVisibleRangesOfAllViewportsAPI to retrieve visible ranges of all viewports. #6368 - Fix
getVisibleRangeAPI returning incorrect ranges when there are frozen panes. #6368
- Add
- 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
REGEXMATCHformula calculation errors. #6384 - Fix errors when using the
importXLSXToSnapshotAsyncAPI 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
removeStylesAPI. #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:
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)
🎉 Release v0.14.0
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
IDialogPropspropertiesmask,maskClosable, andkeyboardwere 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
InsertSheetMutationcould be modified by subsequent operations in collaborative environments. #6338 - Fix where some APIs like
setGridLinesColorwere 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
IConfirmServiceinterface definition from the@univerjs/uipackage to the@univerjs/corepackage; please update if you are using it. #6320 - Move merge cell related commands from the
@univerjs/sheets-uipackage to the@univerjs/sheetspackage; please update if you are using them. #6320 - Change the
COLORScolor keyword constants in the@univerjs/corepackage 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:
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
🎉 Release v0.13.0
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
AuthzIoLocalServiceto 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:
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 Onlymenu 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
🎉 Release v0.12.4
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
UniverUIPluginintroduced a new configuration optioncustomFontFamilyto add fonts to the font list.- Added
univerAPI.addFontsAPI 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.saveCellImagesAsyncandFRange.saveCellImagesAsyncAPIs 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.addRangeAPI 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.
UniverSheetsCorePresetintroduced a new configuration optioncustomFontFamilyto add fonts to the font list.
We welcome your input and insights as we embark on this exciting journey. Connect with us on:
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
🎉 Release v0.12.3
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
RATEfunction. #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:
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
parseDataStreamToTreeby 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