🎉 Release v0.1.7

[jikkai]

🎊 [email protected]

🚧 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 this release, we've added new features, fixed bugs, and made some breaking changes. Here's a summary of the changes:

📦 New Features

• Now you can start editing a cell by pressing the F2 key. Editing cells in this way will not change the selection when you press the arrow keys. This behavior is consistent with Excel. feat(sheets-ui): add f2 to start editing #1875 [Bug] 编辑单元格内容时，使用左右键移动光标，直接失焦了 #1549
• Added the Maxifs formula. feat(formula): add the Maxifs function #1711

🐞 Bug Fixes

• Fixed the issue that caused the entire application to crash after installing @univerjs/sheets-data-validation. feat(sheets-data-validation): move draggable-list to design #1822

💔 Breaking Changes

@univerjs/sheets-conditional-formatting-ui

If you are using the SheetsConditionalFormattingUiPlugin from @univerjs/sheets-conditional-formatting-ui, please note the following breaking changes:

• SheetsConditionalFormattingUiPlugin has been renamed to SheetsConditionalFormattingUi. Please update your imports accordingly.

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

- univer.registerPlugin(SheetsConditionalFormattingUiPlugin)
+ univer.registerPlugin(UniverSheetsConditionalFormattingUIPlugin)

🎢 Special Thanks

• Thanks to @fmwww for contributing to the project. Your contributions are greatly appreciated! style: standardize justify-content: start to flex-start #1819

📢 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-12)

Bug Fixes

