Showcase
Explore Univer's powerful features through online examples
Minimal Example (Plugin Mode)
A minimal setup example for Univer Sheets, demonstrating the minimum configuration required to use Univer Sheets.
Minimal Example (Preset Mode)
A minimal setup example for Univer Sheets, demonstrating the minimum configuration required to use Univer Sheets.
Basic Example (Plugin Mode)
A basic example of Univer Sheets in plugin mode, demonstrating how to use the core features of Univer Sheets.
Basic Example (Preset Mode)
A basic example of Univer Sheets in preset mode, demonstrating how to use the core features of Univer Sheets.
Lit Example
A minimal configuration example of Univer Sheets using Lit.
Running Headless Univer Sheets in Node.js
This example demonstrates how to run Univer Sheets in a Node.js environment using a plugin. It showcases the minimal setup required to create and manipulate a workbook without a UI.
Stress Test
Univer Sheets supports rendering large datasets efficiently. This example demonstrates how to handle big data rendering in a spreadsheet, ensuring smooth performance even with extensive data.
Custom CSV Import Plugin
This example demonstrates how to create a custom plugin for Univer Sheets that allows users to import CSV files into a spreadsheet. The plugin provides a button that, when clicked, prompts the user to select a CSV file, reads its content, and populates the spreadsheet with the data from the CSV file.
Custom Canvas Rendering
Univer provides an extension mechanism that allows you to customize the rendering of content in a spreadsheet. This mechanism can be used to implement custom row headers, column headers, and middle content area rendering.
Custom Header
Univer allows you to customize the text and style of row and column headers using the `customizeColumnHeader` and `customizeRowHeader` APIs.
Custom Menu
Custom plugins are a way to create custom menus, including toolbars and context menu. By customizing the menu, you can add your own functional buttons to enhance user interaction.
Custom Formula
An example of using custom formulas in Univer Sheets. This example demonstrates how to create and use custom formulas to extend the functionality of spreadsheets.
Custom Shortcuts
This example demonstrates how to create and use custom shortcuts in Univer Sheets. It shows how to define shortcuts for common actions, enhancing user productivity.
Custom Event
Univer supports registering custom events using the `univerAPI.registerEventHandler` and `univerAPI.fireEvent` methods. This example registers a main canvas right-click event, a before-remove-column event, and an after-remove-column event.
Hide Permission Background Shadow
This example demonstrates how to hide the permission background shadow in Univer Sheets.
Images
The image feature allows users to insert and manage images in spreadsheets to better present data and information. It supports various image formats and operations, helping users create richer documents.
Hyper Link
The Hyper Link feature allows users to insert and manage hyperlinks in spreadsheets, enhancing data interactivity and navigation.
Find and Replace
The Find and Replace feature allows users to quickly locate and modify data within their spreadsheets, improving efficiency and accuracy.
Annotations
Annotations functionality allows users to add comments in spreadsheet cells to record additional information or provide context. It supports various comment styles and operations, helping users better understand and collaborate on data.
Crosshair Highlighting
An example of crosshair highlighting in Univer Sheets, demonstrating how to highlight cells based on the current selection.
Watermark
This example demonstrates how to add a watermark to Univer Sheets. The watermark can be customized with different text and styles.
Charts
This example demonstrates how to create and manipulate charts in Univer Sheets
Shapes
This example demonstrates how to create and manipulate shapes in Univer Sheets
This example demonstrates how to create and manipulate print settings in Univer Sheets
Migrate From Luckysheet to Univer
Compared with Luckysheet, our newly designed Univer has made great improvements in terms of architecture, data structure and API, so Luckysheet can no longer be migrated 1:1 to Univer. However, we provide a migration example to help you understand how to migrate Luckysheet features to Univer.
Cross Workbook Formula Calculation
This example demonstrates how to use Univer Sheets to calculate formulas across different workbooks, showcasing the flexibility and power of Univer Sheets in handling complex data operations.
Read Only Demo
This example demonstrates how to set the workbook to read-only mode, hiding the toolbar, formula bar, footer, and disabling the context menu and selection features.
Mobile Example (Plugin Mode)
A mobile-adapted example of Univer Sheets in plugin mode, using the Mobile UI Plugin to provide a touch-friendly experience.
Minimal Example (Plugin Mode)
A minimal setup example for Univer Docs, demonstrating the minimum configuration required to use Univer Docs.
Minimal Example (Plugin Mode)
A minimal setup example for Univer Docs, demonstrating the minimum configuration required to use Univer Docs.
Lit Example
A minimal configuration example of Univer Docs using Lit.
Running Headless Univer Docs in Node.js
This example demonstrates how to run Univer Docs in a Node.js environment using a plugin. It showcases the minimal setup required to create and manipulate a document without a UI.
Stress Test
Univer Docs supports rendering large datasets efficiently. This example demonstrates how to render large data in Univer Docs using preset mode.
Watermark
This example demonstrates how to add a watermark to Univer Docs. The watermark can be customized with different text and styles.
Minimal Example (Plugin Mode)
A minimal setup example for Univer Slides, demonstrating the minimum configuration required to use Univer Slides.