Introduction
Univer provides a comprehensive enterprise-level solution for document and data collaboration, supporting three core document types: spreadsheets, documents, and slides. Through a flexible API and plugin mechanism, developers can customize and extend personalized features on Univer to meet the specific needs of different users in various scenarios.
Highlights
- 🚀 High Performance
Univer uses a rendering engine based on Canvas and a formula engine that supports Web Worker, ensuring high performance on large-scale data rendering and processing.
- 🧩 Plugin-based
The core functionality and capabilities of Univer are provided through plugins, allowing developers to freely combine the required functionality or create custom plugins to extend Univer.
- 🧙 Isomorphic
It can run both on browsers and Node.js (in the future, mobile devices as well), with the same API.
- 🪄 Customizable
Developers can customize the appearance and interaction of Univer by importing custom themes, icons, component libraries, etc.
- 🌍 Internationalization
Supports multiple languages, allowing developers to freely switch languages and customize language packs.
- 📖 Open Source
The core code of Univer OSS is open source under the Apache-2.0 license. Organizations and individuals are free to use its source code and npm package.
- 🌿 Rich Ecosystem
A rich ecosystem, with command-line tools, build tool plugins, example libraries, and more, to help developers get started quickly.
- 💬 Community Support
Provides Discord community and GitHub Discussions to facilitate developer communication and support.
- 📈 Continuous Updates
The Univer team will continue to update and maintain Univer to ensure its rich-feature, stability and reliability.
- 💼 Enterprise Edition
Provides a commercial version for enterprises with specific needs, including but not limited to multi-person collaborative editing and browsing, data connectors, and Live Share for collaborative browsing.
Quick Start
You can start exploring how to access Univer from the document type you are interested in:
Features
🛠 General Capabilities
Editing Operations
- Undo / Redo
- Copy / Paste
Viewing
- High-performance rendering engine based on Canvas, supporting multiple document types
- Scroll and zoom
UI
- Configurable workspace, including title bar, toolbar, sidebar, status bar, context menu, etc.
- Cross-platform shortcut key support
- Shortcut key panel
📊 Spreadsheet
Editing Operations
- Create, delete and re-order worksheets
- Cell styles: bold, italic, underline, strike-through, font family, font size, text color, background color, border style, text alignment, text rotation
- Merged cells: merge and un-merge cells, merge cells in different directions
- Row column operations: insert, delete, and move rows/columns, modify row height and column width
- Copy & paste: paste values only, paste format only, paste formula only, paste column width only, paste border style only
- Clear content: content only, style only, all
- Cell editing: cell editor that support rich-format texts
- Insert and delete cells
- Auto fill
- Format painter
- Cell comments
- Insert floating images
Viewing
- Freeze column and/or rows
- Summary bar
- Sum, Max, Min, Average, Count
- Crosshair Highlight
Data and Calculation
- Formulas
- Fx bar (formula editor)
- Formula highlighting
- Built-in formulas
- Formula calculation using Web Workers (optional)
- Pivot Table
- Number format: general, accounting, currency, date, thousands separator
- Data validation
- Conditional formatting
- Data sorting
- Data filtering
Automation
- Uniscript Scripting (alpha version)
Other Goodies
- Zen Editor Mode (optional)
- Collaborative editing
- Live Share
- Import & Export
📝 Document
Editing Operations
- Text Styles: bold, italic, underline, strike through, font family, font size, text color
- Comments
- Insert floating images
- Collaborative editing
- Tables
Typesetting
- Header and footer
📽️ Slides
- Edit slides
Univer OSS & Business Upgrade Subscription
Univer has open-sourced most of its core functionalities and provides corresponding npm packages. Any organization or individual can use these features for free, which we refer to as Univer OSS (Open Source Software).
Additionally, for some pro features aimed at enterprises and organizations (such as collaborative editing, live sharing, import & export, printing, etc.), we offer corresponding npm packages and backend services. These features are closed-source but are also available for free commercial use.
For enterprises with higher demands, Univer offers business upgrade subscriptions. This service provides more pro features and support for users with special requirements.
Compatibility Statement
Please refer to our Tech Stack & Compatibility Statement for more information.
Join the Community
Join our developer community and discuss with us:
You can also follow us on the following platforms:
How to Contribute
We welcome any form of contribution, including but not limited to submitting issues, submitting PRs, participating in discussions, and more. Please read the Contribution Guidelines before getting involved in the development of Univer.
Open Source License
The code of Univer OSS, available on GitHub, is open source under the Apache-2.0 license. Organizations and individuals are free to use its source code and npm package.