🎊 Univer@v0.1.5

🚧 Important Note

This project is still in heavy development, and major API changes are expected. Your feedback is crucial! Please submit issues and suggestions to help us shape the future of Univer.

🆕 What's new

In the v0.1.5 update, we've added conditional formatting functionality to the Univer Sheet.

Conditional Formatting

New package avaliable:

# Using npm
npm install @univerjs/sheets-conditional-formatting

# Using pnpm
pnpm add @univerjs/sheets-conditional-formatting

• Conditional Formatting Rules: Apply conditional formatting rules to your cells based on specified criteria. Highlight cells that meet certain conditions, such as values greater than a threshold, dates within a specific range, or cells containing specific text.
• Customizable Styles: Customize the formatting styles applied to cells that meet the specified conditions. Choose from a variety of predefined styles or create your own custom styles using font colors, background colors, borders, and more.
• Intuitive Rule Builder: Use the intuitive rule builder interface to create and manage conditional formatting rules easily. Select the range of cells, define the conditions, and apply the desired formatting styles with just a few clicks.
• Rule Management: Easily manage and organize your conditional formatting rules. Edit, delete, or reorder rules as needed. Toggle individual rules on or off to quickly see the impact on your data.

You can enable this functionality by registering the following two plugins with Univer:

import { SheetsConditionalFormattingPlugin } from '@univerjs/sheets-conditional-formatting';

univer.registerPlugin(SheetsConditionalFormattingPlugin);

🚀 Getting Started

If you're eager to explore Univer, check out our getting started documentation. Dive into the world of collaborative document, spreadsheet, and presentation editing powered by Univer!

📢 Join the Conversation

We welcome your input and insights as we embark on this exciting journey. Connect with us on:

• GitHub Discussions
• Discord

📝 Changelog

Full changelog (2024-03-29)

Bug Fixes

• editor: range selector and range drag (#1713) (02e9647)
• editor: short key error and normal range show (#1688) (571ec0b)
• fixing the range of remove merged selection and filter empty ranges (#1680) (117cbbe)
• formula: index function handles base value object (#1692) (1f0b700)
• punctuation adjustment issues in slide (#1690) (15cb6df)
• render: media change for refresh canvas (#1697) (dd6bfed)
• sheet: active dirty dependency ui (#1728) (d8c9e4b)
• sheet: fix the selection is incorrect when autofill intersects w… (#1661) (ebdcc6c)
• sheet: fix toolbar state when there's overlapping selection (#1521) (1ebfe1a)
• sheet: handle key value conflicts (#1720) (9abc7c5)
• sheet: null-value will not unexpected deleted when moving row/cols (#1691) (1a1f7c8)
• sheet: set-tab-order-mutation should has fromIndex in parmas for transforming (#1704) (6d05bd9)
• slides: export locale (#1702) (403c529)
• ui: canvas popup event bind error (#1683) (8a0bfd6)
• ui: fix toolbar display issues by adjusting reactive hidden item filtering logic (8b604eb)
• ui: fix toolbar responsiveness on small screens (#1716) (a9755e8)
• ui: fix use observable (#1719) (eabe6fb)

Features

• conditional-format: support conditional format (#1681) (50edd34), closes #433 #439 #495 #489 #487 #485 #483 #480 #475 #472 #468 #458 #433 #437 #446 #486 #437 #461 #454 #480