• auto height is not work when at default column width (#1840) (55e0869)
• condiational-formatting: rename SheetsConditionalFormattingUiPlugin (#1801) (9b14a5a)
• conditional-formatting: fix the logic for hidden$ in conditional formatting (#1813) (cd631af)
• design: ensure popup component is appended to root to prevent offset from stacking contexts (#1850) (1ad518a)
• design: fix slider to stop responding to mouse movement after release during zoom operations (#1834) (3d5a26e)
• design: fix tooltip behavior (#1845) (bd85759)
• design: set default language to zhCN (#1863) (08e8d58)
• display error in font family (#1700) (8c2282b)
• docs: list indent and hanging (#1675) (4020055)
• docs: strikethrough position is incorrect (#1836) (3f68158)
• engine-render: ignore media change on printing mode (#1808) (f5fc6be)
• formula: copy paste range with formulas (#1765) (58c7d3e)
• formula: null value return not zero (#1851) (87d8e20)
• formula: use ref range formula (#1694) (d8f1dc4)
• inline format error in cell (#1843) (2002fdf)
• rpc: skip missing mutations in remote replica (#1826) (1e10cbf)
• sheet-ui: make the default font family and font size correct (#1827) (ea18b99)
• sheet: defined name vertical (#1832) (edf86f4)
• sheet: editor and selection position (#1830) (e23992f)
• sheet: remove set current mutation (#1802) (79ce85d)
• sheets-ui: data-validation event bind timing (#1804) (d0cac23)
• sheets-ui: fix border panel icons (#1815) (ea7636e)
• sheets: fix the issue where the editor position is incorrect after unmerging cells (#1717) (7d27f11)
• sheet: update internal id (#1825) (fc4cc4c)
• ts-error (#1858) (b8007cb)
• uniscript entry is displayed in zen mode (#1842) (337af7d)
• uniscript: script editor service is not exposed (68647a6)

Features

• conditional-formatting: bugfix (#1838) (c0b3dce)
• design: add indeterminate property support to Checkbox component (#1870) (f522a34)
• docs: support background color in doc (#1846) (3a38828)
• formula: add the Maxifs function (#1711) (52b2698)
• sheets-data-validation: move draggable-list to design (#1822) (3acf286)
• sheets-ui: add f2 to start editing (#1875) (b740dfa)
• sheets-ui: sheet popup service should respond to row col changes (#1848) (6868a47)
• sheets: add watch API to ref-range-service (#1635) (5f7e9a2)
• sheets: data-validation ref-range & optimize package orignize (#1784) (a475474)
• ui: add disable auto focus config (#1682) (6256c15)
• ui: optimize scrollbar (#1856) (9e76a28)

---

This discussion was created from the release 🎉 Release v0.1.7.

[jikkai]

🎊 [email protected]

🚧 重要提示

该项目仍在积极开发中，预计会有重大 API 更改。您的反馈至关重要！请提交 issues 和建议，帮助我们塑造 Univer 的未来。

🚀 快速开始

如果您希望了解 Univer，请查看我们的入门文档。
深入探索由 Univer 提供支持的协作文档、电子表格和演示文稿编辑的世界！

🆕 版本亮点

在本次版本中，我们新增了一些功能，修复了一些错误，并产生了一些破坏性更新。以下是变更的摘要：

📦 新功能

• 现在您可以通过按下 F2 键开始编辑单元格。以这种方式编辑单元格时，按方向键时不会更改选区。此行为与 Excel 一致。 feat(sheets-ui): add f2 to start editing #1875 [Bug] 编辑单元格内容时，使用左右键移动光标，直接失焦了 #1549
• 添加了 Maxifs 公式。 feat(formula): add the Maxifs function #1711

🐞 Bug 修复

• 修复了安装 @univerjs/sheets-data-validation 后导致整个页面崩溃的问题。 feat(sheets-data-validation): move draggable-list to design #1822

💔 破坏性更新

@univerjs/sheets-conditional-formatting-ui

如果您正在使用 @univerjs/sheets-conditional-formatting-ui 中的 SheetsConditionalFormattingUiPlugin，请注意以下破坏性更新：

• SheetsConditionalFormattingUiPlugin 已更名为 UniverSheetsConditionalFormattingUIPlugin。请相应更新您的导入。

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

- univer.registerPlugin(SheetsConditionalFormattingUiPlugin)
+ univer.registerPlugin(UniverSheetsConditionalFormattingUIPlugin)

🎢 特别感谢

• 感谢 @fmwww 对项目的贡献。我们非常感谢您的参与！ style: standardize justify-content: start to flex-start #1819

📢 加入讨论

我们欢迎您的参与和见解，一起踏上这个激动人心的旅程。请通过以下方式与我们联系：

• GitHub Discussions
• 👾 Discord

📝 更新日志

完整的更新日志 (2024-04-12)

Bug Fixes

• auto height is not work when at default column width (#1840) (55e0869)
• condiational-formatting: rename SheetsConditionalFormattingUiPlugin (#1801) (9b14a5a)
• conditional-formatting: fix the logic for hidden$ in conditional formatting (#1813) (cd631af)
• design: ensure popup component is appended to root to prevent offset from stacking contexts (#1850) (1ad518a)
• design: fix slider to stop responding to mouse movement after release during zoom operations (#1834) (3d5a26e)
• design: fix tooltip behavior (#1845) (bd85759)
• design: set default language to zhCN (#1863) (08e8d58)
• display error in font family (#1700) (8c2282b)
• docs: list indent and hanging (#1675) (4020055)
• docs: strikethrough position is incorrect (#1836) (3f68158)
• engine-render: ignore media change on printing mode (#1808) (f5fc6be)
• formula: copy paste range with formulas (#1765) (58c7d3e)
• formula: null value return not zero (#1851) (87d8e20)
• formula: use ref range formula (#1694) (d8f1dc4)
• inline format error in cell (#1843) (2002fdf)
• rpc: skip missing mutations in remote replica (#1826) (1e10cbf)
• sheet-ui: make the default font family and font size correct (#1827) (ea18b99)
• sheet: defined name vertical (#1832) (edf86f4)
• sheet: editor and selection position (#1830) (e23992f)
• sheet: remove set current mutation (#1802) (79ce85d)
• sheets-ui: data-validation event bind timing (#1804) (d0cac23)
• sheets-ui: fix border panel icons (#1815) (ea7636e)
• sheets: fix the issue where the editor position is incorrect after unmerging cells (#1717) (7d27f11)
• sheet: update internal id (#1825) (fc4cc4c)
• ts-error (#1858) (b8007cb)
• uniscript entry is displayed in zen mode (#1842) (337af7d)
• uniscript: script editor service is not exposed (68647a6)

Features

• conditional-formatting: bugfix (#1838) (c0b3dce)
• design: add indeterminate property support to Checkbox component (#1870) (f522a34)
• docs: support background color in doc (#1846) (3a38828)
• formula: add the Maxifs function (#1711) (52b2698)
• sheets-data-validation: move draggable-list to design (#1822) (3acf286)
• sheets-ui: add f2 to start editing (#1875) (b740dfa)
• sheets-ui: sheet popup service should respond to row col changes (#1848) (6868a47)
• sheets: add watch API to ref-range-service (#1635) (5f7e9a2)
• sheets: data-validation ref-range & optimize package orignize (#1784) (a475474)
• ui: add disable auto focus config (#1682) (6256c15)
• ui: optimize scrollbar (#1856) (9e76a28)

[RHTome]

I have generate many data using luckysheet. But now luckysheet is EOL and my data can not export. How can I get back my data?

[hexf00]

We have written a migration guide for Luckysheet users to migrate to Univer. If you have any other questions, please open a new discussion. see https://univer.ai/guides/sheet/tutorials/migrate-luckysheet