🎉 Release v0.4.2

[hexf00]

🎊 Univer@v0.4.2

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

📊 Univer Sheets

🎉 Highlights

In this release, we are excited to introduce a new set of features and improvements to enhance your Univer experience. Here are the highlights:

• Support auto column width feat: auto col #3798
• Added @univerjs/watermark plugin, Learn more feat: watermark #3751

1. register plugin

pnpm add @univerjs/watermark

2. import plugin

import '@univerjs/watermark/lib/index.css'

import { UniverWatermarkPlugin } from '@univerjs/watermark';

3. add locale

import { LocaleType, Tools } from '@univerjs/core'
import { defaultTheme } from "@univerjs/design";
+ import UniverWatermarkEnUS from '@univerjs/watermark/locale/en-US'


const univer = new Univer({
  theme: defaultTheme,
  locale: LocaleType.EN_US,
  locales: {
    [LocaleType.EN_US]: Tools.deepMerge(
+      UniverWatermarkEnUS,
    ),
  },
});

4. register plugin

univer.registerPlugin(UniverWatermarkPlugin)

• Added new Facade API for setting default custom properties for rows and columns: FWorksheet adds setColumnCustom, setRowCustom methods feat(sheet): styles on rows and columns #3816
• Added new Facade API for setting worksheet default styles: FWorksheet adds setDefaultStyle, setColumnDefaultStyle, setRowDefaultStyle methods, Learn more feat(sheet): styles on rows and columns #3816
• Added new Facade API to control gridlines visibility: FWorksheet adds setHiddenGridlines method feat(sheets): toggle gridlines #3805
• Added @univerjs/network plugin, support request behavior override when registering plugins feat(network): network plugin support overrides #3870
• Added 20+ text formula functions and 2 math formula functions feat(formula): add some text formulas #3546
• Added 10+ statistical formula functions feat(formula): support database-related formulas #3749
• Formula function count has reached 408, aiming to exceed 500

🐞 Bug Fixes

• Fixed cell string type behavior fix(cell): fix cell string type #3872
• Fixed SUMIF formula calculation with different range dimensions fix(formula): fix sumif formula range and sumRange different dimensions #3853 fix(formula): fix CELL_INVERTED_INDEX_CACHE range set #3807
• Added scrolling support for sheet switching menu [Bug] Sheet bar menu cannot be scrolled #3821
• Fixed 'local-fonts' console error chore: add fonts check defense #3811 fix(docs): undefined error when call permission query #3841
• Fixed sheet editor focus issues fix(sheets-ui): should disable sheet menus on cell editing #3809
• Fixed formula progress bar loading issue fix(formula): fix progress bar not loaded #3790

📝 Univer Docs

• Support for modern mode feat(docs): support modern mode #3706
• Improved collaboration cursor feat(docs): set inline style at cursor #3846 fix(docs): line break in collaboration #3863
• Various other improvements

🌐 Univer Server

• Enhanced collaboration permissions
• Improved installation script experience

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

Bug Fixes

