dream-num/univer v1.3.0

🎃 Release v1.3.0

on GitHub

👻 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:

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:

 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:

-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:

-import { cssPxToEmu, emuToCssPx, EMU_PER_CSS_PX } from '@univerjs-pro/pdfs';
+import { cssPxToEmu, emuToCssPx, EMU_PER_CSS_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