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.
- 🪄 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.
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 advanced 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 advanced features and support for users with special requirements.
Environment Support
Univer's compilation target is Chrome 70, but this does not mean that Univer can fully support all browsers. We will do our best to ensure that Univer runs smoothly in the following browsers:
(opens in a new tab)IE / Edge | (opens in a new tab)Firefox | (opens in a new tab)Chrome | (opens in a new tab)Safari | (opens in a new tab)Electron |
---|---|---|---|---|
Edge | last 2 versions | last 2 versions | last 2 versions | last 2 versions |
If you encounter compatibility issues, please try to solve them with the corresponding polyfill. If you still cannot solve the problem, please submit an issue (opens in a new tab).
TypeScript
Univer provides a built-in type definition file, so developers can enjoy a better development experience when using Univer.
Join the Community
If you can't wait to experience Univer, please refer to the QuickStart.
Or 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 (opens in a new tab), submitting PRs, participating in discussions, and more. Please read the Contribution Guidelines (opens in a new tab) before getting involved in the development of Univer.
Open Source License
The core code of Univer OSS, available on GitHub (opens in a new tab), is open source under the Apache-2.0 license. Organizations and individuals are free to use its source code and npm package.
This documentation, available on GitHub (opens in a new tab), is open source under the CC-BY-NC-SA 4.0 license. Organizations and individuals are free to use it, but commercial use is not allowed.