🎊 Univer@v0.1.6

致 Univer 的开发者们：

值此清明节来临之际，我们向您致以节日的问候和美好的祝愿。让我们一起感恩当下，珍惜眼前人。

同时，我们很高兴地宣布，Univer 发布了 0.1.6 版本。本次更新正式带来了条件格式和数据验证两项重大功能。

我们希望 Univer 能成为您生活中一个有用的工具，为您提供帮助和支持。也希望您能将 Univer 分享给更多的朋友，让更多的人受益。

再次祝您清明节平安幸福，事业顺利！

---

Dear developers,

As the Qingming Festival approaches, which is a traditional Chinese holiday for honoring ancestors and celebrating the arrival of spring, we would like to extend our warmest regards and best wishes to you.

At the same time, we are pleased to announce the 0.1.6 release of Univer. This update introduces two major features: Conditional Formatting and Data Validation.

We hope that Univer can serve as a useful stuff in your life, providing you with assistance and support.

Once again, we wish you a peaceful and prosperous Qingming Festival.

🚧 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.

🚀 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!

🆕 What's new

In the v0.1.6 update, we have added two major features: Conditional Formatting and Data Validation. These features are designed to help you better manage and analyze your data.

🎨 Conditional Formatting

Conditional formatting allows you to apply different styles to cells based on their values. This feature is useful for highlighting important information and making your data more visually appealing.

To apply conditional formatting to a range of cells, follow these steps:

1. Install the @univerjs/sheets-conditional-formatting-ui package using npm or pnpm:

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

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

Breaking Change: If you are using the 0.1.5 version, please uninstall the @univerjs/sheets-conditional-formatting package and replace it with the @univerjs/sheets-conditional-formatting-ui package.

2. Register the conditional formatting UI in your Univer app:

import '@univerjs/sheets-conditional-formatting-ui/lib/index.css';

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

univer.registerPlugin(SheetsConditionalFormattingUiPlugin)

🛡️ Data Validation

Data validation allows you to set rules for the data entered in a cell. This feature is useful for ensuring data integrity and consistency in your spreadsheets.

To apply data validation to a range of cells, follow these steps:

1. Install the @univerjs/data-validation and @univerjs/sheets-data-validation package using npm or pnpm:

# Using npm
npm install @univerjs/data-validation @univerjs/sheets-data-validation

# Using pnpm
pnpm add @univerjs/data-validation @univerjs/sheets-data-validation

2. Register the data validation plugins in your Univer app:

import '@univerjs/sheets-data-validation/lib/index.css';

import { UniverDataValidationPlugin } from '@univerjs/data-validation';
import { UniverSheetsDataValidationPlugin } from '@univerjs/sheets-data-validation';

univer.registerPlugin(UniverDataValidationPlugin);
univer.registerPlugin(UniverSheetsDataValidationPlugin);

📚 Other Updates: Defined Names

In addition to the above features, we have also added the Defined Names feature to sheets. You can now set custom names for cell ranges to make it easier to reference them.

📢 Join the Conversation

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

• :octocat: GitHub Discussions
• 👾 Discord

📝 Changelog

Full changelog (2024-04-03)

Bug Fixes

• backspace will cause error when doc is not ready (#1725) (f24fdb1)
• conditional-formatting: configuration exceptions are specifically handled (#1750) (37a7787)
• conditional-formatting: support row/col hidden (#1747) (7ed59d1)
• data-validation i18n (#1788) (73aae0b)
• delete undo redo (#1781) (8d8e615)
• design: apply pointer-events: none to avoid ::selection in Safari (#1792) (86bb772)
• design: change tooltip to not remain active after hover (#1756) (2019a77)
• facade: fix set horizontal, vertical, warp (#1766) (1876e68)
• find-replace: add locale exports (#1760) (a573166)
• formula: bracket nested (#1799) (d84a618)
• formula: today fill error (#1798) (4b35198)
• punctuation adjustment in the middle of line (#1686) (2382e3b)
• sheet: error while creating an empty subunit (#1748) (662b4e0)
• sheet: selection size and editor position (#1743) (fd83cbf)
• sheets: fix shallow copy bugs of the sheet snapshot (#1742) (83d910c)
• sheets: fix the issue with selection during autofill (#1707) (eb6f8d0)
• sheets: fix value type casting in set range values (#1646) (227f5b0)
• sheets: merge disappear on hide row (#1714) (e68d47f)
• sheets: some bugs about copy&paste / remove row&col / autofill (#1561) (e1072c7)
• the error clip the last char when linebreak (#1745) (009b5b4)

Features

• condiational-formatting: update enUS locale (#1787) (785e141)
• conditional-formatting: support set cfId (#1753) (4a277f9)
• design: add Textarea component (#1778) (a2dd33d)
• design: set default text color to prevent inheritance (#1751) (71e1d94)
• facade: add getMaxColumns and getMaxRows API on FWorksheet (#1775) (c903780)
• facade: add getSheetBySheetId API on FWorkbook (#1762) (436b1b4)
• facade: sheet api getId rename to getSheetId (#1770) (dff654c)
• sheet: defined name (#1737) (cfa9375)
• sheet: optimize data validation i18n & dropdown bugfix (#1768) (a8c9452)
• sheets: support data validation (#1676) (9961b32)
• support char which length is great than 1 (#1783) (32cfb3b)