Introduction to Univer Sheet
Univer Sheet has completed most of the development of basic features, but there are still key features that have not been fully implemented. Please follow our Roadmap to stay updated on our progress.
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 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
Showcases
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 unmerge 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
Viewing
- Freeze column and/or rows
- Summary bar
- Sum, Max, Min, Average, Count
Data and Calculation
- Formulas
- Fx bar (formula editor)
- Formula highlighting
- Built-in formulas
- Formula calculation using Web Workers (optional)
- Number format: general, accounting, currency, date, thousands separator
Automation
- Uniscript Scripting (alpha version)
Other Goodies
- Zen Editor Mode (optional)
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.
What's Next
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, 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.
Univer Pro Sheet
Univer Pro is a plug-and-play solution designed to meet a range of complex business needs. It adopts the interfaces, components, and event mechanisms provided by the open-source version of Univer and carefully encapsulates them.
While Univer Pro is designed to address specific business scenarios, it may not cover all of your business needs. We recommend that you conduct a detailed assessment of your specific business needs before exploring the possibilities of Univer Pro. If necessary, you can also use the powerful features provided by the open-source version of Univer to customize and extend the specific features you need.
Univer Pro currently provides the following features:
- 👨💻 Collaborative editing and browsing
- 🛜 Data connectors
- 🎚️ Live Share for collaborative browsing
- 📤 Import / Export
To learn more about our commercial edition or request a trial, please visit here.