• add comments for set frozen cmd params (#3743) (ebcf3e0)
• cell: fix cell string type (#3872) (bc65876)
• demo: types (#3794) (0d313f2)
• docs-link: error display url link when add link (#3822) (f6cd524)
• docs-thread-comment-ui: doc comment ot (#3832) (1fd499a)
• docs: close header and footer when switch doc mode (#3869) (888c15c)
• docs: line break in collaboration (#3863) (e95449e)
• docs: merge two paragraphs (#3871) (cf12b98)
• docs: the apply result should be consistent (#3806) (d0054f3)
• docs: transform in bullet list (#3830) (7451d2d)
• docs: undefined error when call permission query (#3841) (d642327)
• doc: transform with REPLACE type (#3827) (42e26e1)
• drawing: fix inner dom position (#3864) (c37f24c)
• drawing: fix remove drawing elements the control when not remove… (#3873) (448d32c)
• fix type-check (#3796) (cc822fa)
• formula: dependency for vlookup (#3817) (3a77cb2)
• formula: fix CELL_INVERTED_INDEX_CACHE range set (#3807) (1092fcb)
• formula: fix lookup related bugs (#3847) (ff9cf49)
• formula: fix progress bar not loaded (#3790) (065dadc)
• formula: fix sumif formula range and sumRange different dimensions (#3853) (faf7936)
• getScale is not correct after ctx.rotate (#3792) (b0c5f13)
• sheets-data-validation: can't copy checkbox with right checked status (#3818) (6da0f1e)
• sheets-drawing-ui: float dom scroll not update on drag range (#3840) (575a604)
• sheets-hyper-link-ui: sheet link menu display wrong in cell editing (#3825) (dbcdcba)
• sheets-hyper-link: link ref range behavior error (#3862) (3126112)
• sheets-ui: can't quit editor after enter '=' (#3861) (5343f2c)
• sheets-ui: lag when editing (#3837) (251186e)
• sheets-ui: should disable sheet menus on cell editing (#3809) (e758013)
• thread-comment: comment datasource (#3787) (8978364)
• thread-comment: thread-comment build types (#3802) (417fdee)
• trigger selectionMoveEnd$ when using keyboard to change selections. (#3731) (7b67be2)
• ui: improve layout and overflow handling in sheet bar menu (#3823) (acb4a45)
• unitId for canvas (#3804) (7107be6)

Features

• add network plugin (#3782) (3e3e795)
• auto col (#3798) (c66cff0)
• design: component style optimize (#3860) (1ab5eff)
• doc: add more apply test case (#3865) (e7b2f78)
• doc: handle custom range transform (#3836) (89d6441)
• docs: set inline style at cursor (#3846) (caed6de)
• docs: support modern mode (#3706) (bea0e78)
• floatdom: add some hookes (#3854) (3747cd4)
• formula: add some text formulas (#3546) (4094288)
• formula: supplement sheet and sheets formula (#3859) (5fcd97a)
• formula: support database-related formulas (#3749) (3b8af5a)
• func addFloatDomToPosition may not execute command (#3855) (e99aec1)
• network: network plugin support overrides (#3870) (cbabe12)
• permission: change permission point logic (#3826) (7e49171)
• sheet: add custom for row and column (#3693) (4e31b24)
• sheets-data-validation: add data validation any-validator and allowBlank options (#3845) (b415476)
• sheets: toggle gridlines (#3805) (c3a7ddf)
• sheet: styles on rows and columns (#3816) (8a27b31)
• thread-comment: didn't show tips on merge-cell comment (#3819) (65cb1c5)
• thread-comment: sync comment after rendered (#3810) (0fec7a9)
• watermark (#3751) (9630e31)

Performance Improvements

• sheets-drawing-ui: float dom scroll performance optimize (#3838) (b4b8810)

---

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

[hexf00]

🎊 Univer@v0.4.2

🚧 重要提示

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

🚀 快速开始

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

📊 Univer Sheets

🎉 新功能

• 支持设置自动列宽 feat: auto col #3798
• 新增 @univerjs/watermark 水印插件，了解更多 feat: watermark #3751

1. 安装插件

pnpm add @univerjs/watermark

2. 导入插件

import '@univerjs/watermark/lib/index.css'

import { UniverWatermarkPlugin } from '@univerjs/watermark';

3. 添加多语言

import { LocaleType, Tools } from '@univerjs/core'
import { defaultTheme } from "@univerjs/design";
+ import UniverWatermarkEnUS from '@univerjs/watermark/locale/en-US'


const univer = new Univer({
  theme: defaultTheme,
  locale: LocaleType.EN_US,
  locales: {
    [LocaleType.EN_US]: Tools.deepMerge(
+      UniverWatermarkEnUS,
    ),
  },
});

4. 注册插件

univer.registerPlugin(UniverWatermarkPlugin)

• 新增 Facade API 用于设置行列单元格的默认 custom 属性：FWorksheet 新增 setColumnCustom、setRowCustom 方法 feat(sheet): styles on rows and columns #3816
• 新增 Facade API 用于设置工作表默认样式: FWorksheet 新增 setDefaultStyle、setColumnDefaultStyle、setRowDefaultStyle 方法，了解更多 feat(sheet): styles on rows and columns #3816
• 新增 Facade API 控制网格线隐藏/显示：FWorksheet 新增 setHiddenGridlines 方法 feat(sheets): toggle gridlines #3805
• 新增 @univerjs/network 网络插件，注册插件时支持通过 override 配置项定义请求行为 feat(network): network plugin support overrides #3870
• 新增 20 + 文本类公式函数、2 个数学类公式函数 feat(formula): add some text formulas #3546
• 新增 10 + 统计类公式函数 feat(formula): support database-related formulas #3749
• 公式函数数量现已达到 408 个，目标是超过 500 个

🐞 Bug 修复

• 修复单元格强制字符串时的行为 fix(cell): fix cell string type #3872
• 修复 SUMIF 函数在 range 和 sumRange 维度不同时的计算问题 fix(formula): fix sumif formula range and sumRange different dimensions #3853 fix(formula): fix CELL_INVERTED_INDEX_CACHE range set #3807
• 工作表切换菜单支持滚动 [Bug] Sheet bar menu cannot be scrolled #3821
• 修复控制台会出现 'local-fonts' 的错误 chore: add fonts check defense #3811 fix(docs): undefined error when call permission query #3841
• 修复表格输入编辑器焦点相关问题 fix(sheets-ui): should disable sheet menus on cell editing #3809
• 修复公式进度条未加载问题 fix(formula): fix progress bar not loaded #3790

📝 Univer Docs

• 文档支持现代模式（modern mode） feat(docs): support modern mode #3706
• 协同光标改进 feat(docs): set inline style at cursor #3846 fix(docs): line break in collaboration #3863
• 其它大量改进

🌐 Univer Server

• 协同权限功能增强
• 优化安装脚本体验

📢 加入讨论

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

• GitHub Discussions
• 👾 Discord

📝 更新日志

完整的更新日志 (2024-10-29)