💼 Release v0.1.8

[jikkai]

🎊 [email protected]

致 Univer 的开发者们：

五一劳动节即将来临，Univer 团队向您送上最诚挚的节日祝福。在这个特殊的日子里，让我们一起向所有不懈努力的劳动者们表达敬意和感激之情。

值此佳节，我们也很高兴地宣布 Univer 迎来了全新的 0.1.8 版本更新。这一版本带来了一系列激动人心的新功能和优化，旨在为您提供更加出色的使用体验。

作为您的工作伙伴，Univer 将一如既往地助力您的工作和生活，为您解决问题、提升效率。我们真诚地邀请您将 Univer 分享给更多的朋友和同事，让这个强大的工具造福更多人。

最后，祝您五一劳动节快乐，工作顺利，生活愉悦，阖家幸福!

---

Dear developers,

As the International Workers' Day draws near, we, on behalf of the Univer team, would like to extend our sincerest holiday greetings to you. On this special day, let's express our respect and gratitude to all the hardworking laborers.

On this joyous occasion, we are also thrilled to announce the release of Univer 0.1.8. This new version brings a series of exciting features and optimizations designed to provide you with an even better user experience.

As your work companion, Univer will continue to empower your work and life, helping you solve problems and boost efficiency. We cordially invite you to share Univer with more friends and colleagues, so that this powerful tool can benefit more people.

Finally, we wish you a happy International Workers' Day, success in your work, joy in your life, and happiness for your family!

🚧 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.8 update, we have added Filtering feature to the Univer Sheets. This feature allows you to filter data in a range of cells based on specific criteria. You can apply filters to columns to display only the data that meets the criteria you specify.

📊 Filtering

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

# Using npm
npm install @univerjs/sheets-filter @univerjs/sheets-filter-ui

# Using pnpm
pnpm add @univerjs/sheets-filter @univerjs/sheets-filter-ui

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

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

import { UniverSheetsFilterPlugin } from '@univerjs/sheets-filter';
import { UniverSheetsFilterUIPlugin } from '@univerjs/sheets-filter-ui';

univer.registerPlugin(UniverSheetsFilterPlugin);
univer.registerPlugin(UniverSheetsFilterUIPlugin);

📦 All-in-one UMD Bundle

Finally, we have added an all-in-one UMD bundle for Univer. This bundle includes all the necessary dependencies and plugins, allowing you to quickly get started with Univer in your web applications.

You can include the UMD bundle in your HTML file using the following script tag:

<script src="https://unpkg.com/@univerjs/umd/lib/univer.full.umd.js"></script>
<link rel="stylesheet" href="https://unpkg.com/@univerjs/umd/lib/univer.css">

If you are already using React, ReactDOM, and RxJS in your project, you can opt for the slim version of the UMD bundle, which excludes these dependencies.

+ <script src="https://unpkg.com/react/umd/react.production.min.js"></script>
+ <script src="https://unpkg.com/react-dom/umd/react-dom.production.min.js"></script>
+ <script src="https://unpkg.com/rxjs/dist/bundles/rxjs.umd.min.js"></script>

- <script src="https://unpkg.com/@univerjs/umd/lib/univer.full.umd.js"></script>
+ <script src="https://unpkg.com/@univerjs/umd/lib/univer.slim.umd.js"></script>
<link rel="stylesheet" href="https://unpkg.com/@univerjs/umd/lib/univer.css">

💔 Breaking Changes

1. univer.createUniverSheet and univer.createUniverDoc have been replaced by univer.createUnit

- univer.createUniverSheet({});
+ univer.createUnit(UniverInstanceType.UNIVER_SHEET, {});

- univer.createUniverDoc({});
+ univer.createUnit(UniverInstanceType.UNIVER_DOC, {});

2. PluginType is removed. Please use UniverInstanceType instead.

export class YourPlugin extends Plugin {
- static override type = PluginType.DOC;
+ static override type = UniverInstanceType.UNIVER_DOC; 
}

🎢 Special Thanks

• @kovsu fix(sheets-ui): after unhiding row or col icon doesn't disappear #2075
• @ljcoder2015 feat(facade): f-worksheet add getName method #2042
• @jackpk235 feat(formula): add the Lower function #1970

🥳 Exciting News About Univer Pro

We have decided to launch the community edition SDK of Univer Pro in the near future. The community edition will include npm packages for front-end code, Docker images for back-end code, and a free trial license for up to one month. This means that developers can use the community edition SDK of Univer Pro for integrated development in their own projects.

