🎊 Univer@v0.1.7

🚧 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. #1875 #1549
• Added the Maxifs formula. #1711

🐞 Bug Fixes

• Fixed the issue that caused the entire application to crash after installing @univerjs/sheets-data-validation. #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! #1819

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