Univer
Univer Doc
Introduction

Introduction

πŸ“ŠπŸ“πŸ“½οΈ Univer General

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 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
  • Cell comments
  • Insert floating images
  • Insert charts

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
  • Data validation
  • Conditional formatting
  • Data sorting
  • Data filtering

Automation

  • Uniscript Scripting (alpha version)

Other Goodies

  • Zen Editor Mode (optional)
  • Print
  • Collaborative editing
  • Live Share
  • Import & Export

πŸ“ Document

Editing Operations

  • Text Styles: bold, italic, underline, strike through, font family, font size, text color
  • Collaborative editing

πŸ“½οΈ 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:

IE / Edge (opens in a new tab)IE / EdgeFirefox (opens in a new tab)FirefoxChrome (opens in a new tab)ChromeSafari (opens in a new tab)SafariElectron (opens in a new tab)Electron
Edgelast 2 versionslast 2 versionslast 2 versionslast 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.


Copyright Β© 2021-2024 DreamNum Co,Ltd. All Rights Reserved.