Stay tuned for more updates on Univer Pro!

📢 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-04-26)

Bug Fixes

• columns is not render properly (#1952) (039e5e2)
• conditional-formatting: create cf rule error (#1969) (ee8f8de)
• conditional-formatting: disregarding computation beyond the tables region (#1891) (c14a3a8)
• conditional-formatting: gradient fills may conceal cell values (#1898) (70d3a7e)
• design: fix checkbox group not updating visually on click (#1989) (967eb39)
• dv: fix data validation plugin type to prevent loading error (#2084) (937fa13)
• editor: formula input esc invalid (#1902) (87f0994)
• facade: fix handling of empty selections in onSelectionChange method (#2066) (e440e04)
• fix API not exported (b4913f9)
• fix current render handling in desktop controller (#2067) (ddbeb02)
• fix lifecycle stages (37777f1)
• fix lint errors (4e970d4)
• fix memory leak on dispose sheet unit (#1900) (4a5eca1)
• fix memory leaking in active cell (761a372)
• fix non-sheet renderer should not be set container (#2044) (00b30e5)
• fix plugin not added to seen list (7591212)
• fix unit cannot be destroyed or recreate (#2081) (b67a9f8)
• fix univer plugin lifecycle not triggered (#2023) (827e5a3)
• fix univer plugin not started (5f5b0a7)
• getCurrent methods should possibly return null (#1892) (859d7fc)
• punctuation adjustment (#1867) (e921128)
• rect-popup event bind error (#1922) (ac17c69)
• refocus sheet cell when create new sheet (#1896) (db88447)
• render-engine: punctuation render error in sheet cell (#2034) (d7ddad1)
• replace whitespace characters in html str (#1904) (1ff1261)
• sheet-formula: fix error message on missing formula (#1885) (0ab866e)
• sheet: add cell custom field (#2021) (53b9041)
• sheet: cell custom supports updating from mutation (#2058) (bec1944)
• sheet: defined name move (#1888) (be2fec3)
• sheet: defined name update name (#1917) (5b6e223)
• sheet: editor set rich error (#1918) (d4f67f8)
• sheet: esc key for editor (#1928) (54487b8)
• sheet: fix some copy/paste bugs (#1754) (496dcb8)
• sheet: header hidden (#1954) (e3dc9ce)
• sheet: life cycle steady (#1927) (fbabfaa)
• sheet: move formula ref (#2078) (fa4ebea)
• sheet: range selector drag row (#1729) (530a852)
• sheet: range selector error (#1897) (a2c8cb6)
• sheets-data-validation: fix reject input incorrect (#2082) (6e03118)
• sheets-formula initialize time (#1910) (a461d16)
• sheets-ui: after unhiding row or col icon doesn't disappear (#2075) (f07c2d9)
• sheets: the text is aligned at editorial and non-editorial states (#1874) (c7e26a0)
• text is cropped when rendered in italic style with background (#1862) (80f43b8)
• the strickthough position is wrong when fontsize is different (#1919) (2564456)
• ui: stop onblur propagation at root to prevent external focusout conflicts (#1894) (04abb1b)
• univer plugin holder start immediately (8c3bb90)
• univer should auto start (af032c8)

Features

• core: refactoring resources load and snapshot (#1853) (8ae91b7)
• core: univer support override dependencies (#2050) (cfad0da)
• data-validation: transform support for data validation (#1915) (22ccbb1)
• doc: refactor of text shaping and support kerning (#1785) (e7f1036)
• engine-formula: add iseven isodd (#1873) (21d145c)
• engine-render: add render unit system (#2025) (a5243da)
• export identifiers from packages index.ts (#2049) (bced914)
• facade: f-worksheet add getName method (#2042) (10cc6e1)
• formula: formula calculation progress (#1985) (ad1d632)
• formula: implement formula lower (#1970) (db3fa45)
• image: add plugin (#1962) (9c494ae)
• numfmt: refactor the numfmt model (#1945) (1840166)
• sheet: force string adds popup (#1934) (add1214)
• sheet: indirect support defined name (#1899) (6c0833a)
• sheets-ui: optimize popup service (#1912) (a555160)
• sheets: filter (#1465) (1f03b7a)
• sheets: register other formula (#2045) (4a8ffd9)
• umd: create all-in-one UMD bundle (#2062) (e76fe4e)
• univer can take parent injector (f8ea16a)
• update codeowners (#2019) (5b0a103)

Performance Improvements

• formula: dependency maintain (#1638) (b745845)

---

This discussion was created from the release 💼 Release v0.1.8.