Repository navigation
Univer 1.6.0 adds planned schedules and dependencies to Base Gantt, and PDF viewing and editing on mobile. It also reorganizes the PDF and Data ribbons, adds the AMORDEGRC and EUROCONVERT functions, and tightens edit and comment permissions in both the clients and the collaboration server.
New features
Plan comparison and predecessors in Base Gantt (Pro)
A Gantt view can keep a planned schedule beside its current one. Each view stores its own date bindings and color, and both schedules share the timeline and work calendar.
Binding a Completion field to a Progress column shows completed and remaining work on each bar, and adds a completion handle. Predecessors bind to a record link. Dragging from either end of a bar creates a finish-to-start link that supports undo and collaboration, and rejects cycles. Hovering a bar compares planned and current dates, completion, and start and finish variance.
Grid and Gantt share one outline, so collapsing a parent hides its descendants and their dependency arrows. Collaborative Gantt editing uses a new Base OT transform, so deploy a gateway that includes it before rolling out to clients.
PDFs on mobile (Pro)
A dedicated mobile PDF UI adds a thumbnail overview, page organization, and continuous page editing. Navigation and tools live in drawers. Text editing runs through Docs, so live editing and IME input behave as they do on desktop. Pinch zoom applies zoom and layout once on release.
The PDF ribbon is reorganized by editing task into Home, Insert, Annotate, and View. Text, Table, and Image tabs appear when their editing context is active.
@univerjs-pro/pdfs-exchange-client adds one-call entry points for appending files and exporting edits. PdfSetZoomRatioOperation sets zoom on desktop, mobile, and read-only workbenches. Registering the mobile plugin with { editor: { enabled: false } } gives read-only navigation and zoom.
Permissions
Sheets edit permissions now gate freeze panes, gridlines, row and column visibility, outline grouping, merge, sort, rename, protection, and worksheet tab actions. Menus disable without permission, and rejected actions report failure instead of success. Grouping and collapsing count as edits, so view-only users can no longer expand or collapse groups.
Notes and comments require their own permissions, with localized errors. The collaboration server rejects the same operations, and worksheet duplication checks WorkbookCopySheetPermission.
Improvements and fixes
- Formulas Add
AMORDEGRCandEUROCONVERT. EvaluateISO.CEILINGand fix Excel compatibility in text, date, and wildcard matching functions. - Sheets Keep date and time formats when changing decimals, and keep row heights through autofill. Correct sorting, data validation, and conditional formatting behavior.
- Docs Match Word for tab stops, split table borders, and justification. Fix IME and pasted-text formatting.
- Slides and shapes (Pro) Keep inherited placeholder text through concurrent edits. Align shape toolbar formatting, sizes, and menu widths.
- Boards (Pro) Redesign the container picker and restore context menu icons.
- Charts (Pro) Add radar scale labels with
setRadarAxisLabelandresetRadarAxisLabel, and inherit the All-series line type. Correct rendering across frozen panes and in 3D. - UI Unify ribbon spacing and alignment, and move overflowing groups into a More menu. Improve keyboard focus indicators, and group sorting, filtering, and table tools in one Data ribbon column.
Full changelog: v1.5.2…v1.6.0