🕶️ Release v1.5.22026-11-16
Univer v1.5.2 是一个纯维护版本,没有新增功能,主要修复了一批已知问题并做了内部优化。建议升级以获得更稳定的体验。
🕶️ Release v1.5.12026-11-16
Univer v1.5.1 是一个补丁版本,主要修复了 v1.5.0 中的若干问题,提升稳定性与使用体验。具体改动可查看完整变更记录。
🛠️ Release v1.5.02026-11-14
Univer 1.5.0 带来了图表工作表、堆积折线图与误差棒。Pro 免费版也开放了更多编辑与本地导出能力,同时优化了公式计算的内存占用,并改进了 Office 文件兼容性。
图表工作表、堆积折线图与误差棒:图表可独占一个标签页,源数据仍留在普通工作表中,跨表移动图表支持撤销重做。加载 Sheets Chart Facade 后,用 workbook.insertChartSheet(info, { name, index }) 设置标签名与零基位置,getPrimaryChart() 获取主图;zoomToFit 可让图表随视口自适应缩放,旧快照无此设置则保持固定缩放。图表编辑器与 builder、live chart API 现支持二维柱状、条形、折线、散点图的按系列误差棒,用 setErrorBars() 和 clearErrorBars() 控制方向、端帽、样式与误差量,支持固定值、百分比、标准差、标准误及自定义字段的正负值,散点图可分别设置 X、Y 误差棒。
Board 图表可编辑与 LaTeX 包:planLayout() 可排布图形或调整连线路径、端点、标签与文本适配,检查返回的诊断信息后用 applyLayoutPlan() 应用,该操作可撤销,生成的形状与连线仍可编辑;setTreeBranchCollapsed() 支持折叠展开导入的树分支,渲染分析会报告标签溢出等问题。新增 @univerjs-pro/boards-latex-ui 包可在 Board 文本中渲染 LaTeX,在 Boards UI 插件之后注册 UniverBoardsLatexUIPlugin 即可。
Slides 保存前提交文本:加载 @univerjs-pro/slides-ui/facade,在自定义保存动作前调用 presentation.isTextEditing() 或 await presentation.endTextEditingAsync(),返回 true 再保存;返回 false 表示草稿未能提交或输入法组合仍在进行。
Sheets 交互配置:新增 selectionAnimation(单元格间点击时的选区描边动画,尊重系统减弱动效设置)、enableFillHandle(桌面端填充柄显隐,隐藏时填充命令与 Facade API 仍可用)、warnBeforeDragOverwrite(拖拽覆盖已有单元格前确认,关闭提示后移动校验与撤销重做依然生效),可直接设在 UniverSheetsUIPlugin 或 UniverSheetsCorePreset 的 sheets 下。
Board 布局与内嵌 UI:FBoard.planLayout() 新增 graph、routes、ports、labels、text 五种模式,图布局支持 elementIds、fixedElementIds、feedbackConnectorIds 划定范围,以及 direction、layerGap、itemGap、origin、maxNodes 控制排布,默认横向。
🗂️ Release v1.4.02026-11-07
Univer 1.4.0 adds Office attachment workflows, shape merging in Slides, richer pivot filtering, and GETPIVOTDATA. This release also separates product-specific comment integrations and introduces several package and API migrations.
New features
Office attachments across Sheets, Docs, and Slides
Preserve embedded OLE files when working with Office documents, with actions to preview, download, rename, and delete attachments. Supported Office files can also be converted into independent online documents when the application provides the required collaboration, attachment, and exchange services.
Office export keeps the original embedded file by default. Applications can request the current confirmed version of a converted online document instead:
``ts
import { ExchangeFormat } from '@univerjs-pro/exchange-client';
const file = await univerAPI.exportSheetByUnitIdAsync(
unitId,
ExchangeFormat.XLSX,
undefined,
{ oleAttachmentSource: 'online' }
);
`
The server must support this export option. Cross-type Office previews require the corresponding existing product UI module; conversion and preview use the existing drawing and exchange plugins.
Merge shapes in Slides
Combine supported selections with Union, Combine, Fragment, Intersect, and Subtract. The operations create new shape geometry and support undo/redo and collaboration. The first selected object determines the primary formatting and the subtraction direction.
Multiple filters and whole-day date filtering
Pivot tables and pivot charts can combine different filter categories on the same field after enabling Allow multiple filters per field. The option is off by default.
Fixed date filters also support whole-day comparison, so timestamps from the same day can match without requiring identical time values.
`ts
await pivotTable.setOptions({ allowMultipleFilters: true });
await pivotTable.setDateFilter(fieldId, {
operator: univerAPI.Enum.ST_PivotFilterOperatorEnum.dateEqual,
expected: dateSerial,
useWholeDay: true,
});
`
Disabling multiple filters while combined filters are active clears the report's filters and the corresponding shared slicer/timeline selections. The UI asks for confirmation.
GETPIVOTDATA
Use GETPIVOTDATA to retrieve aggregated values from a visible PivotTable report:
`excel
=GETPIVOTDATA("Sales",$A$3,"Region","East")
`
The initial implementation reads the visible report from a single-cell anchor, searching up to 200 rows below and 50 columns to its right.
Paragraph word splitting
Docs now respects paragraph settings that allow Latin words to break across lines. A new control in paragraph settings makes this behavior editable and supports inherited and mixed paragraph states.
Product-specific comment integration packages
Image and chart comment Facade integrations have moved out of the generic shape-thread-comment Facade into four new packages:
| Package | Integration |
| --- | --- |
| @univerjs-pro/sheets-drawing-thread-comment | Images in Sheets |
| @univerjs-pro/sheets-chart-thread-comment | Charts in Sheets |
| @univerjs-pro/docs-drawing-thread-comment | Images in Docs |
| @univerjs-pro/docs-chart-thread-comment | Charts in Docs |
These packages provide the existing createCommentAsync, getComments, and listCommentsAsync methods for their respective objects. Generic FShape comments remain in @univerjs-pro/shape-thread-comment.
Improvements and fixes
- Formulas: Improve array-spill invalidation, shared-formula dependencies, and recalculation after worksheet-reference changes. Writing cell values through setValue/setValues now persists removal of the replaced formula.
- Sheets: Preserve imported XLSX table differential formats and inherited font sizes while editing; improve merged-cell rendering, autofill after scrolling, and sheet renaming.
- UI and mobile: Compact the two-row Ribbon before moving groups into More, improve keyboard navigation, and enforce permissions consistently in mobile controls and dialogs.
- Collaboration: Reconnect after Chrome page freeze/resume, include filter/table models during snapshot formula replay, and authorize comment-only changesets with the Unit Comment permission.
- Rendering and performance: Defer SmartArt reference-data initialization, correct spacing for charts with empty titles, preserve LaTeX formula backgrounds, and improve dark-mode editing panels.
Breaking changes and upgrading
Keep all @univerjs/ and @univerjs-pro/ dependencies used by your application on the same version.
Register the matching image/chart comment integration
Applications using image or chart comment methods must add the corresponding package and its Facade import. For example, in an existing Sheets application:
`ts
import { UniverSheetsDrawingThreadCommentPlugin } from '@univerjs-pro/sheets-drawing-thread-comment';
import '@univerjs-pro/sheets-drawing-thread-comment/facade';
univer.registerPlugin(UniverSheetsDrawingThreadCommentPlugin);
`
Apply the same pattern to the other integrations in the table above. Retain the generic shape-comment integration when using FShape comments.
Move Board ink Facade imports
The @univerjs-pro/ink/facade entry has been removed. Board ink methods now belong to FBoard:
`diff
-import '@univerjs-pro/ink/facade';
+import '@univerjs-pro/boards/facade';
`
Import Board ink enums and IBoardInkFacadeInsertOptions from @univerjs-pro/boards/facade as well.
Update custom Worker entry scripts
Use dedicated /worker entry points for worker-side plugins. For example:
`diff
-import { UniverRPCWorkerThreadPlugin } from '@univerjs/rpc';
-import { UniverSheetsPivotChartWorkerPlugin } from '@univerjs-pro/sheets-pivot-chart';
+import { UniverRPCWorkerThreadPlugin } from '@univerjs/rpc/worker';
+import { UniverSheetsPivotChartWorkerPlugin } from '@univerjs-pro/sheets-pivot-chart/worker';
`
The retained root exports for worker-only APIs are deprecated in 1.4.0, with removal planned for 1.5.0 as described below. Docs workers can now register UniverDocsWorkerPlugin from @univerjs/docs/worker instead of calling startDocsLayoutWorker directly. Worker presets have been updated to use the dedicated entries.
Update custom resource serializers
Redundant version/schemaVersion fields have been removed from affected resource payloads, including document formulas, external references, Slides tables, and Slides fonts. Update custom serializers, validators, and imports of the removed schema-version constants.
For example, a document-formula resource is now:
`diff
-const resource = { schemaVersion: 1, formulas: {} };
+const resource = { formulas: {} };
``
Protection and deployment notes
- Applying worksheet/range protection or setting worksheet permission points clears the affected workbook's undo/redo history. Review workflows that apply protection after editing.
- Deployments using the new OLE, shape-merge, or pivot-filter workflows need corresponding server-side support. Use an OLE-capable drawing model and compatible native exchange runtime at the import/export boundary.
- The new table differential-format import requires matching Sheets, Sheets Numfmt, and native exchange components. Historical snapshots are not rewritten automatically; re-import the original XLSX when possible to adopt the new format handling.
- Update self-hosted collaboration runtimes to receive the snapshot-replay and comment-permission fixes.
Upcoming breaking changes: Worker API cleanup
Removal of the deprecated Worker root exports is planned for 1.5.0, tracked in #8079 and its companion update. These exports are still available in 1.4.0, so custom Worker entry scripts ca
🕶️ Release v1.3.12026-11-02
Full changelog: v1.3.0…v1.3.1
🎃 Release v1.3.02026-10-29
👻 Halloween is around the corner, and Univer 1.3.0 comes with a few treats 🎃 This release adds slicers, timelines, and expanded pivot grouping, alongside improvements to document editing, rendering performance, and everyday interactions.
New features
Slicers and timelines (Pro)
Filter tables and pivot reports with interactive slicers. Timelines provide date-range filtering for pivot tables and pivot charts, with year, quarter, month, and day views.
Three new packages provide the feature:
| Package | Purpose |
| --- | --- |
| @univerjs-pro/slicer | Shared slicer and timeline models, rendering, and themes. |
| @univerjs-pro/sheets-slicer | Worksheet integration, data-source connections, commands, and Facade APIs. |
| @univerjs-pro/sheets-slicer-ui | Interactive controls, insertion menus, settings, and connection dialogs. |
These plugins and the slicer Facade API are included in UniverSheetsAdvancedPreset. For direct plugin integrations, register the Sheets Slicer and Sheets Slicer UI plugins and load the corresponding styles and locales.
Expanded pivot grouping (Pro)
Group selected items manually, organize numbers into ranges, and group dates by calendar units. These capabilities work with connected slicers and timelines for interactive report filtering.
Code block fonts and table alignment (Pro)
Code blocks now support built-in and custom monospaced fonts on desktop and mobile. Fonts registered with FontCategory.MONOSPACE are available in the code block font picker.
Traditional documents also gain left, center, and right table alignment controls in the Ribbon.
Conditional formatting: Stop If True
Use “Stop If True” to prevent lower-priority formatting rules from applying when a rule matches. The rule editor and rule list now expose this setting.
Improvements and fixes
- UI: Move overflowing Ribbon groups into a compact More menu, improve the color picker, and support resetting sheet tab colors.
- Sheets: Preserve text values during formatting, correct number-format colors, and retain table borders after filtering.
- Sheets: Improve mobile editing and row/column resizing, and support Format Painter on row and column headers.
- Docs: Improve block dragging, pasting, and focus handling across embedded editors and multiple instances.
- Bases (Pro): Improve view tabs, hierarchical rows, and selection interactions.
- Performance (Pro): Improve PDF scrolling and zooming, and reduce rendering work for 3D charts.
- Collaboration and export (Pro): Provide clearer license errors, expose server rejection reasons through CollaborationConflict.message, and fix formatting loss in generated collaboration snapshots.
Breaking changes and upgrading
Keep all @univerjs/ and @univerjs-pro/ packages on the same version.
Font categories now use an enum
IFontConfig.category now accepts FontCategory from @univerjs/ui instead of string literals. Update custom font registrations and configuration:
``diff
import type { IFontConfig } from '@univerjs/ui';
+import { FontCategory } from '@univerjs/ui';
const font: IFontConfig = {
value: 'My Mono',
label: 'My Mono',
- category: 'monospace',
+ category: FontCategory.MONOSPACE,
};
`
The enum also provides SANS_SERIF, SERIF, DISPLAY, and HANDWRITING.
Pivot date systems now use Core's DateSystem
Replace PivotDateGroupFieldDateSystemEnum with DateSystem from @univerjs/core:
`diff
-import { PivotDateGroupFieldDateSystemEnum, setDateSystem } from '@univerjs-pro/engine-pivot';
+import { setDateSystem } from '@univerjs-pro/engine-pivot';
+import { DateSystem } from '@univerjs/core';
-setDateSystem(PivotDateGroupFieldDateSystemEnum.Date1900);
+setDateSystem(DateSystem.Date1900);
`
Use DateSystem.Date1904 for configurations using the 1904 date system.
PDF unit helpers now come from Core
These helpers are no longer exported by @univerjs-pro/pdfs. Update their imports:
`diff
-import { cssPxToEmu, emuToCssPx, EMUPERCSS_PX } from '@univerjs-pro/pdfs';
+import { cssPxToEmu, emuToCssPx, EMUPERCSS_PX } from '@univerjs/core';
``
Update collaboration server deployments
Update the collaboration backend to include the new slicer transformations. Redeploy Helper with the updated collaboration-server package to apply the snapshot formatting fix.
Existing snapshots affected by formatting loss are not repaired automatically.
Full changelog: v1.2.0…v1.3.0
🎉 Release v1.2.02026-10-22
New features
- Docs: Support persistent heading collapse and enable outlines by default in modern mode.
- Slides (Pro): Add dedicated picture and chart formatting tabs, with image cropping, sizing, and positioning controls.
- Collaboration (Pro): Add conflict callbacks with access to unsynced edits, pending-write status, and retry events.
Improvements and fixes
- Formulas: Correct behavior in ISBLANK, AVERAGE, UNIQUE, and PROPER, and improve numeric literal parsing.
- Sheets: Fix IME input and formula permission checks during autofill.
- Images: Preserve aspect ratios on insertion and keep drawing anchors stable when hiding rows or columns.
- Docs: Improve outline navigation, table layout, and popup positioning.
- Docs (Pro): Improve collaborative table editing, undo/redo, and embedded content loading.
- Slides (Pro): Improve thumbnail rendering and scrolling performance.
- Charts (Pro): Improve axis and legend layout, label placement, and rendering during resizing.
- Collaboration (Pro): Improve automatic retries, offline edit persistence, and status notifications.
- PDFs (Pro): Fix missing fonts and images in imported documents.
Breaking changes and upgrading
- Collaboration loading (Pro): Automatic URL loading and enableUrlUnitLoader have been removed. Set the current user and load documents through the Facade APIs, or adapt the CustomUrlLoadPlugin example.
- Import/export (Pro): Built-in import/export UI has moved to example plugins. Use the retained APIs or adapt the examples, and remove obsolete UI, locale, and style imports.
- Collaboration events (Pro): Legacy conflict and permission UI events no longer fire; use CollaborationConflict. Replace the legacy submit-timeout UI event with CollaborationChangesetResend.
- Docs collaboration (Pro): Upgrade clients and the collaboration backend together to include the shared transformation fixes for heading collapse and table editing.
Full changelog: v1.1.0…v1.2.0
🎉 Release v1.1.02026-10-17
New features
- Sheets: Add workbook-level iterative calculation with configurable iteration limits and convergence thresholds.
- Sheets: Support configurable line spacing for cell text.
- Charts (Pro): Add 3D column, bar, line, area, and pie charts.
- Charts (Pro): Support logarithmic value axes for 2D charts.
- Docs: Add zoom and fullscreen controls to the toolbar.
- Docs (Pro): Add table border presets to the ribbon.
- PDFs (Pro): Add ribbon controls for editing, annotations, zoom, and fullscreen.
- Collaboration (Pro): Allow hosts to disable automatic URL-based document loading.
Improvements and fixes
- Improve cell editing and worksheet-switch focus, and preserve table column order when saving.
- Fix XLOOKUP error handling, SORT calculations, and named-range updates after worksheet renames.
- Correct relative-date filtering and calendar boundaries.
- Improve drawing positioning and selection, and prevent flicker when switching worksheets.
- Pro: Improve document table resizing, selection performance, and shape-editing undo/redo.
- Pro: Improve imported PDF text dragging, rendering, and editing.
- Pro: Improve collaboration reconnection and offline edit recovery, and isolate offline caches by user.
- Refine Slides menus and shape controls, mobile editing, and accessibility labels.
Breaking changes and upgrading
- Iterative calculation: Replace FFormula.setMaxIteration() and global cycle-reference settings with FWorkbook.setCalculationSettings(). Iterative calculation is disabled by default.
- Node.js presets: @univerjs/preset-docs-node-core and @univerjs/preset-sheets-node-core are no longer included in new releases. Use plugin-based initialization for Node.js integrations.
- Formula imports: Import FormulaReorderController from @univerjs/sheets-formula instead of @univerjs/sheets-formula-ui.
- Custom chart renderers (Pro): EChartRenderModel no longer accepts constructor options, and IEChartRenderModelOptions is removed. Lifecycle handling now uses emitChartEvent() instead of cache-clearing hooks.
- Collaboration (Pro): Sync pending offline edits before upgrading. Set the current user before loading documents. Hosts that manage document loading themselves can set enableUrlUnitLoader: false.
Full changelog: v1.0.4…v1.1.0
🕶️ Release v1.0.42026-10-10
New features
- Sheets: Add image transparency controls.
- Sheets: Move tables together with their cell ranges.
- Sheets: Add smooth cell selection transitions.
- Docs: Support page numbers, page counts, and date/time fields in headers and footers.
- Slides & shapes (Pro): Add Paste Special and post-paste formatting options.
- Pivot charts (Pro): Support worksheet copying and deletion.
- Customization: Expose conditional formatting rule previews and an editor-exit callback.
Improvements and fixes
- Fix cell-editing shortcuts, keyboard navigation, and merged-cell editor alignment.
- Fix editor focus when multiple Univer instances share a page.
- Localize date format presets and fix conflicts between text wrapping and shrink-to-fit.
- Fix border style selection and merged-cell border rendering.
- Preserve whitespace in find-and-replace queries.
- Restore spill formula display and prevent delayed calculation results from overwriting newer edits.
- Preserve drawing positions and sizes after row or column changes, and restore properties for imported images.
- Pro: Fix chart legend pagination, resizing, and event handling after switching worksheets.
- Pro: Keep pivot-chart filter popups open during updates.
- Pro: Fix header/footer layout and embedded-editor interactions.
Upgrade notes
univerAPI.registerComponent() now registers an override by default, regardless of registration order. Pass { override: false } to register a default component. Dispose an existing override before registering another for the same name.
Full changelog: v1.0.3…v1.0.4
🕶️ Release v1.0.32026-09-29
New features
- Pivot tables (Pro): Copy pivot tables together with worksheets.
- Shape hyperlinks (Pro): Show hyperlink popups when hovering over shape text in Sheets, Docs, Slides, and Boards.
- Notifications: Support custom CSS classes per notification.
- Extensions: Expose the destination worksheet name to copy-sheet interceptors.
Improvements and fixes
- Formulas: Improve conditional aggregate performance with array criteria.
- Cell editing: Double-click a cell to select its editable content.
- Sheets: Fix automatic row heights after paste, filter range updates, and formula editor focus and help positioning.
- Docs: Preserve selections in long documents and improve paste controls.
- Emoji picker: Support searching by localized names and keywords.
- Networking: Fix interceptor disposal and completion handling for merged requests.
- Cross-document formulas (Pro): Fix stale results after referenced sheets become available.
- Embedded editors (Pro): Fix missing tools, scrolling behavior, and shape tool activation.
- Boards (Pro): Avoid redundant undo entries for unchanged text styles.
- Docs (Pro): Fix mobile editor dependencies and hide empty table menus.
- Charts (Pro): Fix referenced data-source selection and activation.
- Collaboration (Pro): Respect the offline-caching setting from startup.
Breaking changes and upgrading
Custom Pro chart integrations require updates:
- Chart reference APIs moved from @univerjs-pro/engine-chart to @univerjs-pro/chart-embed. Register UniverChartEmbedPlugin when using referenced charts.
- ChartReferencedDataSourceEditor was removed. Custom editors should use ReferencedDataSelector from @univerjs-pro/embed-unit-ui with host-specific controls.
- ChartResourceRepository is now abstract and requires host-specific data-source decoding.
- Saved chart resources no longer include a version field. Existing supported resources remain readable, but older SDK versions may reject newly saved resources.
Keep interdependent Univer and Univer Pro packages aligned at 1.0.3, including applications that read and write shared chart resources.
Full changelog: v1.0.2…v1.0.3